phpmyadmin/sql-parser issues and pull requests

#610 - `ALTER TABLE ADD UNIQUE (KEY)` is not recognized as an alter option

Issue - State: closed - Opened by niconoe- about 1 year ago
Labels: bug

#609 - [Query] Attempt to read property "keyword" on null

Issue - State: open - Opened by faissaloux about 1 year ago - 3 comments
Labels: bug

#605 - Export Issue with Recursive CTEs in Views - RECURSIVE Keyword Missing

Issue - State: open - Opened by ddman over 1 year ago - 3 comments
Labels: bug

#580 - `ALTER TABLE … RENAME KEY … TO …` fails to be parsed, and subsequent issues about it

Issue - State: closed - Opened by niconoe- over 1 year ago
Labels: bug

#578 - Unable to parse table names that start with "e1"

Issue - State: closed - Opened by sergio-paternoster over 1 year ago - 8 comments
Labels: bug

#563 - Issue parsing « WITH PARSER `ngram` »

Issue - State: closed - Opened by dugwood over 1 year ago - 3 comments
Labels: bug

#560 - Fix where 0

Pull Request - State: closed - Opened by MoonE almost 2 years ago
Labels: bug

#511 - ALTER .. MODIFY ... ENUM failed! (Regression)

Issue - State: closed - Opened by BorisValgo over 2 years ago - 2 comments
Labels: bug

#508 - Leading 0x for hex cannot be written as 0X

Issue - State: closed - Opened by MauricioFauth over 2 years ago
Labels: bug

#498 - ? is not correctly parsed around `SELECT`, `LIMIT` and `OFFSET`

Issue - State: closed - Opened by BackEndTea over 2 years ago - 2 comments
Labels: bug

#497 - FORCE INDEX is not parsed correctly

Issue - State: closed - Opened by BackEndTea over 2 years ago
Labels: bug, kind/support

#492 - Missing support for SET = ?

Issue - State: closed - Opened by BackEndTea over 2 years ago - 1 comment
Labels: bug

#491 - Missing support for COLLATE inside WHERE

Issue - State: closed - Opened by BackEndTea over 2 years ago - 3 comments
Labels: bug, help wanted

#490 - BOOL type should be a valid data type

Issue - State: closed - Opened by M393 over 2 years ago - 2 comments
Labels: bug

#484 - Error with parentheses around select statement

Issue - State: open - Opened by M393 over 2 years ago
Labels: bug

#478 - `ALTER TABLE … MODIFY … ENUM('<reserved_keyword>')` is being wrongly parsed.

Issue - State: closed - Opened by niconoe- almost 3 years ago - 7 comments
Labels: bug

#450 - Parsing insert queries with functions trims commas

Issue - State: closed - Opened by gachowy almost 3 years ago - 6 comments
Labels: bug

#445 - DESCRIBE should allow schema.table

Issue - State: closed - Opened by MoonE almost 3 years ago - 2 comments
Labels: bug

#434 - No error when using UPDATE ... SET

Issue - State: closed - Opened by liviuconcioiu almost 3 years ago
Labels: bug

#431 - `ALTER USER 'public'@'%' IDENTIFIED BY 'mypassword';` not well understood

Issue - State: closed - Opened by williamdes almost 3 years ago
Labels: bug

#430 - `ALTER TABLE … RENAME COLUMN … TO …` not understood by the parser/linter

Issue - State: closed - Opened by niconoe- almost 3 years ago - 1 comment
Labels: bug

#428 - Fix TokensList::getPrevious which was not able to reach very first token

Pull Request - State: closed - Opened by Tithugues about 3 years ago - 1 comment
Labels: bug

#427 - Unrecognized keyword and Unrecognized alter operation

Issue - State: open - Opened by liviuconcioiu about 3 years ago - 3 comments
Labels: bug

#426 - Unexpected token because of missing space

Issue - State: open - Opened by liviuconcioiu about 3 years ago
Labels: bug

#425 - Support for special syntaxes for example in SQL_MODE='ORACLE'

Issue - State: open - Opened by calebdw about 3 years ago - 3 comments
Labels: bug, enhancement, kind/support

#419 - `ALTER EVENT … RENAME TO new_db.new_event;` fails to be understood correctly by the parser

Issue - State: closed - Opened by niconoe- about 3 years ago - 3 comments
Labels: bug

#418 - `ALTER EVENT` statement with `DEFINER=user` modifier fails to be parsed

Issue - State: closed - Opened by niconoe- about 3 years ago - 1 comment
Labels: bug

#415 - GROUP BY modifier WITH ROLLUP is treated as a syntax error and prevents export of SQL query results

Issue - State: closed - Opened by njandreasson about 3 years ago - 2 comments
Labels: bug

#407 - MODIFIES SQL DATA is not handled properly when exporting a stored procedure

Issue - State: closed - Opened by offsides about 3 years ago - 1 comment
Labels: bug, duplicate

#406 - Exporting procedures with 'MODIFIES SQL DATA' generates a warning in OptionsArray.php

Issue - State: closed - Opened by offsides about 3 years ago - 9 comments
Labels: bug

#405 - 'ALTER TABLE ... RENAME INDEX ...' statement not parsed correctly

Issue - State: closed - Opened by nachopitt about 3 years ago - 1 comment
Labels: bug

#404 - "ALTER EVENT" is not recognized by the SQL parser

Issue - State: closed - Opened by SanaRebhi about 3 years ago - 2 comments
Labels: bug, enhancement

#396 - Parser does not allow IS NULL in ORDER BY

Issue - State: closed - Opened by Roryvdb over 3 years ago - 1 comment
Labels: bug, enhancement

#387 - Syntax error with row_number alias

