Details
Major Description
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"
|
Attachments
Issue Links
- relates to
-
MDEV-31340 Remove MY_COLLATION_HANDLER::strcasecmp()
-
- Closed
-