I'm using SQLite only for private purpose. This also allows me to try incredably complex queries. And find that SQLite is reliable indeed and fast. Currently I try to execute a script of 30 statements from inside a trigger. And amazed to not have any error. Except one, when using the new functionality for row values from inside a trigger. The example below shows an update that works as a plain statement and fails from inside a trigger. This case luckily raises an error. When supplying just two values the error is not reported. Possibly something is still wrong then.
SQLite version is 3.15.2. create table t(a,b,c) ; insert into t values(1,2,3) ; update t set (a,b,c)=(select 4,5,6) ; select * from t ; 4|5|6 create table step (step integer primary key) ; create trigger trg_step insert on step begin update t set (a,b,c)=(select 7,8,9); end ; Error: near line 17: Expression tree is too large (maximum depth 1000) select * from t ; 4|5|6 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
