Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Richard Hipp
Please send additional information. We are unable to reproduce or fix the problem without further data. On 9/28/18, Vlad Khokholkov wrote: > Good day! > > First of all thanks a lot for this really nice project! > I use it in different projects (including the projects where the DB file is >> 120

Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Simon Slavin
On 29 Sep 2018, at 1:53am, Vlad Khokholkov wrote: > Unfortunately, today I download the latest version of SQLite (3.25.2) and > got crash on the first 'sqlite3_prepare_v2' call. Thank you for posting. Can you tell us 1) What the crash error message is. 2) What statement you are passing to

[sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Vlad Khokholkov
Good day! First of all thanks a lot for this really nice project! I use it in different projects (including the projects where the DB file is > 120 Gb), it works perfectly!!! Unfortunately, today I download the latest version of SQLite (3.25.2) and got crash on the first 'sqlite3_prepare_v2'

[sqlite] SQLite bug: Malformed UTF16 leads to a 2-byte buffer overread

2018-09-29 Thread Kelvin Jiang
Hi there, I'm using SQlite 3.12.1 on Android device and we found this bug on most Android devices. The problem can be reproduced by following procedures: 1. Prepare a malformed Java String, like "123", then cut it right from the middle of the surrogates, like "123".substring(0, 4), and append

Re: [sqlite] SQLite bug: Malformed UTF16 leads to a 2-byte buffer overread

2018-09-29 Thread Richard Hipp
On 9/29/18, Kelvin Jiang wrote: > Hi there, > > I'm using SQlite 3.12.1 on Android device and we found this bug on most > Android devices. Maybe this is a bug in Android or in the SQLite interface that are built into Android. But SQLite itself seems to be working correct. Or, at least, I am

[sqlite] Query performance slower in 3.25

2018-09-29 Thread Stephen F. Booth
A query that ran fine under SQLite 3.24 is substantially slower in 3.25: SQLite version 3.24.0 2018-06-04 19:24:41 > .timer on > select a.id from a join c on a.id = case when c.b_a_name is not null then c.b_a_id else c.a_id end where a.id in (select a_fts.rowid from a_fts where a_fts match 'r*'

[sqlite] using a custom memory allocator in TH3

2018-09-29 Thread James K. Lowden
After stumbling on SQLite's description of its memory allocators, I decided to write a one for testing that might be slow but is certainly robust.[1] I thought it might be interesting to hook it up to TH3, but I don't understand how to do that. The instructions say: 1. Generate the code 2.

[sqlite] How to get RecNo when clicking on a DBGrid?

2018-09-29 Thread Lars Frederiksen
Hello, I am using Delphi and FireDAC. I have som editfields in the upper region of a tabsheet and a DBGrid in the lower part. When I click on my DBGrid I would like to write the fields from the choosen Record to the editfields. I wonder if it is possible to get the RecNo of a record when

Re: [sqlite] Query performance slower in 3.25

2018-09-29 Thread Richard Hipp
Could you please provide us with the database schema, or perhaps even a short script that demonstrates your problem, so that we can try to debug it? On 9/29/18, Stephen F. Booth wrote: > A query that ran fine under SQLite 3.24 is substantially slower in 3.25: > > SQLite version 3.24.0 2018-06-04

Re: [sqlite] How to get RecNo when clicking on a DBGrid?

2018-09-29 Thread Radovan Antloga
DbGrid is linked with DataSource and DataSource with DataSet. DataSet can be TFDQuery or TFDTable. You can read TFDTable.RecNo onclick event of DbGrid. Why do you need that? You do not have to write fields. Just put dbedit controls on your form and link them with DataSource. On record change

Re: [sqlite] Query performance slower in 3.25

2018-09-29 Thread Richard Hipp
On 9/29/18, Stephen F. Booth wrote: > A query that ran fine under SQLite 3.24 is substantially slower in 3.25: Thanks for the data sent off-list Your work-around is to add a plus sign "+" before the "a.id" in the GROUP BY clause. (And, BTW, shouldn't that really be an ORDER BY clause

Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Richard Hipp
On 9/29/18, Vlad Khokholkov wrote: > Yes, you are right that is a link to compiler. > Please, see source code in the attached to prior letter file > (SQLiteDebug.zip). > Do you see attached files? Yes, thank you. I now see the source code buried amongst the other attachments. -- D. Richard

Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Richard Hipp
On 9/29/18, Vlad Khokholkov wrote: > a) Download already fetched compiler files and library from the link: > https://jmp.sh/v/bYhfdyV4ombZcWXVs98Z (Please, download it in next 23 > hours, otherwise link will be invalidated and I need to re-share it) That ZIP archive does not contain any

Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Vlad Khokholkov
Yes, you are right that is a link to compiler. Please, see source code in the attached to prior letter file (SQLiteDebug.zip). Do you see attached files? Regards, Vladimir. сб, 29 сент. 2018 г. в 23:09, Richard Hipp : > On 9/29/18, Vlad Khokholkov wrote: > > a) Download already fetched

Re: [sqlite] Crash observation in certain conditions (SQLite v.3.25.2)

2018-09-29 Thread Vlad Khokholkov
Good day! To answer your questions I prepare a simple test example where I can reproduce the crash (see file 'SQLiteDebug.zip'). The results of its execution please see in files ('SQLite_expected1.png', 'SQLite_expected2.png', 'SQLite_expected3.png', 'SQLite_unexpected.png') - crash is in