Re: [sqlite] sqlite bug? Subquery containing like-expression in where clause with starting '%' returns no rows, but without '%' does

Am Sonntag, den 03.02.2013, 14:00 -0700 schrieb Keith Medcalf: > > SELECT moz_places.id, moz_places.url, moz_places.title, moz_bookmarks.parent > > FROM moz_places, moz_bookmarks > > WHERE moz_places.id = moz_bookmarks.fk > >and moz_bookmarks.parent = (select id > >

[sqlite] sqlite bug? Subquery containing like-expression in where clause with starting '%' returns no rows, but without '%' does

Could this be a bug? SELECT moz_places.id, moz_places.url, moz_places.title, moz_bookmarks.parent FROM moz_places , moz_bookmarks WHERE moz_places.id = moz_bookmarks.fkand moz_bookmarks.parent = (select id from moz_bookmarks where title like '%arbeit%') returns n

Re: [sqlite] problems on importing quoted csv files

Am Dienstag, den 17.05.2011, 13:53 +0800 schrieb jiajianying: > Hello, > > I'm using sqlite to process some csv files. It is very disappointing > that sqlite's csv mode doesn't support quoted csv format. I tried > spatialite which can only strip quote marks but can't parse it correctly. > > Is

Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

Am Sonntag, den 08.05.2011, 10:08 -0400 schrieb Samuel Adam: > On Sun, 08 May 2011 09:36:43 -0400, Jean-Christophe Deschamps > wrote: > > > Change that into: > > > > select date('2011-04-29', quote(-3) || ' day'); > > > > (note the space before day). > > Looks like a parsing change. > > Appare

Re: [sqlite] Issue 608 in sqlite-manager: select date('2011-04-29', quote(-3) || 'day'); shows null after upgrading of firefox to 3.6.17

.4 version, because with my 3.6.16, it's correct as you can see in my previous mail: Weitergeleitete Nachricht > Von: Thomas Mittelstaedt > Reply-to: tmsta...@t-mittelstaedt.de > An: sqlite-mana...@googlecode.com > Betreff: Re: Issue 608 in sqlite-manager: select date(

Re: [sqlite] pthreadMutex

Luiz, You may try to compile with -pthread in the compile flags. Am Mittwoch, den 09.12.2009, 00:12 -0200 schrieb Luiz Gustavo P Tonello: > undefined reference to `pthread_mutexattr_init' -- thomas ___ sqlite-users mailing list sqlite-users@sqlite.

Re: [sqlite] bug? like-search with german umlaut is case-sensitive, should not be

Thanks for that pointer to the icu project. Did not know about that!! thomas Am Freitag, den 14.11.2008, 15:27 +0200 schrieb Elefterios Stamatogiannakis: > Has anybody successfully compiled sqlite with icu for win32? > > I haven't managed to find an libicu for mingw. Any tips welcome. > > lefte

[sqlite] bug? like-search with german umlaut is case-sensitive, should not be

Hallo, Just did a search on my database using SELECT * FROM ku2008 where "Empfaenger 1" like '%köck%'; and nothing was found. Doing a SELECT * FROM ku2008 where "Empfaenger 1" like '%kÖck%'; with the capital umlaut did find the record. The data is utf-8! my sqlite version is 3.5.9 on ubuntu har