Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 107758
Status: stalled
Priority: 0/
Queue: DBD-SQLite
People
Owner: Nobody in particular
Requestors: b244145 [...] tyldd.com
Cc:
AdminCc:
Bug Information
Severity: Normal
Broken in: 1.48
Fixed in: (no value)

History Show all quoted text
  Tue Oct 13 21:19:22 2015 b244145 [...] tyldd.com - Ticket created
Subject: turn on lemon/SQLITE_ENABLE_UPDATE_DELETE_LIMIT
Hello and thank you :) Please turn on SQLITE_ENABLE_UPDATE_DELETE_LIMIT Its not possible with the sources you ship, it requires generation using "lemon" http://www.sqlite.org/compile.html#enable_update_delete_limit http://www.sqlite.org/amalgamation.html http://sourceforge.net/p/brlcad/code/HEAD/tree/brlcad/trunk/misc/tools/lemon/ SQLITE_ENABLE_UPDATE_DELETE_LIMIT This option enables an optional ORDER BY and LIMIT clause on UPDATE and DELETE statements. If this option is defined, then it must also be defined when using the 'lemon' tool to generate a parse.c file. Because of this, this option may only be used when the library is built from source, not from the amalgamation or from the collection of pre-packaged C files provided for non-Unix like platforms on the website.
  Thu Oct 15 12:32:33 2015 ishigaki [...] cpan.org - Correspondence added
On Wed Oct 14 10:19:22 2015, b244145@tyldd.com wrote: Show quoted text
> Hello and thank you :) > > Please turn on SQLITE_ENABLE_UPDATE_DELETE_LIMIT > > Its not possible with the sources you ship, it requires generation > using "lemon" > > > http://www.sqlite.org/compile.html#enable_update_delete_limit > > http://www.sqlite.org/amalgamation.html > > http://sourceforge.net/p/brlcad/code/HEAD/tree/brlcad/trunk/misc/tools/lemon/ > > SQLITE_ENABLE_UPDATE_DELETE_LIMIT > > This option enables an optional ORDER BY and LIMIT clause on UPDATE > and DELETE statements. > > If this option is defined, then it must also be defined when using the > 'lemon' tool to generate a parse.c file. Because of this, this option > may only be used when the library is built from source, not from the > amalgamation or from the collection of pre-packaged C files provided > for non-Unix like platforms on the website.
SQLITE_ENABLNE_UPDATE_DELETE_LIMIT is fancy, but it is not well-accepted enough to be included in the amalgamation by the upstream maintainers. It would also impose us a significant maintenance cost, and would also conflict with rather common needs to use a different version of SQLite than the bundled version (typically, a version supported by some OS package manager). I'd be happy to turn it on if it'd be supported by the upstream and included in the amalgamation, but until then, I won't enable it.
  Thu Oct 15 12:32:34 2015 The RT System itself - Status changed from 'new' to 'open'
  Thu Oct 15 12:32:41 2015 ishigaki [...] cpan.org - Status changed from 'open' to 'stalled'