LOCK TABLE t1 AS t2 -- alias is not case sensitive 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 |

+------+

LOCK TABLE t1 AS t2 READ;

SELECT * FROM t1 AS T2;

UNLOCK TABLES;

+------+

| a    |

+------+

|    1 |

+------+

Table `T2` was not locked with LOCK TABLES"