From: roman.habibov1@yandex.ru
To: "n.pettik" <korablev@tarantool.org>,
"tarantool-patches@freelists.org"
<tarantool-patches@freelists.org>
Subject: [tarantool-patches] Re: [PATCH v1 1/1] sql: added tests for TEMP and TEMPORARY clauses
Date: Sat, 19 May 2018 02:44:00 +0300 [thread overview]
Message-ID: <1716191526687040@web54g.yandex.ru> (raw)
In-Reply-To: <04E4818B-7629-43D0-A647-E8918CD9D82A@tarantool.org>
14.05.2018, 17:50, "n.pettik" <korablev@tarantool.org>:
>> + CREATE TEMP TABLE t1(col1 int, col2 int);
>> + CREATE TEMPORARY TABLE t1(col1 int, col2 int);
>
> You can’t create table this way: you must specify primary key.
diff --git a/test/sql-tap/table.test.lua b/test/sql-tap/table.test.lua
index f0a1cbc..b0e99b0 100755
--- a/test/sql-tap/table.test.lua
+++ b/test/sql-tap/table.test.lua
@@ -617,7 +617,7 @@ test:do_execsql2_test(
test:do_catchsql_test(
"temp",
[[
- CREATE TEMP TABLE t1(col1 int, col2 int);
+ CREATE TEMP TABLE t1(a INTEGER PRIMARY KEY, b VARCHAR(10));
]], {
-- <temp>
1, "near \"TEMP\": syntax error"
@@ -627,7 +627,7 @@ test:do_catchsql_test(
test:do_catchsql_test(
"temporary",
[[
- CREATE TEMPORARY TABLE t1(col1 int, col2 int);
+ CREATE TEMPORARY TABLE t1(a INTEGER PRIMARY KEY, b VARCHAR(10));
]], {
-- <temporary>
1, "near \"TEMPORARY\": syntax error"
next prev parent reply other threads:[~2018-05-18 23:44 UTC|newest]
Thread overview: 15+ messages / expand[flat|nested] mbox.gz Atom feed top
2018-05-05 22:34 [tarantool-patches] [PATCH v1 1/1] Tests for CREATE TEMP TABLE and CREATE TEMPORARY TABLE Roman Khabibov
2018-05-07 13:08 ` [tarantool-patches] " Vladislav Shpilevoy
2018-05-07 18:50 ` roman.habibov1
2018-05-07 23:12 ` Vladislav Shpilevoy
2018-05-07 23:30 ` roman.habibov1
2018-05-08 8:15 ` Vladislav Shpilevoy
2018-05-08 10:30 ` n.pettik
[not found] ` <2050311525824390@web59j.yandex.ru>
2018-05-09 14:30 ` [tarantool-patches] Re: [PATCH v1 1/1] sql: " n.pettik
2018-05-09 17:20 ` roman.habibov1
2018-05-11 13:12 ` n.pettik
2018-05-11 15:18 ` [tarantool-patches] Re: [PATCH v1 1/1] sql: added tests for TEMP and TEMPORARY clauses roman.habibov1
2018-05-14 14:50 ` n.pettik
2018-05-18 23:44 ` roman.habibov1 [this message]
2018-05-19 0:28 ` n.pettik
2018-05-19 11:57 ` Kirill Yukhin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=1716191526687040@web54g.yandex.ru \
--to=roman.habibov1@yandex.ru \
--cc=korablev@tarantool.org \
--cc=tarantool-patches@freelists.org \
--subject='[tarantool-patches] Re: [PATCH v1 1/1] sql: added tests for TEMP and TEMPORARY clauses' \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox