SQLite Forum

Get erron on sqlite3NestedParse API
Login

Get erron on sqlite3NestedParse API

(1) By Jerry Liu (jerry_szcn) on 2020-12-09 12:12:00 [source]

Hi,Friends,

When I porting the Sqlite in the ARM Cortex M4 MCU platform(armcc V5.06), the sqlite3NestedParse return the wrong SQL statement to parser. As below: <<raw source file sqlite3NestedParse(pParse, "UPDATE %Q.%s " "SET type='%s', name=%Q, tbl_name=%Q, rootpage=#%d, sql=%Q " "WHERE rowid=#%d", db->aDb[iDb].zDbSName, MASTER_NAME, zType, p->zName, p->zName, pParse->regRoot, zStmt, pParse->regRowid ); >>raw source file During end the create the table, Sqlite3 always to update the schema item with user column name. Actually, the API will return a "" SQL string to parser, and the schema can't get the corrected column name.

If I try to insert the row to table, it always return the error code (0x0B),because the the table always get the empty column name in the "sqlite3InitCallback API with argv[3]==0"

Aboved is my analysis, who can help to dig out the root cause and fixed it.

Thanks! Jerry