[sqlite] urifuncs.c access violation & crash

2020-01-14 Thread Ralf Junker
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] zipfile.c memory leak

2019-12-23 Thread Ralf Junker
Out = (int)str.total_out; }else{ sqlite3_free(aOut); *pzErr = sqlite3_mprintf("zipfile: deflate() error"); rc = SQLITE_ERROR; } /* Move below: deflateEnd(&str); */ } deflateEnd(&str); /* Move from above. */ return rc; } Ralf --

Re: [sqlite] RBU fails as of checkin f84a1539 - fixed

2019-12-23 Thread Ralf Junker
works for me on trunk, currently at 0b1dbd60f5. Ralf -- #include #include "sqlite3.h" #include "sqlite3rbu.h" static void check(int r, int e) { if (r != e) { printf ("ERROR %d, expected %d\n", e, r); } } static

[sqlite] RBU fails as of checkin f84a1539 - fixed

2019-12-22 Thread Ralf Junker
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

[sqlite] RBU fails as of checkin f84a1539

2019-12-20 Thread Ralf Junker
expected result database. The problem is still present on trunk, checkin 289158aa at the time of this writing. Could anyone reproduce my findings? Many thanks, Ralf -- #include #include "sqlite3.h" #include "sqlite3rbu.h" sta

[sqlite] fossildelta.c memory leak

2019-05-27 Thread Ralf Junker
by adding sqlite3_free(pCur->aDelta); to deltaparsevtabClose(): https://www.sqlite.org/src/artifact/910510968a30ab77?ln=850-854 Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] blobio.c error message typo

2019-05-27 Thread Ralf Junker
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-u

Re: [sqlite] RBU conflicts with SQLITE_UNTESTABLE

2018-08-27 Thread Ralf Junker
abase updates. Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] RBU conflicts with SQLITE_UNTESTABLE

2018-08-25 Thread Ralf Junker
. Tested with MS Visual Studio 2017. Ralf -- #include #include #include "sqlite3.h" #include "sqlite3rbu.h" sqlite3 *db; static void check(int r, int e) { if (r != e) { printf("ERROR %d %s\n", e, sqlite3_errmsg(db)); } } static int callback(void *

[sqlite] Memory leak in csv.c virtual table module

2018-04-24 Thread Ralf Junker
only freed in csv_reader_reset() if the file was opened successfully and the file handle is assigned: http://localhost:8081/artifact?name=1a009b93650732e2&ln=102-106 Hence no file open, no file handle, no buffer freed, memory leak. Ralf ___ sqlite-

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-24 Thread Ralf Junker
n just now as I am "catching up" from a flu. Feels much better now :-) Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-19 Thread Ralf Junker
xpect expect two added spaces and a total length of 4. Ralf PS: SQLite3 returns 2, which is less than the requested width. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-19 Thread Ralf Junker
(lpad ('äöü', 4, ' ')), length(rpad ('abc', 4, ' ')), length(rpad ('äöü', 4, ' ')) I strongly believe that SQLite3 should follow suit. Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-17 Thread Ralf Junker
-8 bytes instead of UTF-8 code points. Should padding not work on code points and output 4 in all cases as requested? Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite 3.21.0 bug? SELECT CAST ('9223372036854775807 ' AS NUMERIC);

2018-01-23 Thread Ralf Junker
the trailing white space which makes the difference. Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] zipfile.c: crc32 not calculated for uncompressed files - extraction fails

2018-01-16 Thread Ralf Junker
oses, it might be helpful to add a CRC32 column to the zipfile virtual table. Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SELECT result different after ANALYZE

2017-11-21 Thread Ralf Junker
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

[sqlite] SELECT result different after ANALYZE

2017-11-20 Thread Ralf Junker
esults regardless of optimization, I assume that this might be a bug in SQLite. Tested with the SQLite 3.21.0 CLI on Windows. Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/

[sqlite] Closing parenthesis missing from doc comment

2017-07-28 Thread Ralf Junker
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

