Changes between Initial Version and Version 2 of Ticket #350
- Timestamp:
- Aug 19, 2005, 4:27:41 PM (19 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #350
- Property Status new → assigned
-
Ticket #350 – Description
initial v2 1 When you use the D hango API to query your data using the get_items(offset=X) style call, the SQL that is actually generated seems to be in a Postgres style that is only recently supported in MySQL (4.x and later, as far as I can tell.) To be clear, the SQL generated is something like the following:1 When you use the Django API to query your data using the {{{get_items(offset=X)}}} style call, the SQL that is generated seems to be in Postgres style that is only recently supported in MySQL (4.x and later, as far as I can tell.) The SQL generated is something like the following: 2 2 3 {{{ 3 4 SELECT ... ORDER BY ... DESC LIMIT 5 OFFSET 4 5 }}} 4 6 5 7 On MySQL 3.x this gives the following error: 6 8 9 {{{ 7 10 "You have an error in your SQL syntax near 'OFFSET 4 '" 11 }}} 8 12 9 13 It works fine on my 4.1. … … 11 15 As far as I can tell from the MySQL manual, there is an alternate form of query that should work on all versions of MySQL. Here's the relevant snippet from the SELECT format: 12 16 17 {{{ 13 18 [LIMIT {[offset,] row_count | row_count OFFSET offset}] 19 }}} 14 20 15 21 Since 3.23 is the default MySQL version for Fedora Core etc, this could affect quite a few people. 16