Ticket Hash: | 5251bd0878d6143abe06b8f6e8d04919dc0d72e4 | |||
Title: | Failed to get column schema if using Indexes On Expressions | |||
Status: | Closed | Type: | Code_Defect | |
Severity: | Important | Priority: | Medium | |
Subsystem: | Connection | Resolution: | Fixed | |
Last Modified: | 2015-12-31 23:10:20 | |||
Version Found In: | 1.0.99.0 | |||
User Comments: | ||||
anonymous added on 2015-12-10 06:47:25:
(text/x-fossil-plain)
src: https://www.sqlite.org/expridx.html CREATE TABLE account_change( chng_id INTEGER PRIMARY KEY, acct_no INTEGER REFERENCES account, location INTEGER REFERENCES locations, amt INTEGER, -- in cents authority TEXT, comment TEXT ); CREATE INDEX acctchng_magnitude ON account_change(acct_no, abs(amt)); mistachkin added on 2015-12-11 23:35:35: (text/x-fossil-plain) Fixed on branch via check-in [c93b891f69483b69]. mistachkin added on 2015-12-14 20:40:17: (text/x-fossil-plain) It should be noted that the fix for this issue simply prevents exceptions from being thrown. It does not actually populate the schema information for any indexed expressions as the necessary information is not currently available from the SQLite core library via "PRAGMA index_info". mistachkin added on 2015-12-31 23:10:20: (text/x-fossil-plain) Merged to trunk. |