[MDEV-28159] Several tests fail on hfs+ because of lowercase table names Created: 2022-03-23  Updated: 2023-04-12

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.8
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Alice Sherepa Assignee: Elena Stepanova
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Ubuntu 20.04 + partition formatted as hfsplus:
10.8 f6fcf827b379fc069563d18. I did not try on the other versions.

rpl.rpl_stm_lcase_tblnames 'innodb,mix'  w5 [ fail ]
 
        Test ended at 2022-03-23 05:45:46
 
 
 
CURRENT_TEST: rpl.rpl_stm_lcase_tblnames
 
--- /10.8/mysql-test/suite/rpl/r/rpl_stm_lcase_tblnames.result	2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/rpl/r/rpl_stm_lcase_tblnames.reject	2022-03-23 05:45:46.000000000 +0100
 
@@ -18,9 +18,9 @@
 
 CREATE TABLE T3 (txt TEXT);
 
 show tables;
 
 Tables_in_BUG_37656
 
-T1
 
-T2
 
-T3
 
+t1
 
+t2
 
+t3
 
 connection slave;
 
 ******** [ SLAVE ] ********
 
 use bug_37656;
 
 
 
mysqltest: Result content mismatch
 
 
 
rpl.rpl_lcase_tblnames_rewrite_db 'mix'  w3 [ fail ]
 
        Test ended at 2022-03-23 05:46:23
 
 
 
CURRENT_TEST: rpl.rpl_lcase_tblnames_rewrite_db
 
--- /10.8/mysql-test/suite/rpl/r/rpl_lcase_tblnames_rewrite_db.result    2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/rpl/r/rpl_lcase_tblnames_rewrite_db.reject    2022-03-23 05:46:23.000000000 +0100
 
@@ -16,7 +16,7 @@
 
 ### assertion: master contains capitalized case table
 
 SHOW TABLES;
 
 Tables_in_B37656
 
-T1
 
+t1
 
 connection slave;
 
 use bug37656;
 
 ### assertion: slave contains lowered case table
 
 
 
mysqltest: Result content mismatch
 
 
 
 
 
rpl.rpl_row_lcase_tblnames 'innodb,row'  w6 [ fail ]
 
        Test ended at 2022-03-23 05:46:53
 
 
 
CURRENT_TEST: rpl.rpl_row_lcase_tblnames
 
--- /10.8/mysql-test/suite/rpl/r/rpl_row_lcase_tblnames.result   2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/rpl/r/rpl_row_lcase_tblnames.reject   2022-03-23 05:46:52.000000000 +0100
 
@@ -18,9 +18,9 @@
 
 CREATE TABLE T3 (txt TEXT);
 
 show tables;
 
 Tables_in_BUG_37656
 
-T1
 
-T2
 
-T3
 
+t1
 
+t2
 
+t3
 
 connection slave;
 
 ******** [ SLAVE ] ********
 
 use bug_37656;
 
 
 
mysqltest: Result content mismatch
 
 
 
rpl.rpl_lcase_tblnames_rewrite_db 'row'  w4 [ fail ]
 
        Test ended at 2022-03-23 05:48:23
 
 
 
CURRENT_TEST: rpl.rpl_lcase_tblnames_rewrite_db
 
--- /10.8/mysql-test/suite/rpl/r/rpl_lcase_tblnames_rewrite_db.result    2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/rpl/r/rpl_lcase_tblnames_rewrite_db.reject    2022-03-23 05:48:23.000000000 +0100
 
@@ -16,7 +16,7 @@
 
 ### assertion: master contains capitalized case table
 
 SHOW TABLES;
 
 Tables_in_B37656
 
-T1
 
+t1
 
 connection slave;
 
 use bug37656;
 
 ### assertion: slave contains lowered case table
 
 
 
mysqltest: Result content mismatch
 
 
 
rpl.rpl_stm_lcase_tblnames 'innodb,stmt' w3 [ fail ]
 
        Test ended at 2022-03-23 05:49:00
 
 
 
CURRENT_TEST: rpl.rpl_stm_lcase_tblnames
 
