Edgewall Software

Ticket #3669 (closed defect: fixed)

Opened 3 years ago

Last modified 3 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:

Description

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

Attachments

Change History

Changed 3 years ago by mgood

  • owner changed from jonas to mgood
  • priority changed from low to highest
  • version changed from 0.10b1 to devel
  • severity changed from normal to blocker
  • milestone set to 0.10

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.

Changed 3 years ago by mgood

  • status changed from new to closed
  • resolution set to fixed

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.

Add/Change #3669 (sqlite CAST operator breaks things for sqlite<3.2.3)

Author


E-mail address and user name can be saved in the Preferences.


Change Properties
<Author field>
Action
as closed
Next status will be 'reopened'
to The owner will change from mgood. Next status will be 'closed'
 
Note: See TracTickets for help on using tickets.