[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