[sqlite] Multiple connections to in-memory DB and virtual tables

On Tue, Oct 6, 2015 at 5:13 PM, Hick Gunter wrote: > 1) Each connection needs to load the image(s) that contain(s) the virtual > module code (unless you have already linked it into a single image). > 2) Each connection needs to declare the virtual module(s) by calling >

[sqlite] sqlite3_trace not showing all steps?

Hi! We use SQLite3 in PowerDNS as one backend and we have implemented query logging using sqlite3_trace. Unfortunately it seems that it does not log all executed queries, despite being turned on. We see one or two queries but most go unlogged. I tried to generate a minimal example to see if it

[sqlite] Help SQlite

On 10/6/15, jonathan wrote: >> Hello my friends, i need your help, i have problems with the use special >> character for example "?" , work with vb net. The problem consist when >> save >> this character in the data base sqlite, this chance in another character. >> I >> hope your help. Thank you.

[sqlite] sqlite3_trace not showing all steps?

On 10/7/15, Aki Tuomi wrote: > Hi! > > We use SQLite3 in PowerDNS as one backend and we have implemented query > logging using sqlite3_trace. Unfortunately it seems that it does not log > all executed queries, despite being turned on. We see one or two queries > but most go unlogged. > > I tried

[sqlite] sqlite3_trace not showing all steps?

On Wed, Oct 07, 2015 at 08:42:47AM -0400, Richard Hipp wrote: > On 10/7/15, Aki Tuomi wrote: > > Hi! > > > > We use SQLite3 in PowerDNS as one backend and we have implemented query > > logging using sqlite3_trace. Unfortunately it seems that it does not log > > all executed queries, despite being

[sqlite] sqlite3_trace not showing all steps?

On 10/7/15, Aki Tuomi wrote: > > Is there any way to see whether sqlite3_trace has been attached to a > particular connection? > Perhaps run "sqlite3_exec(db, "SELECT 'trace-test';",0,0,0)" and see if you get a trace callback? -- D. Richard Hipp drh at sqlite.org

[sqlite] sqlite3_trace not showing all steps?

On Wed, Oct 07, 2015 at 09:35:54AM -0400, Richard Hipp wrote: > On 10/7/15, Aki Tuomi wrote: > > > > Is there any way to see whether sqlite3_trace has been attached to a > > particular connection? > > > > Perhaps run "sqlite3_exec(db, "SELECT 'trace-test';",0,0,0)" and see > if you get a trace

[sqlite] sqlite3_trace not showing all steps?

On Wed, Oct 07, 2015 at 04:58:10PM +0300, Aki Tuomi wrote: > On Wed, Oct 07, 2015 at 09:35:54AM -0400, Richard Hipp wrote: > > On 10/7/15, Aki Tuomi wrote: > > > > > > Is there any way to see whether sqlite3_trace has been attached to a > > > particular connection? > > > > > > > Perhaps run

[sqlite] sqlite3_trace not showing all steps?

On 10/7/15, Aki Tuomi wrote: > > Abusing bit more it would seem that when it's not logging, it's going thru > sqlite3Reprepare and doing a rerun. Wonder if this causes the logging be > suppressed? See http://p.ip.fi/bt6b > Try the patch below to see if it makes a difference: Index: src/vdbe.c

[sqlite] Strange behaviour of IN/NOT IN subqueries?

Hello SQLite team, I have two tables, "item" (items on sale) where a column named "itemcode" is the PK and "tmp_salesitm" (invoice item lines) where the foreign key column to "item" is called "itemid" and not "itemcode" for some reason. I wanted to find all records from the first with no matching

[sqlite] SQLite version 3.8.12 enters testing

