Describe the bug

A numeric database suffix combined with a numeric table name prefix causes a false positive SQL editor error.

To Reproduce

Steps to reproduce the behavior:

1. Go to any SQL Editor page
2. Enter
   INSERT INTO foo_1.2_bar SELECT * FROM foo;
   or
   UPDATE foo_1.2_bar SET a = 1;
3. See error

Unexpected token (near .2)

Expected behavior

Neither of these should flag as syntax errors

The bug does not affect SELECTs e.g.
SELECT * FROM foo_1.2_bar;

Screenshots

image

Server configuration

• Operating system: el8
• Database version: 10.11.7-MariaDB
• PHP version: 8.3.6
• phpMyAdmin version: 5.2.1-1

Client configuration

• Browser: Chrome
• Operating system: Win 10