[tarantool-patches] Re: [PATCH v2 1/1] sql: disallow returning many rows from subselect
- From: Kirill Shcherbatov <kshcherbatov@xxxxxxxxxxxxx>
- To: tarantool-patches@xxxxxxxxxxxxx, "n.pettik@xxxxxxxxxxxx" <n.pettik@xxxxxxxxxxxx>
- Date: Mon, 2 Jul 2018 10:17:46 +0300
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));
Other related posts: