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/Postgres/src/backend/access/hash/ (Postgres Database Version 18.4^©) Datei vom 11.4.2026 mit Größe 257 B

Quelle re_string_range.result Sprache: Lisp

DROP TABLE IF EXISTS t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
0
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
1
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
1
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
1
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'a';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'b';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'b';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
1
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'c';
COUNT(c1)
1
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'c';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
0
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t1 VALUES ('a');
SELECT COUNT(c1) FROM t1;
COUNT(c1)
1
SELECT COUNT(c1) FROM t1 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t2 VALUES ('a');
SELECT COUNT(c1) FROM t2;
COUNT(c1)
6
SELECT COUNT(c1) FROM t2 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 CHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 CHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARCHAR(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 BINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 BINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
DROP TABLE t1,t2,t3;
CREATE TABLE t1(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
CREATE TABLE t2(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t2 (c1) VALUES('a'),('aaa'),('b'),('bb'),('bbb'),('c');
CREATE TABLE t3(c1 VARBINARY(10) NOT NULL PRIMARY KEY);
INSERT INTO t3 (c1) VALUES('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
REPLACE t3 VALUES ('a');
SELECT COUNT(c1) FROM t3;
COUNT(c1)
1
SELECT COUNT(c1) FROM t3 WHERE c1 = 'd';
COUNT(c1)
0
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.2Bemerkung: (Wie Sie bei der Firma Beratungs- und Dienstleistungen beauftragen können 2026-10-08) ¤

*Eine klare Vorstellung vom Zielzustand

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.