CASCADE not supported (sqlite) #897
Description
I've following table in sqlite [TEMP_COMMODITY_UUIDS]:
CREATE TABLE TEMP_COMMODITY_UUIDS (
ID INTEGER NOT NULL
PRIMARY KEY AUTOINCREMENT
REFERENCES COMMODITY (ID) ON DELETE CASCADE,
UUID TEXT NOT NULL,
BACKEND_UUID TEXT
);When I try to execute in browser:
alasql([
'ATTACH SQLITE DATABASE db("test.dat");
USE db;
select * from TEMP_COMMODITY_UUIDS'
]).then(function(res){
console.log("test:",res.pop());
});
I got:
> Uncaught SyntaxError: Parse error on line 1:
...ES COMMODITY(ID) ON DELETE CASCADE, [UUI
-----------------------^
Expecting 'UPDATE', got 'DELETE'
at Parser.parser.parseError (alasql.js:2210)
at Parser.parse (alasql.js:2084)
at Function.alasql.parse (alasql.js:4396)
at alasql.js:17141
at Array.forEach (<anonymous>)
at alasql.js:17138
It seems, alasql.js (0.4.0) can't understand 'ON DELETE CASCADE' construction of sqlite.
Similar query, using sql.js directly work just right.
Thanks.