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/r/ (MariaDB Server Version 8.1-8.4^©) Datei vom 1.9.2026 mit Größe 19 kB

Impressum de_string_range.result Sprache: Lisp

DROP TABLE IF EXISTS 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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
7
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
0
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
0
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'a';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
5
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
5
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
7
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
5
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'b';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
7
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'c';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
0
DELETE FROM t1 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
7
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
7
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
7
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;
COUNT(c1)
7
DELETE FROM t2 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t2;
COUNT(c1)
7
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
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;
COUNT(c1)
1
DELETE FROM t3 WHERE c1 = 'd';
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
DROP TABLE t1,t2,t3;

Messung V0.5 in Prozent

¤ Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.0.4Bemerkung: (vorverarbeitet am 2026-10-08) ¤

Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.