auto_increment ordering breaks parse, no error returned

[earonesty]

the following results in "None", no errors

create table "foo" ("auto" integer not null primary key auto_increment,"inty" integer not null default(4),"blob" blob,"blob3" binary(3),"blob4" varbinary(4),"tex" text not null,"siz3v" varchar(3),"siz3" character(3),"flt" float default(1.1),"dbl" double default(2.2));

if i knew a bit more about how the yacc module worked, i would fix it, looking at it now

looks like the mysql auto_increment breaks it, even though this executes correctly in mysql

[xnuinside]

@earonesty thanks for reporting it, honestly it is a second issue about increment & I already started work on fix for that but didn’t finished yet. I have some time on Sunday - will try to work on it

[xnuinside]

@earonesty in your ddl also one more interesting issue! my parser totally unsupport floats :) will fix it, thanks one more time!

[xnuinside]

@earonesty I just released version 0.28.0 https://pypi.org/project/simple-ddl-parser/, both issues was fixed, I also added test for your sample: https://github.com/xnuinside/simple-ddl-parser/blob/main/tests/test_simple_ddl_parser.py#L2791

If will be needed anything else - feel free to open new issue. And thanks one more time!