The release checklist for version 3.8.12 (https://www.sqlite.org/checklists/3081200/index) is now active. The 3.8.12 release will occur when the checklist goes all-green. A preliminary change log for version 3.8.12 can be seen at https://www.sqlite.org/draft/releaselog/3_8_12.html and

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

? ? On 7 October 2015 at 16:42, Richard Hipp wrote: > The release checklist for version 3.8.12 > (https://www.sqlite.org/checklists/3081200/index) is now active. The > 3.8.12 release will occur when the checklist goes all-green. > > A preliminary change log for version 3.8.12 can be seen at >

[sqlite] sqlite3_trace not showing all steps?

On Wed, Oct 07, 2015 at 10:30:53AM -0400, Richard Hipp wrote: > On 10/7/15, Aki Tuomi wrote: > > > > Abusing bit more it would seem that when it's not logging, it's going thru > > sqlite3Reprepare and doing a rerun. Wonder if this causes the logging be > > suppressed? See http://p.ip.fi/bt6b > >

[sqlite] SQLite version 3.8.12 enters testing

On Wed, Oct 7, 2015 at 4:42 PM, Richard Hipp wrote: > The release checklist for version 3.8.12 > (https://www.sqlite.org/checklists/3081200/index) is now active. The > 3.8.12 release will occur when the checklist goes all-green. > > A preliminary change log for version 3.8.12 can be seen at >

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

On 10/7/15, Jaroslaw Staniek wrote: > ? would you elaborate what? is the > benefit of using x.y.z versioning scheme if so many new features come to > the "z" release? That's the versioning scheme that has been used by SQLite for 15 years. Back when it was adopted, 15 years ago, it was certainly

[sqlite] SQLite version 3.8.12 enters testing

On 10/7/15, Dominique Devienne wrote: > > Could you please provide links to the amalgamation? TIA, --DD https://www.sqlite.org/download.html - the first link at the top of the list of products. -- D. Richard Hipp drh at sqlite.org

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

On 7 Oct 2015, at 4:39pm, Richard Hipp wrote: > The community seems to want the second number (current 8) to increment > every time a new feature is added to SQLite. I will take your request > under advisement. Realize, however, that had the current preferred > number scheme been used for

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

On 10/7/15, Simon Slavin wrote: > (B) The product itself is called SQLite3 so the '3' has to be fixed. Major > rewrites to SQLite to, for example, introduce WAL mode, can't change the > '3'. The "3" is the file format. SQLite1 and SQLite2 used different and incompatible file formats. SQLite

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

On Wed, Oct 7, 2015 at 5:39 PM, Richard Hipp wrote: > On 10/7/15, Jaroslaw Staniek wrote: > > ? would you elaborate what? is the > > benefit of using x.y.z versioning scheme if so many new features come to > > the "z" release? > > [...] The community seems to want the second number (current 8)

[sqlite] SQLite version 3.8.12 enters testing

On Wed, Oct 7, 2015 at 4:42 PM, Richard Hipp wrote: > A preliminary change log for version 3.8.12 can be seen at > https://www.sqlite.org/draft/releaselog/3_8_12.html and preliminary > documentation can be seen at https://www.sqlite.org/draft/ > > If you have issues or concerns with the current

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

On Wed, Oct 7, 2015 at 9:05 AM, Dominique Devienne wrote: > On Wed, Oct 7, 2015 at 5:39 PM, Richard Hipp wrote: > > On 10/7/15, Jaroslaw Staniek wrote: > > > ? would you elaborate what? is the > > > benefit of using x.y.z versioning scheme if so many new features come > to > > > the "z"

[sqlite] compiling sqlite3 with FTS5 support

Is there a way to build the sqlite3 command line utility with integrated FTS5 support? I have been compiling and installing the latest version by downloading the latest 'autoconf' file, such as sqlite-autoconf-3081101.tar.gz, and building and installing that. However, I noticed that this is

[sqlite] Strange behaviour of IN/NOT IN subqueries?

On 10/7/2015 10:40 AM, Constantine Yannakopoulos wrote: > I have two tables, "item" (items on sale) where a column named "itemcode" > is the PK and "tmp_salesitm" (invoice item lines) where the foreign key > column to "item" is called "itemid" and not "itemcode" for some reason. I > wanted to find

[sqlite] SQLite version 3.8.12 enters testing

On 10/7/15, Zsb?n Ambrus wrote: > > I have concerns with the [indexes on expressions] documentation. > New documentation covering indexes on expressions has been added. Please let me know if you think more is needed. -- D. Richard Hipp drh at sqlite.org

[sqlite] SQLite version 3.8.12 enters testing

I assume, like with similar enhancements, a database created at SQLite 3.8.12 with an expression index will be unreadable with earlier versions of SQLite? ?As, for instance, a database created at 3.8.11 with an index with a where clauses causes SQLite 3.715.2 to fail when trying execute any SQL

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

On 7 October 2015 at 17:39, Richard Hipp wrote: > On 10/7/15, Jaroslaw Staniek wrote: > > ? would you elaborate what? is the > > benefit of using x.y.z versioning scheme if so many new features come to > > the "z" release? > > That's the versioning scheme that has been used by SQLite for 15 >

[sqlite] SQLite version 3.8.12 enters testing

On 10/7/15, Peter Aronson wrote: > I assume, like with similar enhancements, a database created at SQLite > 3.8.12 with an expression index will be unreadable with earlier versions of > SQLite? As, for instance, a database created at 3.8.11 with an index with a > where clauses causes SQLite

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

On Wed, Oct 7, 2015 at 2:06 PM, Jaroslaw Staniek wrote: > > > On 7 October 2015 at 17:39, Richard Hipp wrote: > >> On 10/7/15, Jaroslaw Staniek wrote: >> > ? would you elaborate what? is the >> > benefit of using x.y.z versioning scheme if so many new features come to >> > the "z" release? >>

[sqlite] [sqlite-dev] SQLite version 3.8.12 enters testing

"Scott Robison" wrote... > On Wed, Oct 7, 2015 at 2:06 PM, Jaroslaw Staniek wrote: > >> >> >> On 7 October 2015 at 17:39, Richard Hipp wrote: >> >>> On 10/7/15, Jaroslaw Staniek wrote: >>> > ? would you elaborate what? is the >>> > benefit of using x.y.z versioning scheme if so many new

[sqlite] SQLite version 3.8.12 enters testing

On 7 Oct 2015, at 8:42pm, Richard Hipp wrote: > New documentation covering indexes on expressions has been added. > Please let me know if you think more is needed. I tentatively suggest that modifications be made to the text describing

[sqlite] SQLite version 3.8.12 enters testing

Currently if you have a check constraint with a user-defined function that is not defined in the current environment, you can not execute any SQL statements in that database -- you get the same error you get with features not supported in the current release. ?I suspect the same thing would

[sqlite] Problem with sqlite3_db_filename

As I understand it this should produce a filepointer to the filepath of the attached database, given the database handle of file the other database was attached to and the database name of the attached database. I checked all the return values and also did a select involving tables in both

[sqlite] SQLite version 3.8.12 enters testing

Semantic versioning in general doesn't have any specific format, it just means that within a project the succession of version numbers conveys information by itself. There's no requirement there has to be 3 parts or whatever. I consider SQLite's versioning scheme to both be very appropriate

[sqlite] SQLite version 3.8.12 enters testing

On Wed, Oct 7, 2015 at 3:00 PM, Darren Duncan wrote: > Semantic versioning in general doesn't have any specific format, it just > means that within a project the succession of version numbers conveys > information by itself. There's no requirement there has to be 3 parts or > whatever. I