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

Query error : select @test:=Auto_increment

Open JohnDoe8521 opened this issue 8 years ago • 1 comments

Hello,

This query is valid with mysql but not with sql-parser :

select @test:=Auto_increment FROM information_schema.tables WHERE table_name='myTable'

The part "Auto_increment" seems to be the problem.

Thanks

JohnDoe8521 avatar Dec 16 '17 13:12 JohnDoe8521

Actual error with current master:

$ ./bin/lint-query --query " select @test:=Auto_increment FROM information_schema.tables WHERE table_name='myTable'"
#1: Unrecognized keyword. (near "Auto_increment" at position 15)

nijel avatar Dec 18 '17 10:12 nijel