Re: [sqlite] SQLite3 Tutorial error

Thanks, Jens. I will do that. - Ken On 01/04/2017 12:29 AM, Jens Alfke wrote: On Jan 3, 2017, at 9:17 PM, Ken Wagner wrote: About 2/3 the way down the page at: http://www.sqlitetutorial.net/sqlite-glob/ Get names

Re: [sqlite] SQLite3 Tutorial error

> On Jan 3, 2017, at 9:17 PM, Ken Wagner wrote: > > About 2/3 the way down the page at: > > http://www.sqlitetutorial.net/sqlite-glob/ > Get names without [1-9]. You should probably report this to the people who run that

Re: [sqlite] Can the Explain explain what is going on here?

Have recompiled and indeed this makes both statements run at the same fast speed. I can also see that the both Explain now produce near enough the same. So it looks this has fixed it. I can see now that this could affect query speed not only in unrealistic testing situations, so this looks a

Re: [sqlite] Can the Explain explain what is going on here?

Thanks, will try that out. RBS On Wed, Jan 4, 2017 at 1:09 AM, Richard Hipp wrote: > On 1/3/17, Richard Hipp wrote: > > On 1/3/17, Richard Hipp wrote: > >> On 1/3/17, Bart Smissaert wrote: > >>> > >>> Firstly, is

Re: [sqlite] Can the Explain explain what is going on here?

All these UDF's are registered like this: RegisterUDF = sqlite3_create_function_v2(ByVal lDBHdl, _ ByVal cConn.UTF8BytesPointerFromUTF16String(strFunctionName), _ ByVal lArgCount, _

Re: [sqlite] SQLite3 Tutorial error

About 2/3 the way down the page at: http://www.sqlitetutorial.net/sqlite-glob/ Get names without [1-9]. select trackid, name from tracks where name GLOB '*[^1-9]*'; Works properly in SQLiteMan and the SQLite Tutorial. ( Two different products, not officially part of sqlite.org, I

Re: [sqlite] SQLite3 Tutorial error

On 1/3/17, Ken Wagner wrote: > Hi SQLite, > > In the SQLite3 Tutorial What tutorial are you referring to? -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] SQLite3 Tutorial error

Hi SQLite, In the SQLite3 Tutorial the following query is said to find all names WITHOUT numbers in them. But it fails to do so. select trackid, name from tracks where name GLOB '*[^1-9]*'; per the tutorial fails to list names WITHOUT numbers in them. However, this DOES work: select

Re: [sqlite] Can the Explain explain what is going on here?

On 1/3/17, Richard Hipp wrote: > On 1/3/17, Richard Hipp wrote: >> On 1/3/17, Bart Smissaert wrote: >>> >>> Firstly, is this a bug? >> >> No. A "bug" means it gets the wrong answer. In this case, it gets >> the correct answer, just

Re: [sqlite] Can the Explain explain what is going on here?

On 1/3/17, Richard Hipp wrote: > On 1/3/17, Bart Smissaert wrote: >> >> Firstly, is this a bug? > > No. A "bug" means it gets the wrong answer. In this case, it gets > the correct answer, just more slowly than you would like. That means > this is an

Re: [sqlite] problem with sqlite 4

David Empson wrote: SQLite Expert Personal is a third party product which uses the SQLite > database engine. It is not using “SQLite 4” (which is in early development > stages and not been released), but will be using some version of SQLite 3. > This mailing list is not an appropriate place to

Re: [sqlite] Can the Explain explain what is going on here?

On Tuesday, 3 January, 2017 17:18. Simon Slavin wrote: > On 4 Jan 2017, at 12:09am, Bart Smissaert > wrote: > > > Secondly, can the Explain statement tell me that indeed the UDF runs > 10 > > times in the first SQL and only once for the

Re: [sqlite] Can the Explain explain what is going on here?

I have checked and my presumed explanation was indeed correct. Runs 10 times (+ a few more for Prepare and check SQL etc.) with the first SQL and only a few with the second SQL. RBS On Wed, Jan 4, 2017 at 12:17 AM, Simon Slavin wrote: > > On 4 Jan 2017, at 12:09am,

Re: [sqlite] Can the Explain explain what is going on here?

Thanks for that. Yes, indeed not a bug. Not sure there is a scenario imaginable where this optimization will be helpful in real practice. RBS On Wed, Jan 4, 2017 at 12:25 AM, Richard Hipp wrote: > On 1/3/17, Bart Smissaert wrote: > > > > Firstly, is

