diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2021-04-27 13:00:04 +0200 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2021-04-28 09:33:55 +0200 |
| commit | 2e279962e97c03db1546d7069256ccc60d41e67e (patch) | |
| tree | 2e229944119c9b3480530041d440ae9310f9bc65 /mysql-test/main/lowercase_table.result | |
| parent | 1ca56de8a68075bd189140b1fd953262c3b39002 (diff) | |
| download | mariadb-git-2e279962e97c03db1546d7069256ccc60d41e67e.tar.gz | |
cleanup: lowercase_table.test
Diffstat (limited to 'mysql-test/main/lowercase_table.result')
| -rw-r--r-- | mysql-test/main/lowercase_table.result | 31 |
1 files changed, 24 insertions, 7 deletions
diff --git a/mysql-test/main/lowercase_table.result b/mysql-test/main/lowercase_table.result index 823ffa7696f..92dfdfdac96 100644 --- a/mysql-test/main/lowercase_table.result +++ b/mysql-test/main/lowercase_table.result @@ -1,7 +1,3 @@ -drop table if exists t1,t2,t3,t4; -drop table if exists t0,t5,t6,t7,t8,t9; -drop database if exists mysqltest; -drop view if exists v0, v1, v2, v3, v4; create table T1 (id int primary key, Word varchar(40) not null, Index(Word)); create table t4 (id int primary key, Word varchar(40) not null); INSERT INTO T1 VALUES (1, 'a'), (2, 'b'), (3, 'c'); @@ -79,13 +75,21 @@ ERROR 42000: Not unique table/alias: 'C' select C.a, c.a from t1 c, t2 C; ERROR 42000: Not unique table/alias: 'C' drop table t1, t2; +# +# Bug #9761: CREATE TABLE ... LIKE ... not handled correctly when lower_case_table_names is set +# create table t1 (a int); create table t2 like T1; drop table t1, t2; show tables; Tables_in_test +# +# End of 4.1 tests +# +# +# Bug#20404: SHOW CREATE TABLE fails with Turkish I +# set names utf8; -drop table if exists İ,İİ; create table İ (s1 int); show create table İ; Table Create Table @@ -107,7 +111,12 @@ Tables_in_test ii drop table İİ; set names latin1; -End of 5.0 tests +# +# End of 5.0 tests +# +# +# Bug#21317: SHOW CREATE DATABASE does not obey to lower_case_table_names +# create database mysql_TEST character set latin2; create table mysql_TEST.T1 (a int); show create database mysql_TEST; @@ -126,8 +135,16 @@ show databases like "mysql_TE%"; Database (mysql_TE%) mysql_test drop database mysql_TEST; -End of 10.0 tests +# +# End of 10.0 tests +# +# +# MDEV-17148 DROP DATABASE throw "Directory not empty" after changed lower_case_table_names. +# create database db1; create table t1 (a int); drop database db1; drop table t1; +# +# End of 10.2 tests +# |