group_concat in the sense
that it does not mention that the order is (always) arbitrary?
Regards,
Hardy
> Am 2020-03-02 um 04:46 schrieb Keith Medcalf <mailto:kmedc...@dessus.com>>:
>
>
> On Sunday, 1 March, 2020 14:58, mailing lists <mailto:mailingli...@skywind.eu>> wr
Assume I create the following table:
CREATE TABLE Test (ID INTEGER PRIMARY KEY, Value TEXT);
INSERT INTO Test (Value) VALUES('Alpha');
INSERT INTO Test (Value) VALUES('Beta');
INSERT INTO Test (Value) VALUES('Beta');
INSERT INTO Test (Value) VALUES('Alpha');
According to the documentation of grou
I am executing a prepared statement S with a couple of different bindings. The
execution sequence is similar to this
while (moreBindings)
{
bind_parameters_to_prepared_statement;
sqlite3_step();
if (error)
{
…
}
sqlite_reset();
if (error)
{
}
}
The issue is that sqlite_reset() reports the sam
PlayersFTS WHERE (PlayersFTS MATCH
'LastName:B') OR (PlayersFTS MATCH 'FirstNames:2');)
> Am 2020-01-23 um 17:51 schrieb Jens Alfke :
>
>
>> On Jan 23, 2020, at 6:47 AM, mailing lists wrote:
>>
>> The following SELECT statement fails with the error &qu
Hi,
create and fill the tables:
CREATE TABLE Games (ID INTEGER PRIMARY KEY, WhiteID INTEGER, BlackID INTEGER);
CREATE VIRTUAL TABLE PlayersFTS USING FTS5 (LastName,FirstNames);
INSERT INTO Games (WhiteID,BlackID) VALUES(1,2);
INSERT INTO PlayersFTS (rowid,LastName,FirstNames) VALUES(1,'A','1');
Hi sorry,
just forget it. I have overseen a typo.
> Am 2019-11-01 um 15:00 schrieb mailing lists :
>
> Assume the following statements
>
> CREATE VIRTUAL TABLE NamesFTS USING FTS5 (LastName);
> INSERT INTO NamesFTS (LastName) VALUES('L.');
> INSERT INTO
Assume the following statements
CREATE VIRTUAL TABLE NamesFTS USING FTS5 (LastName);
INSERT INTO NamesFTS (LastName) VALUES('L.');
INSERT INTO NamesFTS (LastName) VALUES('"L."');
SELECT rowid FROM NamesFTS;
> 1
> 2
SELECT rowid FROM NamesFTS WHERE NamesFTS MATCH '"L."';
> 1
> 2
How do I get onl
AND FirstNames MATCH
'beta';
Regards,
Hartwig
> Am 2019-11-01 um 07:55 schrieb Dan Kennedy <mailto:danielk1...@gmail.com>>:
>
>
> On 1/11/62 03:03, mailing lists wrote:
>> Hi Dan,
>>
>> I did not know that. What was the reason that it did not wor
Hi Dan,
I did not know that. What was the reason that it did not work before 3.30?
Regards,
Hartwig
> Am 2019-10-31 um 19:16 schrieb Dan Kennedy :
>
>
> On 1/11/62 00:32, mailing lists wrote:
>> For normal tables I can use something like:
>>
>> SELECT * FROM N
For normal tables I can use something like:
SELECT * FROM Names WHERE FirstNames=? AND or OR LastName=?;
For FTS tables I can only use
SELECT * FROM FTSNames WHERE FirstNames MATCH ? OR LastName MATCH ?; AND is not
supported (still do not know why)
Is there any possibility to use prepared stat
ednesday, 30 October, 2019 16:33, mailing lists
> wrote:
>
>> I face the following issue:
>
>> 1) SQLite has been compiled with SQLITE_THREADSAFE=1 and
>> SQLITE_DEFAULT_SYNCHRONOUS=3
>> 2) I am opening in a thread a new database (standard journal mode) and
&g
Hi,
I face the following issue:
1) SQLite has been compiled with SQLITE_THREADSAFE=1 and
SQLITE_DEFAULT_SYNCHRONOUS=3
2) I am opening in a thread a new database (standard journal mode) and creating
some tables, indices etc. (explicit transaction)
3) while creating the database a new database co
Hi,
> Am 2019-09-12 um 10:55 schrieb Keith Medcalf :
>
>
> On Tuesday, 10 September, 2019 09:26, mailing lists
> wrote:
>
>> I cannot really put all the inserts into one transaction because in case of
>> a failure I loose all the already inserted data.
>
separated, are they?
Regards,
Hartwig
> Am 2019-09-10 um 17:16 schrieb Richard Hipp :
>
> On 9/10/19, mailing lists wrote:
>
>> So, the best solution I found so far is to disable indexing while insertion
>> and to index the table afterwards
>
> I think that is the best
I have the following situation:
- in one table relatively small data is inserted (100 bytes per record)
- this table contains three indices
- about 100 million or more records have to be inserted
Insertion really slows down after about 100 000 items have been inserted. I
suppose that the slow do
Hi,
please add to the documentation that column limited phrase search is not
supported by FTS3 and FTS4.
Example:
CREATE VIRTUAL TABLE FTSTable USING FTS3 (content,body);
SELECT * FROM FTSTable WHERE FTSTable MATCH 'content:"one two"';
Does not result in an error but also returns no results.
Hi,
yes, but unfortunately I have still a project using FTS3 tables to which I have
to add new features..
Regards,
Hardy
> Am 2019-08-30 um 13:00 schrieb Dan Kennedy :
>
>
> On 30/8/62 17:39, mailing lists wrote:
>> Hi,
>>
>> but there is no token '
SELECT * FROM myData m1, myData m2 WHERE m1.myData MATCH 'one: 42*' AND
m2.myData MATCH 'two: alpha';
SELECT * FROM myData m1, myData m2 WHERE m1.myData MATCH 'one: 42*' OR
m2.myData MATCH 'two: alpha';
Strange…
Hardy
PS: sqlite3 version 3.24.0
> Am 2019
to match the token must appear
> as the very first token in any column of the matching row."
>
> So change "FTS3" to "FTS4" and it will likely work.
>
> Dan.
>
>
> On 30/8/62 16:31, mailing lists wrote:
>> Hi,
>>
>> I could not f
Hi,
I could not find an example showing a result in the documentation, therefore I
created one by myself:
CREATE VIRTUAL TABLE myData USING FTS3(content);
INSERT INTO myData 'alpha beta';
1)
SELECT * FROM myData WHERE myData MATCH 'beta';
Result:
content
alpha beta
This is what I expected.
Because of my (obviously wrong) automatic query generator I came across this
issue:
CREATE VIRTUAL TABLE myData USING FTS3 (content, body);
SELECT * FROM myData WHERE (content MATCH 'one') AND (body MATCH 'two');
What is the reason that the above query is not allowed and that
SELECT * FROM m
Hi,
is there in general a performance difference between querying using SELECT …
ORDER BY … ASC or DESC? Without an index I believe that the result is the same
(sorting has to be done anyway somehow). Using an index it should be also the
same but… Are there any examples where DESC is (much) slo
ith :
>
> On 2018/06/13 6:35 PM, skywind mailing lists wrote:
>> Hi Ryan,
>>
>> my problem is that I use the "most safest" mode that exists for SQLite and
>> it still fails… Therefore, I need to know why it fails.
>
> Alright, but this implies a ver
Hi Ryan,
my problem is that I use the "most safest" mode that exists for SQLite and it
still fails… Therefore, I need to know why it fails.
Regards,
Hartwig
> Am 2018-06-13 um 01:23 schrieb R Smith :
>
>
> On 2018/06/13 12:21 AM, skywind mailing lists wrote:
>
rs [mailto:sqlite-users-
>> boun...@mailinglists.sqlite.org] On Behalf Of skywind mailing lists
>> Sent: Tuesday, 12 June, 2018 16:06
>> To: SQLite mailing list
>> Subject: [sqlite] How to convert SQL file into database when a column
>> value is Inf?
>>
>>
Hi,
the original database is malformed. So, I cannot access it anymore besides
doing a dump.
Regards,
Hartwig
> Am 2018-06-13 um 00:17 schrieb Bob Friesenhahn :
>
> On Wed, 13 Jun 2018, skywind mailing lists wrote:
>>
>> A workaround is of course to use a text edito
Hi,
when I load my database into sqlite3 and run an integrity check I only get the
error message: Error: database disk image is malformed
I do not get any further information. What causes this simple error message? I
expected to get some more information what is actually the reason why SQLite3
Hi,
I issued the following commands:
echo .dump | sqlite3 Database.sldb > D.sldb
sqlite3 -init D.sldb NewDatabase.sldb
Unfortunately, reading the SQL file produced the following error:
Error: near line 56721: no such column: Inf
The corresponding SQL command is:
INSERT INTO "Flights"
VALUES(36
Hi,
but to which directory should I set it? There is no general tmp directory
accessible.
Regards,
Hartwig
> Am 2018-06-10 um 02:30 schrieb Bob Friesenhahn :
>
> On Sat, 9 Jun 2018, skywind mailing lists wrote:
>
>> Hi,
>>
>> currently I am not creating
edy :
>
> On 06/10/2018 12:00 AM, skywind mailing lists wrote:
>> Hi,
>>
>> what is your experience with temporary files requested by SQLite3 on
>> Android? I am using SQLite3 natively on Android - I compiled SQLite3 by
>> myself - and get an error when
Hi,
what is your experience with temporary files requested by SQLite3 on Android? I
am using SQLite3 natively on Android - I compiled SQLite3 by myself - and get
an error when SQLite3 tries to create temporary files because:
- the directories
/var/tmp
/usr/tmp
/tmp
> by default.
>
> <https://sqlite.org/lang_conflict.html>
> <https://sqlite.org/pragma.html#pragma_recursive_triggers>
>
> On December 23, 2017 7:05:59 AM EST, R Smith wrote:
>>
>>
>> On 2017/12/23 1:57 PM, skywind mailing lists wrote:
>>>
Hello,
I have checked the documentation but did not find an explicit answer concerning
my case. Of course I can test it but this does not mean that the functionality
is guaranteed also for future versions. Assume I have an insertion statement
like
INSERT OR REPLACE INTO TestTable VALUES(1,2);
Hi,
just my few cents: if you are using the RTree module I made very bad
experiences running SQLite in parallel, even when running only two or three
threads in parallel. In this case I use a single thread-safe queue that is
handling all SQLite access.
Regards,
Hartwig
> Am 2017-03-04 um 16:54
Assume I have got a zPath like abc.def passed to mkFullPathname. Inside
mkFullPathname zPath[0] != '/' will evaluate to true. Assume further that
osGetcwd(..) will return '/' (which can actually be the case under Android and
theoretically under other systems as well but probably less likely). In
Thanks!
In the meantime I found out that version 3.8.8.3 is still working while 3.9.0.0
fails.
Regards,
Hartwig
> Am 2016-08-02 um 18:47 schrieb Dan Kennedy :
>
> On 08/02/2016 01:01 PM, skywind mailing lists wrote:
>> HI,
>>
>> it seems to be that I am not allowe
Hi,
I have seen that the branch Apple-OSX is still active. Is there any reason why
the contents of this branch are not merged into trunk? Or is the trunk always
merged into Apple-OSX? What is the best branch to use for OS X / iOS?
Regards,
Hartwig
_
27;Record B1');");
#endif
ExecuteStatement(databaseHandle,"DELETE FROM A WHERE
AnotherID=1;");
ExecuteStatement(databaseHandle,"DELETE FROM B WHERE ID=1;");
ExecuteStatement(databaseHandle,"COMMIT;");
Hi,
I have added a database but it seems to be that the zip file got lost.
Regards,
Hartwig
> Am 2016-08-02 um 01:13 schrieb Richard Hipp :
>
> Do you have a database schema to go with your sample program?
>
> On 8/1/16, skywind mailing lists <mailto:mailingli...@skywind
Hi,
I have got a database that works using SQLite 3.7.7 but not with version SQLite
3.13.0. I get the assertion
Assertion failed: (((Fts3Table *)pVtab)->mxSavepoint < iSavepoint), function
fts3SavepointMethod, file /.../sqlite/sqlite3.c, line 144649.
I have compiled the SQLite amalgamation wit
Hi,
I checked SQLite’s documentation and a bit the internet but it seems to be that
nobody has a definite answer which preprocessor directives have to be used to
compile SQLite for Universal Windows. Without any preprocessor directives the
compilation badly fails (system calls are the problem).
:36 +0200
> skywind mailing lists wrote:
>
>> At the moment I have to run something like:
>>
>> UPDATE A SET item1=(SELECT B.item FROM B WHERE B.ID=A.ID),...
>> itemN=... WHERE EXISTS (SELECT 1 FROM B WHERE B.ID=A.ID);
>>
>> Using a FROM clause I just need on
> Am 2016-06-04 um 15:33 schrieb Gerry Snyder :
>
> If SQLite implemented the FROM it would just be a translation into the
> complex and slow statements you want to avoid.
>
> Gerry Snyder
> On Jun 4, 2016 9:19 AM, "skywind mailing lists"
> wrote:
>
>
Hi,
I am using quite often SQL statements that update the data of one table with
data from another table. This leads to some quite complex (and slow) statements
because SQLite3 is not supporting a FROM clause in update statements. I am just
wondering why the FROM clause is not supported by SQLi
Hi,
according to the documentation this is a slow query for FTS tables:
SELECT * FROM mail WHERE rowid BETWEEN 15 AND 20;
while
SELECT * FROM mail WHERE rowid=15;
is fast.
As far as I know both queries are fast on normal tables. Where is the
difference / what is the reason for the performanc
vin :
>
>
> On 14 Aug 2015, at 4:10pm, skywind mailing lists
> wrote:
>
>> I do not get any error message from SQLite. And the database only gets
>> corrupted when the iDevice has to shut down due to battery issues. I have
>> never had a customer complaining ab
the same application".
>
> Just sayin'.
>
> --
> E
>
>
> On Thu, Aug 13, 2015 at 2:04 PM, Simon Slavin wrote:
>
>>
>> On 13 Aug 2015, at 6:32pm, skywind mailing lists
>> wrote:
>>
>>> Before my app closes I close the database
mon Slavin :
>
>
> On 13 Aug 2015, at 6:32pm, skywind mailing lists
> wrote:
>
>> Before my app closes I close the database explicitly. Though I do not know
>> if this happens always when the iDevice shuts down due to battery issues.
>
> iDevices shut down quite a
Hi,
does anybody have any similar experience that an SQLite database becomes
corrupt on iOS? It seems to be that when the iDevice is running out of battery
it can happen that the SQLite becomes corrupt. I have currently not found a
possibility to reproduce it but once a while my customers exper
Am 07.09.2014 um 21:52 schrieb Simon Slavin :
>
> On 7 Sep 2014, at 7:19pm, Richard Hipp wrote:
>
>> mailingli...@skywind.eu> wrote:
>>
>>> Is it possible to change the fourth parameter in sqlite3_bind_XXX (and
>>> probably other locations) because this seems to be for me the appropriate
>>>
Hello,
I have seen that SQLite uses normally parameters of type "int" to pass the size
of a variable (see sqlite3_bind_blob, fourth parameter). When compiling SQLite3
with Clang and some warnings enabled I get warnings when passing sizeof(...) as
the fourth parameter. The reason is that sizeof(
Hi Clemens,
thanks for the link!
Regards,
Hartwig
Am 22.08.2014 um 22:26 schrieb Clemens Ladisch :
> skywind mailing lists wrote:
>> I hoped that somebody already tried to implement a nearest neighbor
>> algorithm.
>
> Typically, objects are not axis-aligned rectangl
Hello,
I hoped that somebody already tried to implement a nearest neighbor algorithm.
Is the format of the shadow tables somewhere documented or do I have to analyze
the source code?
Regards,
Hartwig
Am 22.08.2014 um 02:58 schrieb Richard Hipp :
> On Thu, Aug 21, 2014 at 8:54 PM, Peter Aronso
Hello,
does anybody have any experience with implementing a nearest neighbor search
using SQLite's RTree functionality? Is a nearest neighbor search possible?
Regards,
Hartwig
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
In
afpUnlock(sqlite3_file *, int)
the sharedLockByte is defined as an int (int sharedLockByte =
SHARED_FIRST+pInode->sharedByte;) although all other related variables and the
following function parameters are defined as unsigned long longs. At least
theoretically this can lead to information
Am 10.12.2013 um 10:59 schrieb Dan Kennedy :
> On 12/10/2013 02:44 PM, skywind mailing lists wrote:
>> This is an example that the ANALYZE command leads to a wrong query plan for
>> RTrees:
>>
>> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude)
This is an example that the ANALYZE command leads to a wrong query plan for
RTrees:
CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
FromLongitude,TillLongitude);
INSERT INTO A VALUES(1,0,0,0);
INSERT INTO
Am 09.12.2013 um 10:06 schrieb Clemens Ladisch :
> skywind mailing lists wrote:
>> Assume I have the following tables:
>>
>> CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
>> CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, Till
Assume I have the following tables:
CREATE TABLE A (ID INTEGER PRIMARY KEY, Latitude, Longitude, Altitude);
CREATE VIRTUAL TABLE B USING RTree (ID, FromLatitude, TillLatitude,
FromLongitude,TillLongitude);
and there is an index on A for Latitude,Longitude. B is filled using
INSERT INTO B SELECT
my SQLite code
> and it seems to be working correctly.
>
> Peter
>
> - Original Message
>> From: skywind mailing lists
>> To: General Discussion of SQLite Database
>> Sent: Tue, May 7, 2013 10:46:42 AM
>> Subject: Re: [sqlite] Update statement
>>
>&g
Hi,
my question is: is it guaranteed that it works?
Regards,
Hartwig
Am 07.05.2013 um 03:24 schrieb James K. Lowden:
> On Mon, 6 May 2013 23:53:40 +0100
> Simon Slavin wrote:
>
>>> How do I create this kind of update statement?
>>>
>>> UPDATE T SET a=0.5*(a+b), b=0.5*(b-a);
>>>
>>> The RHS
Hi,
How do I create this kind of update statement?
UPDATE T SET a=0.5*(a+b), b=0.5*(b-a);
The RHS should always be used with the values of a and b before the assignment.
I think that the result of this kind of statement is undefined, or?
Regards,
Hartwig
_
Hi,
why is the above mentioned still open? It seems to be that the bug does not
exist anymore under 3.7.7.
Best regards,
Hartwig
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
11, at 9:19pm, skywind mailing lists wrote:
>
>> A few user have reported that when the iPhone/iPad runs out of batteries the
>> SQLite3 database may become corrupted. I have received one database back and
>> it is indeed defect and unrecoverable. Does anybody have an idea
is running out of batteries
(perhaps during a write operation?).
BTW: I assume that the rollback journal is in the same folder as the database
file, right?
Best regards,
Hartwig
Am 07.08.2011 um 22:25 schrieb Richard Hipp:
> On Sun, Aug 7, 2011 at 4:19 PM, skywind mailing lists <
>
I am using SQLite 3.6.x and higher for two apps for the iPhone/iPad. I do not
use the built-in SQLite library because I need Rtree and FTS support.
Therefore, I compile it by myself with the following preprocessor directives:
SQLITE_THREADSAFE=1 SQLITE_ENABLE_RTREE=1 SQLITE_ENABLE_FTS3=1
SQLITE
There seem to be a couple of variables in the sqlite3 amalgamation that get
assigned a value but actually their value is not used. If there is an intention
to get rid of these statements I will submit samples like
h = pFile->h;
(sqlite3.c in line 26039 version 3.7.7)
But perhaps these lines
Hi,
FTS and sqlite3_last_insert_rowid do not work together. This is a known
shortcoming. Basically this also means that you can't use any triggers
involving FTS.
Regards,
Hartwig
Am 13.05.2011 um 17:38 schrieb Steven Parkes:
> I gather sqlite3_last_insert_rowid doesn't play well with FTS? I
Hi Rolf,
I am using FMDB and SQLite for more than 2 years now and have not experienced
any problems so far. Therefore, I expect that the bug is somewhere else but not
inside SQLite (3.7.2) nor FMDB (2009-10-18).
Greetings,
Hartwig
Am 04.05.2011 um 23:22 schrieb Rolf Marsh:
>
>
> Prior to ge
table
In both cases you will get an error message.
Hartwig
Am 22.02.2011 um 00:16 schrieb BareFeetWare:
> On 22/02/2011, at 4:31 AM, skywind mailing lists wrote:
>
>> "Supports SQLite extension" would be an accurate feature description. And in
>> the cell (value) I s
y you may have a row for each type of extension but I find this a
bit too much.
Hartwig
Am 20.02.2011 um 21:48 schrieb BareFeetWare:
> On 21/02/2011, at 3:20 AM, skywind mailing lists wrote:
>
>> in your comparison chart it would also be nice to see which software is able
>> to
Hi Tom,
in your comparison chart it would also be nice to see which software is able to
support SQLite extension. A couple of them do not support the FTS nor RTree
capabilities of SQLite.
Hartwig
Am 20.02.2011 um 07:19 schrieb BareFeetWare:
> Hi Ben,
>
> In reply to your announcement of Base
I have created an RTree table with the command
CREATE VIRTUAL TABLE AirspaceRTree USING rtree
(ID,MinLatitude,MaxLatitude,MinLongitude,MaxLongitude,MinAltitude,MaxAltitude);
Furthermore, I have a table Airspace. The contents besides the ID (primary key)
are irrelevant for this context.
When us
73 matches
Mail list logo
