• Alexander Barkov's avatar
    Backporting bugs fixes fixed by MDEV-31340 from 11.5 · 310fd6ff
    Alexander Barkov authored
    The patch for MDEV-31340 fixed the following bugs:
    
    MDEV-33084 LASTVAL(t1) and LASTVAL(T1) do not work well with lower-case-table-names=0
    MDEV-33085 Tables T1 and t1 do not work well with ENGINE=CSV and lower-case-table-names=0
    MDEV-33086 SHOW OPEN TABLES IN DB1 -- is case insensitive with lower-case-table-names=0
    MDEV-33088 Cannot create triggers in the database `MYSQL`
    MDEV-33103 LOCK TABLE t1 AS t2 -- alias is not case sensitive with lower-case-table-names=0
    MDEV-33108 TABLE_STATISTICS and INDEX_STATISTICS are case insensitive with lower-case-table-names=0
    MDEV-33109 DROP DATABASE MYSQL -- does not drop SP with lower-case-table-names=0
    MDEV-33110 HANDLER commands are case insensitive with lower-case-table-names=0
    MDEV-33119 User is case insensitive in INFORMATION_SCHEMA.VIEWS
    MDEV-33120 System log table names are case insensitive with lower-cast-table-names=0
    
    Backporting the fixes from 11.5 to 10.5
    310fd6ff
temporary_tables.cc 43.7 KB