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 need the autotools an
On Tue, Apr 23, 2013 at 8:47 PM, Igor Korot wrote:
> query = wxString::Format(...);
> if( ( result = sqlite3_prepare_v2( m_handle, query, -1, &stmt, 0 ) ) !=
> SQLITE_OK )
>
It's been a while since I've worked with wxWidgets, but when I did,
wxString didn't support an implicit conversion like yo
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
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 Haskell
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 I
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 7:34 PM, Simon Slavin
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 7:34 PM, Simon Slavin
wrote:
On 25 Apr 2013, at 3:28am, Igor Korot wrote:
> Changed. No difference at all. Record is still d
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 objec
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:
>>>
>>> > Changed. No difference at all. Record is still does not show up.
>>>
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 opening different files in the shell and
your
ap
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 your
> app. This is usually caused by a defa
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 SQLiteConnection("Data
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 lock
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 backtra
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
> aggregates) have a defined
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 clause, it finds a match for
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 imp
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 is the number of columns in
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:
http://www.sqlite.org/src/artifact
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 have different eff
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 ./configure
> > files on each machine dependi
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 basic knowledge the
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
> WHEN 2 THEN 6
>
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 that
> > does provide file-system semantics f
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 pointslocati
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 not use an ORDER BY
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. The numbers in the br
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.
>
Have you considered using
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.
Pleas
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.
Pleas
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 annoying to audit before each release, and whic
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 file-system semantics for large blobs, and doin
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
http://sqlite.org:8080/
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 easi
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 aggreg
35 matches
Mail list logo