Re: [sqlite] json_valid() crash on Windows - was: json() number value parsing

2017-04-11 Thread Ralf Junker
rser's nesting depth as RFC 7159 allows: https://tools.ietf.org/html/rfc7159#section-9 Ralf On 10.04.2017 13:54, Richard Hipp wrote: > SQLite returns true from json_valid() for the following cases which > should allegedly be false: > >n_multidigit_number_then_00.j

[sqlite] json_patch(): null not removed with 2nd beta for SQLite 3.18.0.

2017-03-24 Thread Ralf Junker
be removed according to this rule: if Value is null: if Name exists in Target: remove the Name/Value pair from Target Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Performance degradation 3.10->3.13

2016-12-20 Thread Tobel, Ralf
-QPegjkcDdkSVl6Rmp6cHM Does anyone have an idea about the cause? Best Regards, Ralf PS: I know that the code is not optimal. It’s just an example where the performance problem can be reproduced… int main

Re: [sqlite] SQLITE_OMIT_BUILTIN_TEST renders fix for ticket [da784137] useless

2016-12-07 Thread Ralf Junker
EST a no-op. Your report adds fresh impetus to that proposal. I welcome SQLITE_OMIT_BUILTIN_TEST for smaller binaries and better performance. Up to now it has not caused me any problems. So many thanks for the quick fix: http://www.sqlite.org/src/info/afab166313e0b8

[sqlite] SQLITE_OMIT_BUILTIN_TEST renders fix for ticket [da784137] useless

2016-12-07 Thread Ralf Junker
ote: 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? R

Re: [sqlite] VACUUM causes Out of memory error

2016-11-02 Thread Ralf Junker
. Bisection shows that the error entered the SQLite code base here, which is the first version which runs out of memory during VACUUM: http://www.sqlite.org/src/info/29d63059b4d2bb61 I am investigating further. Ralf On 01.11.2016 14:11, Hennekens, Stephan wrote: Since last version of sqlite

[sqlite] Session documentation: Invalid link for sqlite3_changegroup

2016-09-16 Thread Ralf Junker
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

[sqlite] No messages from this list since outage

2016-08-03 Thread Ralf Junker
logged into the web interface and reconfirmed my details - but still received nothing. I wonder if this affects just me or other users as well? Could anyone please look into this? Thanks, Ralf ___ sqlite-users mailing list sqlite-users

[sqlite] #include - angle brackets instead of quotation marks

2016-08-01 Thread Ralf Junker
/16c1b2114eae8804?ln=17 Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] csv.c - Unicode filename failure (Windows, at least)

2016-08-01 Thread Ralf Junker
te library (except for testing etc.). Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3_scrub_backup() -> database disk image is malformed

2016-07-28 Thread Ralf Junker
that it is as small as possible. Understood. Thanks for the info! Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_scrub_backup() -> database disk image is malformed

2016-07-26 Thread Ralf Junker
scrub.c or with my code? Ralf [1] http://www.sqlite.org/src/artifact?ci=trunk&filename=ext/misc/scrub.c --- #include #include "sqlite3.h" sqlite3 *db; static void check(int r, int e) { if (r != e) { printf (&quo

Re: [sqlite] can not generate table when using :memory: database via app.config

2016-07-25 Thread Ralf Kralemann
Hi omitting pragma "foreign keys = true " does not help Ralf Beckhoff Automation GmbH & Co. KG | Managing Director: Dipl. Phys. Hans Beckhoff Registered office: Verl, Germany | Register court: Guetersloh HRA 7075 ___ sqlite-user

[sqlite] can not generate table when using :memory: database via app.config

2016-07-25 Thread Ralf Kralemann
Hi Everyone, I am using the app.config because I have to deal with different databases. I absolutely cannot generate a table in a memory database. If it's a real one it works properly. my app.config: with the Code: DatabaseProviderFactory factory = new DatabaseProviderFac

Re: [sqlite] sqlite3_scrub_backup() not mentioned in 3.14 release log

