View Ticket
Not logged in
Ticket UUID: 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:
User Comments:
anonymous added on 2015-12-10 06:47:25:

CREATE TABLE account_change(
  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:
Fixed on branch via check-in [c93b891f69483b69].

mistachkin added on 2015-12-14 20:40:17:
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:
Merged to trunk.