Re: [sqlite] is ticket 4037 not a bug?

On 11/17/09 6:10 , "Bogdan Ureche" wrote: > 1. Is this a bug or not? If not, any reason why not? > 2. Are other databases supporting this syntax? > 3. Is this an invalid syntax according to the SQL standard? > 4. Is there a workaround? > > I would appreciate any help. > >

Re: [sqlite] is ticket 4037 not a bug?

On Mon, Nov 16, 2009 at 9:49 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Bogdan Ureche wrote: >> I just noticed the ticket was closed without being fixed, with the following >> remark: > > I was the one who closed it and added that remark. >

Re: [sqlite] SQLite, network share, and Qt

On 17 Nov 2009, at 7:45am, Dan Kennedy wrote: > On Nov 17, 2009, at 2:32 AM, Israel Brewster wrote: > >> Simple (I hope) question here for my first posting to this list: >> Running SQLite 3.4.0 on Mac OS X 10.5.8, should I or should I not be >> able to place a SQLite database on a network share

Re: [sqlite] Why does LIKE operator affect order of query plan?

Thanks once again. If the optimizer is unaffected by the choice of function to prepare the statement when a string literal is on the RHS, I have to come up with another theory to explain why three different front-ends for SQLite report a query plan that differs from the one SQLite3.EXE

[sqlite] feature request: built-in FLIP(string) function

STARTS-WITH and ENDS-WITH searches are the bread-and-butter of text-centric/word-centric applications (e.g. in linguistics and philology) where you have to work with suffixes, prefixes, and enclitic|proclitic particles quite often. You must routinely examine the ends of strings in a wide range

Re: [sqlite] feature request: built-in FLIP(string) function

Tim Romano wrote: > You can accomplish this on the front-end, of course, but it would be > much more convenient and efficient to have a built-in function. It is difficult to define a "reverse" operation on arbitrary Unicode strings in a useful way. E.g., consider the string 'Á' (U+0041 Lating

[sqlite] understanding the query optimizer

Recent travails of the user trying to figure out how the optimizer figures out how to optimize query with a LIKE clause set me thinking... I really don't know anything about this optimizer. When I work with a db, I spend a considerable amount of time thinking about the most appropriate db

Re: [sqlite] is ticket 4037 not a bug?

Many thanks to all who replied, that was very helpful. So the ticket was closed because the old CVSTRACKER was closed, and a new ticket should be created with the replacement mechanism, after being discussed in the mailing list. @Roger: I apologize for the misunderstanding. > If > it alters the

[sqlite] Removing the 'Delete message(s)' confirmation.

I'd like to remove the delete confirmation when I delete a message or messages. Is this in Configuraton->Preferences? Am I just missing something? Ted ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Removing the 'Delete message(s)' confirmation.

This list is mostly about SQLite database engine. And it has neither Configuration, nor Preferences, neither messages, nor confirmation of their deletion. If you're talking about some GUI tool for SQLite (there're many of them) then you better name what you're talking about. Pavel On Tue, Nov

Re: [sqlite] Removing the 'Delete message(s)' confirmation.

On Tue, 17 Nov 2009 11:39:43 -0500 Pavel Ivanov wrote: Oopsie... senior moment. I've since posted it to the correct group, Claws-Mail. Ted ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] feature request: built-in FLIP(string) function

Thanks for the reply, Igor. Understood that an index cannot be placed on a function; I wasn't thinking of a "virtual field" as one can have in Oracle or MS-Access, or in legacy non-1NF databases such as Revelation, for example. The flip() function would simply be a utility that would enable me

Re: [sqlite] SQLite, network share, and Qt

On Nov 17, 2009, at 12:49 AM, Simon Slavin wrote: On 17 Nov 2009, at 7:45am, Dan Kennedy wrote: On Nov 17, 2009, at 2:32 AM, Israel Brewster wrote: Simple (I hope) question here for my first posting to this list: Running SQLite 3.4.0 on Mac OS X 10.5.8, should I or should I not be able to

Re: [sqlite] SQLite, network share, and Qt

On Nov 16, 2009, at 3:41 PM, Simon Slavin wrote: On 16 Nov 2009, at 7:32pm, Israel Brewster wrote: Now I know that this sounds like a Qt problem, and in fact I believe that to be the case. However, when I ask them about it, they stubbornly keep insisting that it is a sqlite problem. I

Re: [sqlite] feature request: built-in FLIP(string) function

Tim Romano wrote: > Understood that an index cannot be placed on a function; I wasn't > thinking of a "virtual field" as one can have in Oracle or MS-Access, > or in legacy non-1NF databases such as Revelation, for example. The > flip() function would simply be a utility

Re: [sqlite] feature request: built-in FLIP(string) function

