Richard Hipp wrote:
On 12/10/17, javaj1...@elxala.com <javaj1...@elxala.com> wrote:
According to the documentation UPDATE SET admits column-name-list as
argument
but I cannot get it working. Here some tries
DROP TABLE IF EXISTS test; CREATE TABLE test(a,b,c);
-- ok
UPDATE test SET a = "vala", b = "valb" ;
UPDATE test SET a = (SELECT "vala"), b = (SELECT "valb") ;
-- not ok
UPDATE test SET (a, b) = "vala", "valb" ;
Error: near "(": syntax error
UPDATE test SET (a, b) = (SELECT "vala", "valb") ;
Error: near "(": syntax error
What am I doing wrong ? or is this syntax really supported ?
It is supported beginning with SQLite 3.15.0 (2016-10-14). What
version of SQLite are you running?
Certantly! my application uses sqlite 3.17 2017-02-08 which is pretty
new and support it
but I did the check in the command line actually with an older version
(3.8.8.1 2015-01-20)
I will update this executable as well to avoid such wrong checks in future.
thank you!
PD:
-- not ok anyway (bad syntax from me)
UPDATE test SET (a, b) = "vala", "valb" ;
Error: 2 columns assigned 1 values
-- both ok
UPDATE test SET (a, b) = ("vala", "valb") ;
UPDATE test SET (a, b) = (SELECT "vala", "valb") ;
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
