Re: [sqlite] sqlite3: .width counts bytes, not characters

> I think the enhancement is here: > https://sqlite.org/src/timeline?c=ed0842c156ab1a78 > > That would correspond to version 3.20.0. > > -- > D. Richard Hipp Thank you. The upcoming Ubuntu LTS release (20.04) includes sqlite version 3.31.1, so the issue should disappear soon also for me. @Keith:

[sqlite] sqlite3: .width counts bytes, not characters

Hi I use sqlite3 (sqlite3 --version = "3.11.0 2016-02-15 17:29:24 3d862f207e3adc00f78066799ac5a8c282430a5f" on Ubuntu 16.04.6 LTS) for formatted output. '.width' does not behave as I expected when non-ASCII Unicode characters are printed. It seems that .width counts bytes and not characters. S

Re: [sqlite] unexpected sqlite_busy behaviour within transactions

Dear Igor, Andy, Keith Thank you for your patience to explain. Now very clear to me why it is not worth for the second process to honor the sqlite_busy handler, and instead returns immediately. In retrospect re-reading with your explanations in mind, I also understand the official documentation

[sqlite] unexpected sqlite_busy behaviour within transactions

Hi A busy_timout is honored by write commands outside of transactions and by single write commands inside transactions, but not if preceded by a read command. I did not find this behaviour in the documentation, thus it might be a bug. To reproduce (in a linux terminal): sqlite3 ~/test.db "C

Re: [sqlite] Bug in sqlite3 (CLI, linux/Ubuntu)

> Dear colleagues > > I detected an unexpected behaviour in sqlite3 (CLI) that I consider a bug as > it seems not documented. > > When using an init file (even if an empty file), sqlite3 outputs an extra > empty line to stdout. This messes up parsing of the sqlite3 output, as this > line is

[sqlite] Bug in sqlite3 (CLI, linux/Ubuntu)

Dear colleagues I detected an unexpected behaviour in sqlite3 (CLI) that I consider a bug as it seems not documented. When using an init file (even if an empty file), sqlite3 outputs an extra empty line to stdout. This messes up parsing of the sqlite3 output, as this line is not present in the

Re: [sqlite] recursive clause

(Ibtech-Software Infrastructure) wrote: > CREATE TABLE InstanceReferences (InstanceAddress INTEGER, RefByAddress > INTEGER) CREATE TABLE Instances (TypeId INTEGER, Address INTEGER) > CREATE TABLE Types (Id INTEGER, Name TEXT, MethodTable INTEGER, Count > INT, TotalSize INTEGER) > > Wha

[sqlite] recursive clause

Hello there, I am trying to find a memory leak with MemoScope. It is using sqllite. Memoscope has some issue to find the problem so I am actually querying the data. CREATE TABLE InstanceReferences (InstanceAddress INTEGER, RefByAddress INTEGER) CREATE TABLE Instances (TypeId INTEGER, Address INTE

Re: [sqlite] sqlite3 very slow even after creating without rowid

Hi, > I also did another experiment. I created this table and did a vaccum and then > the select count(*) in sqlite3 was around 2 mins. > > When I create an index manually after the table is loaded (imported from > csv), select count(*) in sqlite3 was within 30 to 40 secs. >In the second case

[sqlite] sqlite3 very slow even after creating without rowid

Hello, My Process.csv is around 27G. I've gzipped it and put at ftp://navinps:sqlit...@h2.usa.hp.com as process.csv.gz There is only 1 file there. md5sum process.csv.gz e77a322744a26d4c8a1ad4d61a84ee72 process.csv.gz [root@centosnavin sqlite-autoconf-3080801]# cat sqlite3commands.txt CREATE

Re: [sqlite] sqlite3 very slow even after creating without rowid

Repost: Since it didn't get into the archives or in the mailing list. Sorry about that. Quoted and replied to simon after [Repost End] Hello, [Repost Begin] My Process.csv is around 27G. I've gzipped it and put at ftp://navinps:sqlit...@h2.usa.hp.com as process.csv.gz There is only 1 file

[sqlite] sqlite3 performance on select count very slow for 16 GB file

Hello, I've few questions about sqlite3 , the database it creates. Actually I'm finding lot of differences in performance. My story: I have this sqlite3 database called hp.db which is like 100+ million records for table1. The size of hp.db on Linux x64 (CentOS 7) is like 16 GB. Wh

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database)on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