Re: [sqlite] Can the Explain explain what is going on here?

On 1/3/17, Bart Smissaert wrote: > > Firstly, is this a bug? No. A "bug" means it gets the wrong answer. In this case, it gets the correct answer, just more slowly than you would like. That means this is an optimization opportunity. Thanks for bringing it to my

Re: [sqlite] Can the Explain explain what is going on here?

> What makes you think that this is the case ? I didn't check, but this was the only explanation I could think of. Will check in a bit. RBS On Wed, Jan 4, 2017 at 12:17 AM, Simon Slavin wrote: > > On 4 Jan 2017, at 12:09am, Bart Smissaert >

Re: [sqlite] Can the Explain explain what is going on here?

On 4 Jan 2017, at 12:09am, Bart Smissaert wrote: > Secondly, can the Explain statement tell me that indeed the UDF runs 10 > times in the first SQL and only once for the second SQL? What makes you think that this is the case ? Why would SQLite not be running the

[sqlite] Can the Explain explain what is going on here?

Have a table (only used for testing) like this: CREATE TABLE Table1([Field1] INTEGER) It has 10 rows and all the values in Field1 are 1. There are no indexes. Now I run queries that include a UDF. The code of this UDF is in VBScript and generally this is slow. This is the first SQL:

[sqlite] problem with sqlite 4

In reply to > On 3/01/2017, at 4:48 AM, claude.del-vi...@laposte.net David Empson wrote: SQLite Expert Personal is a third party product which uses the SQLite > database engine. It is not using “SQLite 4” (which is in early development > stages and not been released), but will be using some

Re: [sqlite] SQlite shell tool

Unfortunately I don't think there is a way to get the times into redirected output automatically. It looks like the callback that handles the redirected output runs completely before the endTimer function runs, which does a straight up printf right there in the endTimer function with no

[sqlite] SQlite shell tool

What are the orders to get the following text ? I tried with: .once prueba.txt .output prueba.txt .log prueba.txt .timer ON .echo ON PRAGMA integrity_check; ... but I did not get the lines "Run Time..." into de file SQLite version 3.14.0 2016-07-26 15:17:14 Enter ".help" for usage hints.

Re: [sqlite] problem with sqlite 4

> The current version of SQLite Expert Personal is 4.2.0, available here: > > http://www.sqliteexpert.com/download.html > > They don’t appear to give any clues as to which version of SQLite the > application is using. The SQLite version is displayed just below the ribbon on the right hand side of

Re: [sqlite] What is the best way to select "evenly" ?

On 2017/01/02 5:28 PM, Ron Aaron wrote: Hello, all - I'm trying to select from a table which contains pairs of "id", "name", where the "name" may appear in multiple "ids". For example, the table might have "10", "abc" "20", "abc" "10", "def" "10", "ghi" "20", "ghi" etc.That is, not every

Re: [sqlite] Testing Sqlite3* DB_handle?

> On Jan 2, 2017, at 6:28 PM, Domonic Tom wrote: > > Is there a way to test whether the DB_handle used when opening a database is > good? > I need to find some way of testing it to make sure it represents the live > connection to a database? “DB_handle” isn’t a term

Re: [sqlite] SQLite announce

The current thinking is that version 3.16.1 release will be available within 24 hours and that I will simply do an announcement then, and completely skip the 3.16.0 announcement. On 1/3/17, David Raymond wrote: > Makes sense, thank you. > > > > -Original

Re: [sqlite] SQLite announce

Makes sense, thank you. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Tuesday, January 03, 2017 10:50 AM To: SQLite mailing list Subject: Re: [sqlite] SQLite announce On 1/3/17, David Raymond

[sqlite] SQLite announce

Quick question, did something go out to the sqlite-announce mailing list for the 3.16.0 release? Just noticed that it got released yesterday and I'm not seeing a notification in my inbox or in any of my junk or spam folders. I confirmed I'm on the list and a password reminder request email got

Re: [sqlite] SQLite announce

On 1/3/17, David Raymond wrote: > Quick question, did something go out to the sqlite-announce mailing list for > the 3.16.0 release? Just noticed that it got released yesterday and I'm not > seeing a notification in my inbox or in any of my junk or spam folders. I >

[sqlite] 3.16.0 Release notes bug

Happy new 2017 to everyone on this list. Once again, I want to thank Dr. Hipp for his wonderful provision to the world called SQLite. Anyway, in the release notes, https://www.sqlite.org/releaselog/3_16_0.html on the first bullet, between the parenthesis, it states: (See the CPU