--- Marco Bambini <[EMAIL PROTECTED]> wrote:
> Here it is the output of explain SELECT a FROM One WHERE b1 = 99 AND
> b2 = 100 and b3 = 101;
>
> 0|Goto|0|20||1|
> Integer|0|0||2|
> OpenRead|1|4|keyinfo(3,BINARY,BINARY)|3|
> SetNumColumns|1|4||4|
> Integer|99|0||5|
> IsNull|-1|18||6|
> Integer|10
Yes sure Joe, I just needed some more time.
Here it is the output of explain SELECT a FROM One WHERE b1 = 99 AND
b2 = 100 and b3 = 101;
0|Goto|0|20||1|
Integer|0|0||2|
OpenRead|1|4|keyinfo(3,BINARY,BINARY)|3|
SetNumColumns|1|4||4|
Integer|99|0||5|
IsNull|-1|18||6|
Integer|100|0||7|
IsNull|-2|1
You're not the least bit interested in finding out what the issue
in CodeWarrior was? It might be a symptom of another problem.
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
> The problem was somewhere inside CodeWarrior because the same exact
> code worked fine with Visual C.
> I used CodeWarrio
The problem was somewhere inside CodeWarrior because the same exact
code worked fine with Visual C.
I used CodeWarrior for Win for all my win32 sqlite compilation but it
seems time to update my Win Dev environment...
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://w
Could you also report the md5sum values of the resultant
test.sqlite database file for Win32/CodeWarrior, OSX and linux?
(Assuming they all have the same default pragma page_size=1024;)
--- Marco Bambini <[EMAIL PROTECTED]> wrote:
> To be really sure I rewrote the example in C linked to the offi
Can you post the output of this command when you compile
sqlite 3.4.2 with code warrior for your test.sqlite database?
explain SELECT a FROM One WHERE b1 = 99 AND b2 = 100 and b3 = 101;
With the sqlite 3.5.1 shell compiled with gcc 4.1.1 I see:
0|Goto|0|25|
1|Integer|0|0|# One
2|OpenRead|0|2|
and got:
a
98
Hope this helps
Dan
-Original Message-
From: Marco Bambini [mailto:[EMAIL PROTECTED]
Sent: 31 October 2007 09:33
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version
No, the database is created by the code it doesn't already exis
I compiled up your code and ran it on Windows using VC6 and got:
a
98
Hope this helps
Dan
-Original Message-
From: Marco Bambini [mailto:[EMAIL PROTECTED]
Sent: 31 October 2007 09:33
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Strange error in sqlite 3.4.2 Win32 version
No, the
No, the database is created by the code it doesn't already exists.
I was able to reproduce the issue only on Windows, Mac and Linux
worked fine.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Oct 31, 2007, at 10:25 AM, Stephan Bea
On 10/31/07, Marco Bambini <[EMAIL PROTECTED]> wrote:
>
> ...
> On Windows (not on Mac!) it returns 99 instead of the correct 98 value.
> Anyone can confirm that on Windows?
Hi, Marco! While i can't confirm how it behaves under Windows, i can confirm
that it returns 98 on Linux:
[EMAIL PROTECTED
To be really sure I rewrote the example in C linked to the official
sqlite 3.4.2.
Here it is my source code:
#include
#include
#include
#include "sqlite3.h"
int main(void)
{
sqlite3 *db = NULL;
int rc = SQLITE_OK;
charsql[256];
char**result;
i
Marco Bambini <[EMAIL PROTECTED]> wrote:
>
> I am experiencing a very strange issue in sqlite 3.4.2 (only with the
> Win32 version, OSX and linux works fine).
>
> I wonder if there was a bug in the 3.4.2 version that I should fix...
> Please note that I cannot upgrade to the latest 3.5.x versio
Hi guys,
I am experiencing a very strange issue in sqlite 3.4.2 (only with the
Win32 version, OSX and linux works fine).
Here it is what's happen:
// create table
CREATE TABLE One( a varchar primary key, b1 integer, b2 integer, b3
integer, z varchar )
CREATE UNIQUE INDEX idx_One ON One( b1
13 matches
Mail list logo