2016-07-24 Thread Ralf Junker
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

[sqlite] sqlite3_scrub_backup() not mentioned in 3.14 release log

2016-07-24 Thread Ralf Junker
version? * Is it safe to use for production? * It is officially part of SQLite? Ralf ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Conversion failure

2016-06-23 Thread Ralf Junker
nversion. For safety, all changes are by default performed within a transaction. The dialog closes when done and can browse the tables to check the changes. Depending on the outcome, at last manually COMMIT or ROLLBACK. Ralf On 23.06.2016 18:16, Hick Gunter wrote: Your data entry device

[sqlite] Debugging variable left in fts5_index.c?

2016-03-30 Thread Ralf Junker
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

[sqlite] FTS5 returns "corrupt" plus trailing zero

2015-09-21 Thread Ralf Junker
&rc, &s, 7, (const u8*)"corrupt"); so that the number of characters passed matches the length of "corrupt". Ralf

[sqlite] json1.c: isalnum(), isspace(), and isdigit() usage

2015-09-17 Thread Ralf Junker
r ctype functions, or if I just thought it was a > good idea to be careful, once I realized the class of problem. And this check-in therefore misses the point as it does not address this LOCALE problem IMHO: http://www.sqlite.org/src/info/6713e35b8a8c997a Ralf

[sqlite] json1.c: isalnum(), isspace(), and isdigit() usage

2015-08-26 Thread Ralf Junker
/fts3_tokenizer1.c: https://www.sqlite.org/src/artifact/5c98225a53705e5e?ln=54-56 Shouldn't json1.c avoid them for the same reasons? Ralf

[sqlite] queryplanner.html invalid links

2015-08-03 Thread Ralf Junker
o the image does not work because the document does not contain an anchor or ID named "fig2". It looks like the tcl documentation generator does not process the #fig2 argument passed here: https://www.sqlite.org/docsrc/artifact/ce9ee7160e98d868?ln=108 This also applies to the remaining images in the document. Ralf

[sqlite] FTS5 Porter extra arguments not passed through

2015-07-30 Thread Ralf Junker
does not follow the documentation and specifies 0 instead of the argument parameters: http://www.sqlite.org/src/artifact/30f97a8c74683797?ln=540 Ralf

[sqlite] Access Violation in fts5_expr()

2015-07-29 Thread Ralf Junker
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

[sqlite] FTS5 xColumnSize() documentation

2015-07-29 Thread Ralf Junker
://www.sqlite.org/src/artifact/0de7ba81488d2c50?ln=1672-1677 However, not in the documentation: https://www.sqlite.org/src/artifact/81d1a92fc2b4bd47?ln=66-67 Unless this is a hidden feature, could you add it to the docs? Ralf

[sqlite] sqlite3rbu: void function returns value

2015-07-24 Thread Ralf Junker
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

[sqlite] sqlite3rbu.c: ANSI C incomatible variable delcaration

2015-07-24 Thread Ralf Junker
); Ralf

[sqlite] sqlite3rbu.c: Replace sprintf() with sqlite3_mprintf()

2015-07-24 Thread Ralf Junker
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

Re: [sqlite] Using SQLite's VFS in C++

2014-05-15 Thread Ralf
Thanks for this tip, this could possibly work! On 05/14/2014 06:18 AM, J Decker wrote: > the name that gets passed is the one you pass to sqlite_open... so just use > that as an indicator of which object to use and in the open callback, > result with the appropriate object... or don't use the

[sqlite] Using SQLite's VFS in C++

2014-05-13 Thread Ralf
d also offer a nice solution) [1] http://sqlite.org/vfs.html [2] http://sqlite.org/inmemorydb.html Regards and thanks! Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 64 bits Dll

2014-05-09 Thread Ralf Junker
to Delphi 4: http://yunqa.de/delphi/doku.php/products/sqlite3/index Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 64 bits Dll

