Skip to content

Parser crashes with complex default values #1950

@ghost

Description

The parser crashed with a table with a definition like this:

CREATE TABLE IF NOT EXISTS lkpcrop_yield_units(
crop_yield_units_cod varchar(2) NOT NULL, 
crop_yield_units_des varchar(16) , 
rowuuid varchar(80) DEFAULT (hex( randomblob(4)) || '-' || hex( randomblob(2)) || '-' || '4' || substr( hex( randomblob(2)), 2) || '-' || substr('AB89', 1 + (abs(random()) % 4) , 1)  || substr(hex(randomblob(2)), 2) || '-' || hex(randomblob(6))) , 
PRIMARY KEY (crop_yield_units_cod) , UNIQUE(rowuuid));

The message is:
Warning: There is something with this table definition that our parser doesn't fully understand. Modifying and saving the table might result in problems.

Version 3.11.99 (Jul 23 2019)
Built for x86_64-little_endian-lp64, running on x86_64
Qt Version 5.9.5
SQLite Version 3.22.0

Metadata

Metadata

Assignees

Labels

bugConfirmed bugs or reports that are very likely to be bugs.

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions