sql-parser

sql-parser copied to clipboard

doesn't see missed dot-comma

1

Sample code: ``` sql START TRANSACTION; CREATE TABLE `tb_test` ( `uid` int(10) unsigned NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMIT; ``` Parser doesn't see missed dot-comma before `COMMIT;`

SailorMax

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

2

``` NOTICE: PHP message: PHP Fatal error: Uncaught TypeError: implode() expects parameter 2 to be array, null given in vendor/phpmyadmin/sql-parser/src/Utils/Routine.php:123" Stack trace:" #0 vendor/phpmyadmin/sql-parser/src/Utils/Routine.php(123): implode(',', NULL)" #1 libraries/classes/Rte/RteList.php(304): PhpMyAdmin\SqlParser\Utils\Routine::getParameters(Object(PhpMyAdmin\SqlParser\Statements\CreateStatement))" #2...

williamdes

ANSI mode not working, PHP 7

7

Hi, while investigating issue https://github.com/phpmyadmin/phpmyadmin/issues/15821 i came to conclusion, that sql-parser does not work correctly in my environment. I'm using php from sury.org, currently `2:7.4+72+0~20200122.20+debian10~1.gbpcd96c7` Using MySQL server version 8.0.18...

smarek

unrecognized multipoint and multipolygon field types

1

### Describe the bug The automatic highlighting when editing the SQL command text does not recognize multipoint and multipolygon as valid field types. ### To Reproduce Steps to reproduce the...

peterdd

unrecognised keyword 'CASE'

1

``` $ ./lint-query --query 'SELECT * FROM `Caracteristiques` WHERE CASE `an` WHEN 86400 THEN 4 WHEN 604800 THEN 5 WHEN 2419200 THEN 6 WHEN 31536000 THEN 7 ELSE -1 END...

aschuch247

The following command: ```sql ALTER TABLE orders ADD COLUMN `n_deleted_at` timestamp AS (COALESCE(deleted_at, '1980-01-01')) VIRTUAL; ``` Produces the sql-parser error "Missing comma before start of a new alter operation. (near...

bmcn99

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

1

HI! Despite I'm using your sql-parser as part of [php-sqllint](https://github.com/cweiske/php-sqllint) I think the following issue origins from sql-parser. I have the following statement: `ALTER TABLE XXX DROP COLUMN YYY, ALGORITHM=INPLACE,...

PierreKerschgens

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

4

sql query written: ```sql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourRootPassword'; -- then FLUSH PRIVILEGES; ```

soumya1810

While discovering the parser I started to wrongly add implementations, they never where pushed but here are some commit lines that pinpoint missing MariaDB commands - Add new "BACKUP {LOCK,UNLOCK}"...

williamdes

Add phpbench & improve a function

1

- Add phpbench - improve a function that costs a lot on phpMyAdmin imports (pushed onto master as 79d5db8474a029539424f2e643b90a3858862b37) ## Todo - [ ] `composer phpbench/phpbench requires php 7.2`

williamdes