Re: [sqlite] Bug in sqlite: "View with UNION ALL and limit in subquery" (v 3.28.0)

Thank you for the report. The problem is now fixed on trunk. Ticket: https://www.sqlite.org/src/info/c41afac34f15781f Fix: https://www.sqlite.org/src/info/523b42371122d9e1 On 5/29/19, Marco Foit wrote: > Dear SQLite Developers, > > I just noticed the following bug in SQLite version 3.28.0: > >

Re: [sqlite] SQLite4 version

On May 29, 2019, at 7:12 AM, Mike King wrote: > > Would it make sense for DRH to rename V4 to something else? For the > uninitiated it’s not always apparent that V3 is what you should be using. drh appears to use major version number changes to mean “breaking file format change,” rather than

Re: [sqlite] How to set access permissions to protect a database file?

This is what the UNIX group ID and the set-group-id capability is for. You make the files readable (or read and write) by a group (mode 640 or 660). You make the program that controls access to the files set-group-id to that group. You may need a small "C" wrapper program to run the script

[sqlite] Bug in sqlite: "View with UNION ALL and limit in subquery" (v 3.28.0)

Dear SQLite Developers, I just noticed the following bug in SQLite version 3.28.0: create table t AS values (1), (2); .print "select with correct output ..." select * from ( select * from t limit 1 ) union all select * from t ; .print "same select leads to incorrect result when used inside

Re: [sqlite] SQLite4 version

On top of https://sqlite.org/src4/doc/trunk/www/index.wiki, the statement "/All development work on SQLite has ended." /should hopefully be/ / /"///All development work on SQLite4 has ended."// :-) Thank you, mario// // On 5/29/19 3:17 PM, Simon Slavin wrote: On 29 May 2019, at 2:12pm,

Re: [sqlite] SQLite4 version

On 29 May 2019, at 2:12pm, Mike King wrote: > Would it make sense for DRH to rename V4 to something else? It might be helpful to put a note at the top of ___ sqlite-users mailing list

Re: [sqlite] SQLite4 version

On 29 May 2019, at 2:02pm, Warren Young wrote: > On May 29, 2019, at 6:16 AM, Simon Slavin wrote: > >> There may one day be a release of SQLite4 > > It doesn’t look like it: https://sqlite.org/src4/info/c0b7f14c0976ed5e Right. I was considering a 'new' SQLite4 with new ideas in. Unless the

Re: [sqlite] SQLite4 version

Would it make sense for DRH to rename V4 to something else? For the uninitiated it’s not always apparent that V3 is what you should be using. Cheers On Wed, 29 May 2019 at 14:03, Warren Young wrote: > On May 29, 2019, at 6:16 AM, Simon Slavin wrote: > > > > There may one day be a release of

Re: [sqlite] SQLite4 version

Hello, Mittal, Do you have a particular problem that you perceive would be solved by sqlite4, and not by sqlite3, or were you simply wanting the "latest" sqlite version? > > ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] SQLite4 version

On May 29, 2019, at 6:16 AM, Simon Slavin wrote: > > There may one day be a release of SQLite4 It doesn’t look like it: https://sqlite.org/src4/info/c0b7f14c0976ed5e ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] SQLite4 version

On 29 May 2019, at 7:21am, Mittal, Pradeep wrote: > I am new to SQLite and looking for SQLite version which supports the SQLite4 > interfaces and implementation. There has never been a release version of SQLite4. SQLite4 is a testbed for new ideas and new features. Some features which

Re: [sqlite] I am unable to build sqlite3 on windows. Possible errors in https://sqlite.org/src/doc/trunk/README.md

D:\Source\SQLite3 contains the fossil checkout of trunk D:\Source\Bld is an empty directory D:\Source\Bld>nmake -f ..\sqlite3\makefile.msc sqlite3.c TOP=..\sqlite3 ... for the rest of the targets you want In other words, you point to the makefile.msc wherever it may be found, and set TOP=

[sqlite] LSM INT key problem

Both SQlite.exe and lsm.dll are compiled on Win10 with Mingwin64. Lsm by copying sqlite3.h and sqlite3ext.h to the lsm1 directory and then: make lsm.so TCCX="gcc -g -O2" and rename to lsm.dll Creating a lsm table with an INT key results in the following: SQLite version 3.28.0 2019-04-16 19:49:53

[sqlite] SQLite4 version

Hi, I am new to SQLite and looking for SQLite version which supports the SQLite4 interfaces and implementation. Please suggest me the released version of SQLite which support SQLIte4. Also please let me know, if there is any license requirements for the same. If there is any web portal for

[sqlite] I am unable to build sqlite3 on windows. Possible errors in https://sqlite.org/src/doc/trunk/README.md

I am unable to successfully build SQLite3 following your instructions: "Using MSVC On Windows, all applicable build products can be compiled with MSVC. First open the command prompt window associated with the desired compiler version (e.g. "Developer Command Prompt for VS2013"). Next, use NMAKE

Re: [sqlite] Making blob as a sqlite database.

https://sqlite.org/c3ref/deserialize.html https://sqlite.org/c3ref/serialize.html --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users-