Re: [sqlite] sqlite3_transfer_bindings obsolete?

transfer_bindings(), though. You are using sqlite3_prepare_v2() in place of sqlite3_prepare() I trust. You should be if you are not since applications that use sqlite3_prepare_v2() are less prone to bugs in error handling logic (by virtue of the fact that they can essentially ignore SQLIT

Re: [sqlite] ATTACH problem

> than one thread (it is failing in worker thread). > sqlite3_step() returns SQLITE_MISUSE , but _sqlite3_errmsg() returns > "database is locked". > What can be the problem? What does sqlite3_threadsafe() return? D. Richard Hipp [EMAIL PROTECTED]

Re: [sqlite] Who is using SQLite prior to version 3.3.0?

r database will continue to be readable and writable by newer versions of SQLite. The only time this will cause a problem is when you create a new database file using SQLite 3.6.0 or later and then try to read or write that file using a different version of SQLite that is more than 2 years old.

[sqlite] Who is using SQLite prior to version 3.3.0?

databases to be used as the default. FWIW, SQLite version 3.3.0 was released over 2 years ago on January 10, 2006. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

Re: [sqlite] corrupt database with update?

On May 8, 2008, at 2:54 AM, C M wrote: > How likely (or possible) is it to corrupt or in some way screw up an > SQlite database if one is doing an UPDATE and it fails? (computer goes > out, etc.) Thank you.\ http://www.sqlite.org/atomiccommit.html D. Richard Hipp [EMAIL

Re: [sqlite] PRAGMA journal_mode not implemented?

rrectness of the database. In PERSIST journaling mode, you never know and you delete the file at your peril. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Porting into a microcontroller, minimum requirements

orage (SD card). Has > anyone ported > this before to an embedded system without an OS? > I have doubts that you will be able to get SQLite to work on anything less than a 32-bit processor. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-u

Re: [sqlite] PRAGMA journal_mode not implemented?

ERSIST mode nearly as carefully as we have the existing DELETE mode. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] import files with more than 2GB?

core SQLite, btw. It is part of the CLI. You can find the code by searching for "import" in the shell.c source file. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] splite database under version control (subversion)?

nature of binary files. I don't think any SCM system is able to diff or merge arbitrary binary files. There may be modules for diffing and merging specific binary files formats (ex: DOC files) but not arbitrary binary files nor likely SQLite database files. So take care not to fork. But

Re: [sqlite] Proposed incompatible changes to the SQLite VFS layer

On May 3, 2008, at 12:30 AM, Roger Binns wrote: > > I would like a #define of the current version number. http://www.sqlite.org/c3ref/c_version.html D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.or

Re: [sqlite] SQLite & TCL: A "SELECT" from one-column table

h8.5 [~/tmp/tcltk]dbcomm eval "SELECT a_string FROM something" > Version V8.5 > > Why so much parentheses? A list, nested in a list, nested in a list? > But why? I get just {Version V8.5} when I try this. D. Richard Hipp [EMAIL PROTECTED] __

Re: [sqlite] property/config file for SQLite

l . The lack of a configuration file is a feature, not a bug. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Proposed incompatible changes to the SQLite VFS layer

mode Before you rush out and try this on 3.5.8, please note that it is currently only available in CVS HEAD. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Proposed incompatible changes to the SQLite VFS layer

on version 3.6.0. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how is sqlitedll-3.5.8.zip built?

orrect? If so, what options are > defined when it is being built? If not, how is it built? > > TIA > Dennis Cote > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listin

Re: [sqlite] Concurrency access to SQLite

gt;>>> more >>>>>>> than N*2 sec and dies on my SQLITE_BUSY asserts :/ >>>>>>> >>>>>>> So, I am wondering, is there any ideas how to avoid this? >>>>>>> >>>>>> >>>>>> ___ >>>>>> 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 >>>> >>> >>> >>> >>> -- >>> Alexander Batyrshin aka bash >>> bash = Biomechanica Artificial Sabotage Humanoid >>> ___ >>> >>> 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 >> > > > > -- > Alexander Batyrshin aka bash > bash = Biomechanica Artificial Sabotage Humanoid > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_OMIT_PAGER_PRAGMAS

GMAS the cache_size pragma is omitted. A feature of the PRAGMA command is that unrecognized pragmas are silently ignored. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems with SQLITE_OMIT_xxx

ateView referenced in function _yy_reduce > > Are there any workarounds for these, or will > I have to remove the above OMIT options? > > Thanks, > - Richard > ___ > sqlite-users mailing list > s

