Re: [sqlite] Feature request: Support for aarch64

On Thu, 25 Apr 2013 10:30:31 -0400 Richard Hipp wrote: > > The configure script is typically generated by a build machine that > > has autotools installed, and included in a distribution tarball. > > The user unpacks the tarball and runs the configure script. He > > doesn't

Re: [sqlite] Programming API vs console

On Tue, Apr 23, 2013 at 8:47 PM, Igor Korot wrote: > query = wxString::Format(...); > if( ( result = sqlite3_prepare_v2( m_handle, query, -1, , 0 ) ) != > SQLITE_OK ) > It's been a while since I've worked with wxWidgets, but when I did, wxString didn't support an implicit

Re: [sqlite] System.Data.SQLite: Incompatible file locking behavior starting version 1.0.82.0

Levi Haskell wrote: > > Is this what the INTEROP_LEGACY_CLOSE compile-time option refers to? > Yes. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.SQLite: Incompatible file locking behavior starting version 1.0.82.0

Is this what the INTEROP_LEGACY_CLOSE compile-time option refers to? *Use the legacy connection closing algorithm when built with the INTEROP_LEGACY_CLOSE compile-time option. Thanks, - Levi - Original Message - From: sql...@mistachkin.com To: sqlite-users@sqlite.org Cc: Levi

Re: [sqlite] System.Data.SQLite: Incompatible file locking behavior starting version 1.0.82.0

Levi Haskell wrote: > > What was the motivation for this change (it seems to be quite inconvenient > in my case)? > The previous method used to deal with the non-deterministic finalization order imposed by the CLR did not work reliably in all circumstances, did not follow best-practices for the

Re: [sqlite] Programming API vs console

Hi, On Thu, Apr 25, 2013 at 1:09 PM, wrote: > Am 2013-04-25 21:43, schrieb Igor Korot: > > Hi, >> >> On Thu, Apr 25, 2013 at 12:31 PM, wrote: >> >> Am 2013-04-25 21:25, schrieb Igor Korot: >>> >>> Simon, >>> On Wed, Apr 24, 2013 at

Re: [sqlite] Programming API vs console

Am 2013-04-25 21:43, schrieb Igor Korot: Hi, On Thu, Apr 25, 2013 at 12:31 PM, wrote: Am 2013-04-25 21:25, schrieb Igor Korot: Simon, On Wed, Apr 24, 2013 at 7:34 PM, Simon Slavin wrote: On 25 Apr 2013, at 3:28am, Igor Korot

Re: [sqlite] System.Data.SQLite: Incompatible file locking behavior starting version 1.0.82.0

Thank you Joe, What was the motivation for this change (it seems to be quite inconvenient in my case)? - Levi - Original Message - From: sql...@mistachkin.com To: sqlite-users@sqlite.org Cc: Levi Haskell (BLOOMBERG/ 731 LEXIN) At: Apr 25 2013 15:07:54 As of release 1.0.82.0, the

Re: [sqlite] Programming API vs console

Hi, On Thu, Apr 25, 2013 at 12:31 PM, wrote: > Am 2013-04-25 21:25, schrieb Igor Korot: > > Simon, >> >> On Wed, Apr 24, 2013 at 7:34 PM, Simon Slavin >> wrote: >> >> >>> On 25 Apr 2013, at 3:28am, Igor Korot wrote: >>> >>> >

Re: [sqlite] Programming API vs console

Am 2013-04-25 21:25, schrieb Igor Korot: Simon, On Wed, Apr 24, 2013 at 7:34 PM, Simon Slavin wrote: On 25 Apr 2013, at 3:28am, Igor Korot wrote: > Changed. No difference at all. Record is still does not show up. My guess is that you are

Re: [sqlite] Programming API vs console

Simon, On Wed, Apr 24, 2013 at 7:34 PM, Simon Slavin wrote: > > On 25 Apr 2013, at 3:28am, Igor Korot wrote: > > > Changed. No difference at all. Record is still does not show up. > > My guess is that you are opening different files in the shell and

Re: [sqlite] System.Data.SQLite: Incompatible file locking behavior starting version 1.0.82.0

