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 --error 1093
23 UPDATE t1 SET c1 = (SELECT MAX(c1) FROM t1);
24 DROP TABLE t1;
25 DROP TABLE t2;
26 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100),c3 FLOAT);
27 INSERT INTO t1 VALUES (null,null,0.0);
28 INSERT INTO t1 VALUES (1,'',1.0);
29 INSERT INTO t1 VALUES (2,'abcde',2.0);
30 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
31 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
32 INSERT INTO t2 VALUES (1,'abcde');
33 INSERT INTO t2 VALUES (2,'abcde');
34 --error 1235
35 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1);
36 --error 1241
37 SELECT (SELECT c1, c2 FROM t2) FROM t1;
38 --error 1242
39 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
40 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
41 --error 1093
42 UPDATE t1 SET c1 = (SELECT MAX(c1) FROM t1);
43 DROP TABLE t1;
44 DROP TABLE t2;
45 CREATE TABLE t1 (c1 INT, c2 BINARY(100),c3 FLOAT);
46 INSERT INTO t1 VALUES (null,null,0.0);
47 INSERT INTO t1 VALUES (1,'',1.0);
48 INSERT INTO t1 VALUES (2,'abcde',2.0);
49 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
50 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
51 INSERT INTO t2 VALUES (1,'abcde');
52 INSERT INTO t2 VALUES (2,'abcde');
53 --error 1235
54 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1);
55 --error 1241
56 SELECT (SELECT c1, c2 FROM t2) FROM t1;
57 --error 1242
58 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
59 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
60 --error 1093
61 UPDATE t1 SET c1 = (SELECT MAX(c1) FROM t1);
62 DROP TABLE t1;
63 DROP TABLE t2;
64 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100),c3 FLOAT);
65 INSERT INTO t1 VALUES (null,null,0.0);
66 INSERT INTO t1 VALUES (1,'',1.0);
67 INSERT INTO t1 VALUES (2,'abcde',2.0);
68 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
69 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
70 INSERT INTO t2 VALUES (1,'abcde');
71 INSERT INTO t2 VALUES (2,'abcde');
72 --error 1235
73 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1);
74 --error 1241
75 SELECT (SELECT c1, c2 FROM t2) FROM t1;
76 --error 1242
77 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
78 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
79 --error 1093
80 UPDATE t1 SET c1 = (SELECT MAX(c1) FROM t1);
81 DROP TABLE t1;
82 DROP TABLE t2;
83