--- /10.8/mysql-test/suite/rpl/r/rpl_stm_lcase_tblnames.result   2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/rpl/r/rpl_stm_lcase_tblnames.reject   2022-03-23 05:49:00.000000000 +0100
 
@@ -18,9 +18,9 @@
 
 CREATE TABLE T3 (txt TEXT);
 
 show tables;
 
 Tables_in_BUG_37656
 
-T1
 
-T2
 
-T3
 
+t1
 
+t2
 
+t3
 
 connection slave;
 
 ******** [ SLAVE ] ********
 
 use bug_37656;
 
 
 
mysqltest: Result content mismatch
 
 
 
rpl.rpl_lcase_tblnames_rewrite_db 'stmt' w1 [ fail ]
 
        Test ended at 2022-03-23 05:50:59
 
 
 
CURRENT_TEST: rpl.rpl_lcase_tblnames_rewrite_db
 
--- /10.8/mysql-test/suite/rpl/r/rpl_lcase_tblnames_rewrite_db.result    2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/rpl/r/rpl_lcase_tblnames_rewrite_db.reject    2022-03-23 05:50:59.000000000 +0100
 
@@ -16,7 +16,7 @@
 
 ### assertion: master contains capitalized case table
 
 SHOW TABLES;
 
 Tables_in_B37656
 
-T1
 
+t1
 
 connection slave;
 
 use bug37656;
 
 ### assertion: slave contains lowered case table
 
 
 
mysqltest: Result content mismatch
 
 
 
atomic.drop_db_long_names                w4 [ fail ]
 
        Test ended at 2022-03-23 06:06:50
 
 
 
CURRENT_TEST: atomic.drop_db_long_names
 
--- /10.8/mysql-test/suite/atomic/drop_db_long_names.result      2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/atomic/drop_db_long_names.reject      2022-03-23 06:06:50.000000000 +0100
 
@@ -1,11 +1,11 @@
 
 RESET MASTER;
 
 "engine: aria  crash point: ddl_log_drop_after_drop_tables  position: 1"
 
-master-bin.000002      #       Query   #       #       use `test2`; DROP TABLE IF EXISTS `tABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB`,`tACCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC`,`tADDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD`,`tAEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE`,`tAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF`,`tAGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG`,`tAHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH`,`tAIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII`,`tAJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJ`,`tAKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK`,`tALLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL` /* generated by ddl recovery */
 
-master-bin.000002      #       Query   #       #       use `test2`; DROP VIEW IF EXISTS `tABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBv`,`tACCCCCCCCCCCCCCCCCCCCCCCCCCCCCCv`,`tADDDDDDDDDDDDDDDDDDDDDDDDDDDDDDv`,`tAEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEv`,`tAFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFv`,`tAGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGv`,`tAHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHv`,`tAIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIv`,`tAJJJJJJJJJJJJJJJJJJJJJJJJJJJJJJv`,`tAKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKv` /* generated by ddl recovery */
 
-master-bin.000002      #       Query   #       #       use `test2`; DROP TABLE IF EXISTS `tAMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMM`,`tANNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNNN`,`tAOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO`,`tAPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP`,`tAQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQ`,`tARRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR`,`tASSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS`,`tATTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT`,`tAUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU`,`tAVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVV`,`tAWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW` /* generated by ddl recovery */
 
-master-bin.000002      #       Query   #       #       use `test2`; DROP VIEW IF EXISTS `tALLLLLLLLLLLLLLLLLLLLLLLLLLLLLLv`,`tAMMMMMMMMMMMMMMMMMMMMMMMMMMMMMMv`,`tANNNNNNNNNNNNNNNNNNNNNNNNNNNNNNv`,`tAOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOv`,`tAPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPv`,`tAQQQQQQQQQQQQQQQQQQQQQQQQQQQQQQv`,`tARRRRRRRRRRRRRRRRRRRRRRRRRRRRRRv`,`tASSSSSSSSSSSSSSSSSSSSSSSSSSSSSSv`,`tATTTTTTTTTTTTTTTTTTTTTTTTTTTTTTv`,`tAUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUv`,`tAVVVVVVVVVVVVVVVVVVVVVVVVVVVVVVv` /* generated by ddl recovery */
 