On 17 Nov 2009, at 5:52pm, Igor Tandetnik wrote: > But for your goals, it has to be sortable, right? In a proper Unicode > collation, U+0041 U+0301 would behave quite differently from U+0301 U+0041. > Consider "A ' E" (where ' stands for a combining acute accent). In most > locales, this

Re: [sqlite] feature request: built-in FLIP(string) function

>So, for example, if one wanted to find all rows where myNormalColumn >ENDS WITH 'fi c d', one could search myFlippedColumn like this: > >select * from LEXICON where myFlippedColumn LIKE 'd c if%' -- >allows index use Make this select * from LEXICON where myFlippedColumn LIKE flip('fi c

Re: [sqlite] feature request: built-in FLIP(string) function

Simon Slavin wrote: > On 17 Nov 2009, at 5:52pm, Igor Tandetnik wrote: > >> But for your goals, it has to be sortable, right? In a proper >> Unicode collation, U+0041 U+0301 would behave quite differently from >> U+0301 U+0041. Consider "A ' E" (where ' stands for a

[sqlite] Unicode support

On 17 Nov 2009, at 6:37pm, Igor Tandetnik wrote: > Simon Slavin wrote: >> On 17 Nov 2009, at 5:52pm, Igor Tandetnik wrote: >> >>> But for your goals, it has to be sortable, right? In a proper >>> Unicode collation, U+0041 U+0301 would behave quite differently from >>>

Re: [sqlite] Unicode support

Simon Slavin wrote: > On 17 Nov 2009, at 6:37pm, Igor Tandetnik wrote: > >> Simon Slavin wrote: >>> First split the string into characters, then reassemble them in >>> reverse order. >> >> The problem is, in Unicode it's not quite clear what

Re: [sqlite] feature request: built-in FLIP(string) function

'cba', right. I don't mean to dismiss the sophisticated version as unnecessary; rather I was thinking there could be a "naive" flip() function where the raw codepoints were simply reversed irrespective of whether the source string contained combining forms, and a different, sophisticated

Re: [sqlite] feature request: built-in FLIP(string) function

If there were two flip() functions, Simon, a naive one that understands nothing more than raw codepoints, and a sophisticated one that is "aware" of combined Unicode forms/graphemes, then the excellent would not become the enemy of the good and the raw one could be put in place without much

[sqlite] compiler warnings with 3.6.20 on Visual St udio 2005 (with all updates)

Hello, I'm receiving the following compiler warnings with VS2005 for both Win32 and x64 platforms. -- Rich .\sqlite3.c(49492) : warning C4244: 'function' : conversion from 'ynVar' to 'int', possible loss of data .\sqlite3.c(51336) : warning C4244: 'return' : conversion from 'ynVar' to

Re: [sqlite] compiler warnings with 3.6.20 on Visual Studio 2005 (with all updates)

On Nov 17, 2009, at 3:39 PM, r...@lambdares.com wrote: > > Hello, > > I'm receiving the following compiler warnings with VS2005 for both > Win32 and x64 platforms. Harmless. http://www.sqlite.org/src/vinfo/f1c09acaca3e205acf5b077c9b2d0fe35f035c1e > > -- Rich > > .\sqlite3.c(49492) :

Re: [sqlite] is ticket 4037 not a bug?

On Mon, 16 Nov 2009 21:49:58 -0800, Roger Binns wrote: >-BEGIN PGP SIGNED MESSAGE- >Hash: SHA1 > >Bogdan Ureche wrote: >> I just noticed the ticket was closed without being fixed, with the following >> remark: > >I was the one who closed it and added that remark. >

Re: [sqlite] is ticket 4037 not a bug?

> > > > I can imagine query generators tend to use more, possibly > redundant, qualifiers than a human programmer would. > -- > ( Kees Nuyt > ) > c[_] > That may be true but sometimes the qualifiers are needed to avoid ambiguity, in which case they are not redundant. Bogdan >

Re: [sqlite] Unicode support

On Tue, Nov 17, 2009 at 02:01:55PM -0500, Igor Tandetnik wrote: > This would mean that the result of the hypothetical flip() function > would be locale-dependent. E.g. in Spanish Traditional sort, a > combination 'ch' sorts as if it were a single letter between 'c' and > 'd', forming a single sort

Re: [sqlite] Unicode support

>> On 17 Nov 2009, at 5:52pm, Igor Tandetnik wrote: >> >>> But for your goals, it has to be sortable, right? In a proper >>> Unicode collation, U+0041 U+0301 would behave quite differently from >>> U+0301 U+0041. Consider "A ' E" (where ' stands for a combining >>> acute accent). In most locales,

Re: [sqlite] Unicode support

Nicolas Williams wrote: > On Tue, Nov 17, 2009 at 02:01:55PM -0500, Igor Tandetnik wrote: >> This would mean that the result of the hypothetical flip() function >> would be locale-dependent. E.g. in Spanish Traditional sort, a >> combination 'ch' sorts as if it were a

Re: [sqlite] Unicode support

A few minutes ago I wrote that: >I think that as a general rule, the "combining" accents should be disregared >during collation. > > etc. I just read that "collation" page from Unicode.org and it seems to be completely at odds with what I suggested, e.g. in its insistence that some sequences

Re: [sqlite] SQLite, network share, and Qt

On 11/17/2009 05:45 PM, ext Dan Kennedy wrote: > On Nov 17, 2009, at 2:32 AM, Israel Brewster wrote: > > >> Simple (I hope) question here for my first posting to this list: >> Running SQLite 3.4.0 on Mac OS X 10.5.8, should I or should I not be >> able to place a SQLite database on a network

Re: [sqlite] Unicode support

On Tue, Nov 17, 2009 at 05:15:16PM -0500, Igor Tandetnik wrote: > Nicolas Williams wrote: > > This is no longer true, either of 'ch' nor 'll'. > > There is a number of contractions in Hungarian that are still very > much in use, but I can't recall them off the top of my

[sqlite] bad data in a database file or bug?

hi all attached is a database file with a strange behavior. it has a table "feeds". has the following data (just selected 2 columns for discussion purpose) sqlite> select _id, feed from feeds; _id feed --

Re: [sqlite] bad data in a database file or bug?

On Nov 17, 2009, at 8:09 PM, Vasu Nori wrote: > > but can't select the row _id = 0 What does the following query show: SELECT _id, typeof(_id) FROM feeds; D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Unicode support

For those who are insisting on Unicode graphemic codepoint-combination intelligence: why can't we have a function that simply reverses the order of the codepoints, and is blissfully ignorant about what those individual codepoints or codepoint-combinations might signify as graphemes in a

Re: [sqlite] bad data in a database file or bug?

if I vacuum it, database file sems to have correct data. sqlite> vacuum ...> ; sqlite> select count(*) from feeds where _id = '0'; count(*) -- 1 I can't tell if this is a bug in sqlite3 or if the database file is corrupt but sqlite3 can't recognize it when I do "pragma

Re: [sqlite] Unicode support

Tim, >For those who are insisting on Unicode graphemic codepoint-combination >intelligence: why can't we have a function that simply reverses the >order of the codepoints, and is blissfully ignorant about what those >individual codepoints or codepoint-combinations might signify as >graphemes in

Re: [sqlite] bad data in a database file or bug?

in one case you do: select count(*) from feeds where _id = '0'; in the other you do: select count(*) from feeds where _id = 0; <--- note the missing quotes this shouldn't make a difference (since SQLite is typeless), but I wonder if it is in this case. what is the type of _id? can you run

Re: [sqlite] Unicode support

but if ORDER BY is relying on an index for ordering, then flip() can have negative effects. Substr() could have negative effects on ordering too. That is a red herring. Flip() is merely a function that reverses the order of codepoints "as found" without knowing anything about what those

Re: [sqlite] bad data in a database file or bug?

> in one case you do: > select count(*) from feeds where _id = '0'; > in the other you do: > select count(*) from feeds where _id = 0; <--- note the missing quotes > this shouldn't make a difference (since SQLite is typeless), but I wonder if > it is in this case. > what is the type of _id?

Re: [sqlite] bad data in a database file or bug?

attached. thanks for your time. On Tue, Nov 17, 2009 at 6:49 PM, D. Richard Hipp wrote: > > On Nov 17, 2009, at 9:45 PM, Vasu Nori wrote: > > > > sqlite> SELECT _id, typeof(_id) FROM feeds; > > 1|integer > > 2|integer > > 3|integer > > 4|integer > > 5|integer > > 6|integer > >

[sqlite] Asynchronous I/O and shared cache

Hello, I'm wondering if shared cache and read uncommited isolation level with asyncronous I/O enabled is possible ? In sqlite3async.c I see a shared mutex between read and write operations, so I doubt that it is possible to have real concurrency between read and write... Regards -- View

[sqlite] Asynchronous I/O and shared cache

Hello, I'm wondering if shared cache and read uncommited isolation level with asyncronous I/O enabled is possible ? In sqlite3async.c I see a shared mutex between read and write operations, so I doubt that it is possible to have real concurrency between read and write... Regards -- View

Re: [sqlite] Asynchronous I/O and shared cache

On Nov 18, 2009, at 1:25 PM, presta wrote: > > Hello, > > I'm wondering if shared cache and read uncommited isolation level with > asyncronous I/O enabled is possible ? I haven't tried, but I assume it is possible. The two features don't really interact. > In sqlite3async.c I see a shared