Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras 
Well, thank you all.
I managed to solve the problem.
It was some initialization problems with sqlite.

On Mon, May 25, 2009 at 7:20 PM, João Eiras  wrote:
> Okay, but I'm using the latest sqlite source version 3.6
>
> On Mon, May 25, 2009 at 7:17 PM, Derrell Lipman
>  wrote:
>> On Mon, May 25, 2009 at 1:10 PM, João Eiras  wrote:
>>> Btw, the same happens with the command line sqlite program
>>>
>>> $ sqlite
>>> SQLite version 2.8.17
>>
>> These pragmas didn't exist six years ago when 2.8.17 was current. The
>> only pragmas in that version are:
>>
>> default_cache_size
>> cache_size
>> default_synchronous
>> synchronous
>> temp_store
>> default_temp_store
>>
>> Derrell
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras 
Okay, but I'm using the latest sqlite source version 3.6

On Mon, May 25, 2009 at 7:17 PM, Derrell Lipman
 wrote:
> On Mon, May 25, 2009 at 1:10 PM, João Eiras  wrote:
>> Btw, the same happens with the command line sqlite program
>>
>> $ sqlite
>> SQLite version 2.8.17
>
> These pragmas didn't exist six years ago when 2.8.17 was current. The
> only pragmas in that version are:
>
> default_cache_size
> cache_size
> default_synchronous
> synchronous
> temp_store
> default_temp_store
>
> Derrell
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reading pragma's results

2009-05-25 Thread Derrell Lipman 
On Mon, May 25, 2009 at 1:10 PM, João Eiras  wrote:
> Btw, the same happens with the command line sqlite program
>
> $ sqlite
> SQLite version 2.8.17

These pragmas didn't exist six years ago when 2.8.17 was current. The
only pragmas in that version are:

default_cache_size
cache_size
default_synchronous
synchronous
temp_store
default_temp_store

Derrell
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras 
Btw, the same happens with the command line sqlite program

$ sqlite
SQLite version 2.8.17
Enter ".help" for instructions
sqlite> create table t(a integer);
sqlite> insert into t values(1);
sqlite> select * from t;
1
sqlite> pragma page_size;
sqlite> pragma page_count;
sqlite>

Both pragmas don't return anything

On Mon, May 25, 2009 at 6:55 PM, João Eiras  wrote:
> On Mon, May 25, 2009 at 6:48 PM, Igor Tandetnik  wrote:
>> "João Eiras"  wrote
>> in message
>> news:e72b1b360905250934h1b39c95eycab618faca87d...@mail.gmail.com
>>> Sorry, wrong url...
>>> http://pastebin.ca/1433959
>>>
>>> On Mon, May 25, 2009 at 5:37 PM, João Eiras
>>>  wrote:
 Hi there.
 I'm trying the following code
 http://pastebin.ca/143395
>>
>> Are you, by any chance, building a release version of that code? Realize
>> that, in release build, assert() completely disappears together with
>> whatever expression it contains, so your program becomes mostly a no-op.
>>
>
> If I posted that code, it's safe to assume it is running and I know
> what an assert it.
>
>> How exactly do you determine whether your code works or doesn't work?
>
> Because if breaks many of the asserts, like, I get errors in standards output.
>
>>
>> Igor Tandetnik
>>
>>
>>
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras 
On Mon, May 25, 2009 at 6:48 PM, Igor Tandetnik  wrote:
> "João Eiras"  wrote
> in message
> news:e72b1b360905250934h1b39c95eycab618faca87d...@mail.gmail.com
>> Sorry, wrong url...
>> http://pastebin.ca/1433959
>>
>> On Mon, May 25, 2009 at 5:37 PM, João Eiras
>>  wrote:
>>> Hi there.
>>> I'm trying the following code
>>> http://pastebin.ca/143395
>
> Are you, by any chance, building a release version of that code? Realize
> that, in release build, assert() completely disappears together with
> whatever expression it contains, so your program becomes mostly a no-op.
>

If I posted that code, it's safe to assume it is running and I know
what an assert it.

> How exactly do you determine whether your code works or doesn't work?

Because if breaks many of the asserts, like, I get errors in standards output.

>
> Igor Tandetnik
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reading pragma's results

2009-05-25 Thread Igor Tandetnik 
"João Eiras"  wrote
in message
news:e72b1b360905250934h1b39c95eycab618faca87d...@mail.gmail.com
> Sorry, wrong url...
> http://pastebin.ca/1433959
>
> On Mon, May 25, 2009 at 5:37 PM, João Eiras
>  wrote:
>> Hi there.
>> I'm trying the following code
>> http://pastebin.ca/143395

Are you, by any chance, building a release version of that code? Realize 
that, in release build, assert() completely disappears together with 
whatever expression it contains, so your program becomes mostly a no-op.

How exactly do you determine whether your code works or doesn't work?

Igor Tandetnik



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Reading pragma's results

2009-05-25 Thread João Eiras 
Sorry, wrong url...
http://pastebin.ca/1433959

On Mon, May 25, 2009 at 5:37 PM, João Eiras  wrote:
> Hi there.
> I'm trying the following code
> http://pastebin.ca/143395
>
> Strangelly, both pragmas don't return any row at all !
> What am I missing ?
> The same happens if I open a data file on disk.
>
> Thanks.
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Reading pragma's results

2009-05-25 Thread João Eiras 
Hi there.
I'm trying the following code
http://pastebin.ca/143395

Strangelly, both pragmas don't return any row at all !
What am I missing ?
The same happens if I open a data file on disk.

Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users