Re: [sqlite] SQLITE_OMIT_xxx

uggest you use a C compiler instead. Surely Visual Studio must include a C compiler. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] blob api

in f.i. SQLiteSpy. > Perhaps: SELECT CAST(b AS TEXT) FROM table Really I suppose it depends on what SQLiteSpy is using to determine that the column type is BLOB. If you can subversion that mechanism into thinking the column type is TEXT, then it should just work. D. Richard

Re: [sqlite] a suggestion to write tutorial for sqlite

FWIW, I'll be happy to give write access to the documentation repository (http://www.sqlite.org/docsrc/) and even a prestigious "sqlite.org" email alias to anybody who is willing to step up and make some improvements and updates to the current documentation. D. Richard Hipp [EMAIL

Re: [sqlite] a suggestion to write tutorial for sqlite

mailing list if you think it would help. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] no VFS error

blank string - this would appear to be the problem! > errorCode = sqlite3_open_v2("data/texts.db", , > SQLITE_OPEN_READONLY, ""); > A null pointer (aka zero). 0. Very different from an empty string. D. Richard Hipp [EMAIL PROTECTED]

Re: [sqlite] EXISTS operator doesn't seem to work

here ORT.person_id = register.person_id and ORT.document_id = register. document_id); D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] no VFS error

p would be appreciated > What value are you passing as the 4th argument to sqlite3_open_v2()? (I assume you are using sqlite3_open_v2() since that seems the mostly likely way to get this error.) D. Richard Hipp [EMAIL PROTECTED] ___ sqli

Re: [sqlite] how to select uncomitted rows?

ltiple pages. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] OUTER JOIN and PRIMARY KEY in 3.5.8

id = pets.owner_id instead if what you have. In other words, put the table on the left side of the join before the equals sign instead of after it. It shouldn't make any difference. SQLite should generate exactly the same code regardless of whether you say A=B or B=A. Clearly something is

Re: [sqlite] OUTER JOIN and PRIMARY KEY in 3.5.8

It is doing a nested > table scan instead of using the index for the left join. > Likely this has to do with ticket #3015. http://www.sqlite.org/cvstrac/tktview?tn=3015 D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-

Re: [sqlite] SQLite>=3.5.6 does not open database file

: [sqlite] SQLite>=3.5.6 does not open database file > > I am on Windows XP using sqlite 3.5.6 dll created from the source. Why don't you try the pre-compiled DLLs off of the website. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing

Re: [sqlite] SQLite version 3.5.8

have the shell.c code. > > Was this intended ? > There are a dozen different build products in the latest release. I'm sorry that the one you wanted is not there. Perhaps we can find time to add it later. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-u

[sqlite] SQLite version 3.5.8

. Richard Hipp [EMAIL PROTECTED] P.S.: As I type this, two test failures have emerged in the new release: utf16-bind-6.4 and utf16-bind-7.4. Both failures are benign. The fault is actually in the test script, not in SQLite itself. The test script in these cases assumes a UTF8 database and hence

Re: [sqlite] SQLITE_OMIT_TRIGGER compilation problems

