Re: [sqlite] Bug report: sqlite3_column_name vs. LIKE clause in prepared statements

On Mon, Mar 28, 2011 at 7:44 PM, Klaus Keppler wrote: > Hi, > > I'd like to submit the following bug report. However, before suspecting > the problem in SQLite, we've debugged and traced our own code for two > days, and at last got it reproducible within SQLite. > >

Re: [sqlite] What stack size is required for SQLite to spin?

On Mon, Mar 28, 2011 at 5:25 AM, Mikael wrote: > Hi, > > I'm looking at the possibility of using SQLite in an environment with a > fixed-size stack, and wish to know, what stack size do I need for SQLite > always to work? > We have heard of people running SQLite in as

[sqlite] Bug report: sqlite3_column_name vs. LIKE clause in prepared statements

Hi, I'd like to submit the following bug report. However, before suspecting the problem in SQLite, we've debugged and traced our own code for two days, and at last got it reproducible within SQLite. DESCRIPTION: It's an absolute strange behaviour: if you do queries with the LIKE operator

Re: [sqlite] receive signal 7 bus error when heavily read/write in the mode Journal_mode = WAL

What version of SQLite are you using? Specifically, what is the output of this query: SELECT sqlite_source_id(); On Mon, Mar 28, 2011 at 4:57 PM, ChingChang Hsiao < chingchang.hs...@overturenetworks.com> wrote: > The GDB report is shown as below. > > Program terminated with signal 7, Bus

[sqlite] FW: receive signal 7 bus error when heavily read/write in the mode Journal_mode = WAL

The GDB report is shown as below. Program terminated with signal 7, Bus error. #0 0x1009fcd4 in sqlite3WalRead (pOut=, nOut=, pInWal=, pgno=, pWal=) at sqlite3.c:43910 43910 sqlite3.c: No such file or directory. in sqlite3.c (gdb) bt #0 0x1009fcd4 in sqlite3WalRead (pOut=,

[sqlite] receive signal 7 bus error when heavily read/write in the mode Journal_mode = WAL

The GDB report is shown as below. Program terminated with signal 7, Bus error. #0 0x1009fcd4 in sqlite3WalRead (pOut=, nOut=, pInWal=, pgno=, pWal=) at sqlite3.c:43910 43910 sqlite3.c: No such file or directory. in sqlite3.c (gdb) bt #0 0x1009fcd4 in sqlite3WalRead (pOut=,

Re: [sqlite] primary key on two columns of an associative table

On 29/03/2011, at 12:59 AM, Sam Carleton wrote: > The system calls for an associative table, a table with two foriegn > keys to two other tables, allowing for a many to many relationship. > Is there any way to make the primary key be both the columns? Yes, you can define a primary key on two

Re: [sqlite] unexpected deadlocks in shared cache mode with unlock_notify

On 28 Mar 2011, at 8:45pm, Boris Kolpackov wrote: > As expected, I periodically get deadlocks (SQLITE_LOCKED return code from > unlock_notify()) for the second transaction due to the read to write > lock upgrade. But I also get deadlocks reported for the first transaction > and this is something

Re: [sqlite] unexpected deadlocks in shared cache mode with unlock_notify

Hi Igor, Igor Tandetnik writes: > On 3/28/2011 3:45 PM, Boris Kolpackov wrote: > > > > The first transaction behaves as if, for some reason, it first obtained > > the read lock and then tried to upgrade it to the write lock. > > No, it first obtained a RESERVED lock, and

Re: [sqlite] unexpected deadlocks in shared cache mode with unlock_notify

On 3/28/2011 3:45 PM, Boris Kolpackov wrote: > As expected, I periodically get deadlocks (SQLITE_LOCKED return code from > unlock_notify()) for the second transaction due to the read to write > lock upgrade. But I also get deadlocks reported for the first transaction > and this is something that I

[sqlite] unexpected deadlocks in shared cache mode with unlock_notify

