Re: [sqlite] Bug due to left join strength reduction optimization?

This has been fixed by revision d840e. Thanks for the quick response, drh! Danny ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug due to left join strength reduction optimization?

turns one row, as in Keith's example, while "= 0", "= false", and "is false" all give no rows. Danny ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug due to left join strength reduction optimization?

similar in spirit to an existing, fixed bug [1], but the output for the test case there has gone back to its pre-LJSRO value at some point since dd568, while this one has not. Thanks, Danny [1] https://www.sqlite.org/src/tktview/1e39b966ae9ee7394334

[sqlite] "ORDER BY ?" sqlite3_bind_int OK, but does weird things

Hi, I'm trying to prepare a statement for "SELECT a FROM t ORDER BY ?" and then sqlite3_bind_int the parameter to 1 (on sqlite 3.19.3). Expected result: Orders result by column "a", in ascending order. Observed result: Orders in some strange order. I also tried sqlite3_bind_int64, didn't change

[sqlite] 3 fixes for 3.19.3

/c93d35b54213049c86be76b8d0e74948fecfbf4b.patch Thanks Danny ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Potential corruption on VACUUM crash when SQLITE_OMIT_AUTOVACUUM is defined

to put a breakpoint at sqlite3.c:56747 and step over it and then restart the app right there. The next integrity_check will fail completely :) Thanks Danny Couture Technical Architect Ubisoft Montreal #include "stdafx.h" //DON'T FORGET TO COMPILE SQLITE WITH #define SQLITE_

Re: [sqlite] How about a proper forum rather than an e-mail list

I for one would love a forum, and disagree about it being the same as an email list. I would love to not see 40+ emails in my inbox every day from this mailing list, but I do find the available resource handy to have when I need it. A forum would allow us to be more active because we can quick

Re: [sqlite] Hidding records from the application

In my mainframe days, using IDMS/SQL, I limited user access to table data, down to the column level, based upon logged on userid.  This was accomplished via database procedures.  I'm new to SQLite, so don't know if it has any similar capabilities. > >From: Igor T

Re: [sqlite] current version support wal mode?

Paul Like the old saying goes ... "When all else fails, read the manual." http://www.sqlite.org/pragma.html Have a nice day. Danny > >From: Paul Linehan >To: sqlite-users@sqlite.org >Sent: Saturday, July 2, 2011 7:51 PM >Subject: Re:

Re: [sqlite] Sqlite database integrity check fails with disk I/O error (10)

If I had the same problem ... I would: 1. Refresh the surface of the hard drive using spinrite (grc.com), which is OS and file-structure independent; 2. Then, I'd run the Linux equivalent to the Windows chkdsk command to resolve any file-structure issues; In all but the worst hard drive issu

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

Paul I too have had a bad experience with this Firefox addon. I found it to be buggy, to generate all sorts of errors, and frequently I had to shutdown the addon between transactions to get it to continue to work. Months ago I switched to SQLite Expert Personal and haven't looked back.

Re: [sqlite] Unlocking the database

John, I've had nothing but trouble with the Firefox plugin. Download and install the SQLite Expert Personal 3 GUI (free) and see if that does anything for you, or at least gives you better diagnostics. --- On Sat, 5/28/11, Simon Slavin wrote: > From: Simon Slavin > Subject: Re: [sqlite] Unlo

Re: [sqlite] How to upgrade from SQLite 3.7.4 to 3.7.6.3

In the meantime, I have found SQLite Expert Personal 3 to be a more stable solution than the firefox plugin. I finally ditched the plugin entirely. http://www.sqliteexpert.com/download.html --- On Wed, 5/25/11, Simon Slavin wrote: > From: Simon Slavin > Subject: Re: [sqlite] How to upgrade

Re: [sqlite] Sqlite Files

Or a good GUI shell ... SQLite Expert Personal http://www.sqliteexpert.com/download.html --- On Sun, 5/22/11, Stephan Beal wrote: > From: Stephan Beal > Subject: Re: [sqlite] Sqlite Files > To: "General Discussion of SQLite Database" > Date: Sunday, May 22, 2011, 7:42 AM > On Sun, May 22,

Re: [sqlite] Can't send messages to list from pc?

TB giving any errors? Do they show up in the Sent folder? The Outbox folder? Are you sending in HTML instead of text? Have you confirmed "one more time" that you are sending it to the correct address? Can't think of any other questions. --- On Fri, 5/13/11, Don Ireland wrote: > From

Re: [sqlite] SQLite as a Logger: How to mimic "rotation of logs"?

