|
2015-12-31
| ||
| 23:10 | • Closed ticket [5251bd0878]: Failed to get column schema if using Indexes On Expressions plus 3 other changes artifact: 329a684b65 user: mistachkin | |
| 22:58 | Merge fix for [5251bd0878]. Update SQLite core library to the latest trunk code. Bump version to 1.0.100.0. Update version history docs. check-in: 59a224a9cf user: mistachkin tags: trunk | |
| 22:50 | Merge fix for [5251bd0878]. Update SQLite core library to the latest trunk code. Bump version to 1.0.100.0. Update version history docs. check-in: 9f0c9b796f user: mistachkin tags: updates | |
|
2015-12-14
| ||
| 20:40 | • Ticket [5251bd0878] Failed to get column schema if using Indexes On Expressions status still Pending with 3 other changes artifact: a515c02f30 user: mistachkin | |
|
2015-12-12
| ||
| 01:59 | Revise fix for [5251bd0878] to use null for the 'COLUMN_NAME' if the original value was DBNull.Value. check-in: f8c2007d48 user: mistachkin tags: tkt-5251bd0878 | |
|
2015-12-11
| ||
| 23:35 | • Pending ticket [5251bd0878]: Failed to get column schema if using Indexes On Expressions plus 7 other changes artifact: 50148645f9 user: mistachkin | |
| 23:35 | Properly handle NULL values in the 'name' column of the results returned by PRAGMA index_info(). Fix for [5251bd0878]. check-in: c93b891f69 user: mistachkin tags: tkt-5251bd0878 | |
| 23:10 | Add test case for ticket [5251bd0878]. check-in: 5f7617eb79 user: mistachkin tags: tkt-5251bd0878 | |
|
2015-12-10
| ||
| 06:47 | • New ticket [5251bd0878] Failed to get column schema if using Indexes On Expressions. artifact: e185929243 user: anonymous | |
| 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:
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: 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. | ||||