[MDEV-32080] Blank table alias weirdness Created: 2023-09-03  Updated: 2023-12-07

Status: Stalled
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0, 11.1
Fix Version/s: 10.6, 10.11, 11.0, 11.1

Type: Bug Priority: Minor
Reporter: Rex Johnston Assignee: Rex Johnston
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by CONC-664 test for illegal blank table alias. Open

 Description   

Oddly, this is valid.

select * from (select * from t1) as ``;

The SQL standard (2016) states this
Syntax Rules
  1) An <identifier start> is any character in the Unicode General Category classes “Lu”, “Ll”, “Lt”, “Lm”,“Lo”, or “Nl”.
    NOTE 126 — The Unicode General Category classes “Lu”, “Ll”, “Lt”, “Lm”, “Lo”, and “Nl” are assigned to Unicode
    characters that are, respectively, upper-case letters, lower-case letters, title-case letters, modifier letters, other letters, and
    letter numbers.

further https://mariadb.com/kb/en/identifier-names/ states

_Identifiers are not permitted to contain the ASCII NUL character (U+0000) and supplementary characters (U+10000 and higher). _


Generated at Thu Feb 08 10:28:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.