Re: [sqlite] sqlite3_btreeinfo causes sql logic error

[x]

Thanks Richard, working now.

From: Richard Hipp<mailto:d...@sqlite.org>
Sent: 24 January 2018 14:08
To: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] sqlite3_btreeinfo causes sql logic error

On 1/24/18, x <tam118...@hotmail.com> wrote:
> Sorry Richard, it was my app that was triggering the exception in response
> to the error. The queries prepare OK but, for any select containing the
> aforementioned non-text cols, sqlite3_step returns 1 and
> (wchar_t*)sqlite3_errmsg16(DB) returns “SQL logic error”.
>
>
>
> I’m using the amalgamation in c++ builder 10.2, 64 bit clang compiler on
> windows 10

Please add -DSQLITE_ENABLE_DBPAGE_VTAB to your build.

--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

[Richard Hipp]

On 1/24/18, x  wrote:
> Sorry Richard, it was my app that was triggering the exception in response
> to the error. The queries prepare OK but, for any select containing the
> aforementioned non-text cols, sqlite3_step returns 1 and
> (wchar_t*)sqlite3_errmsg16(DB) returns “SQL logic error”.
>
>
>
> I’m using the amalgamation in c++ builder 10.2, 64 bit clang compiler on
> windows 10

Please add -DSQLITE_ENABLE_DBPAGE_VTAB to your build.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

[x]

Sorry Richard, it was my app that was triggering the exception in response to 
the error. The queries prepare OK but, for any select containing the 
aforementioned non-text cols, sqlite3_step returns 1 and 
(wchar_t*)sqlite3_errmsg16(DB) returns “SQL logic error”.



I’m using the amalgamation in c++ builder 10.2, 64 bit clang compiler on 
windows 10




From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of 
Richard Hipp <d...@sqlite.org>
Sent: Wednesday, January 24, 2018 1:16:22 PM
To: SQLite mailing list
Subject: Re: [sqlite] sqlite3_btreeinfo causes sql logic error

On 1/24/18, x <tam118...@hotmail.com> wrote:
> Works OK for
>
> SELECT name FROM sqlite_btreeinfo WHERE type='table'
>
> But crashes with
>
> SELECT name, nEntry FROM sqlite_btreeinfo WHERE type='table'

Do it crash, or does it return an error?  There is a difference.

--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

[Richard Hipp]

On 1/24/18, x  wrote:
> Works OK for
>
> SELECT name FROM sqlite_btreeinfo WHERE type='table'
>
> But crashes with
>
> SELECT name, nEntry FROM sqlite_btreeinfo WHERE type='table'

Do it crash, or does it return an error?  There is a difference.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

[curmudgeon]

Seems to be if you include any non-text column (apart from rootpage) from
sqlite_btreeinfo in the select it causes an sql logic error.



--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_btreeinfo causes sql logic error

[x]

Works OK for

SELECT name FROM sqlite_btreeinfo WHERE type='table'

But crashes with

SELECT name, nEntry FROM sqlite_btreeinfo WHERE type='table'

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