2014-05-09 Thread Ralf Junker
with many extensions and extras here: http://yunqa.de/delphi/doku.php/products/sqlite3/index Enjoy, Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-15 Thread Ralf
On 15. April 2014 09:46:43 MESZ, Joe Mistachkin wrote: > >Ralf wrote: >> >> I just tried... No change :-( >> > >Have you looked at the contents of the database using the SQLite >command >line tool for Windows? > > https://www.sqlite.org/2014/sql

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-15 Thread Ralf
On 15. April 2014 01:55:40 MESZ, Joe Mistachkin wrote: > >Ralf Jantschek wrote: >> >> The connection as such is ok. Updates are working. It is only the >> executereader that is troubling me >> > >For database files that need a UNC path, four leading backsl

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Ralf Jantschek
4 20:36 > An: 'General Discussion of SQLite Database' > Betreff: Re: [sqlite] Problems with executereader in System.Data.SQLite > > > Ralf Jantschek wrote: > > > >$cn.ConnectionString = "Data Source=\\..." > > > > If you are

Re: [sqlite] Problems with executereader in System.Data.SQLite

2014-04-14 Thread Ralf Jantschek
;<<<< > -Ursprüngliche Nachricht- > Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] Im Auftrag von Joe Mistachkin > Gesendet: Freitag, 11. April 2014 21:02 > An: 'General Discussion of SQLite Database' > Betreff: Re: [

[sqlite] Problems with executereader in System.Data.SQLite

2014-04-11 Thread Ralf Jantschek
urns the FieldCount which is 2 I am accessing SQlite in a powershell script I hope the info provided is sufficient. Any ideas? Thx a lot Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

2014-01-24 Thread Ralf Junker
e the opposite: DISQLite3 outperformed sqlite3.dll whenever I tested. You can test yourself with the example projects located in \DISQLite3_Log_Inserts\ and \DISQLite3_20_Million\ sub-folders of the \Demo\ directory. Ralf ___ sqlite-users mailing

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

2014-01-23 Thread Ralf Junker
erous extensions. * UTF-8 string conversion functions provided. * Many Delphi demo projects. * Exhaustive documentation. Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE_OMIT_FLAG_PRAGMAS issue: sqlite3_busy_timeout() called for all flag pragmas

2013-10-21 Thread Ralf Junker
/249742bd762770e5e6e5b67cfcb2fa9b1049?ln=1960 Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug: analyze.c does not honor SQLITE_64BIT_STATS

2013-10-10 Thread Ralf Junker
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 "trun

Re: [sqlite] Bug: analyze.c does not honor SQLITE_64BIT_STATS

2013-10-09 Thread Ralf Junker
This is more portable: #ifdef SQLITE_64BIT_STATS sqlite3_snprintf(24, zRet, "%lld", p->nRow); #else sqlite3_snprintf(24, zRet, "%d", p->nRow); #endif Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug: analyze.c does not honor SQLITE_64BIT_STATS

2013-10-09 Thread Ralf Junker
snprintf(24, zRet, "%d", p->nRow); #endif Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Hints for the query planner

2013-09-11 Thread Ralf Junker
as a non native English speaker. Both, however, express an action rather than a quality which is more telling to me than "unlikely" or the other adjectives suggested so far. Maybe the function name could be prefixed by "qp_" (for query planner) or

Re: [sqlite] Hints for the query planner

2013-09-11 Thread Ralf Junker
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

Re: [sqlite] Database locking without locking database file

2013-08-14 Thread Ralf Ramsauer
On 14.08.2013 18:36, Stephan Beal wrote: > On Wed, Aug 14, 2013 at 3:06 PM, Ralf Ramsauer < > ralf+sql...@ramses-pyramidenbau.de> wrote: > >> Why is it proposed not to use NFS? Why is it so risky? I can hardly >> believe that NFS locking is that broken... >> > F

Re: [sqlite] Database locking without locking database file

2013-08-14 Thread Ralf Ramsauer
) One further question: Why is it proposed not to use NFS? Why is it so risky? I can hardly believe that NFS locking is that broken... Neither cifs. [1] : http://www.sqlite.org/vfs.html Thanks in advance -- Ralf Ramsauer PGP: 0x8F10049B ___ sqlite-