-master-bin.000002      #       Query   #       #       use `test2`; DROP TABLE IF EXISTS `tAXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX`,`tAYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY`,`tAZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ`,`tBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA`,`tBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB`,`tBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC`,`tBDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDD`,`tBEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE` /* generated by ddl recovery */
 
-master-bin.000002      #       Query   #       #       use `test2`; DROP VIEW IF EXISTS `tAWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWv`,`tAXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXv`,`tAYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYv`,`tAZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZv`,`tBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAv`,`tBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBv`,`tBCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCv`,`tBDDDDDDDDDDDDDDDDDDDDDDDDDDDDDDv`,`tBEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEv` /* generated by ddl recovery */
 
+master-bin.000002      #       Query   #       #       use `test2`; DROP TABLE IF EXISTS `tabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb`,`tacccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc`,`tadddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd`,`taeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee`,`taffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff`,`tagggggggggggggggggggggggggggggggggggggggggggggggggggggggggggg`,`tahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh`,`taiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii`,`tajjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj`,`takkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk`,`tallllllllllllllllllllllllllllllllllllllllllllllllllllllllllll` /* generated by ddl recovery */
 
+master-bin.000002      #       Query   #       #       use `test2`; DROP VIEW IF EXISTS `tabbbbbbbbbbbbbbbbbbbbbbbbbbbbbbv`,`taccccccccccccccccccccccccccccccv`,`taddddddddddddddddddddddddddddddv`,`taeeeeeeeeeeeeeeeeeeeeeeeeeeeeeev`,`taffffffffffffffffffffffffffffffv`,`taggggggggggggggggggggggggggggggv`,`tahhhhhhhhhhhhhhhhhhhhhhhhhhhhhhv`,`taiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiv`,`tajjjjjjjjjjjjjjjjjjjjjjjjjjjjjjv`,`takkkkkkkkkkkkkkkkkkkkkkkkkkkkkkv` /* generated by ddl recovery */
 
+master-bin.000002      #       Query   #       #       use `test2`; DROP TABLE IF EXISTS `tammmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm`,`tannnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn`,`taoooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo`,`tapppppppppppppppppppppppppppppppppppppppppppppppppppppppppppp`,`taqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq`,`tarrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr`,`tassssssssssssssssssssssssssssssssssssssssssssssssssssssssssss`,`tatttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt`,`tauuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu`,`tavvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv`,`tawwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww` /* generated by ddl recovery */
 
+master-bin.000002      #       Query   #       #       use `test2`; DROP VIEW IF EXISTS `tallllllllllllllllllllllllllllllv`,`tammmmmmmmmmmmmmmmmmmmmmmmmmmmmmv`,`tannnnnnnnnnnnnnnnnnnnnnnnnnnnnnv`,`taoooooooooooooooooooooooooooooov`,`tappppppppppppppppppppppppppppppv`,`taqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqv`,`tarrrrrrrrrrrrrrrrrrrrrrrrrrrrrrv`,`tassssssssssssssssssssssssssssssv`,`tattttttttttttttttttttttttttttttv`,`tauuuuuuuuuuuuuuuuuuuuuuuuuuuuuuv`,`tavvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv`,`tawwwwwwwwwwwwwwwwwwwwwwwwwwwwwwv` /* generated by ddl recovery */
 
+master-bin.000002      #       Query   #       #       use `test2`; DROP TABLE IF EXISTS `taxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx`,`tayyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy`,`tazzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz`,`tbaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa`,`tbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb`,`tbcccccccccccccccccccccccccccccccccccccccccccccccccccccccccccc`,`tbdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd`,`tbeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee` /* generated by ddl recovery */
 
