Debian Codegraph @

mysql-test/suite/engines/funcs/r/sq_error.result

raw
1 DROP TABLE IF EXISTS t1;
2 DROP TABLE IF EXISTS t2;
3 CREATE TABLE t1 (c1 INT, c2 CHAR(100),c3 FLOAT);
4 INSERT INTO t1 VALUES (null,null,0.0);
5 INSERT INTO t1 VALUES (1,'',1.0);
6 INSERT INTO t1 VALUES (2,'abcde',2.0);
7 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
8 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
9 INSERT INTO t2 VALUES (1,'abcde');
10 INSERT INTO t2 VALUES (2,'abcde');
11 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1)
12 --error 1241
13 SELECT (SELECT c1, c2 FROM t2) FROM t1;
14 ERROR 42000: This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
15 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
16 ERROR 21000: Subquery returns more than 1 row
17 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
18 DROP TABLE t1;
19 DROP TABLE t2;
20 CREATE TABLE t1 (c1 INT, c2 VARCHAR(100),c3 FLOAT);
21 INSERT INTO t1 VALUES (null,null,0.0);
22 INSERT INTO t1 VALUES (1,'',1.0);
23 INSERT INTO t1 VALUES (2,'abcde',2.0);
24 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
25 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
26 INSERT INTO t2 VALUES (1,'abcde');
27 INSERT INTO t2 VALUES (2,'abcde');
28 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1)
29 --error 1241
30 SELECT (SELECT c1, c2 FROM t2) FROM t1;
31 ERROR 42000: This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
32 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
33 ERROR 21000: Subquery returns more than 1 row
34 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
35 DROP TABLE t1;
36 DROP TABLE t2;
37 CREATE TABLE t1 (c1 INT, c2 BINARY(100),c3 FLOAT);
38 INSERT INTO t1 VALUES (null,null,0.0);
39 INSERT INTO t1 VALUES (1,'',1.0);
40 INSERT INTO t1 VALUES (2,'abcde',2.0);
41 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
42 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
43 INSERT INTO t2 VALUES (1,'abcde');
44 INSERT INTO t2 VALUES (2,'abcde');
45 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1)
46 --error 1241
47 SELECT (SELECT c1, c2 FROM t2) FROM t1;
48 ERROR 42000: This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
49 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
50 ERROR 21000: Subquery returns more than 1 row
51 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
52 DROP TABLE t1;
53 DROP TABLE t2;
54 CREATE TABLE t1 (c1 INT, c2 VARBINARY(100),c3 FLOAT);
55 INSERT INTO t1 VALUES (null,null,0.0);
56 INSERT INTO t1 VALUES (1,'',1.0);
57 INSERT INTO t1 VALUES (2,'abcde',2.0);
58 INSERT INTO t1 VALUES (100,'abcdefghij',3.0);
59 CREATE TABLE t2 (c1 INT, c2 VARCHAR(100));
60 INSERT INTO t2 VALUES (1,'abcde');
61 INSERT INTO t2 VALUES (2,'abcde');
62 SELECT * FROM t1 WHERE c2 IN (SELECT c2 FROM t2 ORDER BY c1 LIMIT 1)
63 --error 1241
64 SELECT (SELECT c1, c2 FROM t2) FROM t1;
65 ERROR 42000: This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
66 SELECT * FROM t1 WHERE c1 = (SELECT c1 FROM t2);
67 ERROR 21000: Subquery returns more than 1 row
68 UPDATE t1 SET c2 = (SELECT MAX(c1) FROM t2);
69 DROP TABLE t1;
70 DROP TABLE t2;