[sqlite] Database locking without locking database file

2013-08-14 Thread Ralf Ramsauer
wtocorrupt.html Chapter 2.1 [4] : http://www.sqlite.org/faq.html#q5 Regards, - -- Ralf Ramsauer PGP: 0x8F10049B -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.20 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBAgAGBQJSClJeAAoJEPovtFKPEASbWbMQAJPhmoCxo

Re: [sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Ralf Junker
SQL function extensions: ieee754, nextchar. * Extensive documentation and lots of demo projects. Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] A few questions about SQLite Encryption Extension

2013-07-19 Thread Ralf Junker
. http://www.yunqa.de/delphi/doku.php/products/sqlite3/index Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Ralf Junker
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. >

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Ralf Junker
where SQLiteSpy does no behave exactly as SQLite. If you believe otherwise, please provide working example SQL for testing. Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Security concern with new fts3tokenize virtual table

2013-05-07 Thread Ralf Junker
er besides calling fts3_tokenizer()? Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] amatch extension

2013-05-02 Thread Ralf Junker
from Fossil trunk. Is there something I am missing? Ralf DROP TABLE IF EXISTS f; DROP TABLE IF EXISTS c; DROP TABLE IF EXISTS v; CREATE TABLE v (w TEXT, l INTEGER); CREATE INDEX v_index ON v(w); INSERT INTO v VALUES ('abc', 0); INSERT INTO v VALUES ('bcd

Re: [sqlite] Version 3.7.17 Preview

2013-05-02 Thread Ralf Junker
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 > pr

[sqlite] pager.c does not compile with SQLITE_OMIT_WAL

2013-04-25 Thread Ralf Junker
src/artifact/6c3a8a5d665498b0344395a2c9f82d5abc4cc771?ln=2876 http://www.sqlite.org/src/artifact/6c3a8a5d665498b0344395a2c9f82d5abc4cc771?ln=5243 http://www.sqlite.org/src/artifact/6c3a8a5d665498b0344395a2c9f82d5abc4cc771?ln=5333 Ralf ___ sqlite-users mailing l

[sqlite] Link pragma.html#pragma_user_version invalid

2012-12-10 Thread Ralf Junker
s documentation draft. Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] AsyncIO fails with current 3.7.15 trunk

2012-12-07 Thread Ralf Junker
_run(); This change eliminates the warnings: void sqlite3async_shutdown(void); void sqlite3async_run(void); Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] AsyncIO fails with current 3.7.15 trunk

2012-12-06 Thread Ralf Junker
AsyncIO is no longer actively maintained, can anyone reproduce my findings? I am running on Windows and have limited testing capabilities like no Valgrind, etc. Ralf [1] http://www.sqlite.org/src/info/3d548db7eb [2] http://www.mail-archive.com/sqlite-users@sqlite.org/msg74170.html

Re: [sqlite] Async IO in SQLite 3.7.15

2012-12-04 Thread Ralf Junker
They should continue to work, as far as we are aware. Nothing in the core > has changed to break them. Thanks! Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Async IO in SQLite 3.7.15

2012-12-04 Thread Ralf Junker
Or has something in the SQLite core changed so that you'd expect Async IO failures in 3.7.15, or later versions? Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Async IO in SQLite 3.7.15

2012-12-04 Thread Ralf Junker
with SQLite 3.7.15? Is it just deprecated for new development? Or has something else changed that I should take care of? Ralf On 03.12.2012 21:25, Richard Hipp wrote: > We want 3.7.15 to be a good release, so please do have a look at the > amalgamation snapshot described in the previous

Re: [sqlite] How to restore from backup or alter db in multi-user envionment?

2012-12-02 Thread Ralf Junker
, just conveniently made available for the Delphi programming language. What works in SQLite3 also works in DISQLite3. Some extras are added, but nothing left out or modified. Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to know what terms were created using FTS

