[MDEV-33103] LOCK TABLE t1 AS t2 -- alias is not case sensitive with lower-case-table-names=0 - Jira

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

CREATE OR REPLACE TABLE t1 (a INT);

INSERT INTO t1 VALUES (1);

LOCK TABLE t1 AS t2 READ;

SELECT * FROM t1 AS t2;

UNLOCK TABLES;

+------+

| a    |

+------+

|    1 |

+------+

Now I run this script

LOCK TABLE t1 AS t2 READ;

SELECT * FROM t1 AS T2;

UNLOCK TABLES;

It returns a result set without errors:

+------+

| a    |

+------+

|    1 |

+------+

Looks wrong. The expected behavior would be to return this error:

Table `T2` was not locked with LOCK TABLES"

relates to

MDEV-31340 Remove MY_COLLATION_HANDLER::strcasecmp()

Alexander Barkov created issue - 2023-12-21 12:04

Alexander Barkov made changes - 2023-12-21 12:05

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

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

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

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

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

Julien Fritsch made changes - 2024-07-01 07:41

Assignee

Alexander Barkov [ bar ]

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

MariaDB Server