Issue - State: closed - Opened by DorianCoding over 3 years ago - 11 comments
Labels: bug

#378 - Unrecognized keyword when using 'x' as table alias

Issue - State: closed - Opened by svivian over 3 years ago - 5 comments
Labels: bug, help wanted

#377 - PARTITION syntax error

Issue - State: closed - Opened by williamdes almost 4 years ago - 1 comment
Labels: bug

#373 - WITH...AS parse errors

Issue - State: closed - Opened by ibennetch about 4 years ago - 8 comments
Labels: bug

#372 - erroneously reports syntax error when calling stored procedure with schema

Issue - State: closed - Opened by mousumis over 4 years ago - 2 comments
Labels: bug

#335 - Unable to parse table name

Issue - State: open - Opened by williamdes almost 5 years ago - 6 comments
Labels: bug

#333 - doesn't see missed dot-comma

Issue - State: open - Opened by SailorMax about 5 years ago - 1 comment
Labels: bug

#332 - Inline comments improperly removed during query

Issue - State: open - Opened by ibennetch about 6 years ago - 6 comments
Labels: bug

#327 - Parser does not recognize single character table name or alias

Issue - State: closed - Opened by joseffi about 5 years ago - 2 comments
Labels: bug

#323 - "Missing comma before start of a new alter operation. (near COALESCE)" for valid statement

Issue - State: closed - Opened by bmcn99 over 5 years ago
Labels: bug

#319 - '",": Unrecognized alter operation' when altering table with ALGORITHM and LOCK clauses

Issue - State: closed - Opened by PierreKerschgens over 5 years ago - 2 comments
Labels: bug

#316 - Missing comma before start of a new alter operation. (near "BY" at position 68) and Unrecognized alter operation. (near "BY" at position 68)

Issue - State: closed - Opened by soumya1810 over 5 years ago - 10 comments
Labels: bug

#308 - Parsing failure CREATE TABLE with order in INDEX

Issue - State: closed - Opened by Gared over 5 years ago - 4 comments
Labels: bug

#306 - Syntax error in subquery when used in SET

Issue - State: closed - Opened by rusakov92 over 5 years ago - 2 comments
Labels: bug

#298 - Subquery in expressions support

Issue - State: open - Opened by m0003r almost 6 years ago - 2 comments
Labels: bug, enhancement

#293 - NOTICE: PHP message: PHP Fatal error: Uncaught TypeError: implode() expects parameter 2 to be array, null given in src/Utils/Routine.php:123

Issue - State: closed - Opened by williamdes about 6 years ago - 13 comments
Labels: bug, invalid

#284 - ANSI mode not working, PHP 7

Issue - State: open - Opened by smarek about 6 years ago - 7 comments
Labels: bug

#283 - SQL query editor: MariaDB window function with alias gives bad linting errors

Issue - State: closed - Opened by markus-ksg about 6 years ago - 3 comments
Labels: bug

#274 - Formatter doesn't handle CASE expressions and statements

Issue - State: open - Opened by MauricioFauth about 6 years ago
Labels: bug

#269 - Parser fails for updates that include subqueries for source tables

Issue - State: open - Opened by juacala over 6 years ago - 4 comments
Labels: bug

#266 - LIMIT SYNTAX error when using SELECT FOR UPDATE

Issue - State: open - Opened by williamdes over 6 years ago - 4 comments
Labels: bug, help wanted

#262 - unrecognised keyword 'CASE'

Issue - State: open - Opened by aschuch247 over 6 years ago - 1 comment
Labels: bug, help wanted

#260 - Missing `left join` in UPDATE statement build

Issue - State: closed - Opened by wheng82 over 6 years ago - 4 comments
Labels: bug

#257 - Support multiple-table syntax of DELETE statement

Issue - State: open - Opened by JanVoracek over 6 years ago
Labels: bug

#256 - CREATE TABLE statement not properly parsed or build

Issue - State: open - Opened by DBA-HH over 6 years ago - 7 comments
Labels: bug, help wanted

#254 - Subqueries in WHERE clause

Issue - State: open - Opened by andrews05 over 6 years ago
Labels: bug, enhancement

#252 - Re-formating LIMIT destroys DELETE and UPDATE queries

Issue - State: open - Opened by werner-freytag over 6 years ago
Labels: bug

#251 - ContextMariaDb100133 does not exist

Issue - State: open - Opened by mrbrown2207 over 7 years ago - 4 comments
Labels: bug, question

#236 - "enclosed by" is not recognized by the SQL parser

Issue - State: closed - Opened by svaningelgem almost 7 years ago - 5 comments
Labels: bug

#234 - Missing comma on ALTER TABLE with ENUM

Issue - State: closed - Opened by MasterSalomon almost 7 years ago - 1 comment
Labels: bug

#226 - Parser leaves comment string at the end of the query in mysql-specific comment

Issue - State: closed - Opened by pszalko about 7 years ago
Labels: bug

#225 - Syntax error using FROM and INTO @variablename

Issue - State: open - Opened by williamdes about 7 years ago
Labels: bug

#184 - Query error : select @test:=Auto_increment

Issue - State: open - Opened by JohnDoe8521 about 8 years ago - 1 comment
Labels: bug

#179 - Linter does not recursively validate expressions

Issue - State: closed - Opened by ssandler over 8 years ago - 3 comments
Labels: bug

#171 - Use of certain keywords in SELECT field list

Issue - State: closed - Opened by stevenwdv over 8 years ago - 1 comment
Labels: bug, enhancement

#170 - Add support for CREATE TABLE tbl AS query_expression

Issue - State: open - Opened by stevenwdv over 8 years ago - 1 comment
Labels: bug

GitHub / phpmyadmin/sql-parser issues and pull requests