[sqlite] unreached code in sqlite3.c?

Hi, I'm getting the following two warnings when compiling sqlite3.c with the latest clang tools: > sqlite3.c:116769:39: warning: code will never be executed [-Wunreachable-code] > if( pTerm->wtFlags & TERM_VNULL ) continue; > ^~~~ >

[sqlite] Performance regression between SQLite 3.8.4.1 and 3.8.8

Hi, we encountered an issue where a query that performed well using SQLite 3.8.4.1 (i.e. execution time way below 1 second) suddenly took several seconds to execute. Unfortunately, I could not yet reduce the query and database to a sample that I could send along and the real query / database

[sqlite] Assertion fires in SQLite 3.8.4.1 for rather basic query

Hi, I ran into the following problem after updating the SQLite 3.8.4.1: When executing the following (rather basic) SELECT query in a debug build of sqlite3, this will cause an assertion to fire in whereLoopAddBtreeIndex() (sqlite3.c, line 13411): SELECT * FROM t1 WHERE(foo_id=5 AND name IN

Re: [sqlite] Assertion fires in SQLite 3.8.4.1 for rather basic query

Sorry, forgot to mention that our previous version of SQLite was 3.7.17 and we did not experience the issue there... Am 20.03.2014 um 12:26 schrieb Jens Miltner <j...@mac.com>: > Hi, > > I ran into the following problem after updating the SQLite 3.8.4.1: > > When ex

Re: [sqlite] Assertion fires in SQLite 3.8.4.1 for rather basic query

o verify that this is the >> correct fix and add new test cases, etc. >> >> Your work-around is to simply compile without -DSQLITE_DEBUG (thus >> disabling all assert() statements) or delete the assert() that is failing. >> >> >> On Thu, Mar 20,

[sqlite] What's the purpose of the "automatic index on" warning message?

We get an sqlite3_log() message with errorCode 284 and message "automatic index on ...". I assume this is some performance penalty warning, but I have no idea what to make of it: We do have an explicit index on the table and column mentioned in the warning message, so I don't know what to do

Re: [sqlite] What's the purpose of the "automatic index on" warning message?

Am 07.04.2014 um 18:42 schrieb Richard Hipp <d...@sqlite.org>: > On Mon, Apr 7, 2014 at 11:51 AM, Jens Miltner <j...@mac.com> wrote: > >> We get an sqlite3_log() message with errorCode 284 and message "automatic >> index on ...". >> I assume this i

[sqlite] amalgamation from source distribution

When I recreate the amalgamation from the source tarball using "make sqlite3.c" on Mac OS X, I end up with a slightly different amalgamation file. The differences are (obviously) only in the generated source files and mostly seems to be re-ordered token tables, different token values, etc.

[sqlite] how to run tests with amalgamized build?

How do I run the tests with an amalgamized build? I have tried to mingle the Makefile to build libsqlite3 from sqlite3.c, but apparently, testfixture compiles some source files again and I get conflicts of symbols being multiple defined... Since we're not using precompiled binaries, I'd

[sqlite] warnings about potentially uninitialized variables when building 3.3.16 with -O3

When I build sqlite3 3.3.16 on Mac OS X with -O3 optimization, I get the following list of warnings about potentially uninitialized variables: gcc 3.3: CompileC build/sqlite.build/Release/sqlite_static_lib.build/Objects- normal/ppc/sqlite3.o sqlite3.c normal ppc c com.apple.compilers.gcc.

Re: [sqlite] how to run tests with amalgamized build?

Am 19.04.2007 um 15:42 schrieb [EMAIL PROTECTED]: Jens Miltner <[EMAIL PROTECTED]> wrote: How do I run the tests with an amalgamized build? You may need to adjust a pathname or two, but the following is the general idea: make sqlite3.c gcc -o testfixure -g -O3

Re: [sqlite] testing with single source file

Am 01.04.2007 um 20:05 schrieb Iulian Musat: [EMAIL PROTECTED] wrote: [...] In past releases of SQLite, we have made available a ZIP archive with preprocessed source files. In the future, we may change this so that instead of a ZIP archive full of individual files, we ship a single

Re: [sqlite] testing with single source file

Am 20.04.2007 um 09:13 schrieb Jens Miltner: Am 01.04.2007 um 20:05 schrieb Iulian Musat: [EMAIL PROTECTED] wrote: [...] In past releases of SQLite, we have made available a ZIP archive with preprocessed source files. In the future, we may change this so that instead of a ZIP archive

Re: [sqlite] chickens and egg problem: how to set page size before creating

Am 12.5.07 um 04:26 schrieb Andrew Finkenstadt: It would appear that I need one "sqlite3* handle" in order to execute statements such as "pragma page_size=32768;", but the act of calling sqlite3_open(filename, ) creates the file, which prevents the changing of the page size, as the sqlite

Re: [sqlite] Quick question about multithread and SQLITE_BUSY/SQLITE_LOCKED in 3.5.4

Am 19.1.08 um 03:13 schrieb [EMAIL PROTECTED]: OK I figured out SQLITE_THREADSAFE=0 for the second question... And it seems the answer for the first question is yes, but if you know a simpler way please share it with us, thanks! You could use a read-write mutex to serialize access to your

Re: [sqlite] How to realize the ROWID in a view?

Am 13.06.2006 um 04:14 schrieb PY: Thanks for you reply. I Just want to get a sequence number in a view, that is not the ID field in the table foo. Table foo is a sample of mine. In fact, my table is not only the id and x field. And the x field could be duplicate in the table foo.

[sqlite] use of index in ORDER BY clause

I have a schema similar to this: CREATE TABLE foo (id integer primary key, name text); CREATE TABLE bar (id integer primary key, foo_id integer, something text); CREATE INDEX bar_idx on bar(foo_id, something); When I run a query like SELECT foo.id AS foo_id, bar.id AS

Re: [sqlite] use of index in ORDER BY clause

Am 27.06.2006 um 18:06 schrieb Dennis Cote: Jens Miltner wrote: I have a schema similar to this: CREATE TABLE foo (id integer primary key, name text); CREATE TABLE bar (id integer primary key, foo_id integer, something text); CREATE INDEX bar_idx on bar(foo_id, something); When I run

[sqlite] database corruption

Hi everybody, We have encountered two corrupted databases so far at customers and we have no idea how they could become corrupted (we haven't had any corruption in house so far). (Yes, I've read the "How to corrupt your database files" section, but I don't think any of the methods

Re: [sqlite] database corruption

Am 30.06.2006 um 00:01 schrieb [EMAIL PROTECTED]: I have never yet found anything useful by analyzing a corrupt database file. Generally, the only way to fix this kind of problem is come up with a reproducible test case. Unfortunately, that may prove difficult, if not impossible :( Anyway,

Re: [sqlite] use of index in ORDER BY clause

Am 29.06.2006 um 17:17 schrieb Dennis Cote: Jens Miltner wrote: Is there any way to improve the ORDER BY performance for joined queries? From your answer that the intermediate results are sorted, I take it no index won't ever be used when using ORDER BY with a join query

Re: [sqlite] update or insert.

Am 27.06.2006 um 22:15 schrieb [EMAIL PROTECTED]: My brain does not seem to be able to function properly today. I can think of many ways to do what I want to do but none of them I like. I will describe the problem in the most symplistic form. I have two tables. The first table, has a row

Re: [sqlite] Question on reading UTF-16 files using sqlite3.exe

Am 03.07.2006 um 03:49 schrieb Ché Gonzalez: From my browsing through the documentation, I have observed the ability to have UTF-16 column names in sqlite3. I would like to use the command-line: sqlite3 ae.db ".read filename.sql" where filename.sql is a UTF-16 encoded file. Is there any

Re: [sqlite] SQLite String

Am 10.07.2006 um 10:52 schrieb Ernesto Olmos: I have an SQLite database which I work in memory (:MEMORY) and I have to get the binary text (string) of it. Is there a way to do it without writing it to disk and reading the file? Command ATTACH works good to get and write from disk or to

Re: [sqlite] INT and INTEGER are not same, behaves differently (for PRIMARY KEY) ?

Am 12.07.2006 um 11:16 schrieb RohitPatel: INT and INTEGER behaves differently (for PRIMARY KEY) !!! (SQLite 3.3.4) create table t1 ( id INTEGER PRIMARY KEY ); create table t2 ( id INT PRIMARY KEY ); insert into t1 values(NULL); insert into t1 values(NULL); insert into t2 values(NULL);

Re: [sqlite] filter and sort in CREATE VIEW or CREATE TABLE ?

Am 13.07.2006 um 14:10 schrieb Christian Smith: Inline. ditto Jens Miltner uttered: Hi all, I need to create a temporary table holding ID column values from a number of tables, so that I have a unique way to access the data for display purposes: say I have 2 related tables [snip

Re: [sqlite] Memory exhaust

Am 13.07.2006 um 14:31 schrieb Robert Wallner: Hi all, I have a software packages managing system that uses an sqlite database. It's written in python using pysqlite2 as the wrapper. The installed version of sqlite is 3.2.7. After upgrading sqlite to the 3.3.x series, every operation against

Re: [sqlite] Major projects using SQLite

Am 14.07.2006 um 15:32 schrieb Jon García de Salazar Bilbao: Could you give examples of some major software projects using SQLite? Did you check out the list at ? May not list _all_ the major projects, but sure lists quite a few...

[sqlite] temp_store=1 performance on Mac OS X vs. Windows

Hi, we just found that when using file-based temporary storage (compile time macro definition TEMP_STORE=1) vs. memory-based temporary storage (TEMP_STORE=2), on Mac OS X, the performance almost doesn't degrade at all, whereas on Windows, we're getting a huge performance penalty when

Re: [sqlite] temp_store=1 performance on Mac OS X vs. Windows

(Probably depends on the antivirus software?) Thanks --- Jens Miltner <[EMAIL PROTECTED]> wrote: Hi, we just found that when using file-based temporary storage (compile time macro definition TEMP_STORE=1) vs. memory-based temporary storage (TEMP_STORE=2), on Mac OS X, the performanc

Re: [sqlite] sqlite3_interrupt() and threads

Am 26.07.2006 um 01:06 schrieb [EMAIL PROTECTED]: Michael Scharf <[EMAIL PROTECTED]> wrote: Rob, I notice in the documentation that the sqlite3_progress_handler() method is marked "experimental". Is that significant? No idea, that's a question Richard Hipp may answer.. I need to

Re: [sqlite] Reading the same table from two threads

Am 26.07.2006 um 14:43 schrieb Rob Richardson: Greetings! I am starting two threads in quick succession that read the same table. Each thread calls sqlite3_open(), so they are using separate database pointers. The first thread asks for records recorded in the last 24 hours. The second

Re: [sqlite] temp_store=1 performance on Mac OS X vs. Windows

Am 26.07.2006 um 15:41 schrieb [EMAIL PROTECTED]: Jens Miltner <[EMAIL PROTECTED]> wrote: OTOH, our customers might also have antivirus software installed, so this still would not be a solution :( Does anybody have advice on how to make sqlite work smoothly with antivirus so

Re: [sqlite] random access table row

Am 08.08.2006 um 13:15 schrieb Lijia Jin: Hi, I am new to sqlite and need some help for random accessing a table row using Sqlite C API. The project I am working on supports network users to query the sqlite database from remote sites. We like to provide an interface so that user can

Re: [sqlite] Query Execution speed.

Am 09.08.2006 um 05:51 schrieb Manzoor Ilahi Tamimy: hi All, I have to use SQLite for one of my project as ":memory:" db. // - Can I get a better speed if I change or omit some macros. I saw "

[sqlite] handling of BLOB bound parameters

I just stumbled across a problem where sqlite would be stuck for quite a long time inside sqlite3VdbeExpandSql when using bound BLOB parameters, i.e. my query looks like INSERT INTO foo VALUES (?,?,?,?...) and one of the parameters is a BLOB of about 700k. What I found is that when this query

Re: [sqlite] handling of BLOB bound parameters

Am 14.10.2010 um 12:56 schrieb Dan Kennedy: > > On Oct 14, 2010, at 5:43 PM, Jens Miltner wrote: > >> I just stumbled across a problem where sqlite would be stuck for >> quite a long time inside sqlite3VdbeExpandSql when using bound BLOB >> parameter

Re: [sqlite] bit operations in select statements

Am 20.02.2008 um 11:54 schrieb Jos van den Oever: > Hi all, > > Is it possible to use logic operations on fields, in particular on > integers and on fixed sized blobs (256 bits/32 bytes). > I'd like to do queries like this: > select key where number_of_bits_set(value) = 10; I believe for this

Re: [sqlite] Optimization Question - multithread prepare ?

Am 20.02.2008 um 14:03 schrieb Mark Gilbert: > Folks. > > Our application uses SQlite on Mac OSX. It is a central data hub for > a larger infrastructure and manages data coming in from some clients, > and requests for data from other clients, using our own XML based > protocols via TCPIP. > >

Re: [sqlite] Index for Primary Key column missing?

Am 21.02.2008 um 10:30 schrieb Neville Franks: > I have created a table with a column: tag text primary key > > When I do: > sqlite> .indices tags > sqlite_autoindex_tags_1 > > I only see the one index which I assume is for the ROWID clm. No, this is the index for your 'tag' column as can be

Re: [sqlite] Moving port from 3.5.1 to 3.5.7...

I'd like to chime in that we have somewhat similar requirements: Our app is heavily threaded and we had sqlite's memory allocations show up as bottlenecks at times. This happened when the 'new' allocators that allow for high-water marks, etc. appeared first. Since we don't need any of the

[sqlite] changed default ordering of SELECT queries in 3.5.9?

Hi, I've got a question and I don't know exactly whether the behavior is standard or expected or not. Assuming the following schema and data: CREATE TABLE t1 (id, name); INSERT INTO t1 values (1, 'John'); INSERT INTO t1 values (2, 'Arnold'); INSERT INTO t1 values (3, 'Zork'); We

[sqlite] Follow-up: changed default ordering of SELECT queries in 3.5.9?

Am 30.05.2008 um 12:45 schrieb Jens Miltner: > Hi, > > I've got a question and I don't know exactly whether the behavior is > standard or expected or not. > > Assuming the following schema and data: > CREATE TABLE t1 (id, name); > INSERT INTO t1 values (1, 'John');

Re: [sqlite] Follow-up: changed default ordering of SELECT queries in 3.5.9?

Am 30.05.2008 um 12:55 schrieb Jens Miltner: > > Am 30.05.2008 um 12:45 schrieb Jens Miltner: > >> Hi, >> >> I've got a question and I don't know exactly whether the behavior >> is standard or expected or not. >> >> Assuming the following

Re: [sqlite] SQLite Analyzer OSX

Am 02.06.2008 um 07:17 schrieb Bruce Robertson: > I see that SQLite3 Analyzer for OSX is listed on the download page > but no > instructions are provided and when unzipped it does nothing. > > What are we supposed to do with this? Hmmh - I downloaded and unzipped the archive and launched the

Re: [sqlite] plain vanilla memory allocator (was: Moving port from 3.5.1 to 3.5.7...)

Am 28.05.2008 um 17:52 schrieb D. Richard Hipp: > > On May 28, 2008, at 11:25 AM, Jens Miltner wrote: > >> s there any work being done trying to either minimize the >> synchronization needed or provide a memory allocator that doesn't do >> all the alerting > &

[sqlite] sqlite 3.6.2 tests on Mac OS X

Hi, I just merged our code base with the sqlite 3.6.2 distribution and decided to run the tests on Mac OS X (10.5.4). I had two issues: (1) make tests would not properly link the testfixture - it complains about missing Tcl symbols - I guess the libtool link phase does not know about the

[sqlite] all.test failures on Mac OS X

Hi, I just ran the full test suite (all.test) in our Mac OS X build and got a few failures, but I'm not quite sure what to make of them and whether they're critical failures - they don't seem to be part of the quick tests suite, so I figure they might be less important? Anyway, here's the

Re: [sqlite] ATTACH problem

Am 09.10.2008 um 18:21 schrieb [EMAIL PROTECTED]: > > Ok it seems last time I've posted too many errors so I'll try to ask > about this one. Maybe other are just consequences of this. I've > finally received this error also on my computer, but only in release > build. > > - windows XP,

[sqlite] Ticket #3461

Hi, I just found another issue that looks like it might be related to ticket #3461: The following query returns incorrect data for the column 'column_56f32f43' - it seems to repeat the data from other rows for some rows instead of picking the correct data. SELECT

[sqlite] Terrible performance for one of our tables

Hi, we're seeing terrible performance problems when fetching data from one of our tables: The table contains roughly 1.2 Million rows and a plain "SELECT COUNT(*) FROM t" query takes 8 minutes to finish. The table contains 10 fields, but the records average to about 100 Bytes of data total.

Re: [sqlite] Terrible performance for one of our tables

Am 19.11.2008 um 13:05 schrieb D. Richard Hipp: > > On Nov 19, 2008, at 3:08 AM, Jens Miltner wrote: > >> Hi, >> >> we're seeing terrible performance problems when fetching data from >> one >> of our tables: >> The table contains roughly 1.2 Millio

Re: [sqlite] Sqlite thread safety on iPhone

Am 19.11.2008 um 17:53 schrieb Paul Clarke: > My current understanding, which may well be imperfect, is as follows: > > > > 1) If you open an Sqlite database more than once (i.e. issue > multiple calls to sqlite3_open) for reading and writing then you will > get locking conflicts between the

Re: [sqlite] Database file size

Am 27.11.2008 um 09:12 schrieb Simon Bulman: > I have been playing around with SQLite to use as an alternative to > one of > our proprietary file formats used to read large amounts of data. Our > proprietary format performs very badly i.e. takes a long time to > load some > data; as expected

Re: [sqlite] Database file size

varchar size constraints you can actually put any amount of data into a varchar(30) column) ? > > I am actually recreating the whole database (delete file and recreate) > programmatically so vacuuming has not effect. > > Cheers, > S. > > -Original Message- >

Re: [sqlite] Database file size

varchar size constraints you can actually put any amount of data into a varchar(30) column) ? > > I am actually recreating the whole database (delete file and recreate) > programmatically so vacuuming has not effect. > > Cheers, > S. > > -Original Message- >

Re: [sqlite] Database file size

n your database to see the memory usage of each table, free space, etc. Are you using a stock sqlite3 installation or did you modify/customize it through build settings? > > -Original Message- > From: Jens Miltner [mailto:[EMAIL PROTECTED] > Sent: 28 November 2008 08:38 &

[sqlite] segmentation violation in fulltest on Mac OS X

Hello, I just upgraded to sqlite 3.6.10 and keep getting a segmentation violation when running the full tests on Mac OS X: The last test completed is consistently thread001.1.3. We're using a custom Xcode build of sqlite, so there's a chance that it has to do with our build settings.

Re: [sqlite] segmentation violation in fulltest on Mac OS X

Am 19.01.2009 um 18:42 schrieb D. Richard Hipp: > > On Jan 19, 2009, at 3:50 AM, Jens Miltner wrote: > >> Hello, >> >> I just upgraded to sqlite 3.6.10 and keep getting a segmentation >> violation when running the full tests on Mac OS X: >> The last test

[sqlite] Ticket #3602

Hi, I filed ticket #3602 a couple of days ago: Essentially, when using empty test sets ("IN ()" / "NOT IN ()") in the WHERE expression of a query, an assert() fires inside the bestIndex function. The assert expects pExpr->pList to be non-NULL and the code actually checks for this to be

Re: [sqlite] Ticket #3602

Am 23.01.2009 um 12:44 schrieb Dan: > > On Jan 23, 2009, at 5:37 PM, Jens Miltner wrote: > >> Hi, >> >> I filed ticket #3602 a couple of days ago: >> >> Essentially, when using empty test sets ("IN ()" / "NOT IN ()") in >

Re: [sqlite] Wiki page on Management Tools - should it explicitely state Mac OS X support?

Am 03.03.2009 um 22:53 schrieb BareFeet: > Hi, > >>> on the Wiki page listing SQLite Management Tools >>> >>> , there are columns for Web, Windows, Linux and Misc. as supported >>> platforms. Since Mac OS X is a well-supported SQLite

Re: [sqlite] Converting BLOB Data type to String

Am 02.04.2009 um 07:45 schrieb SATISH: > Hello Buddies, > >I have written a string into database by converting into > "BLOB Data > Type".writing into database is Ok I got a problem when reading from > the > database to read a blob from the database I am using the function > "const

Re: [sqlite] which tool do they use to generate the SQL Syntax diagrams?

FWIW - you can still get a textual description at ... Am 20.04.2009 um 15:59 schrieb J. King: > On Mon, 20 Apr 2009 08:59:02 -0400, Jean-Denis Muys > > wrote: > >>> It's a shame: I far preferred the BNF: more compact, not to >>>

Re: [sqlite] Column headers of result

Am 29.06.2009 um 06:57 schrieb BareFeet: > Hi, > > Is there any way in the command line to get the columns in a query > result? > > For example, given an ad-hoc SQL command, such as: > > begin; > insert into MyTableOrView select * from SomeSource; > select * from MyTableOrView join

[sqlite] assertion in balance_nonroot

We get a strange assertion in the sqlite3 code in our app which is multithreaded and heavily uses sqlite. The assertion we get is from within balance_nonroot in btree.c, line 4085: assert( cntNew[0]>0 ); We use separate database connections from each thread (actually, more likely, even

Re: [sqlite] Segmentation fault on large selects

Am 01.08.2005 um 21:41 schrieb Kervin L. Pierre: scunacc wrote: I have built with debugging on, and can't do anything with the core dump: dbx Type 'help' for help. enter object file name (default is `a.out', ^D to exit): sqlite3 reading symbolic information ... [using memory image in

Re: [sqlite] Segmentation fault on large selects

Am 02.08.2005 um 19:18 schrieb D. Richard Hipp: On Tue, 2005-08-02 at 09:30 -0400, D. Richard Hipp wrote: On Mon, 2005-08-01 at 22:04 +0200, Jens Miltner wrote: we get an assertion (no crash here, though) in btree.c and the backtrace looks similar to the one scunacc provided, which made me

Re: [sqlite] import function

Am 03.08.2005 um 20:50 schrieb Dan Wellisch: Hello: I understand there is the .import function for the sqlite3 command interface, but I need to execute this function from within the C API. What do I use to do this? I need to execute this type of function from within my C++ program, not

Re: [sqlite] Import CSV in sqlite3?

Am 6.8.05 um 09:06 schrieb Joe Noon: You can use a system call to execute a command like the following; sqlite3 -separator , test.db ".import test.csv sometable" That is exactly what I needed! Thanks a ton. Joe Noon My issue now is that the csv may or may not have all of the columns

Re: [sqlite] 2.8.16

How did you download the archive? Using which client? I never had any problems using the source archives (may not have used that exact version, but I never had any problems using the .tar.gz archives on Mac OS X...) Make sure you don't use any older version of Stuffit or the like to

Re: [sqlite] User-defined Collating Sequences

Am 29.09.2005 um 17:40 schrieb Martin Pfeifle: Hi, does anybody know whether a code example for User-defined Collating Sequences in C exists, and where I can find such an example. Check out func.c in the sqlite source distribution - it contains the implementations of the built-in collation

Re: [sqlite] Speed Test not work (pt2)

Am 01.10.2005 um 06:58 schrieb Richard Nagle: Well, Did this: sqlite3 test2.db create Table T (A, B, C ); .separator , .import 'sqtest2.txt' T It looks like it working, but the file size is still 4K and not 170 Megs. Please note: I exported this database as a Tab delimiter

Re: [sqlite] Transactions

Am 05.10.2005 um 13:17 schrieb Christian Smith: On Tue, 4 Oct 2005, Martin Engelschalk wrote: Hello Christian, thank you, but synchronous is already off. What i aim to avoid is writing the rollback - journal. In order to rollback, some additional writing to disk is surely unaviodable.

Re: [sqlite] Infinite loop on sqlite3_close()

Am 10.10.2005 um 16:53 schrieb Preston Zaugg: While running some performance tests i ran into a condition where sqlite3_close got caught in an infinite loop. The loop it gets caught in is on line main.c 194: while( pPrev && pPrev->pNext!=db ){ pPrev = pPrev->pNext; } This did not

Re: [sqlite] Please, please do _not_ remove this feature from SQLite...

Am 12.10.2005 um 12:12 schrieb pilot pirx: P.S. On somewhat related note: since sqlite is written in C - why it does not expose some basic functions from the standard C library (log, exp, sqrt, sin), at least optionally? Understandably, the idea is to keep it 'lite'. But, may be, an

Re: [sqlite] Multithreading Question

Am 21.10.2005 um 11:58 schrieb Michael J. Sviridov: Using sqlite 3.2.7 in a multi-threaded C++ application: I've got two thread's (with unique db handles), each thread does the following: BEGIN EXCLUSIVE TRANSACTION; (60,000 INSERT OR REPLACE statements into the same table) COMMIT

[sqlite] Ticket #1654

Regarding the checkin comment from the fix for ticket 1654: Always register BINARY collating sequences for UTF-16BE and UTF-16LE both. Formerly we were only registering the native byte order by default. Ticket #1654 . Note: There may still be problems with collating sequence synthesis. (By

Re: [sqlite] Executing SQL from file

Am 01.02.2006 um 17:10 schrieb deBooza (sent by Nabble.com): Hi I'm using sqlite in a c++ program, using functions sqlite3_open, sqlite3_exec, sqlite3_close etc. I am trying to import a lot of data, probably around 100,000 rows+. I have found it quicker if I format the data into SQL

Re: [sqlite] import

Am 19.2.06 um 15:06 schrieb Randall: Hi, Sorry for the basic queries here... If I ".output" with .mode "tabs" , "lines" etc, the resulting text file or csv file cannot be ".imported" by import, as the EOL is not read? Can I fix this easily? Thanks, Randall You didn't tell what you want

Re: [sqlite] Older sources

Am 20.02.2006 um 10:08 schrieb Manfred Bergmann: Am 20.02.2006 um 19:12 schrieb Jose Da Silva: On February 19, 2006 06:45 pm, Manfred Bergmann wrote: Hi there. I would need the sources of an older version (3.1.2) of SQLite. Are they still available for download? If nobody has it, go to

Re: [sqlite] How to verify sqlite file?

Am 14.4.06 um 04:30 schrieb Charlie Li: Is there any way to verify a file is sqlite3 file? When I tried to open a non-sqlite file by sqlite_open(), the system crash. I checked the source codes and found no file type checking. The final trace is toward to page.c file. How to revise

Re: [sqlite] Converting ver 2 to ver 3

Am 15.4.06 um 02:36 schrieb Paul Nash: I have taken the plunge and am converting from ver 2.8.16 to ver 3. I used the .DUMP method but found a problem. My char/text fields containg numbers were output as pure numbers without the quotes, so that on input to ver 3 they were stored as

Re: [sqlite] How to convert a sqlite table in a sqlite db into a text file?

Am 17.4.06 um 10:58 schrieb 杰 张: Hi,all I just want to implement to download a sqlite table in a sqlite db from IE browser , but I must first convert sqlite format into text format for reading data information of the table. I want to finish the conversion automatically through

Re: [sqlite] SQLite3 command line utility crashes on MacOS X

Am 15.04.2006 um 00:50 schrieb Thomas Chust: On Fri, 14 Apr 2006, Will Leshner wrote: On 4/14/06, Thomas Chust <[EMAIL PROTECTED]> wrote: I just downloaded the 3.3.5 distribution tarball and confirmed that the problem occurs with a binary built from that codebase as well. I assume you

Re: [sqlite] Re: How to improve performance of SQL DELETE

Am 19.04.2006 um 14:08 schrieb Igor Tandetnik: Kai Wu <[EMAIL PROTECTED]> wrote: 2. The table schema is simple TABLE MID(id VARCHAR(8),scts VARCHAR(12),daddr VARCHAR(20)) the scenario is it needs first select the "id" by select id from MID where scts= .. AND daddr=... after

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Am 22.04.2006 um 15:48 schrieb COS: Thanks for the info. I did have found in the manual that UTF16 is converted to UTF8 on Windows environments. But one little question: How would one know if the filename is in UTF8 or UTF16? You see, my little application is installed in PC's all around

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

Am 24.04.2006 um 14:51 schrieb COS: Hi Jens, - Original Message - From: "Jens Miltner" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, April 24, 2006 5:30 AM Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16? Am 22.04.2006 um 15:4

[sqlite] searching sqlite tickets?

Before the timeline was migrated to fossil, I was able to search for tickets. In the current sqlite.org website, I can no longer search for tickets - I can only show all tickets, all closed tickets or all open tickets, but I can't search for keywords any more... Is there still a way to

Re: [sqlite] searching sqlite tickets?

Am 19.10.2009 um 09:47 schrieb Dan Kennedy: > > On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote: > >> Before the timeline was migrated to fossil, I was able to search for >> tickets. >> In the current sqlite.org website, I can no longer search for tickets >> -

Re: [sqlite] searching sqlite tickets?

Am 19.10.2009 um 09:47 schrieb Dan Kennedy: > > On Oct 19, 2009, at 2:36 PM, Jens Miltner wrote: > >> Before the timeline was migrated to fossil, I was able to search for >> tickets. >> In the current sqlite.org website, I can no longer search for tickets >> -

Re: [sqlite] Late data typing. Am I missing something?

Am 29.10.2009 um 14:31 schrieb Simon Slavin: > > On 29 Oct 2009, at 9:36am, John Crenshaw wrote: > >>> Consider the case of an application using an SQLite database to >>> store >>> its settings (like the Windows registry, but portable). The dynamic >>> type system is great for this. >>> >>>

[sqlite] sqlite3_analyzer with 3.6.19 distribution

Hi, I just tried to build the sqlite3_analyzer from the 3.6.19 distribution on Mac OS X (using 'make sqlite3_analyzer'), but when I run the tool, I get the following error: > Analyzing table agent_registry... > ERROR: invalid command name "btree_cursor_info" > invalid command name

Re: [sqlite] sqlite3_analyzer with 3.6.19 distribution

Am 11.11.2009 um 17:45 schrieb D. Richard Hipp: > > On Nov 11, 2009, at 11:24 AM, Jens Miltner wrote: >> >> Is sqlite3_analyzer supposed to work in 3.6.19? >> > > > No. sqlite3_analyzer has been busted for a long time. But the 3.6.0 > version of sq

Re: [sqlite] sqlite3 for Mac OSX 10.5

Am 12.11.2009 um 20:08 schrieb Peter Haworth: > Thanks for all the info. I believe the problem lies within Revolution > since I'm pretty sure it includes its own private library of the > sqlite code. I've reported it to them and hopefully they will fix it. > > I understand the reasons for

Re: [sqlite] image upload to db trouble

Am 13.11.2009 um 09:25 schrieb Keith Roberts: > On Fri, 13 Nov 2009, Artur Reilin wrote: > >> To: General Discussion of SQLite Database >> From: Artur Reilin >> Subject: Re: [sqlite] image upload to db trouble >> >>>//echo $images; >>> $db

Re: [sqlite] Problem with database (SELECT hangs)

Am 21.11.2009 um 04:48 schrieb Phil Longstaff: > sqlite> explain query plan SELECT DISTINCT t.* FROM transactions AS > t, splits > AS s WHERE s.tx_guid=t.guid AND > s.account_guid='e3ea8186deb3a9c160ab3b9409ea618f'; > 0|0|TABLE transactions AS t WITH INDEX > sqlite_autoindex_transactions_1

Re: [sqlite] BUG: the rowid column in view is automatically named as id

Am 09.12.2009 um 13:42 schrieb Alexey Pechnikov: > Hello! > > On Wednesday 09 December 2009 15:07:16 Pavel Ivanov wrote: >> It's been said in this list not once already: unless you're using "as >> ..." to name the column it's not guaranteed to have any particular >> name you expect it to. So

[sqlite] usage of indexes - query performance

Hi everybody, consider the following database schema: CREATE TABLE t1 ( id INTEGER PRIMARY KEY, uid, x ); CREATE INDEX t1_idx ON t1(uid); CREATE TABLE t2 ( id INTEGER PRIMARY KEY, t1_id INTEGER, y ); CREATE INDEX t2_idx ON t2(t1_id); Shouldn't

Re: [sqlite] usage of indexes - query performance

actually make SQLite use the proper indexes. Thanks a lot! > > On Fri, Dec 18, 2009 at 3:52 AM, Jens Miltner <j...@mac.com> wrote: >> Hi everybody, >> >> consider the following database schema: >> >> CREATE TABLE t1 ( >>id INTEGER PRIMA

  1   2   >