[sqlite] How can custom tokenizer tell it's parsing a search string?

Is there any way for a custom FTS4 tokenizer to know when it’s tokenizing a search string (the argument of a MATCH expression), as opposed to text to be indexed? Here’s my problem: I’ve implemented a custom tokenizer that skips “stop words” (noise words, like “the” and “a” in English.) It

Re: [sqlite] Allow inclusion of generate_series function

Hi, I think both your requirements and Dr Hipp's point-of-view are valid if we continue to see SQLite as just a tool. Yes, SQLite is an amazing tool for all the things it does and especially for a great design which almost never stands in the way of user customization and extension. However,

Re: [sqlite] SQLITE gives incorrect results for 'NOT IN' query if partial index exists

On 11-12-2018 10:09, Wout Mertens wrote: Hi Luuk, Not sure if you realize this, but your email comes over as very aggressive, and if there's one person on this mailing list that doesn't deserve that, it's dr Hipp. In particular, the quotes around forgot seem to imply that it was forgotten on

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

Diagnosis is quite straightforward: If you can reproduce the problem by running your statements in the SQLite shell, then there is a problem in SQLite. If not, then it is caused by the wrapper. The wrapper having a commit method is a strong indication that it has an internal model of SQLite

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

I have already been upgrading sqlite version. After this If I encounter with the same problem I will inform you.. For Hick Gunter I'm sorry for the inconveinence. I have been using C++. I have been using some kind of wrapper : yes. Operating system (cat /proc/version): Linux version

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

On 11 Dec 2018, at 1:21pm, Aydin Ozgur Yagmur wrote: > No, I did not use it. Then use it. By default, timeout is not set. If you do not set a timeout, any clash will cause the error you are seeing. Simon.

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

Obviously you are using some kind of wrapper and a currently undisclosed programming language running under some OS you have neglected to name to call SQLite. Without the aid of a debugger, it will not even be possible to discern if the problem is in SQLite itself or the wrapper code you are

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

No, I did not use it. On Tue, Dec 11, 2018 at 3:59 PM Simon Slavin wrote: > On 11 Dec 2018, at 12:42pm, Aydin Ozgur Yagmur > wrote: > > > I am trying to edit the database using command shell. > > for instance i try to execute analyze commad i get "database is locked" > > message > > Have you

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

*Ist hat always the same location or is it maybe running in a loop? Is it always the same statement that "hangs"? * >>> I use sqlite for more than 3 years, i encouter such an error for the first time. That is, no. *Can you check what the thread is doing with a debugger? * >>> I have been logging

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

On 11 Dec 2018, at 12:42pm, Aydin Ozgur Yagmur wrote: > I am trying to edit the database using command shell. > for instance i try to execute analyze commad i get "database is locked" > message Have you used the timeout PRAGMA inside the command shell ? If not, it's not retrying. Simon.

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

That answers question 2. What about the thread? Can you check what the thread is doing with a debugger? Ist hat always the same location or is it maybe running in a loop? Is it always the same statement that "hangs"? -Ursprüngliche Nachricht- Von: sqlite-users

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

I am trying to edit the database using command shell. for instance i try to execute analyze commad i get "database is locked" message On Tue, Dec 11, 2018 at 1:36 PM Hick Gunter wrote: > If you have only one thread accessing the database, how do you determine > that it is hanging and that the

Re: [sqlite] Allow inclusion of generate_series function

On Thu, Dec 6, 2018 at 8:06 PM Keith Medcalf wrote: > > Why one would want a particular capability available in the shell that is > not available when compiling the amalgamation code directly is beyond my > ken. The issue is not limited to generate_series (although that one seems to be pain

[sqlite] SQLite EBCDIC glitch?

Hello, I have been working on making SQLite usable on IBM z/OS. Apart from a different compile process, I think there is a glitch in sqlite's management of EBCDIC which should be fixed. It is about newline character management. Below my analysis of the problem: - Routine local_getline in

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

If you have only one thread accessing the database, how do you determine that it is hanging and that the database is locked? -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Aydin Ozgur Yagmur Gesendet: Dienstag, 11.

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

I set busy-timeout 1000 ms. I have been using threads but only one thread can access to database. I will upgrade sqlite version as soon as possible. Could this lead to that problem? On Tue, Dec 11, 2018 at 12:11 PM Hick Gunter wrote: > You are leaving out a lot of necessary detail. Are you

Re: [sqlite] Transaction commits hangs up

Do you still have the issue with a current version of the library? On Tue, Dec 11, 2018, 12:53 AM Aydin Ozgur Yagmur I have been using sqlite3.8.11 on fat32 file system. Sometimes, while > committing a transaction commit process hangs up and database became > locked. I am trying to find a cause

Re: [sqlite] [EXTERNAL] Transaction commits hangs up

You are leaving out a lot of necessary detail. Are you using threads? Does each thread have it's own connection or are you sharing connections? Did you set a busy timeout? BTW: Your Version of SQLiteis quite old. -Ursprüngliche Nachricht- Von: sqlite-users

Re: [sqlite] SQLITE gives incorrect results for 'NOT IN' query if partial index exists

Hi Luuk, Not sure if you realize this, but your email comes over as very aggressive, and if there's one person on this mailing list that doesn't deserve that, it's dr Hipp. In particular, the quotes around forgot seem to imply that it was forgotten on purpose. Personally, I would have worded it

[sqlite] Transaction commits hangs up

I have been using sqlite3.8.11 on fat32 file system. Sometimes, while committing a transaction commit process hangs up and database became locked. I am trying to find a cause or a solution for this problem. Does anyone encounter with similar problem before? Do you have any suggestion or any idea