Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT

2018-10-16 Thread Olivier Mascia
> Le 16 oct. 2018 à 16:39, Olivier Mascia a écrit : > > https://www.sqlite.org/compile.html#enable_update_delete_limit ... > I can manage to run the build tools properly, for the target sqlite3.c or > sqlite_analyzer.exe for instance. I'm just not confident yet as to where to > start to patch t

[sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT

2018-10-16 Thread Olivier Mascia
https://www.sqlite.org/compile.html#enable_update_delete_limit > 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 > parser generato

[sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT - my "final" patch

2017-02-11 Thread Ziemowit Laski
Hello again, So after discussions with Jan and further contemplation, I concluded that the only way to get a hold on the '#line ... ' issues in the generated parse.c is to write a dedicated tool to do it. The patch herein contains such a tool, named 'lineclean'. The tool detects sequences of

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT (Was: Patch Etiquette)

2017-02-09 Thread Ziemowit Laski
Hi Jan, Thanks for trying out my patch, and for your improvement. If I may suggest one thing: change the 'for alignment' comments to something more informative, e.g., 'please keep this line for SQLITE_ENABLE_UPDATE_DELETE_LIMIT debugging'. I also toyed with the idea of running lemon with '-l'

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT (Was: Patch Etiquette)

2017-02-08 Thread Jan Nijtmans
2017-02-06 23:25 GMT+01:00 Ziemowit Laski: > Here is my approach to the SQLITE_ENABLE_UPDATE_DELETE_LIMIT problem. [If > the attachment does not arrive intact, please let me know.] Hi Ziemowit, I tried your patch, and it works fine! Below is an additional patch, which makes the resulting amalgam

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT (Was: Patch Etiquette)

2017-02-08 Thread Ziemowit Laski
Hello, I checked the message archive and it appears that the attachment got stripped from my previous message. So I'm plastering it inline below. Thank you, --Zem diff -C5 sqlitesrc2/sqlite-src-3160200/main.mk sqlitesrc3/sqlite-src-3160200/main.mk *** sqlitesrc2/sqlite-src-3160200/main.mk

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT (Was: Patch Etiquette)

2017-02-06 Thread Ziemowit Laski
Hello Jan + Maintainers, Here is my approach to the SQLITE_ENABLE_UPDATE_DELETE_LIMIT problem. [If the attachment does not arrive intact, please let me know.] It is different from Jan's in that it operates strictly on the Makefile level. The idea is simple: When compiling parse.y with lemon,

[sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT (Was: Patch Etiquette)

2017-02-06 Thread Ziemowit Laski
Hi Jan, Thank you for the link. I'll take a look. --Zem [P.S. It appears I cannot reply to the whole list directly from the https://www.mail-archive.com/sqlite-users webpage. Is this because I'm not (yet) a members of the list?] ___ sqlite-users ma

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-07 Thread Andy Froncioni
>> See? That's how I read this, too. Oh, well... I've wasted more >> time >> on stupider things than this, so it's no use cying over spilled >> milk. :-) > > This, at least, seems pretty clear: > > > http://sqlite.org/compile.html#enable_update_delete_limit Yup, you're right, Jay. I don't

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-06 Thread Jay A. Kreibich
On Mon, Jul 06, 2009 at 01:22:52PM -0400, Andy Froncioni scratched on the wall: > > On 6-Jul-09, at 1:20 PM, D. Richard Hipp wrote: > > At http://www.sqlite.org/compile.html under section 1.6, it says you > > cannot use SQLITE_OMIT_ compile-time options with the amalgamation. > > The documentation

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-06 Thread Dan
On Jul 7, 2009, at 1:56 AM, Andy Froncioni wrote: >> On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote: >> >>> I know I'm probably doing something wrong, but I can't seem to get >>> a simple UPDATE...LIMIT query working. >>> >>> sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10; >>> SQL

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-06 Thread Andy Froncioni
> On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote: > >> I know I'm probably doing something wrong, but I can't seem to get >> a simple UPDATE...LIMIT query working. >> >> sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10; >> SQL error: near "LIMIT": syntax error >> >> >> I have compiled

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-06 Thread Andy Froncioni
On 6-Jul-09, at 1:20 PM, D. Richard Hipp wrote: > At http://www.sqlite.org/compile.html under section 1.6, it says you > cannot use SQLITE_OMIT_ compile-time options with the amalgamation. > The documentation never says you cannot use > SQLITE_ENABLE_UPDATE_DELETE_LIMIT with the amalgamation, but

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-06 Thread D. Richard Hipp
On Jul 6, 2009, at 1:03 PM, Andy Froncioni wrote: >> >> You will need to build from the source tarball (the one with the >> unsupported configure script), not the amalgamation package for >> this to work. > > Thanks a bunch. I'll try that... > > But I don't remember reading that the tarball I use

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-06 Thread Andy Froncioni
On 6-Jul-09, at 12:18 PM, Dan wrote: > > On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote: > >> I know I'm probably doing something wrong, but I can't seem to get >> a simple UPDATE...LIMIT query working. >> >> sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10; >> SQL error: near "LIMIT

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-06 Thread Dan
On Jul 6, 2009, at 11:08 PM, Andy Froncioni wrote: > I know I'm probably doing something wrong, but I can't seem to get > a simple UPDATE...LIMIT query working. > > sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10; > SQL error: near "LIMIT": syntax error > > > I have compiled sqlite3 wi

[sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT Works?

2009-07-06 Thread Andy Froncioni
I know I'm probably doing something wrong, but I can't seem to get a simple UPDATE...LIMIT query working. sqlite> UPDATE customers SET lock=1 WHERE lock!=1 LIMIT 10; SQL error: near "LIMIT": syntax error I have compiled sqlite3 with the following configure options: % CFLAGS="-Os -DSQLITE_ENABLE