[tarantool-patches] Re: [PATCH v2 1/1] sql: disallow returning many rows from subselect

Kirill Shcherbatov kshcherbatov at tarantool.org
Mon Jul 2 10:17:46 MSK 2018


> Please, use upper-case for all SQL keywords (here and in other SQL tests you modified).
-        CREATE TABLE t5(a int primary key, b int);
+        CREATE TABLE t5(a INT PRIMARY KEY, b INT);

-        SELECT b from t5 WHERE a = (SELECT a FROM t5 WHERE b=6);
+        SELECT b FROM t5 WHERE a = (SELECT a FROM t5 WHERE b=6);

-        SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6 LIMIT (select b-1 from t1 where a =1));
+        SELECT b FROM t1 WHERE a = (SELECT a FROM t1 WHERE b=6 LIMIT (SELECT b-1 FROM t1 WHERE a =1));


-        SELECT b from t1 where a = (SELECT a FROM t1 WHERE b=6 LIMIT (select b from t1 where a =1));
+        SELECT b FROM t1 WHERE a = (SELECT a FROM t1 WHERE b=6 LIMIT (SELECT b FROM t1 WHERE a =1));




More information about the Tarantool-patches mailing list