As of release 1.0.82.0, the object disposal semantics were changed to keep the underlying connection around until all associated System.Data.SQLite objects have been properly disposed. Levi Haskell wrote: > > var file = Path.GetTempFileName(); > using (var connection = new

[sqlite] System.Data.SQLite: Incompatible file locking behavior starting version 1.0.82.0

It seems that in version 1.0.81.0 and earlier the database file was released immediately after all SQLiteConnection objects were disposed even if some dependent SQLiteCommand and/or SQLiteDataReader objects were not yet disposed or closed. However starting version 1.0.82.0 the file remains

[sqlite] sqlite4: consistent BUS ERROR on dropping index

Is this the right list for sqlite4 bugs? I have sqlite4 build fde11ff78c433d66 and a largish database. When I drop one of the indices on it through the sqlite4 command line tool, the tool dies with a BUS ERROR. For this database file it reproduces 100% of the time for me. I have the gdb

Re: [sqlite] Order of columns in group by statement affects query performance

On 25 Apr 2013, at 4:23pm, Jay A. Kreibich wrote: > Except there is no such thing as "GROUP BY order". SQL Golden Rule: > If there is no ORDER BY, the rows have no order. According to SQL, > neither the groups, nor the rows within a group (as they are fed into >

Re: [sqlite] Order of columns in group by statement affects query performance

On Thu, Apr 25, 2013 at 05:08:04PM +0200, Daniel Winter scratched on the wall: > 2013/4/25 James K. Lowden > > > > > Nonsense. The query parser sees GROUP BY A,B. The optimizer sees an > > index ordered B,A. By permuting the order of the columns in the GROUP > > BY

Re: [sqlite] Order of columns in group by statement affects query performance

On Thu, Apr 25, 2013 at 10:29:34AM +0200, Hick Gunter scratched on the wall: > AFAIK SQLite treats GROUP BY the same way as ORDER BY (taken from hints > in the virtual table description). They're not the same clause, they don't do the same thing. Now, it is true that most database systems

Re: [sqlite] Order of columns in group by statement affects query performance

2013/4/25 James K. Lowden > > Nonsense. The query parser sees GROUP BY A,B. The optimizer sees an > index ordered B,A. By permuting the order of the columns in the GROUP > BY clause, it finds a match for the index and uses it. > > Yes, the problem is O(n^2), where n

[sqlite] pager.c does not compile with SQLITE_OMIT_WAL

The current SQLite Fossil snapshot does not compile with SQLITE_OMIT_WAL defined. Reason: The Pager->pWal element is compiled out in pager.c here: http://www.sqlite.org/src/artifact/6c3a8a5d665498b0344395a2c9f82d5abc4cc771?ln=691-694 but still accessed here:

Re: [sqlite] Order of columns in group by statement affects query performance

On Thu, 25 Apr 2013 10:29:34 +0200 Hick Gunter wrote: > AFAIK SQLite treats GROUP BY the same way as ORDER BY (taken from > hints in the virtual table description). That might be so, in some limited sense. It's obviously false in general because they mean different things and

Re: [sqlite] Feature request: Support for aarch64

On Thu, Apr 25, 2013 at 10:22 AM, James K. Lowden wrote: > On Wed, 24 Apr 2013 19:17:32 -0700 > Dimiter 'malkia' Stanev wrote: > > > > Why keep autoconf output in the source code repository? > > > > Maybe it's simply to guard from generating different

Re: [sqlite] Feature request: Support for aarch64

On Wed, 24 Apr 2013 19:17:32 -0700 Dimiter 'malkia' Stanev wrote: > > Why keep autoconf output in the source code repository? > > Maybe it's simply to guard from generating different ./configure > files on each machine depending on what autotools were installed (I > have very

Re: [sqlite] Select WHERE IN List ordering

On 25 Apr 2013, at 1:58pm, Clemens Ladisch wrote: > SELECT id > FROM pointslocation > WHERE id IN (1,7,3,4,5,2,6) > ORDER BY CASE id > WHEN 1 THEN 1 > WHEN 7 THEN 2 > WHEN 3 THEN 3 > WHEN 4 THEN 4 > WHEN 5 THEN 5 >

Re: [sqlite] Writing in a blob

On Tue, Apr 23, 2013 at 6:17 PM, James K. Lowden wrote: > On Tue, 23 Apr 2013 10:28:35 -0400 > Richard Hipp wrote: > > > In summary: No, a bare SQLite blob does not provide file-system > > semantics. But you can write a wrapper library around SQLite

Re: [sqlite] Select WHERE IN List ordering

Gary Baranzini wrote: > SELECT id FROM pointslocation WHERE id IN (1,7,3,4,5,2,6) > > How do I retain the order in the IN list? If you don't want to create a (temporary) table for the ordering, you can also do the mapping from id to the order in the query itself: SELECT id FROM

Re: [sqlite] Select WHERE IN List ordering

On Wed, Apr 24, 2013 at 5:09 PM, Gary Baranzini wrote: > Hi, > > I have the following query: > > SELECT id FROM pointslocation WHERE id IN (1,7,3,4,5,2,6) > > What 's returned is 1,2,3,4,5,6,7. > The output order for rows in a SELECT statement is undefined in SQL if you do

Re: [sqlite] Select WHERE IN List ordering

On 24 Apr 2013, at 10:09pm, Gary Baranzini wrote: > I have the following query: > > SELECT id FROM pointslocation WHERE id IN (1,7,3,4,5,2,6) > > What 's returned is 1,2,3,4,5,6,7. > > How do I retain the order in the IN list? There's no simple way to do that in SQL.

Re: [sqlite] Porting Sqlite to MQX Operating system

On Thu, Apr 25, 2013 at 7:38 AM, arun.pradeep wrote: > > Hi Geoff > > I am currently working on porting of SQLITE to MQX RTOS in MPC5125 > Platform. > > I am trying to rewrite the sqlite_os_init() for MQX and I have taken Win32 > VFS implementation as the reference. >

Re: [sqlite] Porting Sqlite to MQX Operating system

Hi Geoff I am currently working on porting of SQLITE to MQX RTOS in MPC5125 Platform. I am trying to rewrite the sqlite_os_init() for MQX and I have taken Win32 VFS implementation as the reference. But I am not able to map all of the Win32 file system calls with that of MQX functions.

Re: [sqlite] Porting Sqlite to MQX Operating system

Hi Geoff I am currently working on porting of SQLITE to MQX RTOS in MPC5125 Platform. I am trying to rewrite the sqlite_os_init() for MQX and I have taken Win32 VFS implementation as the reference. But I am not able to map all of the Win32 file system calls with that of MQX functions.

Re: [sqlite] Feature request: Support for aarch64

On 4/23/2013 3:22 PM, James K. Lowden wrote: On Tue, 23 Apr 2013 09:26:20 -0400 Richard Hipp wrote: I really dislike changing autoconf versions since any autoconf upgrade results in a massive change in the generated "configure" script, which is

Re: [sqlite] Writing in a blob

On 4/23/2013 3:17 PM, James K. Lowden wrote: On Tue, 23 Apr 2013 10:28:35 -0400 Richard Hipp wrote: In summary: No, a bare SQLite blob does not provide file-system semantics. But you can write a wrapper library around SQLite that does provide

[sqlite] Select WHERE IN List ordering

Hi, I have the following query: SELECT id FROM pointslocation WHERE id IN (1,7,3,4,5,2,6) What 's returned is 1,2,3,4,5,6,7. How do I retain the order in the IN list? jb ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Port SQLite to VxWorks 6.8

Hi All, First a very general question: Does anyone have experiences with porting SQLite to VxWorks? Preferably to Version 6.8 but not much too older versions could be also interesting for me. The documentation and the directives like #if OS_VXWORKS in the source suggest it would be possible

Re: [sqlite] Order of columns in group by statement affects query performance

AFAIK SQLite treats GROUP BY the same way as ORDER BY (taken from hints in the virtual table description). If you have an index that covers the GROUP BY clause in field order, then aggregate functions need store only the current value; if not, then you need an ephemeral table to hold the