Debian Codegraph @

mysql-test/suite/engines/funcs/t/sq_error.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 --disable_warnings
5 DROP TABLE IF EXISTS t2;
6 --enable_warnings
7 CREATE TABLE t1 (c1 INT, c2 CHAR(100),c3 FLOAT);
8 INSERT INTO t1 VALUES (null,null,0.0);
9 INSERT INTO t1 VALUES (1,'',1.0);
10 INSERT INTO t1 VALUES (2,'abcde',2.0);
11 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
12 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
13 INSERT INTO t2 VALUES (1,'abcde');
14 INSERT INTO t2 VALUES (2,'abcde');
15 --error 1235
16 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1)
17 --error 1241
18 SELECT (SELECT c1, c2 FROM t2) FROM t1;
19 --error 1242
20 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
21 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
22 DROP TABLE t1;
23 DROP TABLE t2;
24 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100),c3 FLOAT);
25 INSERT INTO t1 VALUES (null,null,0.0);
26 INSERT INTO t1 VALUES (1,'',1.0);
27 INSERT INTO t1 VALUES (2,'abcde',2.0);
28 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
29 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
30 INSERT INTO t2 VALUES (1,'abcde');
31 INSERT INTO t2 VALUES (2,'abcde');
32 --error 1235
33 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1)
34 --error 1241
35 SELECT (SELECT c1, c2 FROM t2) FROM t1;
36 --error 1242
37 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
38 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
39 DROP TABLE t1;
40 DROP TABLE t2;
41 CREATE TABLE t1 (c1 INT, c2 BINARY(100),c3 FLOAT);
42 INSERT INTO t1 VALUES (null,null,0.0);
43 INSERT INTO t1 VALUES (1,'',1.0);
44 INSERT INTO t1 VALUES (2,'abcde',2.0);
45 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
46 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
47 INSERT INTO t2 VALUES (1,'abcde');
48 INSERT INTO t2 VALUES (2,'abcde');
49 --error 1235
50 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1)
51 --error 1241
52 SELECT (SELECT c1, c2 FROM t2) FROM t1;
53 --error 1242
54 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
55 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
56 DROP TABLE t1;
57 DROP TABLE t2;
58 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100),c3 FLOAT);
59 INSERT INTO t1 VALUES (null,null,0.0);
60 INSERT INTO t1 VALUES (1,'',1.0);
61 INSERT INTO t1 VALUES (2,'abcde',2.0);
62 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
63 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
64 INSERT INTO t2 VALUES (1,'abcde');
65 INSERT INTO t2 VALUES (2,'abcde');
66 --error 1235
67 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1)
68 --error 1241
69 SELECT (SELECT c1, c2 FROM t2) FROM t1;
70 --error 1242
71 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
72 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
73 DROP TABLE t1;
74 DROP TABLE t2;
75