Thanks Dan. I had checked the database integrity using the following command:
sqlite3 myfile.db "PRAGMA integrity_check;"
And it had reported ok. I will see if I can share the database file here.
Can you let me know how to check the db file (in case I am not able to share
the db file here) ? And
>Why does the "=" query fail and the "like" query work? There are no
>wildcards involved.
>The behavior is the same in Sqlite command line. There are no
>wildcards involved.
sqlite> create table songfiletable (
...> songfile_id integer primary key,
...> dancename text
...> );
sqlite>
On 4 Jun 2019, at 12:46am, Doug wrote:
> Why does the "=" query fail and the "like" query work?
To help us investigate ...
Which version of SQLite is this ? You can use
SELECT sqlite_version();
to find out.
What do you mean by 'work' and 'fail' ? Are you referring to an error code ?
I am using Sqlite under QT 5.12.0.
Why does the "=" query fail and the "like" query work? There are no
wildcards involved.
I create the table this way:
QString sqlcreate = QLatin1String(
"CREATE TABLE songfiletable ("
"songfile_id INTEGER PRIMARY KEY,"
"dancename TEXT"
I'm on a SiFive Unleashed board running Debian Linux on Kernel 4.19.
--
Sent from IPhone
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On 3/6/62 12:51, bhandari_nikhil wrote:
I am facing a crash in sqlite3fts5BufferAppendBlob. Following is the
backtrace:
#0 sqlite3Fts5BufferAppendBlob (pRc=pRc@entry=0xf54139c8,
pBuf=pBuf@entry=0xf5afeb90, nData=4294967295, pData=0xf49fff76 "90246ture")
at sqlite3.c:180474
#1 0xf717b6f8
On 31/5/62 04:54, Sebastien Boisvert wrote:
I've got a couple of general questions about the session extension,
specifically about applying changesets/patchsets:
- Assuming little to no conflicts, what's the performance of applying a
changeset to a database; let's say for 1 (or multiples
7 matches
Mail list logo