From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D0DE8216BC for ; Sat, 5 May 2018 18:34:26 -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 5fZWCT8iUZqk for ; Sat, 5 May 2018 18:34:26 -0400 (EDT) Received: from forward101o.mail.yandex.net (forward101o.mail.yandex.net [37.140.190.181]) (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 23BA421266 for ; Sat, 5 May 2018 18:34:25 -0400 (EDT) From: Roman Khabibov Subject: [tarantool-patches] [PATCH v1 1/1] Tests for CREATE TEMP TABLE and CREATE TEMPORARY TABLE Date: Sun, 6 May 2018 01:34:17 +0300 Message-Id: Sender: tarantool-patches-bounce@freelists.org Errors-to: tarantool-patches-bounce@freelists.org Reply-To: tarantool-patches@freelists.org List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: tarantool-patches List-subscribe: List-owner: List-post: List-archive: To: tarantool-patches@freelists.org Cc: v.shpilevoy@tarantool.org, Roman Khabibov Added tests for removed SQL functions "CREATE TEMP TABLE" and "CREATE TEMPORARY". There is exeptions, when these functions are used. Tests catch its. Closes #2166 --- test/sql-tap/table.test.lua | 20 +++++++++++++++++++- 1 file changed, 19 insertions(+), 1 deletion(-) diff --git a/test/sql-tap/table.test.lua b/test/sql-tap/table.test.lua index 6e10561..4882b18 100755 --- a/test/sql-tap/table.test.lua +++ b/test/sql-tap/table.test.lua @@ -1,6 +1,6 @@ #!/usr/bin/env tarantool test = require("sqltester") -test:plan(56) +test:plan(58) --!./tcltestrunner.lua -- 2001 September 15 @@ -611,6 +611,24 @@ test:do_execsql2_test( -- SELECT * FROM [t4"abc]; -- } -- } {cnt 1 max(b+c) 5} +test:do_catchsql_test( + "temp", + [[ + CREATE TEMP TABLE + ]], { + -- + 1, "near \"TEMP\": syntax error" + -- + }) +test:do_catchsql_test( + "temporary", + [[ + CREATE TEMPORARY TABLE + ]], { + -- + 1, "near \"TEMPORARY\": syntax error" + -- + }) test:do_execsql2_test( "table-8.6", [[ -- 2.7.4