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

2020-03-10 Thread Software
> 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.

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

2020-03-09 Thread Software
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.

Re: [sqlite] unexpected sqlite_busy behaviour within transactions

2020-02-26 Thread Software
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

[sqlite] unexpected sqlite_busy behaviour within transactions

2020-02-22 Thread Software
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

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

2019-03-31 Thread Software
> 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

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

2019-03-30 Thread Software
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

Re: [sqlite] recursive clause

2017-04-05 Thread Cem Dayanik (Ibtech-Software Infrastructure)
(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

2017-04-04 Thread Cem Dayanik (Ibtech-Software Infrastructure)
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

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

2015-01-23 Thread Parakkal, Navin S (Software Engineer)
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

[sqlite] sqlite3 very slow even after creating without rowid

2015-01-23 Thread Parakkal, Navin S (Software Engineer)
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

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

2015-01-23 Thread Parakkal, Navin S (Software Engineer)
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

2015-01-20 Thread Parakkal, Navin S (Software Engineer)
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.

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

2014-03-27 Thread Muharrem Bilgin (Bright Software)
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

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

2014-03-27 Thread Muharrem Bilgin (Bright Software)
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

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

2014-03-27 Thread Muharrem Bilgin (Bright Software)
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

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

2014-03-27 Thread Muharrem Bilgin (Bright Software)
database) onWinRT/ WP8 when querying large (!) result sets using 3.8.4.1 On 27 Mar 2014, at 4:00am, Muharrem Bilgin (Bright Software) <mbil...@brightsoft.com.au> wrote: > The blob issue mentioned is happening with another table in another > application. The reason it was mentioned

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

2014-03-27 Thread Muharrem Bilgin (Bright Software)
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

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

2014-03-27 Thread Muharrem Bilgin (Bright Software)
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

2014-03-26 Thread Muharrem Bilgin (Bright Software)
M, Muharrem Bilgin (Bright Software) < > mbil...@brightsoft.com.au> wrote: > >> The table in question is created by using the following statement. >> >> CREATE TABLE PRD_DETAILS (PRD_CODE TEXT COLLATE NOCASE NOT NULL, >> TERID INTEGER NOT NULL, SEQ INTEGER, PR

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

2014-03-26 Thread Muharrem Bilgin (Bright Software)
) 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

2014-03-26 Thread Muharrem Bilgin (Bright Software)
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

2014-03-26 Thread Muharrem Bilgin (Bright Software)
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

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

2014-03-26 Thread Muharrem Bilgin (Bright Software)
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

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

2011-06-20 Thread Alessandro Caliaro software
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"

2011-01-30 Thread GHCS Software
(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://www.ghcssoft

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

2010-10-28 Thread Art Age Software
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

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

2010-10-27 Thread Art Age Software
e: > -BEGIN PGP SIGNED 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. >

[sqlite] Loss of Binary Data in Dump File

2010-10-27 Thread Art Age Software
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

Re: [sqlite] FTS3 MATCH syntax

2010-09-25 Thread GHCS Software
iven:q. On Fri, Sep 24, 2010 at 4:16 PM, GHCS Software<g...@ghcssoftware.com> 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 refe

[sqlite] FTS3 MATCH syntax

2010-09-24 Thread GHCS Software
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 *GHCS Software* http://www.ghcssoftware.com g

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

2010-07-14 Thread GHCS Software
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.com> Fro

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

2010-07-13 Thread GHCS Software
e3.cpp" 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

2009-07-02 Thread Software
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

Re: [sqlite] SQLite Version 2.1

2009-06-09 Thread Marcus Hassmann / Hassmann-Software
e 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 > -- Mit freundl

[sqlite] SQLite Version 2.1

2009-06-07 Thread Marcus Hassmann / Hassmann-Software
. -- 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_Hassmann

[sqlite] Pragma integrity_check and attached ddatabases

2008-11-03 Thread BR-Software
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?

2006-04-20 Thread DBTools Software
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