[sqlite] FTS: Phrase queries
When I have a basic FTS query that needs to be restricted to a column, I can write it in two ways: 1.) WHERE column MATCH 'apple' 2.) WHERE table MATCH 'column:apple' But when I have a phrase query, I can only write it in one way: 1.) WHERE column MATCH 'apple juice' The problem is that when I want to combine the queries (search for 'apple' in column1 and for apple juice in column2) i cannot write the query like: WHERE column1 MATCH 'apple' AND column2 MATCH 'apple juice' Nor can I write it like: WHERE table MATCH 'column1:apple column2:apple juice' So this fairly simple query, seems impossible in FTS? Or does anyone know how to workaround this (without doing two seperate queries)? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Wanted: Windows SQLite shell 3.6.x (not the current version!)
On 12.11.2011 16:00 CE(S)T, Yves Goergen wrote: Could somebody please send me an older version 3.6.x of the SQLite Windows shell client? Thank you. -- Yves Goergen LonelyPixel nospam.l...@unclassified.de Visit my web laboratory at http://beta.unclassified.de ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] determine SQLITE_MAX_LENGTH or sql_limit/sqlite3_limit
Hi All I need to create table with more than 2000 columns, How to reset SQLITE_MAX_COLUMN value which is 2000 . Plz help me on this issue. Thanks Vinay Vannus wrote: That should do the trick, thanks for pointing it out. On 10 February 2011 06:18, Dan Kennedy danielk1...@gmail.com wrote: On 02/10/2011 01:56 AM, Vannus wrote: Zeoslib is reading sqlite field lengths incorrectly, as it checks for brackets after the field typename ie. CHAR(123) presumably this is only affecting me because I haven't defined field lengths in my sqlite3 db. I don't want to hard-code 1,000,000,000 or 2147483647 in as the field length - but how do I check what SQLITE_MAX_LENGTH or the limit imposed by sql_limit or sqlite3_limit is? At http://www.sqlite.org/c3ref/limit.html the third paragraph has: Regardless of whether or not the limit was changed, the sqlite3_limit() interface returns the prior value of the limit. Hence, to find the current value of a limit without changing it, simply invoke this interface with the third parameter set to -1. Maybe you can use that. Dan. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- View this message in context: http://old.nabble.com/determine-SQLITE_MAX_LENGTH-or-sql_limit-sqlite3_limit-tp30885748p32838625.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 3.7.7.1 database corruption
Dear all, we are using SQLite in our projects. We are using the 3.7.7.1 version compiled on Windows platform from the amalgamation file. One of our servers crashed badly (power outage) and after the server restarted, we saw that the database was corrupt (all queries we tried return SQLITE_CORRUPT). We had a look at http://www.sqlite.org/howtocorrupt.html and verified, that the hardware (disk, memory) of the server should be ok - we used some hardware tools to check. In the past we already had some crash situations and SQLite could recover from the crash nicely, so we were surprised that after this crash the database was corrupt. In fact, we cant create a repro, because we do not know, what the server was exactly doing, so it might be difficult to find the reason, but we saved the corrupted database in the hope, that somebody from the develpers (maybe) could put some light on this problem. Because the database is rather small and is used to save some configuration data only, I have att ached it to this message. Thanks for any suggestions. Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users