From dfbaa16160a82b7e70603ba89e76804ba771b7e1 Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 7 Feb 2004 00:57:22 +0400 Subject: 1. fixed bug @2593 "SHOW CREATE TABLE doesn't properly double quotes" 2. added automatic quotation of keywords in SHOW CREATE TABLE mysql-test/r/show_check.result: added tests for bug #2593 "SHOW CREATE TABLE doesn't properly double quotas" and for automatic quotation of keywords mysql-test/t/show_check.test: added tests for bug #2593 "SHOW CREATE TABLE doesn't properly double quotas" and for automatic quotation of keywords sql/mysql_priv.h: added declaration of function is_keyword sql/sql_lex.cc: added implementation of function is_keyword sql/sql_show.cc: changed function append_identifier and it's subfunctions 1. fixed bug @2593 "SHOW CREATE TABLE doesn't properly double quotes" 2. added automatic quotation of keywords --- mysql-test/t/show_check.test | 40 ++++++++++++++++++++++++++++++++++++++++ 1 file changed, 40 insertions(+) (limited to 'mysql-test/t/show_check.test') diff --git a/mysql-test/t/show_check.test b/mysql-test/t/show_check.test index d262f02c978..1d64cfd2105 100644 --- a/mysql-test/t/show_check.test +++ b/mysql-test/t/show_check.test @@ -142,3 +142,43 @@ drop table t1; create table t1 (c decimal(3,3), d double(3,3), f float(3,3)); show columns from t1; drop table t1; + +# +# Test for Bug #2593 "SHOW CREATE TABLE doesn't properly double quotes" +# + +SET sql_mode=''; +SET sql_quote_show_create=OFF; + +CREATE TABLE ```ab``cd``` (i INT); +SHOW CREATE TABLE ```ab``cd```; +DROP TABLE ```ab``cd```; + +CREATE TABLE ```ab````cd``` (i INT); +SHOW CREATE TABLE ```ab````cd```; +DROP TABLE ```ab````cd```; + +CREATE TABLE ```a` (i INT); +SHOW CREATE TABLE ```a`; +DROP TABLE ```a`; + +SET sql_mode='ANSI_QUOTES'; + +CREATE TABLE """a" (i INT); +SHOW CREATE TABLE """a"; +DROP TABLE """a"; + +# to test quotes around keywords.. : + +SET sql_mode=''; +SET sql_quote_show_create=OFF; + +CREATE TABLE t1 (i INT); +SHOW CREATE TABLE t1; +DROP TABLE t1; + +CREATE TABLE `table` (i INT); +SHOW CREATE TABLE `table`; +DROP TABLE `table`; + +SET sql_quote_show_create=ON; -- cgit v1.2.1