Edgewall Software
Modify

Opened 18 years ago

Closed 18 years ago

#3669 closed defect (fixed)

sqlite CAST operator breaks things for sqlite<3.2.3

Reported by: mspieth@… Owned by: Matthew Good
Priority: highest Milestone: 0.10
Component: ticket system Version: devel
Severity: blocker Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

the CAST operator was introduced in sqlite 3.2.3 should probably be tested for like other places

Attachments (0)

Change History (2)

comment:1 by Matthew Good, 18 years ago

Milestone: 0.10
Owner: changed from Jonas Borgström to Matthew Good
Priority: lowhighest
Severity: normalblocker
Version: 0.10b1devel

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.

comment:2 by Matthew Good, 18 years ago

Resolution: fixed
Status: newclosed

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Matthew Good.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Matthew Good to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.