Why not have TWO tables? Log_A and Log_B? When Log_A is full, DELETE everything from Log_B and start logging to it. When Lob_B is full, DELETE everything from Log_A and start logging to it again. If you want, while logging to one, the other can be archived ... --- On Tue, 5/10/11, Simon Slav

Re: [sqlite] installing sqlite

SQLite Manager for firefox has real problems.  I made it work for a while until I found a real GUI. And does a pretty decent job. SQLite Expro Personal is FREE. Of course, there is also a paid version with some additional features. http://www.sqliteexpert.com/ --- On Tue, 4/19/11, Kees Nuyt

Re: [sqlite] What happens if you insert more than your RAM

Depends on access type. If accessing sequentially, paging would be minimal, that is, you would process the "segment" that fits into memory, then page in another "segment" and process that, etc., etc. However completely random hits on the database could result in heavy paging, unless it were po

Re: [sqlite] SELECT help for newbie

Thanks everyone. That was so easy it was embarrassing! :) --- On Mon, 4/18/11, Simon Slavin wrote: > From: Simon Slavin > Subject: Re: [sqlite] SELECT help for newbie > To: j...@kreibi.ch, "General Discussion of SQLite Database" > > Date: Monday, April 18, 2011, 1:06 PM > > On 18 Apr 2011,

[sqlite] SELECT help for newbie

p you care to give as I continue to learn SQL. Thanks. Danny ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] The underlying provider failed to open?

first time I try to access data via my code (C#) it says the provider failed to open. Thanks for responding. Danny -Original Message- From: Stephen Chrzanowski Sent: Thursday, January 06, 2011 4:16 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] The underlying provider

Re: [sqlite] The underlying provider failed to open?

world of microsoft development it is pretty common. Thanks. Danny -Original Message- From: Simon Slavin Sent: Monday, January 03, 2011 7:07 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] The underlying provider failed to open? On 3 Jan 2011, at 1:58am, Danny Staten

[sqlite] The underlying provider failed to open?

like I must have forgotten something simple like installing something etc, but everything I have found makes me feel like I have all my ducks in a row. I would be incredibly grateful if anybody on this mailing list has any information. thanks, Danny

[sqlite] .NET WPF application with SQLite - The underlying provider failed to open

my machine, my application worked great. Any ideas? Thanks for reading my question. Danny ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/

[sqlite] Using the static lib of sqlite3 under 64 bit ubuntu

Settings: Gcc 4.3.3 Added usr/lib64/libsqlite3.a Error: Undefined reference to 'pthread_mutex_trylock' What I am missing? If I use the so shared lib no problems at all. Tx, Danny ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] Importing tab-separated data containing quotes

y first before jumping to conclusions. Thanks for your reply. - Danny Griggs wrote: > Hi Danny, > > When you wrote "... and try to import it in SQLite..." > I'm pretty sure you were using the sqlite3 commandline utility. > > I ran your test using the sqlit

[sqlite] Importing tab-separated data containing quotes

cing it with single quotes is easy (sed "s/\"/'/g"), but I would prefer to load the data as delivered. Thanks in advance, - Danny ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiler errors

