From 03b0df9481c6f83ab67c1c79d8c6cc2db0ca9223 Mon Sep 17 00:00:00 2001
From: unknown <monty@mashka.mysql.fi>
Date: Fri, 14 Mar 2003 17:08:42 +0200
Subject: Check for empty table/column names

mysql-test/t/create.test:
  Test for empty table/column name
tests/grant.pl:
  More tests
tests/grant.res:
  More tests
---
 mysql-test/t/create.test | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'mysql-test')

diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index 1a829eec6a3..b11c07e5b8d 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -59,6 +59,14 @@ create table test_$1.test2$ (a int);
 drop table test_$1.test2$;
 drop database test_$1;
 
+--error 1103
+create table `` (a int);
+--error 1103
+drop table if exists ``;
+--error 1166
+create table t1 (`` int);
+drop table if exists t1;
+
 #
 # Test of CREATE ... SELECT with indexes
 #
-- 
cgit v1.2.1


From 9681f4a8cd242e3828f211e0bed5235e70ee5f4e Mon Sep 17 00:00:00 2001
From: unknown <monty@mashka.mysql.fi>
Date: Sun, 16 Mar 2003 16:28:30 +0200
Subject: Write binlog before commit when doing INSERT ... SELECT

mysql-test/r/create.result:
  After merge fix
sql/sql_insert.cc:
  Write binlog before commit
sql/sql_update.cc:
  Added comment
---
 mysql-test/r/create.result | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'mysql-test')

diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result
index c3083dbfb03..0cc98c38d49 100644
--- a/mysql-test/r/create.result
+++ b/mysql-test/r/create.result
@@ -58,6 +58,13 @@ a$1	$b	c$
 create table test_$1.test2$ (a int);
 drop table test_$1.test2$;
 drop database test_$1;
+create table `` (a int);
+Incorrect table name ''
+drop table if exists ``;
+Incorrect table name ''
+create table t1 (`` int);
+Incorrect column name ''
+drop table if exists t1;
 create table t1 (a int auto_increment not null primary key, B CHAR(20));
 insert into t1 (b) values ("hello"),("my"),("world");
 create table t2 (key (b)) select * from t1;
-- 
cgit v1.2.1