SQLite

View Ticket
Login
2018-10-01
11:00
Ensure that the OP_VColumn opcode does set sqlite3_vtab_nochange() unless the OPFLAG_NOCHNG bit is set in P5. Fix for ticket [69d642332d25aa3b7315a6d385] (check-in: 31ac8dba user: drh tags: branch-3.25)
2018-09-27
20:20 Fixed ticket [69d64233]: The typeof() and length() functions fail in some virtual tables. plus 5 other changes (artifact: 8d26e66a user: drh)
20:20
Ensure that the OP_VColumn opcode does set sqlite3_vtab_nochange() unless the OPFLAG_NOCHNG bit is set in P5. Fix for ticket [69d642332d25aa3b7315a6d385] (check-in: 322ab1fc user: drh tags: trunk)
20:04 New ticket [69d64233] The typeof() and length() functions fail in some virtual tables.. (artifact: 43a256c6 user: drh)

Ticket Hash: 69d642332d25aa3b7315a6d385b7bb92b349bc19
Title: The typeof() and length() functions fail in some virtual tables.
Status: Fixed Type: Code_Defect
Severity: Severe Priority: Immediate
Subsystem: Unknown Resolution: Fixed
Last Modified: 2018-09-27 20:20:10
Version Found In: 3.25.0
User Comments:
drh added on 2018-09-27 20:04:49:

When the typeof() or length() functions are used on a column of a virtual table that makes use of the sqlite3_vtab_nochange() optimization, those functions always return NULL rather than the appropriate value.