Closed mikeschinkel closed 8 months ago
Running sqlean version 3.45.0 on macOS I get this error:
sqlean
3.45.0
Parse error near line 120: non-deterministic functions prohibited in generated columns domain VARCHAR(24) GENERATED ALWAYS AS (lower(substr(email, instr(em error here ---^
The DDL for the table is:
create table email ( email_id INTEGER primary key autoincrement, source CHAR(1), -- A=Account,C=Contact source_email VARCHAR(48), is_valid CHAR(1), email VARCHAR(48), domain VARCHAR(24) GENERATED ALWAYS AS (lower(substr(email, instr(email, '@') + 1))) );
I am assuming that lower(), substr(), and instr() are all deterministic, right?
lower()
substr()
instr()
This DDL works in sqlite3 v3.37.0.
sqlite3
v3.37.0
Sure! Fixed in 0.21.9.
Wow, talk about service! Thanks.
P.S. I have another one for you, slightly harder I expect. Issue pending.
Running
sqlean
version3.45.0
on macOS I get this error:The DDL for the table is:
I am assuming that
lower()
,substr()
, andinstr()
are all deterministic, right?This DDL works in
sqlite3
v3.37.0
.