+master-bin.000002      #       Query   #       #       use `test2`; DROP VIEW IF EXISTS `taxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxv`,`tayyyyyyyyyyyyyyyyyyyyyyyyyyyyyyv`,`tazzzzzzzzzzzzzzzzzzzzzzzzzzzzzzv`,`tbaaaaaaaaaaaaaaaaaaaaaaaaaaaaaav`,`tbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbv`,`tbccccccccccccccccccccccccccccccv`,`tbddddddddddddddddddddddddddddddv`,`tbeeeeeeeeeeeeeeeeeeeeeeeeeeeeeev` /* generated by ddl recovery */
 
 "engine: aria  crash point: ddl_log_drop_before_binlog  position: 1"
 
 master-bin.000002      #       Query   #       #       DROP DATABASE IF EXISTS `test2` /* generated by ddl recovery */
 
 Warnings:
 
 
 
mysqltest: Result content mismatch
 
 
 
 
 
atomic.rename_case                       w7 [ fail ]
 
        Test ended at 2022-03-23 06:10:45
 
 
 
CURRENT_TEST: atomic.rename_case
 
--- /10.8/mysql-test/suite/atomic/rename_case.result     2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/atomic/rename_case.reject     2022-03-23 06:10:45.000000000 +0100
 
@@ -37,9 +37,6 @@
 
 T2.MYD
 
 T2.MYI
 
 T2.frm
 
-T4.MYD
 
-T4.MYI
 
-T4.frm
 
 db.opt
 
 t1.MYD
 
 t1.MYI
 
@@ -47,6 +44,9 @@
 
 t3.MYD
 
 t3.MYI
 
 t3.frm
 
+t4.MYD
 
+t4.MYI
 
+t4.frm
 
 # Cleanup
 
 drop table t1,T2,t3,T4;
 
 drop database test2;
 
 
 
mysqltest: Result content mismatch
 
 
 
compat/oracle.sp-inout                   w7 [ fail ]
 
        Test ended at 2022-03-23 06:11:06
 
 
 
CURRENT_TEST: compat/oracle.sp-inout
 
--- /10.8/mysql-test/suite/compat/oracle/r/sp-inout.result       2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/suite/compat/oracle/r/sp-inout.reject       2022-03-23 06:11:06.000000000 +0100
 
@@ -727,7 +727,7 @@
 
 3      CCC     30
 
 set @a = 0;
 
 INSERT INTO Persons SELECT 5, 'EEE', PKG2.func(@a);
 
-ERROR HY000: OUT or INOUT argument 1 for function PKG2.func is not allowed here
 
+ERROR HY000: OUT or INOUT argument 1 for function pkg2.func is not allowed here
 
 DROP TABLE Persons;
 
 DROP PACKAGE pkg2;
 
 # 
@@ -808,7 +808,7 @@
 
 4      DDD     40
 
 set @a = 0;
 
 DELETE FROM Persons WHERE ID = PKG2.func(@a);
 
-ERROR HY000: OUT or INOUT argument 1 for function PKG2.func is not allowed here
 
+ERROR HY000: OUT or INOUT argument 1 for function pkg2.func is not allowed here
 
 DROP TABLE Persons;
 
 DROP PACKAGE pkg2;
 
 # 
 
 
mysqltest: Result content mismatch
 
 
 
 
 
main.lowercase_table2 'innodb'           w3 [ fail ]
 
        Test ended at 2022-03-23 06:15:55
 
 
 
CURRENT_TEST: main.lowercase_table2
 
--- /10.8/mysql-test/main/lowercase_table2.result        2022-03-22 22:11:53.000000000 +0100
 
+++ /10.8/mysql-test/main/lowercase_table2.reject        2022-03-23 06:15:54.000000000 +0100
 
@@ -6,10 +6,10 @@
 
 INSERT INTO T1 VALUES (1);
 
 SHOW TABLES LIKE "T1";
 
 Tables_in_test (T1)
 
-T1
 
+t1
 
 SHOW TABLES LIKE "t1";
 
 Tables_in_test (t1)
 
-T1
 
