Hello Joe Wilson,
the build-in database engine is a much praised feature of SQLiteSpy. It
simplifies the life of many users, and mine as well, since there can be no
incompatabilities with wrong DLLs and versions.
I am sorry that you can not use SQLiteSpy with your custom DLL. Maybe you would
l
Hello Nahor,
there is no need for you to use SQLiteSpy 1.4 to create SQLite 3.2.x compatible
database files. You can do so with the latest version of SQLiteSpy as well.
Here's how to do so:
1. Create a new database as usual.
2. Execute the following two SQL statements:
PRAGMA legacy_file_f
Hello Joe Wilson,
I want to thank you and everybody else to share their thoughts on SQLiteSpy and
let you know that I very much value your feedback. I initially wrote SQLiteSpy
for my own personal needs only, but it has since then certainly improved thanks
to the responses I have received by ma
Hello,
I have just uploaded the new SQLiteSpy 1.5.2 to
http://www.yunqa.de/delphi/sqlitespy/
SQLiteSpy is a freeware, single-exe SQLite database manager for Microsoft Win32
platforms. It has been reported to run under Linux / Wine as well.
New in this release:
* Internal database engine upd
>But I do not think that DOS has the ability
>to automatically delete a file when it is closed, so the
>files remain on disk after SQLite has finished with them.
Just a thought:
Wouldn't it possible to have SQLite thoughtfully delete all files it creates
when closing the database instead of re
Hello,
I am using SQLite compiled with SQLITE_ENABLE_MEMORY_MANAGEMENT on Win32.
I execute the following psydocode, all with same DB handle:
* In application's main thread: sqlite3_open
* Create a new thread
* In new thread: sqlite3_close
This creates an access violation in pager.c, lines 2065
Hello Ludovic Ferrandis,
thanks, but this is not quite true for the latest version:
http://www.sqlite.org/faq.html#q8 reads:
"The restriction on moving database connections across threads was relaxed
somewhat in version 3.3.1. With that and subsequent versions, it is safe to
move a connection
Hello Rob Lohman,
SQLite is multithreaded since 3.3.1. Still, threre are restrictions:
"When shared-cache mode is enabled, a database connection may only be used by
the thread that called sqlite3_open() to create it. If another thread attempts
to use the database connection, in most cases an SQ
Hello Richard,
in case of stating the obvious: Thanks for your answer! It is always my
pleasure reading your explanations on SQLite: Quick, precise, and right up to
the point!
Ralf
>> While I understand from the FAQ that it might be problematic to use more
>> than one thread with SQLITE_ENABL
>Would it be useful to have recursive DELETE triggers
>even without recursive INSERT or UPDATE triggers?
Recursive DELETE triggers would certainly be usefull and have in fact already
been asked for on this list occasionally. They would allow to move referential
integrity of hierarchical data o
I am aware that the use of SQLITE_UNTESTABLE is discouraged. Still I
want to point developers to the fact that SQLITE_UNTESTABLE breaks RBU.
In particular, RBU relies on SQLITE_TESTCTRL_IMPOSTER to be fully
working. With SQLITE_UNTESTABLE defined, this is not the case. RBU
functions return err
On 8/25/2018 4:53 PM, Richard Hipp wrote:
There are lots of similar situations, where omitting features from
SQLite will break extensions that depend on those features. For
example SQLITE_OMIT_VIRTUALTABLE will break FTS3, FTS4, FTS5, and
RTREE, all of which depend on virtual tables.
Depend
This readblob() error message "BLOB write failed" is misleading:
https://www.sqlite.org/src/artifact?ln=79&name=085bbfa57ea58bb1
To me, "BLOB read failed" would make more sense in the readblob() context.
Ralf
___
sqlite-users mailing list
sqlite-use
I experience a memory leak in fossildelta.c using the delta_parse()
table-valued function.
Given this schema:
CREATE TABLE t (x, y, d);
INSERT INTO t VALUES (' +
X'112233445566778899AABBCCDDEEFF',
X'112233445566778899AABBCCDDEE11',
Null);' +
UPDATE t SET d = delta_create(x, y);
I believe, a closing parenthesis should be before the final comma in
this line:
http://www.sqlite.org/src/artifact/0e2603c23f0747c5?ln=4202
Ralf
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/
I am presenting a scenario where a SELECT produces a different result
after running ANALYZE.
To reproduce, download this database file (5.6MB, SHA1
12d1295d06327ee19ed2453517b0dd83233c6829, available for two days from now):
https://expirebox.com/download/328baafe26688579fccd55debfc54ad3.htm
On 21.11.2017 15:36, Richard Hipp wrote:
I'll be working on some other solution for you.
Many thanks, but this is not necessary. I can rebuild from Fossil.
Ralf
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.s
zipfile.c fails to calculate the CRC32 value if the compression method
is explicitly set to 0. Example SQL:
INSERT INTO zz(name, mode, mtime, data, method)
VALUES('f.txt', '-rw-r--r--', 10, 'abcde', 0);
As a result, a CRC32 value of 0 is written to the file. Some archive
managers h
On 23.01.2018 15:31, Richard Hipp wrote:
I'm still unable to reproduce this problem.
sqlite3.exe from this ZIP:
https://www.sqlite.org/2018/sqlite-tools-win32-x86-322.zip
Running on Windows 7:
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
Connected to a tran
Example SQL:
select
length(printf ('%4s', 'abc')),
length(printf ('%4s', 'äöü')),
length(printf ('%-4s', 'abc')),
length(printf ('%-4s', 'äöü'))
Output is 4, 3, 4, 3. Padding seems to take into account UTF-8 bytes
instead of UTF-8 code points.
Should padding not work on code points an
On 18.02.2018 00:36, Richard Hipp wrote:
The current behavior of the printf() function in SQLite, goofy though
it may be, exactly mirrors the behavior of the printf() C function in
the standard library in this regard.
SQLite3 is not C. SQLite3 text storage is always Unicode. Thus SQL text
proc
On 19.02.2018 09:50, Rowan Worth wrote:
What is your expected answer for:
select length(printf ('%4s', 'です'))
'です' are 2 codepoints according to
http://www.fontspace.com/unicode/analyzer/?q=%E3%81%A7%E3%81%99
The requested overall width is 4, so I would expect expect two added
spaces and
On 18.02.2018 00:36, Richard Hipp wrote:
So I'm not sure whether or not this is something that ought to be "fixed".
I want to send a big Thank You! for your efforts to enhance the printf()
string formatter:
http://www.sqlite.org/src/info/c883c4d33f4cd722
I saw the check-in just now as I
This SQL causes a memory leak in the csv.c virtual table module:
CREATE VIRTUAL TABLE if not exists t1
USING csv(filename='FileDoesNotExists.csv');
Cause is that the zIn buffer which is allocated here:
http://localhost:8081/artifact?name=1a009b93650732e2&ln=128
is only freed in csv_rea
On 17.09.2015 20:14, Scott Hess wrote:
> The problem is that there are LOCALE settings where tolower() does things C
> programmers don't expect. I think tr_TR was one case, the handling of 'I'
> (Google "tr_tr locale bug" and you'll see lots of people hitting the same
> general problem). It isn'
My implementation of
http://www.sqlite.org/src/artifact/400384798349d658?ln=94-96
returns "corrupt" plus a trailing zero, that is 8 characters in total.
Maybe this line
http://www.sqlite.org/src/artifact/4fdbc0a321e3a1d7?ln=5364
should be corrected to
sqlite3Fts5BufferSet(&rc, &s, 7,
These 2 lines seem to serve no purpose. Also, they are not indented like
the reset of the code. This makes me think they might have been left in
from debugging:
http://www.sqlite.org/src/artifact/b271b19dd28d3501?ln=3819-3820
Ralf
If you are on Windows, you can use SQLiteSpy to correct such wrongly
entered ANSI text to Unicode throughout an entire database:
http://yunqa.de/delphi/products/sqlitespy/index
Open the database and from the menu pick
Execute -> Text to Unicode Convertsion ...
A dialog opens where you can
On 23.07.2016 17:16, Richard Hipp wrote:
Look over the changes. Speak up loudly and quickly if you have any
issues.
http://127.0.0.1:8080/artifact/ea0903701e3ac02b
sqlite3_scrub_backub() is not mentioned in the 3.14 draft release log
nor documentation.
* Will it be part of the next version
Absolutely, thanks for the catch!
This link might be even better as it always points to the latest version
on trunk:
https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/misc/scrub.c
Ralf
On 24.07.2016 15:19, Simon Slavin wrote:
By which you mean, of course,
http://www.sqlite.org/cgi
I use the following C code to test sqlite3_scrub_backup() [1].
Unfortunately, it results in a malformed database disk image.
Also, I am surprised that VACUUMing the original database produces a
smaller file than sqlite3_scrub_backup(). Should they not be the same size?
Is this a problem with
On 26.07.2016 12:53, Dan Kennedy wrote:
The corrupt database thing is unexpected, of course. It might be fixed
here:
http://sqlite.org/src/info/483994a54dee3c7a
Please let us know if you get the chance to try the fix above with your
databases.
I confirm that the fix solves the problem repo
At current, the csv extension fails to open Unicode file names like
CREATE VIRTUAL TABLE t1 USING csv(
filename = "äöü.csv");
because internally the filename is passed to fopen() as UTF-8:
http://www.sqlite.org/src/artifact/816a3715356e4210?ln=131
However, fopen() does not honor UTF-8,
The files csv.c and vfsstat.c use
#include
with angle brackets
http://www.sqlite.org/src/artifact/816a3715356e4210?ln=42
http://www.sqlite.org/src/artifact/bf10ef0bc51e1ad6?ln=17
where quotation marks are otherwise used throughout SQLite, i.e.
http://www.sqlite.org/src/artifact/16c1b
Since the previous mailing list outage, I was able to post to this list
http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/msg98671.html
http://www.mail-archive.com/sqlite-users%40mailinglists.sqlite.org/msg98672.html
but I have not received any messages since. I have logged
The invalid link is in red font. Reference:
https://www.sqlite.org/sessionintro.html#extended_functionality
Ralf
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I am the author of the DISQLite3 Delphi wrapper. Assurance to all
DISQLite3 users: The leak is not DISQLite3 specific. DISQLite3 5.15.0
behaves exactly like the official SQLite 3.15.0 release.
The problem can reliably be reproduced using the official sqlite3.exe
3.15.0 binary on Win32.
Bisec
Alarming side effect of SQLITE_OMIT_BUILTIN_TEST: It renders the fix
[005d5b87] for ticket [da784137] useless.
Ticket: http://www.sqlite.org/src/info/da7841375186386c
Fix, trunk: http://www.sqlite.org/src/info/005d5b870625d175
Fix, 3.15.2: http://www.sqlite.org/src/info/27438fb43db4eae9
R
On 07.12.2016 14:21, Richard Hipp wrote:
Side note: I notice that the SQLite binaries (Windows, at least) are not
compiled with SQLITE_OMIT_BUILTIN_TEST and not affected by the problem.
Is there a reason to omit SQLITE_OMIT_BUILTIN_TEST from the builds, as
it adds at least some overhead?
>
The
On 24.03.2017 00:50, Richard Hipp wrote:
This second beta adds a new SQL function: json_patch(). See
https://www.sqlite.org/draft/json1.html#jpatch for details.
json_patch() fails to produce the expected result for the last example
in https://tools.ietf.org/html/rfc7396#appendix-A
SELECT
SQLite on Windows crashes when running this test:
n_structure_10_opening_arrays.json
The crash results from a stack overflow because json_valid() is
implemented using a recursive parser. All versions of json1.c up to
current trunk are affected.
Here is a small SQL snippet that also tri
On 23.01.2014 11:28, dean gwilliam wrote:
More specifically...is there the equivalent of that powerbasic include
file for D5 i.e. that enables you to access the dll's function calls
unchanged?
Failing that...anything that will let me work with the latest sqlite 3 dll
The meaner and leaner...the
On 24.01.2014 10:06, Max Vlasov wrote:
BCC 5.5 (freely downloadable) compiles any version of sqlite3 to
object files linkable to Delphi 5 and later, the only drawback I
noticed is that for memory-intensive operations (memory databases) the
performance is twice as worst comparing to the dll on th
On 09.05.2014 12:36, Carlos Ferreira wrote:
I am using a win32 DLL built "sqlite-dll-win32-x86-3071700" . the DLL is
from 20-5-2013.
I am using it with Delphi, and it works fine for what I need.
I need however a 64 bits version of the DLL.
SQLite3 for Delphi, both Win32 and Win64, with many
On 09.05.2014 13:50, Carlos Ferreira wrote:
XE6 itself seems to native have access to both...
FireDAC only, and outdated by 2 months at the day of release. Delphi XE5
SQLite is still at 3.7.17, almost one year behind.
DISQLite3 has always been up to date for years and Delphi versions back
I know that AsyncIO is now superseded by WAL [1], but according to
Richard it should still work for existing applications [2].
However, I experience the opposite.
The small C application below runs well when linked against SQLite
3.7.14. With SQLite 3.7.15, it mysteriously fails. I see two types
On 07.12.2012 00:19, Joe Mistachkin wrote:
> Could you please try the changes in:
>
> http://www.sqlite.org/src/info/c507ca4a8e
>
> and then let us know if this clears the issue you are seeing?
Yes, this clears my issues. Many thanks for the quick fix!
Looks like it updates AsyncIO to s
In the list of PRAGMAs in
pragma.html
the "PRAGMA user_version" documentation link to
http://www.sqlite.org/pragma.html#pragma_user_version
is invalid. It should point to
http://www.sqlite.org/pragma.html#pragma_schema_version
instead.
This is also present in today's documentation draf
The current SQLite Fossil snapshot does not compile with SQLITE_OMIT_WAL
defined.
Reason:
The Pager->pWal element is compiled out in pager.c here:
http://www.sqlite.org/src/artifact/6c3a8a5d665498b0344395a2c9f82d5abc4cc771?ln=691-694
but still accessed here:
http://www.sqlite.org/src/artifact
Current trunk still does not compile with SQLITE_OMIT_WAL #defined.
Details here:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg76672.html
Ralf
On 26.04.2013 17:34, Richard Hipp wrote:
> Please visit http://www.sqlite.org/draft/releaselog/3_7_17.html to see the
> proposed enhancements
I am unsure about how the amatch extension works. According to the
documentation, I believe that the SQL below should return at least one
record, but it does not. No errors are reported either.
I compiled the shell executable with the 201304290917 draft amalgamation
and today's amatch.c from Fossi
The new fts3tokenize virtual table calls the fts3_tokenizer() SQL function
internally to retrieve the pointer to the tokenizer implementation for a FTS
table:
http://www.sqlite.org/src/artifact/a29f126b9e6c6a6f1021a8f7440bf125e68af1f9?ln=74-100
However, this call is rejected if, for security re
On 19.06.2013 17:18, Tom Holden wrote:
> I use the SQLiteSpy compilation of SQLite3 which recently upgraded
> from pre SQLite 3.7.8 to pre 4.2.0.
You must be mistaken. As the author of SQLiteSpy, I can clearly say that
there is no SQLiteSpy version 3.7.8 nor 4.2.0. The current version is
SQLiteS
On 21.06.2013 05:10, Tom Holden wrote:
> Ralf Junker ralfjunker at gmx.de Thu Jun 20 18:44:15 EDT 2013 wrote:
>
> On 19.06.2013 17:18, Tom Holden wrote:
>
>> I use the SQLiteSpy compilation of SQLite3 which recently upgraded
>> from pre SQLite 3.7.8 to pre 4.2.0.
>
On 19.07.2013 09:21, Sqlite Dog wrote:
> Our database manager is developed using Delphi (Pascal). Thus it is
> not possible to statically link SQLite library, SQLite.dll is used.
> Is there some other way to support SEE in our project?
You have two options:
* Create your own sqlite.dll and com
On 19.07.2013 15:27, Sqlite Dog wrote:
>> * Statically link SQLite to your Delphi application. My DISQLite3
>> enables you to do just that and has numerous extensions: One is a
>> custom encryption algorithm. This is not compatible with SEE,
>> but if you like I can replace it with your orig
I suggest a verb to express what the function is actually doing, namely
to reduce its argument in rank or degree for the query planner:
DEGRADE
1. to reduce in worth, character, etc; disgrace;
2. to reduce in rank, status, or degree; remove from office;
3. to reduce in strength, quality, intens
On 11.09.2013 16:07, Ryan Johnson wrote:
Perhaps you meant "demote" rather than "degrade" ? That would be a
better fit (an external action that does not necessarily make the
object worse or less useful), and less vague, but it still carries a
negative connotation.
"demote" sounds fine to me, e
analyze.c always prints 32-bit variables as 64-bit here:
http://www.sqlite.org/src/artifact/d322972af09e3f8debb45f420dfe3ded142b108b?ln=746
http://www.sqlite.org/src/artifact/d322972af09e3f8debb45f420dfe3ded142b108b?ln=792
This can cause wrong sqlite_statX tables which I have experienced
compi
On 09.10.2013 15:50, Eric Minbiole wrote:
With this change, tests pass again:
#if sizeof(p->nRow) == sizeof(long long)
sqlite3_snprintf(24, zRet, "%lld", p->nRow);
#elseif sizeof(p->Row) = sizeof(long)
sqlite3_snprintf(24, zRet, "%ld", p->nRow);
#else
sqlite3_snpri
On 10.10.2013 03:53, Richard Hipp wrote:
I think that http://www.sqlite.org/src/info/e97d7d3044 fixes this issue.
Works well for me.
Please correct me if I've missed something.
You committed to the "row-size-est" branch. I guess this will be merged
into "trunk" for 3.8.1?
Ralf
SQLite 3.8.1 compiled with SQLITE_OMIT_FLAG_PRAGMAS #defined calls
sqlite3_busy_timeout() for all flag pragmas.
Example:
PRAGMA legacy_file_format=100;
should do nothing but sets
sqlite3_busy_timeout(db, 100);
The change was introduced here:
http://www.sqlite.org/src/artifact/249742bd
On 05.03.2012 14:50, Rob Richardson wrote:
> I keep hoping to find something better, because SQLiteSpy does not
> offer the ability to edit a table inside a grid.
Not quite true. SQLiteSpy can edit table cells inside a grid.
Double-click the table-icon in the schema treeview to display the table
On 05.03.2012 16:11, Rob Richardson wrote:
> With the latest version, I think you can.
SQLiteSpy grid editing has been around for years, it is available since
version 1.6.0., 7 Feb 2007.
> But I haven't been able to get the latest version. The link you
> provided does not work for me. Do you kn
On 05.03.2012 18:45, Rob Richardson wrote:
> I can't get to www.yunqa.de now. I tried in IE8 and FireFox.
Most strange. Luckily, search engines find plenty of SQLiteSpy download
alternatives. Here is one of the more well known ones:
http://www.softpedia.com/get/Internet/Servers/Database-Utils/S
On 27.04.2012 11:38, Gabriel Corneanu wrote:
> There is one more reason to use DLLs, I'm surprised noone mentioned it.
> What if you don't use C??? (I use myself Delphi with a header conversion).
DISQLite3 compiles right into your Delphi application. Both 32-bit and
64-bit supported:
http://ww
On 27.04.2012 15:08, Gabriel Corneanu wrote:
> With the amalgamation, it's also quite easy to compile to one obj and
> link directly in Delphi (similar to jpeg; that's probably what you also
> do). No pun intended, why should I pay for it?
- DISQLite3 Personal edition if free!
- DISQLite3 is 64-
On 04.05.2012 16:39, Richard Hipp wrote:
> If a single min() or max() aggregate function appears in a query, then any
> other columns that are not contained within aggregate functions and that
> are not elements of the GROUP BY will take values from one of the same rows
> that satisfied the one mi
... at both end and beginning of these lines:
http://www.sqlite.org/src/artifact/45a846045ddb8c4318f2919f3a70f011df5ca783?ln=2584-2585
Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-user
Testing SQLite Fossil [0abdc2903d], sqlite_open_v2() returns SQLITE_PERM when
trying to open a named memory database if the flag SQLITE_OPEN_CREATE is not
passed. This is in contrast to unnamed memory databases. Is this intentional?
Basic C code below demonstrates the issue.
Ralf
-
On 26.06.2012 14:33, Vivien Malerba wrote:
> The code is some SQL entered by the user, I have no control over it. There
> is effectively the possibility to parse the SQL entered, detect the CREATE
> table statement and act accordingly, but I would like to see if SQLite has
> some kind of builtin f
On 17.08.2012 09:30, Mohit Sindhwani wrote:
> We're using FTS4 and it works well for many things. One of the things
> that we'd like to do is to see what terms are being created by the
> tokenizer in use. What would be the easiest way to do that?
>
> I tried looking through the fts_aux table an
On 02.12.2012 04:37, Simon Slavin wrote:
>> I'm using DISQLite and the online api in delphi, not the command
>> line thing.
>
> I have seen some bad drivers which assume that underlying schema will
> not be changed by another user while they have a database connection
> open. I have no reason to
I experience problems with Async IO testing the latest 3.7.15 trunk.
Simple statements like CREATE TABLE fail with SQLITE_IOERR.
I read the note in the Async IO README.txt that Async IO is now
superceded by WAL mode and no longer maintained.
Does this also mean that it will no longer be working w
On 04.12.2012 22:14, Richard Hipp wrote:
>> Does this also mean that it will no longer be working with SQLite
>> 3.7.15? Is it just deprecated for new development? Or has something else
>> changed that I should take care of?
>
> That means that we are not willing to devote large amounts of time to
On 04.12.2012 22:25, Richard Hipp wrote:
>> My question is if existing applications which Async IO should continue
>> to work with SQLite 3.7.15? Or has something in the SQLite core changed
>> so that you'd expect Async IO failures in 3.7.15, or later versions?
>
> They should continue to work, a
VACUUM with multiplex does not delete chunks on Windows (fossil [8ce2b74a82]).
It seems this is because the file handle(s) are still held open by the
multiplex layer when xDelete is triggered. Since Windows can not delete open
files, they are kept.
I have not investigated this in depth, but clo
The sqlite3_uri_int64() doc reads: "If the value of P is something other
than an integer, then zero is returned." I found this to be not true.
Instead, it returned default.
Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
Reading the sources, sqlite3_db_release_memory() always returns
SQLITE_OK. Will it stay this way or will it some day return another
value like the amount of memory released?
Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
The new feature to insert multiple rows of VALUES in a single INSERT
http://www.sqlite.org/src/info/eb3b6a0ceb
gives wrong results if SQLite is compiled with SQLITE_OMIT_COMPOUND_SELECT.
Example:
CREATE TABLE t10(a,b,c);
INSERT INTO t10 VALUES(1,2,3), (4,5,6), (7,8,9);
SELECT * FROM t10
On 07.02.2012 12:28, Ralf Junker wrote:
> The new feature to insert multiple rows of VALUES in a single INSERT
>
> http://www.sqlite.org/src/info/eb3b6a0ceb
>
> gives wrong results if SQLite is compiled with SQLITE_OMIT_COMPOUND_SELECT.
Has the team seen this or has it been ov
On 13.02.2012 10:18, Dan Kennedy wrote:
> On 02/10/2012 11:06 PM, Ralf Junker wrote:
>>
>>> The new feature to insert multiple rows of VALUES in a single INSERT
>>>
>>>http://www.sqlite.org/src/info/eb3b6a0ceb
>>>
>&
https://www.sqlite.org/queryplanner.html
contains the text "The process is illustrated by figure 2 below." where
the "figure 2" part links to
https://www.sqlite.org/queryplanner.html#fig2
DocSrc: https://www.sqlite.org/docsrc/artifact/ce9ee7160e98d868?ln=100
The link to the image does not work
ext/misc/json1.c uses the following functions from the C library:
isalnum(): http://www.sqlite.org/src/artifact/541004e47235cefc?ln=564
isspace(): http://www.sqlite.org/src/artifact/541004e47235cefc?ln=635
isdigit(): http://www.sqlite.org/src/artifact/541004e47235cefc?ln=829
Existing source code
sqlite3rbu.c uses sprintf(), which SQLite3 uses nowhere else:
http://www.sqlite.org/src/artifact/d37e1ca2d13e439c?ln=2643
Could you replace this with sqlite3_mprintf(), just like one function above?
http://www.sqlite.org/src/artifact/d37e1ca2d13e439c?ln=2625-2628
Ralf
sqlite3rbu.c intermingles variable declaration and code, which is not
with ANSI C here:
http://www.sqlite.org/src/artifact/d37e1ca2d13e439c?ln=623-624
Declaring zSql before calling va_start() solves the problem for me:
char *zSql;
va_start(ap, zFmt);
zSql = sqlite3_vmprintf(zFmt, ap);
Warning: sqlite3rbu.c 3528: void functions may not return a value in
function rbuVfsDlClose.
http://www.sqlite.org/src/artifact/d37e1ca2d13e439c?ln=3526-3529
Looks like the return value is not needed.
Ralf
From fts5aux.test 2.3 I conclude that the FTS5 xColumnSize() function
accepts negative column values and returns the total token size of all
columns from the current row:
https://www.sqlite.org/src/artifact/8c687c948cc98e9a?ln=64-66
Indeed, this is also in source:
https://www.sqlite.org
This SQL
SELECT fts5_expr();
results in an AV here:
https://sqlite.org/src/artifact/56dcbcbdc9029dd7?ln=145
Reason is that fts5ExprFunction() does not check for at least one
argument to fts5_expr() here:
http://sqlite.org/src/artifact/56dcbcbdc9029dd7?ln=1886
Ralf
As per the documentation, extra arguments to the Porter stemmer are
handed on to the underlying tokenizer:
http://www.sqlite.org/docsrc/artifact/9eca0ea509ae3e4d?ln=544-546
Example syntax a few lines below:
http://www.sqlite.org/docsrc/artifact/9eca0ea509ae3e4d?ln=556
However, the code d
As of Fossil checkin f84a1539, the RBU code in the following C example
is no longer executed to completion. Instead, an error message is
generated and the result database is not correctly written.
The code works fine with Fossil checkin 28091a48. It generates no error
messages and produces the ex
Replying to myself just to confirm that
https://www.sqlite.org/src/info/0b9d8a1202c4220f fixes the problem.
Thank you, Dan!
Ralf
On 20.12.2019 17:48, Ralf Junker wrote:
As of Fossil checkin f84a1539, the RBU code in the following C example
is no longer executed to completion. Instead, an
On 22.12.2019 17:23, Keith Medcalf wrote:
I get:
RBU error: near ")": syntax error ERROR 1, expected 101 Done - Press
ENTER to exit.
with the current trunk ...
Thanks for following up on this. I spotted a typo in the test code.
Corrected version below. With that, Dan's fix works for me on tr
Checkin f5ee3042 introduces a memory leak in zipfile.c. It is still
present on trunk, tested with 0b1dbd60.
Cause: zipfileDeflate() calls deflateInit2() twice and allocates zlib
stream memory twice in certain situations.
Also, deflateEnd(&str); may not be called if aOut is not allocated after
an
With the urifuncs extension enabled, the each of following SQL queries
causes an access violation & crash:
select sqlite3_filename_database('');
select sqlite3_filename_journal('');
select sqlite3_filename_wal('');
Ralf
___
sqlite-users mailing l
201 - 295 of 295 matches
Mail list logo