2012-08-17 Thread Ralf Junker
through the fts_aux table and the segments and content > tables, but nothing struck me directly as usable. Any suggestions? http://www.sqlite.org/fts3.html#fts4aux Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] Detecting when a table is created

2012-06-26 Thread Ralf Junker
d of builtin feature I could use first. Two options, both not intended for it, but could work well: - http://sqlite.org/c3ref/set_authorizer.html - http://sqlite.org/c3ref/c_config_getmalloc.html#sqliteconfiglog Ralf ___ sqlite-users mailing list

[sqlite] SQLITE_OPEN_CREATE required by named memory database?

2012-05-30 Thread Ralf Junker
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

[sqlite] Documentation glitch: Repeated "or" ...

2012-05-29 Thread Ralf Junker
... 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

Re: [sqlite] Details on New Features

2012-05-04 Thread Ralf Junker
fied the one min() or max() aggregate function. Given that more than one row satisfies the one min() or max() aggregate function (think of multiple, identical smallest or largest values). Which row will SQLite pick? Ralf ___ sqlite-users mailing list

Re: [sqlite] SQLITE3 64-bit version

2012-04-27 Thread Ralf Junker
calling conventions and Delphi's internal memory manager. This makes it faster then sqlite3.dll. - DISQLite3 is regularly updated. This saves you from maintaining your own, local API translations so you can focus on your application. Ralf ___ sqlite-us

Re: [sqlite] SQLITE3 64-bit version

2012-04-27 Thread Ralf Junker
pported: http://www.yunqa.de/delphi/doku.php/products/sqlite3/index Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

2012-03-05 Thread Ralf Junker
se-Utils/SQLiteSpy.shtml Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

2012-03-05 Thread Ralf Junker
for me. Do you know any site other than > yunqa.de where the latest SQLite can be downloaded? SQLiteSpy downloads might be available from various portals. But usually http://www.yunqa.de works just fine. Just try again later. Ralf ___ sqlite-users ma

Re: [sqlite] What do people think of SQLite Root?

2012-03-05 Thread Ralf Junker
ay the table. When you then select a table cell in the grid and press F2, the edit window will pop up. See feature item 2 and the screenshot at http://yunqa.de/delphi/doku.php/products/sqlitespy/index Ralf ___ sqlite-users mailing list sqlite-users@sqlite.or

[sqlite] SQLite with Powershell

2012-02-14 Thread Ralf Jantschek
t; I'm stuck In case this isn't the correct forum can somebody point me to a correct one. Thanks a lot Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] multiple rows of VALUES in an INSERT incompatible with SQLITE_OMIT_COMPOUND_SELECT

2012-02-13 Thread Ralf Junker
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 >>> >&

Re: [sqlite] multiple rows of VALUES in an INSERT incompatible with SQLITE_OMIT_COMPOUND_SELECT

2012-02-10 Thread Ralf Junker
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

[sqlite] multiple rows of VALUES in an INSERT incompatible with SQLITE_OMIT_COMPOUND_SELECT

2012-02-07 Thread Ralf Junker
: all VALUES must have the same number of terms Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_db_release_memory(): Return value undocumented.

2012-01-16 Thread Ralf Junker
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

[sqlite] sqlite3_uri_int64() doc error

2012-01-16 Thread Ralf Junker
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] Multiplex VACUUM fails to delete chunks on Windows

2011-07-23 Thread Ralf Junker
up->aReal[iChunk].z); memset(&pGroup->aReal[iChunk], 0, sizeof(pGroup->aReal[iChunk])); } By the way: No error is returned if multiplex VACUUM fails to delete a chunk. Maybe it should, to warn curious end users who like to investigate files with uncommon names? Ralf _

[sqlite] test/exists.test 2.$tn.1 fails if both DBs are in WAL mode

2011-04-10 Thread Ralf Junker
tter to let you know in case you want to check this last-minute change before you release 3.7.6. Ralf ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   3   4   >