ros you much compile from canonical sources using a unix-like development environment. The reason for this is that SQLite includes several code files that contain automatically generated code. And the generated code depends on which OMIT macros are present. D. Richard Hipp [EMA

Re: [sqlite] Transaction across threads

one can have a write transaction open and one or more others can have a read transaction open, but you cannot have two or more write transactions active at once and all of the read transactions will need to close prior to the write transaction committing (otherwise the writer g

Re: [sqlite] SQLite>=3.5.6 does not open database file

t problems on MacOSX using SQLite version 3.4.0, 3.5.6, 3.5.7 and the latest in CVS. I ran PRAGMA integrity_check using all four versions of SQLite and all return "ok". D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-

Re: [sqlite] SQLite>=3.5.6 does not open database file

On Apr 14, 2008, at 6:58 PM, Steve Topov wrote: > 1.8 Meg > email it to me, please. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite>=3.5.6 does not open database file

On Apr 14, 2008, at 4:53 PM, D. Richard Hipp wrote: > > On Apr 14, 2008, at 4:47 PM, Steve Topov wrote: >> I can open the file with 3.3.5. I did not try to dump it and recreate >> with 3.5.6. >> > > With version 3.5.5, please do this: > > sqlite3 you

Re: [sqlite] SQLite>=3.5.6 does not open database file

On Apr 14, 2008, at 4:47 PM, Steve Topov wrote: > I can open the file with 3.3.5. I did not try to dump it and recreate > with 3.5.6. > With version 3.5.5, please do this: sqlite3 yourdatabasefile.db .schema >schema.txt then email me schema.txt file. D. Richard Hipp [EMA

Re: [sqlite] Table modifications and analyze

into every new database you create with the same schema. Some database engines benefit from running ANALYZE periodically. SQLite does not, in general. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.o

Re: [sqlite] SQLITE_LOCKED behavior

SQLITE_MISUSE > being returned. > Did you call sqlite3_reset() before each retry? D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLITE_LOCKED behavior

a table out from under a reader. I am not aware of any reason why you cannot retry an SQLITE_LOCKED error after a delay, however. Have you actually tried doing that? Is it giving you trouble? D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailin

Re: [sqlite] SQLITE_LOCKED behavior

across > that page. Are these the only times you can get SQLITE_LOCKED errors? If you are in the middle of a SELECT statement and from the same database connection you try to DROP one of the tables that is being read, the DROP statement will return SQLITE_LOCKED. D. Richard Hipp [EMAIL PRO

Re: [sqlite] Planner choosing wrong index

in front of the column name). The plus sign is a no-op - it generates no code and returns the value of its operand unchanged even if the value is a string. But it also disables the term as a candidate for using indices. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Documentation for the register based VM?

nerator. But you should know that we are not through changing it yet and more big changes could appear in future releases. The virtual machine in SQLite is not an API and we make positively zero effort to maintain backwards compatibility from one point release to the next. D. Richard Hi

Re: [sqlite] Direct access to Btree routines in SQLite

e to use the BTree routines directly, and your code breaks or malfunctions due to some unseen subtly or some future change, then the rule is: "No Tears". D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] for function extension in sqlite3

On Apr 8, 2008, at 12:57 PM, dark0s dark0s wrote: > Hi all, I'd like write extension for sqlite3 creating soundex > function like below: > SQLite already contains a soundex function. You just have to recompile using -DSQLITE_SOUNDEX=1 D. Richard Hipp [EMAIL

Re: [sqlite] how to add extensions to amalgamation

avvy but can blunder my way around. (am reading a > basic C tutorial right now). > You might be interested in sqlite3_auto_extension http://www.sqlite.org/c3ref/auto_extension.html D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlit

Re: [sqlite] What is the standard way to store dates and do operations with dates please?

On Apr 7, 2008, at 6:27 PM, Dennis Cote wrote: > D. Richard Hipp wrote: >> >> See http://en.wikipedia.org/wiki/Julian_day >> >> Note that "Julian" in Julian Day Number and Julian Calendar >> refer to two different people named Julius. The Jul

Re: [sqlite] What is the standard way to store dates and do operations with dates please?

alendar refer to two different people named Julius. The Julian Day Number Julian is Julius Scaliger, the father of the guy who invented the julian day number in 1583. Julian in Julian Calendar refers to Julius Caesar, the Roman emperor. The date and time routines in SQLite use the Gregorian calend

Re: [sqlite] French Translation of SQLite documentation

> > Thank you for your answer D. Richard, > > So I continue the translation and I will see fossil for future. > Can you take a ticket for this evolution ? > We can work with you to import your translation whenever you are ready. D. Richard Hip

Re: [sqlite] French Translation of SQLite documentation

some way to have pointers from the English-language pages over to the translated pages. This same offer applies to anybody else who wants translate SQLite documentation into any other living language. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mail

Re: [sqlite] 3.5.7 & TCL: "undefined symbol: sqlite3StrICmp"

isk. Different strokes for different folks, I guess... Anyway, you can fix the problem by either using the precompiled binaries, or downloading the latest from CVS. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sql

Re: [sqlite] sqlite3_finalize(pReadStmt); and sqlite3_close(pDB);

en which uses some memory and at least one file descriptor. If you really are never going to use the database again (or at least not soon) it is better to call sqlite3_close() too. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlit

Re: [sqlite] sqlite3_aggregate_context with C++ classes

On Apr 3, 2008, at 3:39 PM, Steven Fisher wrote: > Can Final be called without Step first being called? Yes. > > > If Step is called, will Final always be called? Yes D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list

Re: [sqlite] Trigger's actions and callbacks

s to the db inside callback > > sqlite3_prepare((sqlite3*)data_arg_3, [...]) > > , an error SQLITE_MISUSE is returned to me SQLite is not reentrant through the update hook. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sq

Re: [sqlite] mem5 ("buddy system") usable?

On Apr 1, 2008, at 2:37 PM, Richard Klein wrote: >> > Fair enough. But can I assume that mem5 *does* currently > work, as far as you know? (I'd really like to use it, as > I'm using SQLite on an embedded system.) > mem5 works as far as I know. D. Richard Hip

Re: [sqlite] mem5 ("buddy system") usable?

tomorrow. But mem5 is high on the list of memory allocators to keep since it can, under some circumstances, guarantee not to fragment memory, which is a desirable property for embedded systems. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users m

Re: [sqlite] "Unsupported File Format" from 3.1.3

er database with an historic version of SQLite - that would be forwards compatibility. SQLite is generally forwards compatible, except when the newer database uses features which were added later. The added feature is probably a descending index. D. Richard Hipp [EMAIL PROTECTED] __

Re: [sqlite] TCL & tester.tcl question

tead of saying: sqlite3_prepare $::DB ... we can now say: sqlite3_prepare db ... which is much more convenient. However, the test scripts have been generated incrementally over the past 8 years and most of them have not been upgraded to take advantage of the new syn

Re: [sqlite] I want to this project but I need help..

you login. Userid="anonymous" Password="anonymous". Then click on the link again. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to select Strict Affinity or No Affinity modes?

it, having never seen any benefit for such a thing. Can you explain why you think strict affinity mode might be beneficial to you? If somebody can provide a good enough rational to justify strict affinity mode, we might just put it in. D. Richard

[sqlite] Testing the new SQLite mailing list

This is the initial test message for the new SQLite mailing list, using GNU mailman now instead of ezmlm. D. Richard Hipp [EMAIL PROTECTED] ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Foreign Constraint Triggers Across Attached Databases

] -- --- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Variable substitution (TCL & SQLite)

ometimes, when you want the text of your SQL statement to be under program control, you want to use "..." instead. Just be very sure you know exactly what you are doing whenever you use "..." D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Next Version of SQLite

On Jan 13, 2008, at 7:53 PM, Gerry Snyder wrote: Joe Wilson wrote: --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: There are people on this mailing list (ex: Joe Wilson) who appear to read every line of every change that we make to SQLite, within minutes of making th

Re: [sqlite] Next Version of SQLite

to work on and less error prone. An entire class of errors (stack overflow) such as the recent ticket #2832 (which could cause database corruption) will become impossible since the VM will no longer have a stack to overflow. D. Richard Hipp [EMAIL PROTECTED

Re: [sqlite] Next Version of SQLite

and the thoroughness of the test suite. Not much is likely to slip through the cracks. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Next Version of SQLite

thorough, but I have found that users can be very creative in stressing SQLite in ways that I would have never imagined, and have not developed tests for. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email

Re: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

imperfectly executed, but it is my goal. If that means that SQLite is uncompetitive, then so be it. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Huge performance drop when using prepared statement

GLOB where the right parameter is a literal string. It will not do so if the right parameter is a parameter. http://www.sqlite.org/optoverview.html#like_opt D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] PATCH: compound query column naming and resolving (Ticket #2822)

ously here. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] ORDER BY Performance on 30,000 records

