Opened 4 years ago

Closed 4 years ago

#1486374 closed Bugs (fixed)

SQLIte doesn't support the TRUNCATE command

Reported by: trisk Owned by:
Priority: 4 Milestone: 0.4-beta
Component: Database Version: 0.3.1
Severity: normal Keywords: sqlite truncate upgrade
Cc:

Description

r2952 added "TRUNCATE messages" to the upgrade SQL scripts.

However, TRUNCATE is not a valid command in SQLite. ​http://www.sqlite.org/lang_delete.html states that "DELETE FROM <table>" performs the same optimisation as "TRUNCATE <table>" in other databases.

Attachments (1)

truncate.diff​ (475 bytes) - added by trisk 4 years ago.
Patch SQLite upgrade script to use DELETE FROM.

Download all attachments as: .zip

Change History (2)

Changed 4 years ago by trisk

Patch SQLite upgrade script to use DELETE FROM.

comment:1 Changed 4 years ago by alec

  • Resolution set to fixed
  • Status changed from new to closed

Fixed in [9273c837].

Note: See TracTickets for help on using tickets.