Hi, I run several threads each having a shared cache connection to the same database containing a single table. No other threads or processes access this database. Half of the threads executes the following transaction: BEGIN INSERT INSERT INSERT COMMIT Where each INSERT inserts a unique row

Re: [sqlite] Problem with VACUUM feature

On Mon, Mar 28, 2011 at 08:55:28PM +0530, Sudha Venkatareddy scratched on the wall: > Dear Jay, > Please check the below source code from Amalgamation file and suggest me > which section of the code is critical and what happens during execution of > each of the APis called within

Re: [sqlite] connect to sqlite using OLE-DB or ODBC

Andi Suhandi writes: > > Hi guys, > > I am a newbie in sqlite. Is it possible to connect sqlite db using > OLE-DB or ODBC ? > If possible, what do i need ? > for ODBC (M$,Linux,Mac) go to http://www.ch-werner.de/sqliteodbc/ greetings oliver

Re: [sqlite] Problem with VACUUM feature

Dear Jay, In the course of execution of Sqlite3RunVacuum() API, total 4 new files will be created. 3 temporary files and 1 journal file. Since my main DB file name is "MyDb.db", the journal file which is created is "MyDb.db-journal" I observed that there was no failure in sqlite3_io_methods API

Re: [sqlite] primary key on two columns of an associative table

On Mon, Mar 28, 2011 at 09:59:59AM -0400, Sam Carleton scratched on the wall: > The system calls for an associative table, a table with two foriegn > keys to two other tables, allowing for a many to many relationship. > Is there any way to make the primary key be both the columns? > > CREATE

[sqlite] primary key on two columns of an associative table

The system calls for an associative table, a table with two foriegn keys to two other tables, allowing for a many to many relationship. Is there any way to make the primary key be both the columns? CREATE TABLE Invoice_Item_Favorite( Invoice_Item_Id INTEGER, FavoriteId INTEGER,

Re: [sqlite] Lack of "decimal" support

On 28 Mar 2011, at 5:09am, Nico Williams wrote: > On Mar 27, 2011 10:20 PM, "Darren Duncan" wrote: >> >> >> SQLite already has Blobs, and I see those as being exactly the same thing > > Blobs are _octet_ strings. Sure, one could write functions that encode and >

Re: [sqlite] connect to sqlite using OLE-DB or ODBC

On 28 Mar 2011, at 12:14pm, Andi Suhandi wrote: > I am a newbie in sqlite. Is it possible to connect sqlite db using > OLE-DB or ODBC ? > If possible, what do i need ? What programming language are you using ? What operating system is the computer running ? Simon.

Re: [sqlite] Lack of "decimal" support

On Mar 27, 2011 10:20 PM, "Darren Duncan" wrote: > > Nico Williams wrote: > > User defined types. There are two types in particular that I'd like > > to see added: > > > > - Bit strings. Bit strings are like character strings, but the > > elements can only be bits.

[sqlite] connect to sqlite using OLE-DB or ODBC

Hi guys, I am a newbie in sqlite. Is it possible to connect sqlite db using OLE-DB or ODBC ? If possible, what do i need ? Andi ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_step behavior on empty set

Wouldn't the addition of "Empty result sets will return SQLITE_DONE on the first call to sqlite3_step." add some clarity? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From: sqlite-users-boun...@sqlite.org

[sqlite] CPU time consumption from sqlite3_* call to VFS (or Application Defined Page Cache) procedure call and back

Hi, What CPU time consumption can I expect SQLite to keep under, from between that I enter it (i.e. calling a sqlite3_* procedure such as sqlite3_exec , sqlite3_open , etc.), until (either of the respective two): * it returns OR a VFS procedure is called * it returns OR a VFS procedure is

[sqlite] What stack size is required for SQLite to spin?

Hi, I'm looking at the possibility of using SQLite in an environment with a fixed-size stack, and wish to know, what stack size do I need for SQLite always to work? Obviously I want it to be as small as possible, as I want as much RAM to be available for other purposes as possible. The