sql-parser icon indicating copy to clipboard operation
sql-parser copied to clipboard

A validating SQL lexer and parser with a focus on MySQL dialect.

Results 107 sql-parser issues
Sort by recently updated
recently updated
newest added

Since MariaDB 10.7 a column could have a [datatype uuid](https://mariadb.com/docs/server/reference/data-types/string-data-types/uuid-data-type), but this type is not recognized by the parser: ```sql CREATE TABLE `users` ( `id` uuid NOT NULL PRIMARY );...

enhancement
kind/support

ON gets mistaken for a keyword here. There should be no error, the query works. MariaDB 11.4.4 sql-parser 5.10 & master

bug

According to the MariaDB documentation, the statement `INSTALL SONAME 'ha_rocksdb';` is valid for use. phpMyAdmin 5.2.3 has the red warning X that says "Unrecognized statement type. (near INSTALL)"

help wanted
kind/support

Fixes #607 _ and $ are also non-separator characters.

Hi, I have a problem on parsing and build an `INSERT INTO` query using `Context::SQL_MODE_POSTGRESQL`. Given this code ```php $query = "INSERT INTO foo (bar, baz) VALUES ('bar', 'baz');"; Context::setMode(Context::SQL_MODE_POSTGRESQL);...

bug

![Image](https://github.com/user-attachments/assets/30325632-04eb-4232-a82c-75318e7e97e0)