Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma

Benutzer


products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/engines/funcs/t/ (MariaDB Server Version 8.1-8.4^©) Datei vom 1.9.2026 mit Größe 19 kB

Quelle up_string_range.test Sprache: unbekannt

Spracherkennung für: .test vermutete Sprache: SQL {SQL[216] Lisp[97] Masm[97]} [Methode: maximale Elemente, drei Dimensionen]

--disable_warnings
DROP TABLE IF EXISTS t1,t2,t3;
--enable_warnings
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
UPDATE t1 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
UPDATE t1 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
UPDATE t1 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
UPDATE t1 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
UPDATE t2 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
UPDATE t2 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
UPDATE t2 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
UPDATE t2 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
UPDATE t3 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
UPDATE t3 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
UPDATE t3 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
UPDATE t3 SET c1='a' WHERE c1 = 'a';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
UPDATE t1 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
UPDATE t1 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
UPDATE t1 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
UPDATE t1 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
UPDATE t2 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
UPDATE t2 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
UPDATE t2 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
UPDATE t2 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
UPDATE t3 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
UPDATE t3 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
UPDATE t3 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
UPDATE t3 SET c1='a' WHERE c1 = 'b';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
UPDATE t1 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
UPDATE t1 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
UPDATE t1 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
UPDATE t1 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
UPDATE t2 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
UPDATE t2 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
UPDATE t2 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
UPDATE t2 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
UPDATE t3 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
UPDATE t3 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
UPDATE t3 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
UPDATE t3 SET c1='a' WHERE c1 = 'c';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
UPDATE t1 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
UPDATE t1 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
UPDATE t1 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
UPDATE t1 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t1;
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
UPDATE t2 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
UPDATE t2 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
UPDATE t2 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
UPDATE t2 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t2;
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL);
CREATE TABLE t2(c1 CHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
UPDATE t3 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
UPDATE t3 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL);
CREATE TABLE t2(c1 BINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
UPDATE t3 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
UPDATE t3 SET c1='a' WHERE c1 = 'd';
SELECT COUNT(c1) FROM t3;
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
DROP TABLE t1,t2,t3;