se files belong to a normal sqlite build. So these symbols should be defined if you link your program correctly with the sqlite library... - Danny -- Danny Reinhold Reinhold Software & Services - To unsubscribe, e-mail: [EM

Re: [sqlite] src/encode.c missing...

ite itself. It is just a set of utility functions that can be used along with SQLite - but it is not needed to compile or run SQLite. - Danny -- Danny Reinhold Reinhold Software & Services - To unsubscribe, e-mail: [EMA

Re: [sqlite] SqLite on Windows

r do I know it. But it surely has an option to add a library on the command line. (maybe a call like lcc -o mytest mytest.c sqlite.lib is enough if mytest.c is the source of your test program and sqlite.lib is in an appropriate directory?!?) - Danny -- Danny Reinhold Reinho

Re: [sqlite] Compiling a shared library (.so) WITH threadsafe option enabled

#x27;t use assert() very often...) I really think that I need to sleep... ;-)) BTW: I didn't find a way to control the creation of debug (with correct setting of NDEBUG) or thread safe code in the configure.ac file. Shall I add tho

Re: [sqlite] Compiling a shared library (.so) WITH threadsafe option enabled

Hi! > Danny, > > thank you for your answer!! =) No problem - but it wasn't correct... ;-) (I should sleep a little ;-)) > > > TCC = gcc -g -O2 -DTHREADSAFE=1 -DNDEBUG=1 The important thing is not only the option -DNDEBUG=1 but mainly -g ofcourse... -DNDEBUG

Re: [sqlite] Compiling a shared library (.so) WITH threadsafe option enabled

rom object files, executables and libraries while -DNDEBUG=1 causes the compiler to not generate them (and so it's useless to strip the library after creation)... - Danny -- Danny Reinhold Reinhold Software & Services http://www.rsas.de -

Re: [sqlite] Developers of SQLite

the archive)... BTW: I found it in a thread about autoconf, automake and friends. What happened to this? Is somebody actively maintaining these build method for SQLite? - Danny -- Danny Reinhold Reinhold Software & Services -

Re: [sqlite] backslash problem

\\pluto > while other database (PostgreSQL, MySQL, BerkeleyDB) insert it as: > pippo\pluto > > Seems such behavior is conform to the SQL standard. I don't know what the standard says. Oracle inserts the value as 'pippo\\pluto'.

Re: [sqlite] Modifying an existing table

does not yet support ALTER TABLE statements, you can do those things by creating temporary tables to store the data and dropping and recreating your tables... Search the archive - these questions come quite often... - Danny -- Danny Reinhold Reinhol

Re: [sqlite] Where statements are they case sensitive?

tive , By default I don't think it should. > > Should I report a bug on this or was it by design?? I think it is very well designed and should not be changed. If you want case insensitive where clauses, use something like this:

Re: [sqlite] Checking the busy state

great if such a client library would be API compatible to the SQLite library itself. Then you could turn a simple SQLite application to a client application for your SQLite server simply by linking against your client library instead of linking with SQLite directly... Just an idea... - Danny --

Re: [sqlite] sqlite grammar

Hi > Where can I get a sqlite's language grammar (for example, in Backus-Naur form) ? The grammar is in the file parse.y in the sources. It is in the lemon parser generator format which is quite good readable... - Danny -- Danny Reinhold Reinhold Software &a

Re: [sqlite] change db-journal dir ????

nal file to restore your database and to undo the half completed transaction... - Danny -- Danny Reinhold Reinhold Software & Services - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Performance benchmarking

> Danny Reinhold wrote: > > DRH tested inserts with and without transactions on several > > DBMSs. PostgreSQL and MySQL where faster _without_ > > explicit transactions. > > That looks a bit strange to me... > If you are referring to Test 1 and Test 2 at http://www.s

Re: [sqlite] Performance benchmarking

. I have read > the architecture books on most other major databases, but not on Sqlite. : -) Read the code - it is very, very well documented - and short enough to be understood! - Danny -- Danny Reinhold Reinhold Software & Services

Re: [sqlite] Sqlite databases file extension

dation for extensions that should NOT be used. For example I think .db isn't a good choice, because other applications probably already use that. All well known extensions aren't good choices... - Danny -- Danny Reinhold Reinhold Software & Services

Re: [sqlite] Performance benchmarking

> select * from mytable where a like 'b%'; > may be slow - even if a is an indexed column. > select * from mytable where a >= 'ba' and a <= 'bz'; > may be very fast. Ahhh, sorry, I meant: select * from mytable where a > 'a' and a <

Re: [sqlite] Sqlite databases file extension

db are good choices. - Danny -- Danny Reinhold Reinhold Software & Services - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Performance benchmarking

r transactions, SQLite should outperform nearly everything else... But I don't know the VB<->SQLite technology you use. Maybe your wrapper unneccessarily converts much data or is otherwise slow... I hope this helps a bit, Danny -- Danny Reinhold Reinhold Software & Services -

Re: [sqlite] Alter Table?!

(without copying large tables twice)... - Danny -- Danny Reinhold Reinhold Software & Services - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Alter Table?!

Hi! Some months ago (9th of May) Jim Lyon wrote: > PS: I'm working on adding ALTER TABLE as a background project I would like to know about the current status of this background project. Will you add this useful extension to the standard SQLite sources? - Danny -- Danny Reinhold

Re: [sqlite] Can I strip libsqlite.so.0.5.3 ?

ng information. Mixing of debug and release code can cause conflicts at run time! (Another problem is that your end users usually don't have the debug libraries that comes with the MSVC++...) I hope this helps... - Danny -- Danny Reinhold Reinhold Software & Services -

Re: [sqlite] File Portability

7;t need the file on the original platform anymore, it may be wise to recreate the file on the new platform. Maybe anybody has measured the effect of marshalling? It should be quite low, but who knows... - Danny -- Danny Reinhold Reinhold Software & Services --