Re: [sqlite] sqlite 3.21.0 fts3rank test failure on big-endian linux

On 01/24/2018 03:45 PM, Richard Hipp wrote: On 1/24/18, Petr Kubat wrote: I am hitting a failure in fts3rank test on big-endian architectures (ppc64, s390x; logs in [1][2]) running Fedora rawhide: Should now be fixed on trunk. Thanks! I can verify that the fts3rank test

Re: [sqlite] Make some changes to the source code

Yup, I guess I understand you correctly about the mmap problem in the OS. I have seen some threads about it before. But I think wal+mmap is still a worthy consideration as db+mmap has already been supported even though it is disabled by default. At least I think I could use it in my own

Re: [sqlite] Make some changes to the source code

On 25 Jan 2018, at 1:34am, Nick wrote: > Do you mean the corruption problems you mentioned will happen in db+mmap? When memory-mapping was used for all file access of SQLite, some users reported that they occasionally got corrupted databases. When memory mapping

Re: [sqlite] Make some changes to the source code

I ran tests in my MacOS 10.12.6. -- 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

Re: [sqlite] Make some changes to the source code

I use sqlite in my Android application. And I tried to run sqlite test on my MacOS PC. Some cases failed but I can not figure out it is indeed a corruption. Do you mean the corruption problems you mentioned will happen in db+mmap? I guess it should happen in both wal+mmap and db+mmap if it

Re: [sqlite] SQLite DELUXE Re: sqlite command line tool NUL support

On 1/24/18, petern wrote: > Have you worked out an automated way for your changes to shadow and > auto-merge from the official trunk? https://www.sqlite.org/privatebranch.html -- D. Richard Hipp d...@sqlite.org ___

Re: [sqlite] SQLite DELUXE Re: sqlite command line tool NUL support

On Wed, Jan 24, 2018 at 1:30 PM, petern wrote: > Have you worked out an automated way for your changes to shadow and > auto-merge from the official trunk? That is, aside from collision edits, > is it automated? Longer term, your shadow distribution also needs >

[sqlite] SQLite DELUXE Re: sqlite command line tool NUL support

Have you worked out an automated way for your changes to shadow and auto-merge from the official trunk? That is, aside from collision edits, is it automated? Longer term, your shadow distribution also needs new/merged test cases and a regression test run to re-qualify the merged changes at each

Re: [sqlite] .DUMP displays floats differently from SELECT

Hello, On 2018-01-22 13:00, Iulian Onofrei wrote: I have a "REAL" column with float values having up to 2 decimals, and using ".dump" with the latest version incorrectly converts them like this: "0.0" -> "0.0" "0.05" -> "0.050002775" > [...] Did you consider an using of INTEGERs

Re: [sqlite] sqlite command line tool NUL support

This is a picture. This is a tortoise git log view of merges. https://drive.google.com/open?id=1RosGlprJRoutFsou2XDRlflxc8xWoHks On Wed, Jan 24, 2018 at 8:59 AM, J Decker wrote: > > So for output of a select in the shell ( unlike .dump ) is this. > > for(i=1; i

[sqlite] sqlite command line tool NUL support

So for output of a select in the shell ( unlike .dump ) is this. for(i=1; iout, ",%s", sqlite3_column_text(pSelect, i)); } option 1) add text conversion in the column_text to escape NUL characters. in TEXT... then everyone everywhere would inherit the

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

Thanks Richard, working now. From: Richard Hipp Sent: 24 January 2018 14:08 To: SQLite mailing list Subject: Re: [sqlite] sqlite3_btreeinfo causes sql logic error On 1/24/18, x wrote: > Sorry Richard, it

Re: [sqlite] sqlite 3.21.0 fts3rank test failure on big-endian linux

On 1/24/18, Petr Kubat wrote: > > I am hitting a failure in fts3rank test on big-endian architectures > (ppc64, s390x; logs in [1][2]) running Fedora rawhide: Should now be fixed on trunk. Big-endian processors are getting harder to get ahold of. I don't have one that is

[sqlite] sqlite 3.21.0 fts3rank test failure on big-endian linux

Hi all, I am hitting a failure in fts3rank test on big-endian architectures (ppc64, s390x; logs in [1][2]) running Fedora rawhide: Time: fts3query.test 515 ms ! fts3expr5-1.5 expected: [1 {invalid matchinfo blob passed to function rank()}] ! fts3expr5-1.5 got: [1 {wrong number of

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

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

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

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

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

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

Re: [sqlite] Make some changes to the source code

On 24 Jan 2018, at 11:35am, Nick wrote: > As I found > there will be a little improvement if I support MMAP to wal file. Which OS are you using ? The developers of SQLite have previously had corruption problems with memory-mapping under some versions of Windows

Re: [sqlite] sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

Thanks for the patch! Tests on i686 are green when included. There are still some failures for other architectures but I will make separate threads for these once I investigate. Petr On 01/23/2018 06:35 PM, Richard Hipp wrote: On 1/23/18, Petr Kubat wrote: Still present

[sqlite] Make some changes to the source code

I am trying to make some changes to the source code of sqlite. As I found there will be a little improvement if I support MMAP to wal file. I guess the optimization is micro but it is useful in my test and this is a good way for me to study the code of sqlite :D 1.wal+mmap I could use

Re: [sqlite] sqlite3_btreeinfo causes sql logic error

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] sqlite3_btreeinfo causes sql logic error

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