Joe, Bingo !!! You are a legend ! This fixes the issue. After a careful code review, we found that sqlite3_shutdown() was being called in between. Then naturally, that is why when we reached to a stage where the big query in question is executed, because the temp store setting was not in effect,

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

Hi Joe, Answers below. Is the directory obtained via the Windows::Storage::ApplicationData::Current->LocalFolder->Path property? > Yes What SQLite warning/error log entries are you seeing when you set the temporary directory to the LocalState directory? > Nothing. sqlite returns success w

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result setsusing 3.8.4.1

Joe, Yes to both questions (we are checking the result and it is returning SQLITE_OK, and we are passing a UTF-16 string). MB -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Friday, 28 March 2014 11:54 AM

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1

database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1 On 27 Mar 2014, at 4:00am, Muharrem Bilgin (Bright Software) wrote: > The blob issue mentioned is happening with another table in another > application. The reason it was mentioned because we have the feeling

Re: [sqlite] SQLITE_ERROR (SQL logic error or missingdatabase) on WinRT/ WP8 when querying large (!) result setsusing 3.8.4.1

Joe, Tried using the suggested " int sqlite3_win32_set_directory(DWORD type, LPCWSTR zValue);" before opening any database connection. sqlite still reports " sqlite3_temp_directory variable should be set for WinRT". We are trying to set the Windows RT's sandbox local directory of the application

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on Win RT/ WP8 when querying large (!) result sets using 3.8.4.1

when querying large (!) result sets using 3.8.4.1 On Wed, Mar 26, 2014 at 8:13 PM, Muharrem Bilgin (Bright Software) < mbil...@brightsoft.com.au> wrote: > > FROM PRD_DETAILS > > As a work-around, please try changing this line of your query to read: FROM PRD_DETAILS INDEXED BY sqlit

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1

