sqlite3_sql return value
(1) By anonymous on 2021-09-23 10:55:52 [source]
I am on the wal2 branch.
prepare with this sql:
" REPLACE INTO tab1 VALUES(abs(random() % 100)); REPLACE INTO tab1 VALUES(abs(random() % 100)); REPLACE INTO tab1 VALUES(abs(random() % 100)); REPLACE INTO tab1 VALUES(abs(random() % 100)); REPLACE INTO tab1 VALUES(abs(random() % 100)); "
sqlite3_sql only return this:
" REPLACE INTO tab1 VALUES(abs(random() % 100)); "
Is this correct ? how I can get the full SQL related with the stmt ?
(2) By Larry Brasfield (larrybr) on 2021-09-23 11:06:28 in reply to 1 [link] [source]
You may have noticed a parameter, pzTail, in the sqlite3_prepare() signatures. The prepare operation only operates upon one SQL statement at a time, but if you ask for it (by setting the pzTail pointer to reference a char *), the prepare will let you know where the remainder of your submitted string begins.
What you see is correct. See the prepare doc.