ms. Tried to index also 'ModifiedDate' but it didn't help. What am i doing wrong? Thanks, Ofir Neuman. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] 3.5.x and pthreads design

ame database within the same process and use them independently and locking should work correctly. You should not have to change anything. It should just work. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Threading (again)

connection. SQLite contains its own mutexes to serialize access. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Memory Usage

On Nov 19, 2007, at 12:36 PM, James Dennett wrote: -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Monday, November 19, 2007 7:36 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Memory Usage Not only applicable to real time systems. If you want a program to

Re: [sqlite] Memory Usage

system. On Linux systems that typically use Doug Lea's malloc, there is no measurable performance difference. But I have had some people running embedded systems tell me that using the malloc-free SQLite results in a significant speed boost. Your mileage may vary. D. Richard Hipp [EMAIL PROTECTED

Re: [sqlite] sqlite and lemon operator precedence problem/question

erator precedence as the SQL standard requires. If I am wrong about that, please correct me and I will change it. On the other hand, changing the operator precedence to agree with MySQL or MSSQL is not something we are interested in doing if they are using a non-standard precedence. D. Richar

Re: [sqlite] sqlite and lemon operator precedence problem/question

On Nov 17, 2007, at 5:12 PM, D. Richard Hipp wrote: On Nov 17, 2007, at 4:58 PM, Joe Wilson wrote: I'm having difficulty with Lemon's operator precedence. That would be a bug in lemon... I was wrong. Turns out the bug was in the SQLite grammar file parse.y. It was assigning the same

