[Query] Attempt to read property "keyword" on null

[faissaloux]

This error appears when I want to access a table that has a column with a backtick on its name ( `col_one in my case ).

Note

The table must contain at least two records.

Internal error in .\vendor\phpmyadmin\sql-parser\src\Utils\Query.php#413
ErrorException: Attempt to read property "keyword" on null

Backtrace

sql-parser/src/Utils/Query.php

Line 413 in 00c8e55

$clauseType = $lexer->list->getNextOfType(TokenType::Keyword)->keyword;

Reproduce

1. Run

CREATE TABLE `table` (
  `id` int NOT NULL PRIMARY KEY AUTO_INCREMENT,
  ```col_one` int NOT NULL
);

INSERT INTO `table` (```col_one`) VALUES(1), (2);

2. Try to access the table.

[kamil-tekiela]

Cross-duplicate of phpmyadmin/phpmyadmin#19349

[kamil-tekiela]

If my PR gets merged it should fix the issue in PMA. I don't know how we can prevent this problem from occurring in sql-server though.

[williamdes]

I don't know how we can prevent this problem from occurring in sql-server though.

sql-parser

I think it will be worth investigating