From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <tarantool-patches-bounce@freelists.org>
Received: from localhost (localhost [127.0.0.1])
	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F06C224DFD
	for <tarantool-patches@freelists.org>; Fri, 18 May 2018 19:44:03 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
	by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 7sTkZsAJ5u5A for <tarantool-patches@freelists.org>;
	Fri, 18 May 2018 19:44:03 -0400 (EDT)
Received: from forward1o.cmail.yandex.net (forward1o.cmail.yandex.net [37.9.109.84])
	(using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits))
	(No client certificate requested)
	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 5A6B024DEA
	for <tarantool-patches@freelists.org>; Fri, 18 May 2018 19:44:02 -0400 (EDT)
From: roman.habibov1@yandex.ru
In-Reply-To: <04E4818B-7629-43D0-A647-E8918CD9D82A@tarantool.org>
References: <aae0bec697872f421cf229b02ae3fc5f93a2b24e.1525474833.git.roman.habibov1@yandex.ru>
	 <BB1D3105-6F9A-445C-9675-F9A172F79737@tarantool.org>
	 <2050311525824390@web59j.yandex.ru>
	 <225ED31B-14F7-4BF1-9383-2100722DFEF2@tarantool.org>
	 <6369401525886435@web18j.yandex.ru>
	 <C3D1B7D5-6BC1-4713-A9EA-76C76CFEA078@tarantool.org>
	 <2421251526051907@web18j.yandex.ru> <04E4818B-7629-43D0-A647-E8918CD9D82A@tarantool.org>
Subject: [tarantool-patches] Re: [PATCH v1 1/1] sql: added tests for TEMP and TEMPORARY clauses
MIME-Version: 1.0
Message-Id: <1716191526687040@web54g.yandex.ru>
Date: Sat, 19 May 2018 02:44:00 +0300
Content-Transfer-Encoding: 8bit
Content-Type: text/plain; charset="utf-8"
Sender: tarantool-patches-bounce@freelists.org
Errors-to: tarantool-patches-bounce@freelists.org
Reply-To: tarantool-patches@freelists.org
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <tarantool-patches-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: tarantool-patches <tarantool-patches.freelists.org>
List-subscribe: <tarantool-patches-request@freelists.org?Subject=subscribe>
List-owner: <mailto:>
List-post: <mailto:tarantool-patches@freelists.org>
List-archive: <http://www.freelists.org/archives/tarantool-patches>
To: "n.pettik" <korablev@tarantool.org>, "tarantool-patches@freelists.org" <tarantool-patches@freelists.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"