Re: [sqlite] sqlite and lemon operator precedence problem/question

the highest precedence? SQLite version 3.5.2 Enter ".help" for instructions sqlite> select ~1 - ~5; -8 sqlite> select (~1) - (~5); 4 That would be a bug in lemon... D. Richard Hipp

Re: [sqlite] Request for help with the SQLite Website

[EMAIL PROTECTED] -- --- D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Request for help with the SQLite Website

t is often a good idea to run your GUI in a separate process from your compute engine so that long computations don't free the display. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] How many virtual table implemenations are there out there?

table implementation (other than the ones that are included with SQLite - such as FTS1-3) that will be broken by an API change, please let me know. And please also advice me how much of a hardship a change would be for you. D. Richard H

Re: AW: AW: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

, or 3? D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Sqlite insertion performance

. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Q: Export Control Classification Number?

extension. So it doesn't have an ECCN. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Sqlite 3.4.2 and VC++ : lib size too big

On Sep 2, 2007, at 1:13 PM, Miguel Fuentes wrote: I didn't know .lib were much larger =\ I always use .a files, so my bad I just linked it into my exe and got a final 420kb exe. See also http://www.sqlite.org/cvstrac/wiki?p=SizeOfSqlite D. Richard Hipp [EMAIL PROTECTED

Re: [sqlite] multiple connections

releases. But until I better understand the backwards compatibility issues, I think it is probably better to leave it off for now. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] version 3.5.0 - Segv

we probably will make the prebuilt libraries threadsafe on all platforms. D. Richard Hipp [EMAIL PROTECTED] - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Using SQL and direct BTree interface to SQLite

BTree layer directly. For these reasons, calls directly into the BTree layer are strongly discouraged. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Issue with sqlite3_result_error inside aggregatefunction

qlite3_result_error at that point if it is appropriate to do so. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: Fw: [sqlite] bestIndex with Float values

(such as gcc) that will emulate floating point. (2) Modify the code to use integers rather than doubles to score indices in the optimizer. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Enhancements for SQLite

On Tue, 2005-09-27 at 13:40 +0200, Joxean Koret wrote: > Why not use mmap, munmap, mprotect, mlock, etc... system calls? > You ever tried to mmap a 10GiB database file into the memory of processor with a 4GiB address space? -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Issue with sqlite3_result_error inside aggregate function

t; You should not call sqlite3_result_* from within the step function of an aggregate. Those routines may be called from within the finalizer function only. -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] Version 3.2.7

SQLite version 3.2.7 is now available on the website. This release fixes several obscure problems that were discovered over the past week. There is no rush to upgrade unless you are having problems. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Easier way ?

On Fri, 2005-09-23 at 13:00 -0400, Richard Nagle wrote: > is there a easier way of typing in data to Sqlite. > > sqlite> insert into car (md_num, md_name, style, year) > ...> values (1, 'Honda', 'Coupe', 1983) > ...> ; > > Man, just 806 more listing > just looking for some short

RE: [sqlite] Version 3.2.6

ithout this workaround. > > > -Original Message- > > From: Jolan Luff [mailto:[EMAIL PROTECTED] > > Sent: Saturday, September 17, 2005 4:14 PM > > To: sqlite-users@sqlite.org > > Subject: Re: [sqlite] Version 3.2.6 > > > > On Sat, Sep 17, 2005 at 03:

Re: [sqlite] Re: query problem

. Or you can get the patches directly from http://www.sqlite.org/cvstrac/chngview?cn=2725. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] query problem

On Mon, 2005-09-19 at 15:19 -0400, D. Richard Hipp wrote: > On Mon, 2005-09-19 at 19:36 +0200, Alain Bertrand wrote: > > hi all, > > > > I am porting a program from mysql to sqlite. > > The following statement doesn't work correctly with sqlite though it does >

Re: [sqlite] query problem

On Mon, 2005-09-19 at 16:06 -0400, Kervin L. Pierre wrote: > D. Richard Hipp wrote: > > Hence, the result set contains no rows. A COUNT() of a empty result > > set gives NULL. > > I thought per the last discussion on "Sum and NULL" > that the count of an empty

Re: [sqlite] Sqlite.dll killing Tcl?

imeline and see if you spot anything similar. -- D. Richard Hipp <[EMAIL PROTECTED]>

<    3   4   5   6   7   8   9   10   11   12   >