+t1
 
 SHOW CREATE TABLE T1;
 
 Table  Create Table
 
 T1     CREATE TABLE `T1` (
 
@@ -18,7 +18,7 @@
 
 RENAME TABLE T1 TO T2;
 
 SHOW TABLES LIKE "T2";
 
 Tables_in_test (T2)
 
-T2
 
+t2
 
 SELECT * FROM t2;
 
 a
 
 1
 
@@ -37,7 +37,7 @@
 
 ALTER TABLE T1 RENAME T2;
 
 SHOW TABLES LIKE "T2";
 
 Tables_in_test (T2)
 
-T2
 
+t2
 
 LOCK TABLE T2 WRITE;
 
 ALTER TABLE T2 drop b;
 
 SHOW TABLES LIKE "T2";
 
@@ -93,12 +93,12 @@
 
 ALTER TABLE T1 RENAME T2;
 
 SHOW TABLES LIKE "T2";
 
 Tables_in_test (T2)
 
-T2
 
+t2
 
 LOCK TABLE T2 WRITE;
 
 ALTER TABLE T2 drop b;
 
 SHOW TABLES LIKE "T2";
 
 Tables_in_test (T2)
 
-T2
 
+t2
 
 UNLOCK TABLES;
 
 RENAME TABLE T2 TO T1;
 
 SHOW TABLES LIKE "T1";
 
@@ -158,7 +158,7 @@
 
 create table myUC (i int);
 
 show tables;
 
 Tables_in_mysqltest_LC2
 
-myUC
 
+myuc
 
 insert into myUC values (1),(2),(3);
 
 select * from myUC;
 
 i
 
@@ -185,7 +185,7 @@
 
 select TABLE_SCHEMA,TABLE_NAME FROM information_schema.TABLES
 
 where TABLE_SCHEMA ='mysqltest_LC2';
 
 TABLE_SCHEMA   TABLE_NAME
 
-mysqltest_lc2  myUC
 
+mysqltest_lc2  myuc
 
 use test;
 
 drop database mysqltest_LC2;
 
 #
 
@@ -214,7 +214,7 @@
 
   ORDER BY trigger_schema, trigger_name;
 
 trigger_schema trigger_name    event_object_table
 
 BUP_XPFM_COMPAT_DB2    trigger1        table1
 
-BUP_XPFM_COMPAT_DB2    TRIGGER2        TABLE2
 
+BUP_XPFM_COMPAT_DB2    TRIGGER2        table2
 
 BUP_XPFM_COMPAT_DB2    TrigGer3        table3
 
 DROP DATABASE BUP_XPFM_COMPAT_DB2;
 
 # End of 5.1 tests
 
@@ -248,8 +248,8 @@
 
 table_schema   table_name      table_comment
 
 mysqltest_UPPERCASE    t_bug44738_lowercase    Old comment
 
 mysqltest_UPPERCASE    t_bug44738_lowercase2   Old comment
 
-mysqltest_UPPERCASE    t_bug44738_UPPERCASE    Old comment
 
-mysqltest_UPPERCASE    t_bug44738_UPPERCASE2   Old comment
 
+mysqltest_UPPERCASE    t_bug44738_uppercase    Old comment
 
+mysqltest_UPPERCASE    t_bug44738_uppercase2   Old comment
 
 alter table t_bug44738_UPPERCASE comment='New comment';
 
 alter table t_bug44738_lowercase comment='New comment';
 
 alter table mysqltest_uppercase.t_bug44738_UPPERCASE2 comment='New comment';
 
@@ -263,8 +263,8 @@
 
 table_schema   table_name      table_comment
 
 mysqltest_UPPERCASE    t_bug44738_lowercase    New comment
 
 mysqltest_UPPERCASE    t_bug44738_lowercase2   New comment
 
-mysqltest_UPPERCASE    t_bug44738_UPPERCASE    New comment
 
-mysqltest_UPPERCASE    t_bug44738_UPPERCASE2   New comment
 
+mysqltest_UPPERCASE    t_bug44738_uppercase    New comment
 
+mysqltest_UPPERCASE    t_bug44738_uppercase2   New comment
 
 drop database mysqltest_UPPERCASE;
 
 use test;
 
 # Let us check that the original test case which led to discovery
 
 
 
mysqltest: Result content mismatch


Generated at Thu Feb 08 09:58:31 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.