Modify ↓
Ticket #3669 (closed defect: fixed)
Opened 5 years ago
Last modified 5 years ago
sqlite CAST operator breaks things for sqlite<3.2.3
| Reported by: | mspieth@… | Owned by: | mgood |
|---|---|---|---|
| Priority: | highest | Milestone: | 0.10 |
| Component: | ticket system | Version: | devel |
| Severity: | blocker | Keywords: | |
| Cc: | |||
| Release Notes: | |||
| API Changes: | |||
Description
the CAST operator was introduced in sqlite 3.2.3
should probably be tested for like other places
Attachments
Change History
comment:1 Changed 5 years ago by mgood
- Milestone set to 0.10
- Owner changed from jonas to mgood
- Priority changed from low to highest
- Severity changed from normal to blocker
- Version changed from 0.10b1 to devel
comment:2 Changed 5 years ago by mgood
- Resolution set to fixed
- Status changed from new to closed
Ok r3699 should fix this. Using 1*column seems to behave the same as CAST(column as int) on older SQLite versions, so it should keep backwards compatibility while still fixing the ordering problems with the enum table.
Note: See
TracTickets for help on using
tickets.
I assume this is in reference to r3690. Crap. If CAST is unavailable this will need to be worked around somehow so that the problems fixed by r3690 don't return. I'll have to look at this tomorrow.