Discussion of SQLite Database Subject: Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1 On Wed, Mar 26, 2014 at 10:26 PM, Richard Hipp wrote: > > > > On Wed, Mar 26, 2014 at 10:21 PM, Muharrem Bilgin (Bri

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1

) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1 On Wed, Mar 26, 2014 at 9:47 PM, Muharrem Bilgin (Bright Software) < mbil...@brightsoft.com.au> wrote: > Hi Joe, > > The following are the log entries, which confirm your suspicion (the > log entry format : time,

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1

Hi Joe, The following are the log entries, which confirm your suspicion (the log entry format : time, error description, error code). As suggested, we are already setting the temp store directory as soon as a database connection is opened (after sqlite3_open16). Now, the question is when to use

Re: [sqlite] SQLITE_ERROR (SQL logic error or missing database) on WinRT/ WP8 when querying large (!) result sets using 3.8.4.1

Hi Joe, Thank you for your input. We are not using the SQLite wrapper. The sqlite source code is compiled into a Windows Store/Phone DLL and used in our application. I have tried your suggestion anyway, but no result. MB. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto

[sqlite] SQLITE_ERROR (SQL logic error or missing database) on Win RT/ WP8 when querying large (!) result sets using 3.8.4.1

Hello, We are trying to query a table with 7011 records (simply first calling sqlite3_prepare16_v2 and then sqlite3_step, nothing complicated that is). It appears sqlite3_step returns SQLITE_ERROR if result sets contain records more than a certain size. The very 3.8.4.1 version on Windows deskt

[sqlite] problem with join and System.Data.Sqlite

Hi. I'm using this wonderful library with no problem till today. I've this simple query SELECT DISTINCT COM_STRADARIO.ID_STRADARIO, COM_STRADARIO.TIPO_VIA, COM_STRADARIO.NOME_VIA FROMCOM_STRADARIO inner join INT_CONDOMINI on COM_STRADARIO.ID_STRADARIO = INT_CONDOMINI.ID_STRADARIO ORDER

[sqlite] Cause of "disk I/O errors"

time (naturally). So it seems it must be something about their particular machine environment, but what? I'm sure that nobody is running out of disk space these days. Any ideas on where to look or what to suggest to them that they can do? -- Doug Gordon *GHCS Software* http://ww

Re: [sqlite] Loss of Binary Data in Dump File

With Roger's help I have gotten to the bottom of this issue, and I wanted to post the resolution to the list in case anyone else bumps into it. There is a bug in PHP versions prior to PHP 5.3 that makes it impossible to reliably create/store BLOB columns. My code ends up creating TEXT data when ru

Re: [sqlite] Loss of Binary Data in Dump File

NED MESSAGE- > Hash: SHA1 > > On 10/27/2010 11:48 AM, Art Age Software wrote: >> New to this list and hoping someone can help. I have a sqlite3 >> database that contains a couple of tables that have binary data in >> BLOB columns. > > Note that there is column aff

[sqlite] Loss of Binary Data in Dump File

Hi All, New to this list and hoping someone can help. I have a sqlite3 database that contains a couple of tables that have binary data in BLOB columns. I know the data is in there and stored correctly because the application accessing the database can retrieve the column data just fine. The probl

Re: [sqlite] FTS3 MATCH syntax

ep 24, 2010 at 4:16 PM, GHCS Software wrote: > > ?I'm just started with generating a table using FTS3 and understand > > most of the query formats, but am stuck on one minor point of syntax. My > > FTS3 query will make reference to a specific table, e.g.: > > > >

[sqlite] FTS3 MATCH syntax

to specify it if the string to be searched for has a space in it. I've tried several varieties of quotes without any success, e.g.: MATCH '"given:john q"' MATCH 'given:"john q"' and so on. Is there a way to get this to work? -- Doug Gordon

Re: [sqlite] Compiling as part of MFC C++ project

Thanks. That took care of it. I'm revamping a Windows app that I wrote 6 or 7 years ago and that was the last time I used Visual C++ for much of anything. I just wasn't sure about mixing C and C++ code in a single build. Doug Gordon *GHCS Software* <http://www.ghcssoftware.co

[sqlite] Compiling as part of MFC C++ project

pp" and put the include of at the top? Or what?? -- Doug Gordon *GHCS Software* http://www.ghcssoftware.com g...@ghcssoftware.com <mailto:g...@ghcssoftware.com> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-b

[sqlite] Compatibility problems with sqlite3 and On-Time RTOS

Does anyone run sqlite3 in an OnTime real time operating system? Massimo Dazzan www.schnell.it Le informazioni trasmesse sono destinate esclusivamente alla persona o alla societa' in indirizzo e sono da intendersi confidenziali e riservate. Ogni trasmissione, inoltro, diffusione o a

Re: [sqlite] SQLite Version 2.1

t; far more than reading it using the SQLite library. More time- > consuming, though. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- M

[sqlite] SQLite Version 2.1

only. -- With kindly regards, Marcus Haßmann -- Hassmann-Software In der Pottaschdell 31 66333 Völklingen ICQ: 192 982 963 Tel.: 06898 / 49 32 30 Mobil: 0176 / 400 53 54 5 Email: i...@hassmann-software.de Web: http://www.hassmann-software.de XING: http://www.xing.com/profile/Marcus_Has

[sqlite] Pragma integrity_check and attached ddatabases

Hello, Will "pragma integrity_check" also check attached databases? Best regards Baard Riiber ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Using sqlite3_open or sqlite3_open16?

Hi, I have an application that needs to open a database in the users's personal folder. I noticed that in some circunstances the sqlite3_open fail as the filename is in UTF16 format. I don't know that in advance so I could open the db with sqlite3_open16. The question is: Is it safe to always us