[MDEV-33110] HANDLER commands are case insensitive with lower-case-table-names=0 - Jira

I execute this SQL script with a Linux MariaDB server running with --lower-case-table-names=0:

CREATE OR REPLACE TABLE t1 (a INT);

INSERT INTO t1 VALUES (1),(2);

HANDLER t1 OPEN;

HANDLER t1 READ FIRST;

CREATE OR REPLACE TABLE T1 (a INT);

DROP TABLE T1;

HANDLER t1 READ NEXT;

ERROR 1109 (42S02): Unknown table 't1' in HANDLER

The above looks wrong. This command should return the second record from `t1`.

The problem is in this code fragment in mysql_ha_find_match() in sql_handler.cc:

      if ((! tables->db.str[0] ||

          ! my_strcasecmp(&my_charset_latin1, hash_tables->db.str,

                          tables->get_db_name())) &&

          ! my_strcasecmp(&my_charset_latin1, hash_tables->table_name.str,

                          tables->get_table_name()))

It compares table and db names in case insensitive style. Also, it erroneously uses latin1 as a character set.

relates to

MDEV-31340 Remove MY_COLLATION_HANDLER::strcasecmp()

Alexander Barkov created issue - 2023-12-22 08:20

Alexander Barkov made changes - 2023-12-22 08:20

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-31340~~ [ ~~MDEV-31340~~ ]

Alexander Barkov made changes - 2024-05-21 13:08

Alexander Barkov made changes - 2024-05-21 13:09

Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Alexander Barkov made changes - 2024-05-21 13:09

Assignee

Alexander Barkov [ bar ]

Daniel Bartholomew made changes - 2024-05-29 17:14

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

MariaDB Server