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 wrote:
> Sorry Richard, it was
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”.
>
>
>
>
c++ builder 10.2, 64 bit clang compiler on
windows 10
From: sqlite-users on behalf of
Richard Hipp
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 wrote
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
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
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/m
6 matches
Mail list logo
