Tarantool development patches archive
 help / color / mirror / Atom feed
From: Roman Khabibov <roman.habibov1@yandex.ru>
To: tarantool-patches@freelists.org
Cc: v.shpilevoy@tarantool.org, Roman Khabibov <roman.habibov1@yandex.ru>
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	[thread overview]
Message-ID: <aae0bec697872f421cf229b02ae3fc5f93a2b24e.1525474833.git.roman.habibov1@yandex.ru> (raw)

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
+	]], {
+	-- <temp>
+	1, "near \"TEMP\": syntax error"
+	-- <temp>
+	})
+test:do_catchsql_test(
+	"temporary",
+	[[
+		CREATE TEMPORARY TABLE
+	]], {
+	-- <temporary>
+	1, "near \"TEMPORARY\": syntax error"
+	-- <temporary>
+	})
 test:do_execsql2_test(
     "table-8.6",
     [[
-- 
2.7.4

             reply	other threads:[~2018-05-05 22:34 UTC|newest]

Thread overview: 15+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2018-05-05 22:34 Roman Khabibov [this message]
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
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=aae0bec697872f421cf229b02ae3fc5f93a2b24e.1525474833.git.roman.habibov1@yandex.ru \
    --to=roman.habibov1@yandex.ru \
    --cc=tarantool-patches@freelists.org \
    --cc=v.shpilevoy@tarantool.org \
    --subject='Re: [tarantool-patches] [PATCH v1 1/1] Tests for CREATE TEMP TABLE and  CREATE TEMPORARY TABLE' \
    /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