[MDEV-28159] Several tests fail on hfs+ because of lowercase table names - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 10.8(EOL)
Fix Version/s: None
Component/s: Tests
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;

@@ -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;

@@ -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

Attachments

Activity

People

Assignee:: Elena Stepanova

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2022-03-23 13:52

Updated:: 2023-04-12 09:05

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.