sql-parser
sql-parser copied to clipboard
phpmyadmin
A validating SQL lexer and parser with a focus on MySQL dialect.
Hello. I found out that phpMyAdmin 5.2.2 is not handling stored aggregate functions defined as CREATE AGGREGATE FUNCTION described in : [https://mariadb.com/kb/en/stored-aggregate-functions/](https://mariadb.com/kb/en/stored-aggregate-functions/) I get an error if I define such...
Fixes #188 and #615
### eg: ```php $sql = statements[0]->expr); ``` output: ```sql SELECT id, pid, appid, appname, row_number() (partition by pid, appid) AS `over` FROM game GROUP BY appname ... 4 => PhpMyAdmin\SqlParser\Components\Expression...
- Fixes https://github.com/phpmyadmin/sql-parser/issues/621 We can work on `master` branch a way of extracting these tests and run them separately.
See https://github.com/phpmyadmin/sql-parser/pull/618#issuecomment-2763011771. - #618
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...
Hi there, Yesterday by copying & pasting, I ended up in this situation: UPDATE table SET field = 1 WHERE condition1; AND condition 2; Notice the ";" in after condition1....
### 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:...
### Description This PR fixes incorrect parsing of `DESC` inside index definitions in `ALTER TABLE` statements. Example: ```sql ALTER TABLE `t` ADD UNIQUE KEY `idx` (`a`, `b` DESC); ``` This...
Metadata
Owner
Metadata
A validating SQL lexer and parser with a focus on MySQL dialect.