Re: [sqlite] Regarding the whole C89/C90 language compliance debacle ...

quot; or "long long" dependant on Tcl version or platform. So, the warning is harmless, understandable, and easy to fix. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

Op do 10 okt. 2019 om 15:15 schreef Jan Nijtmans: > > Op do 10 okt. 2019 om 15:06 schreef Jose Isaias Cabrera: > > > Simon Charette, on Tuesday, October 8, 2019 08:00 PM, wrote... > > > > > > > > While trying to enable support for FILTER (WHERE) on SQ

Re: [sqlite] Segfault when using FILTER (WHERE) referencing aliases from a subquery

to reopen on a persistent database. sqlite> CREATE TABLE item (id int, price int); sqlite> INSERT INTO item (id, price) VALUES (1, 1); sqlite> SELECT COUNT(id) FILTER (WHERE double_price > 42) FROM (SELECT id, (price * 2) as double_price FROM item); Segmentation fault (c

Re: [sqlite] Prebuilt Windows x86 binary missing symbols per sqlite3.def

h-for-Windows-x86-and-x64-dll-td93694.html> Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Win 10 Anniv. Ed. lifts the MAX_PATH 260 limitation

rested, just let me know, I'm happy to provide this patch to the SQLite developers, or anyone else interested. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mail

Re: [sqlite] SQLITE_ENABLE_UPDATE_DELETE_LIMIT (Was: Patch Etiquette)

. Thank you for your idea! Regards, Jan nijtmans Index: src/parse.y == --- src/parse.y +++ src/parse.y @@ -748,10 +748,11 @@ %ifndef SQLITE_ENABLE_UPDATE_DELETE_LIMIT cmd ::= with(C) DELETE FROM fullname(X) indexed_opt(I) where_opt(W

Re: [sqlite] Patch Etiquette

ll thread here: <http://sqlite.1065341.n5.nabble.com/ENABLE-UPDATE-DELETE-LIMIT-td90381.html> Feel free to try this patch (see my message Jul 12, 2016; 11:14am in this thread) Regards, Jan Nijtmans ___ sqlite-users mailing li

Re: [sqlite] sqlite3.def mismatch for Windows x86 and x64 dll

ected to be used from applications, so whether those are exported or not doesn't really matter. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] can't open db when path length extends 512 characters (on linux)

6. So I don't think the risk is really big. Upgrading to 1024 (or even 4096) should be no problem. See also: <https://www.sqlite.org/pragma.html#pragma_page_size> Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@mailinglists.s

[sqlite] tclsqlite 64-bit bug [Was: extension to run bash]

4-bit. Any chance for this to be in the next SQLite release? Thanks! Jan Nijtmans === $ fossil diff Index: src/tclsqlite.c == --- src/tclsqlite.c +++ src/tclsqlite.c @@ -2534,11 +2534,11 @@ for(

Re: [sqlite] ENABLE_UPDATE_DELETE_LIMIT

unk. Regards, Jan Nijtmans Index: src/parse.y == --- src/parse.y +++ src/parse.y @@ -735,54 +735,56 @@ limit_opt(A) ::= LIMIT expr(X) COMMA expr(Y). {A.pOffset = X.pExpr; A.pLimit = Y.pE

Re: [sqlite] ENABLE_UPDATE_DELETE_LIMIT

this, I'm happy to provide that. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Problem loading sqlite3.dll on Windows XP

shows no problem with > sqlite3.dll. > > Do you know if there are any issues regarding Windows XP? You could try this build, done with mingw-w64 (32-bit): https://sourceforge.net/projects/cyqlite/files/3.13/sqlite-dll-win32-x86-313.zip Microsoft's latest compilers have known issu

[sqlite] Use of DELETE LIMIT OFFSET with ENABLE_UPDATE_DELETE_LIMIT

rces) run fine when this patch is applied. Could I add this to the 2016 wish-list?;-) Regards, Jan Nijtmans === --- src/parse.y +++ src/parse.y @@ -740,54 +740,56 @@ limit_opt(A) ::= LIMIT expr(X) COM

[sqlite] shell tool is no longer dynamically linked

igurable, that indeed would be best. Then it even doesn't matter to me what the default is. My guess is the more distributions (e.g. Fedora, Ubuntu ) will make (or have already made) the same modification, since it's much easier to apply a patch than change a distribution policy ;-) R

[sqlite] Version 3.9.0 source_id mismatch

likely, the dll was compiled by cherry-picking [01d3ee7bbe4feeb8] (containing a dll symbol fix) to the 3.9.0 version. Most likely, this merge was committed to a local fossil repository (which created the alternative source_id), but never pushed back to the official repository. That's the best answer I can give. Regards, Jan Nijtmans

[sqlite] Form-Feed (0x0C) is not a space character in JSON

feed or New line %x0D; Carriage return ) Suggested patch below. Regards, Jan Nijtmans $ fossil diff Index: ext/misc/json1.c == --- ext/misc/json1.c +++ ext/misc/json1.c @@ -50,11

[sqlite] [sqlite-announce] SQLite version 3.9.0

h it doesn't actually create a problem, as far as I can tell. Sorry for not noticing this before. Regards, Jan Nijtmans

[sqlite] Proposed new version numbering scheme for SQLite - Feedback requested

managers being less stable than 3.x,y releases. We know that's not necessarily true, but that's the price for advantage 1) Just my 2c. Regards, Jan Nijtmans

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

.sqlite.org/src/artifact/541004e47235cefc?ln=829 > Shouldn't json1.c avoid them for the same reasons? Simpler is: cast the argument to (unsigned char), that has the same effect (but is more efficient). Proposed patch below. Thanks! Regards,

[sqlite] Function lower on index expressions not allowed ?

te.org/c3ref/c_deterministic.html) Just wondering, why doesn't ICU mark "upper" and "lower" as SQLITE_DETERMINISTIC ? <http://www.sqlite.org/src/artifact/b2732aef0b076e42?ln=461-469+482-483> Regards, Jan Nijtmans

[sqlite] SQLite3 to 64-bit DLL

: Suitable for any gcc version (mingw/mingw-64/msys/msys-2) The dll is suitable for any 64-bit windows environment. Regards, Jan Nijtmans

[sqlite] SQLite crash

sqlite starts win32 threads, which don't work well in a cygwin environment. On cygwin you should configure posix threads. I have a fix for that, it's included in the cygwin SQLite package. With that you can use multiple threads as you wish. Regards, Jan Nijtmans

[sqlite] SQLite crash

ackage? In other words, is this a regression or a longstanding problem? Regards, Jan Nijtmans

[sqlite] Numerics bigger than 32-bit and sqlite as 64-bit TCL extension

SELECT * FROM test; } 2147483647 2147483649 2147483649 % @Andreas: could this be a compiler issue? Regards, Jan Nijtmans

[sqlite] SEGV in dbPrepareAndBind() in tclsqlite.c

the outcome, feel free to report this to the Itcl folks (which is not me ) Regards, Jan Nijtmans

[sqlite] Issue: Inconsistency of sqlite3_dbstat_register declaration

2015-05-11 16:33 GMT+02:00 Roger Binns : > On 05/11/2015 01:34 AM, Jan Nijtmans wrote: >> 2) If sqlite is not compiled with -DSQLITE_ENABLE_DBSTAT_VTAB=1, >> or the function is renamed (as it should) it wouldn't even work. > > That was my scenario. I just -DSQLITE_ENABLE_DBS

[sqlite] Bug: Cannot compile the new sqlite-src-3081001: preprocessor and testuite errors

en when running Tcl compiled from trunk? There was a regression introduced in recent Tcl 8.6.x versions, which will be fixed in (upcoming) version 8.6.5. So - in short - I suspect that this assertion is not SQLite's fault but Tcl's ;-). Regards, Jan Nijtmans

[sqlite] Issue: Inconsistency of sqlite3_dbstat_register declaration

n't even work. The latter part is already fixed in the TEA version of SQLite. Suggested patch: <http://cyqlite.sourceforge.net/cgi-bin/sqlite/fdiff?v1=f2e740c1cc90060f=39dc9592b8f99cf9=1> Regards, Jan Nijtmans

[sqlite] Version 3.8.9 is in testing

lease log: <http://www.sqlite.org/src/info/6fc4e79a2350295a> Regards, Jan Nijtmans

Re: [sqlite] sqlite3 fails due to too long path (MAX_PATHNAME)

.net/cgi-bin/sqlite/tarball/cyqlite.tar.gz?uuid=trunk Hopefully, one day you will find this change (or something equivalent) in the official SQLite. Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mail

Re: [sqlite] Compiling error on Cygwin on Windows 8.1: 3.8.7.4 and 3.8.8

that's indeed another possible 'solution' ;-) Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compiling error on Cygwin on Windows 8.1: 3.8.7.4 and 3.8.8

here: <http://cyqlite.sourceforge.net/cgi-bin/sqlite/raw/generic/sqlite3.c?name=83a26f4777390dbcfcc58ba146354002ca2de0c8> An official cygwin build of SQLite 3.8.8 will be available soon. Regards, Jan Nijtmans ___ sqlite-users mailing lis

Re: [sqlite] default ignore-glob for sqlite

nt is MinGW(-w64), therefore I generally don't need those ;-) Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] default ignore-glob for sqlite

2014-11-06 1:14 GMT+01:00 E. Timothy Uy <t...@loqu8.com>: > Hi, I noticed that the ignore-glob for sqlite is empty. Is it just because > fossil does not transfer this information? What should I be using? I'm using the "ignore-glob" versioned setting below. Regards,

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

IR 2949130 0x2d000a S_nfsDrv_NO_SUCH_FILE_OR_DIR 7602186 0x74000a S_cdromFsLib_NO_SUCH_FILE_OR_DIRECTORY The list is not so long, if it helps then it is doable to just add them all. But feedback on behavior on different file systems is crucial, I wouldn't just add all of them blindl

Re: [sqlite] Win32 .def exports != documented APIs ?

2014-08-29 16:22 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>: > I doubt the usefulness > of sqlite3_win32_is_nt(), because on current supported > systems this function should return 1 anyway. On > Windows RT it returns - surprisingly - 0 (which is > already fixed on tru

Re: [sqlite] Win32 .def exports != documented APIs ?

tion that might be interesting on some embedded environments (read: Windows CE) is sqlite3_win32_set_directory(). The other four are not portable anyway, I don't see any practical use for them. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

2014-08-22 9:14 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>: > It looks like this is on its way to being corrected: > > > However, I don't think this will work on Win95/98/NT Fixed here: <http://www.sqlite.org/src/info/9fe0f0754c> Thanks! No more remar

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

2014-08-15 12:50 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>: > Looking at the function sqlite3_win32_is_nt() > It should simply return 1 on any > currently supported platform. Looking closely, > it returns 0 on Windows RT, but who cares > (leaving the "why&q

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

2014-08-12 10:35 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>: > > $ i686-w64-mingw32-gcc -c -DSQLITE_WIN32_NO_ANSI sqlite3.c > sqlite3.c: In function ‘sqlite3_win32_is_nt’: > sqlite3.c:33312:10: error: ‘sInfo’ undeclared (first use in this function) > >

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

TYLE=1 needed for? (User "chw", whoever that is, should be able to answer that question, since he/she committed this Makefile.vxworks) <http://www.sqlite.org/src/artifact/034289efa9?ln=68> Regards, Jan Nijtmans ___ sqlite-users mail

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

as a guideline for > implementing our own changes. > At least that's what the famous Lawyer Lawrence Rosen believes. For another opinion, see: <http://cr.yp.to/publicdomain.html> Unfortunately, I'm not a lawyer :-( Regards, Jan Nijtmans __

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

s > here, where we can ask questions. No more VxWorks changes without direct > communication with actual VxWorks developers. > Original discussion can be found here: <http://www.mail-archive.com/sqlite-users@sqlite.org/msg84480.html>

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

2014-08-03 9:56 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>: > 2014-08-02 16:00 GMT+02:00 王庆刚 <2004wqg2...@163.com>: > > hi ， Can Sqlite3.c and sqlite.h be compiled in Workbench3.2 for > Vxworks6.8 ? > > When I compile them , there have so ma

Re: [sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

2014-08-11 13:12 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>: > And below is a minimal patch which fixes this problem. > Unfortunately, latest SQLite trunk, which fixes the SQLITE_WIN32_GETVERSIONEX problem brought back the SQLITE_WIN32_NO_ANSI problem I reported earlier -(

[sqlite] Crash in sqlite3_mutex_try [Was: SQLite 3.8.6 beta]

in the function sqlite3_win32_is_nt(), because osGetVersionExW is a NULL pointer. Regards, Jan Nijtmans -- Forwarded message ------ From: Jan Nijtmans <jan.nijtm...@gmail.com> Date: 2014-08-05 13:24 GMT+02:00 Subject: Re: SQLite trunk on win32 broken with -DSQLITE_WIN32_NO_ANSI

Re: [sqlite] HELP sqlite3 used in vxworks has someproblem？

developers for inclusion in 3.8.6 (not tested yet on other platforms than vxworks, win32/64 and Linux, there it works fine) Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ISO time leap second.

e the POSIX strftime() function is already adapted to handle this 'problem' exactly the same way. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ISO time leap second.

implements (although it is very close) Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] ISO time leap second.

2014-07-28 16:53 GMT+02:00 Richard Hipp <d...@sqlite.org>: > Better to keep the code simpler and just say that SQLite (and hence Fossil) > does not know about leap seconds. If you can do that in two bytes ;-) Regards,

[sqlite] ISO time leap second.

nk, with adapted test-case): Regards, Jan Nijtmans Index: src/sqlite3.c == --- src/sqlite3.c +++ src/sqlite3.c @@ -14769,11 +14769,11 @@ return 1; } zDate += 5; if( *zDate==':' ){ zDate++; -if( getDigits(zD

Re: [sqlite] Entry Points missing from sqlite3ext.h

gt; sqlite3_cancel_auto_extension() to cancel my extension before calling the > other library's open function (which might open SQLite), and afterwards I set > it again using sqlite3_auto_extension(). Sounds reasonable to me. Suggested patch below. Regards,

Re: [sqlite] trying to get things to work from the command line on windows 7 x64

dll (and runs outside of Cygwin as well). > OR.... > > can I use the 32-bit sqlite? That's another possibility. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] trying to get things to work from the command line on windows 7 x64

2014-07-10 22:17 GMT+02:00 Jonathan Leslie <jlesli...@yahoo.com>: > question 1) what am I doing wrong? Your compiler is 32-bit MinGW, but you unpacked the 64-bit dll in your current directory. Regards, Jan Nijtmans ___ sqlite-users mai

Re: [sqlite] affinity critical problem with 3.8.5 - IN single value optimisation

2014-07-08 16:35 GMT+02:00 Hinrichsen, John <jhinrich...@c10p.com>: > This is a nasty bug; I do not see any follow-up regarding a fix. <http://www.sqlite.org/src/info/92f7ad43db> <http://www.sqlite.org/src/info/9a8b09f8e6> Regar

Re: [sqlite] Building for vxWorks

hat 'struct unixFileId' has different fields on VxWorks compared to other UNIX platforms. I hope this brings it a little bit closer to fully working on VxWorks. Regards, Jan Nijtmans Index: src/os_unix.c == --- src/os_unix.c +++ src/os_

Re: [sqlite] Building for vxWorks

ing other refinements. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 64-bit precompiled command-line shell binary

n't work then there is some incompatibility (no guarantees, but it works with the 64-bit sqlite3.dll download provided by <http://wwwsqlite.org/download.html> as well). Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [ANNOUNCEMENT] Updated: fossil 20140612172556-1 -- DVCS with built-in wiki, http server and issue tracker

age that whenever a new bug in SQLite is found (or SQLite 3.8.6 is released) fossil can take advantage of it without being rebuilt. While on it, the "--json" configuration option would be a good idea too. Many thanks, Jari, for your support! Regards, Jan Nijtmans _

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

now, <http://www.sqlite.org/src/tktview?name=f711d5a937> Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite version 3.8.5 beta

==’ token if( MASKBIT(i) & p->btreeMask)==0 ) continue; ^ sqlite3.c:73742:41: error: expected statement before ‘)’ token if( MASKBIT(i) & p->btreeMask)==0 ) continue; Bisecting points to this commit: <http://www.sqlite.org/src/info/87bf606

Re: [sqlite] SQLite version 3.8.5 beta

e.net/projects/cyqlite/files/> This project is still in the startup phase, but I'm trying to fill the gap Microsoft is leaving behind.. Thanks! Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Code Error -- Cannot compile Amalgamation with SQLITE_THREADSAFE=0 on WIndows

2014-05-11 12:02 GMT+02:00 Jan Nijtmans <jan.nijtm...@gmail.com>: > 2014-05-11 1:15 GMT+02:00 Keith Medcalf <kmedc...@dessus.com>: >> Somewhere you have removed the Windows.h header from being included where it >> is needed when SQLITE_THREADSAFE is set

Re: [sqlite] Code Error -- Cannot compile Amalgamation with SQLITE_THREADSAFE=0 on WIndows

s not included early enough and compilation of the vfs > fails. Confirmed! My suggestion (FWIW) would be to remove the os_win.h file altogether and put it's content in os_config.h. (except the #ifdef __CYGWIN__ part, which doesn't belong here) It's all about configuration i

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.4.3-1 for Cygwin/Cygwin64

; * Wrong filename handling in sqlite3_load_extension() for Cygwin <http://osdir.com/ml/sqlite-users/2014-02/msg00431.html> * pragma database_list returns win32 paths on Cygwin <http://osdir.com/ml/sqlite-users/2014-02/msg00515.html> -- Jan Nijtmans _

[sqlite] SQLite ticket [f711d5a937] not fixed.

reason for the -static-libgcc option is explained here: <http://sqlite.1065341.n5.nabble.com/Compiling-SQLite-with-latest-MinGW-undesired-link-to-MinGW-specific-dll-td73985.html> Regards, Jan Nijtmans = --- Makefile.in +++ Makefile.i

[sqlite] WARNING: 'Makefile.in' seems to ignore the --datarootdir setting

here: <http://www.gnu.org/software/autoconf/manual/autoconf-2.69/html_node/Changed-Directory-Variables.html> Suggested (trivial) patch below. Regards, Jan Nijtmans Index: autoconf/tea/Makefile.in == --- autoco

Re: [sqlite] Problem compiling SQLite 3.8.4.1 with SQLITE_MAX_MMAP_SIZE=0

That's progress! Give that the Cygwin VFS is built on top of the win32 API, and that I have McAfee running (which tries to interfere too!) that's not bad at all! Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.or

Re: [sqlite] Problem compiling SQLite 3.8.4.1 with SQLITE_MAX_MMAP_SIZE=0

hat upstream, the fix could have been in SQLite 3.8.4.1 already. Thanks! Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Problem compiling SQLite 3.8.4.1 with SQLITE_MAX_MMAP_SIZE=0

dff0493d2> Regards, Jan Nijtmans Index: src/btree.c == --- src/btree.c +++ src/btree.c @@ -2163,18 +2163,20 @@ /* ** Change the limit on the amount of the database file that may be ** memory mapped. */ +#if SQLITE_MAX

Re: [sqlite] failure to build static library with -DSQLITE_ENABLE_ICU

f them have the problem you describe. Sorry. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.4.1-1 for Cygwin/Cygwin64

ite3_load_extension() for Cygwin <http://osdir.com/ml/sqlite-users/2014-02/msg00431.html> * pragma database_list returns win32 paths on Cygwin <http://osdir.com/ml/sqlite-users/2014-02/msg00515.html> -- Jan Nijtmans ___ sqlite-users

Re: [sqlite] sqlite3.exe file not produced by sqlite-autoconf-3080400.tar.gz on Cygwin

a7a4bc> those are used to build the sqlite3 Tcl extension, apparently not what you are after. It works fine for me. Anyway, I just uploaded the SQLite 3.8.4.1 build for Cygwin, it just depends on the mirrors how fast they pick it up. Regards, Jan Nijtmans __

Re: [sqlite] SQLite version 3.8.4 release schedule

uoting: If filename contains a slash ("/"), then it is interpreted as a (relative or absolute) pathname. Otherwise, the dynamic linker searches for the library as follows (see ld.so(8) for further details): I want the dlopen() in the Cygwin VFS to behave the same

Re: [sqlite] SQLite version 3.8.4 release schedule

upstream. The MinGW 4.x enhancements works great! Thanks! Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] pragma database_list returns win32 paths on Cygwin

other places, but that's for another day. Regards, Jan Nijtmans Index: src/os_win.c == --- src/os_win.c +++ src/os_win.c @@ -4127,14 +4127,51 @@ /* ** Convert a UTF-8 filename into whatever form the underlying ** operating system w

Re: [sqlite] Wrong filename handling in sqlite3_load_extension() for Cygwin

2014-02-20 14:39 GMT+01:00 Jan Nijtmans <jan.nijtm...@gmail.com>: > The function sqlite3_load_extension() on Cygwin expects a > win32 path, even though it is compiled for Cygwin. Here is a new version of my patch which fixes this bug, which handles better the case that the path does

[sqlite] Wrong filename handling in sqlite3_load_extension() for Cygwin

till in time for SQLite 3.8.4, and given some time for proper evaluation. Regards, Jan Nijtmans == Index: src/os_win.c == --- src/os_win.c +++ src/os_win.c @@ -4131,10 +4131,27 @@ ** func

[sqlite] Compiling SQLite with latest MinGW: undesired link to MinGW-specific dll.

anyway. Most recent MinGW-w64 versions have exactly the same problem, only the required dll name is different (libgcc_s_sjlj-1.dll). This solution works for MinGW-w64 as well. This bug is already reported to MinGW, for details: <https://sourceforge.net/p/mingw/bugs/2065

Re: [sqlite] HTML Tokenizer

.org/check?uri=http%3A%2F%2Fwww.sqlite.org%2F=%28detect+automatically%29=HTML5=0=W3C_Validator%2F1.3+http%3A%2F%2Fvalidator.w3.org%2Fservices> Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.3.1-1 for Cygwin/Cygwin64

using McAfee) that well. Therefore I am working on adaptations improving this situation, I hope this to be ready when SQLite 3.8.4 is released. -- Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Redundant #define's in os_unix.c

this. And, when comments change, they don't need to be updated in two places any more. Regards, Jan Nijtmans == --- src/sqliteInt.h +++ src/sqliteInt.h @@ -32,10 +32,15 @@ ** without this option, LFS is enable. But LFS does not exist in the kernel

[sqlite] Unit-test failure in SQLite (64-bit)

the same mistake, but in many other places it is done correctly. The change from Tcl_GetStringFromObj() to Tcl_GetString() is just meant to shorten the line length: since the second argument is 0, those are equivalent. Regards, Jan Nijtmans --- src/tclsqlite.c +++ src/tclsqlite.c @@ -1835,11

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.3-2 for Cygwin/Cygwin64

Queries. For a complete list, see: <http://www.sqlite.org/releaselog/current.html> * Is compiled with SQLITE_ENABLE_SQLLOG enabled. See: <http://www.sqlite.org/compile.html#enable_sqllog> * New sub-package "sqlite3-tcl", containing the language bindings for Tcl 8.

[sqlite] "PRAGMA data_store_directory" inconsistancies

gma: Since Cygwin is supposed to behave like UNIX, even though it uses the "win32" VFS, there is no reason at all to support this pragma on Cygwin. Cygwin's current SQLite 3.8.3-1 (beta) package already contains those suggested modifications. Suggested patch follows. Regards,

Re: [sqlite] Clang 3.3 and Scan-Build results

s to const's, as tclsqlite.c already uses "const" in may places, and Tcl doesn't support C-compilers without the "const" keyword anyway. Regards, Jan Nijtmans Index: src/tclsqlite.c == --- src/tclsql

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.3-1 (beta, as test package) for Cygwin/Cygwin64

for Tcl 8.5/8.6 (works fine with SQLite 3.8.2 as well) Since this is a test package, this beta release is not installed automatically when running setup.exe. You must explicitly specify version 3.8.3-1! -- Jan Nijtmans ___ sqlite-users mailing list sqlite

Re: [sqlite] SQLITE 3.8.3 beta: SQLITE_OMIT_CTE build doesn't work

nce CTE doesn't make much difference in library size (only 5Kb on x86_64), I don't know if anyone would actually want CTE to be removed. I just tried it out of curiosity. Thanks! Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org ht

Re: [sqlite] SQLITE 3.8.3 beta: SQLITE_OMIT_CTE build doesn't work

etc. Sure, but since addition of a single macro fixes this, I would say: why not fixing it? But - of course- that's up to you. Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLITE 3.8.3 beta: SQLITE_OMIT_CTE build doesn't work

$ gcc -c -Wall -o sqlite3.o -DSQLITE_OMIT_CTE sqlite3.c sqlite3.c: In function ‘yy_reduce’: sqlite3.c:117782:3: warning: implicit declaration of function ‘sqlite3WithAdd’ [-Wimplicit-function-declaration] yygotominor.yy59 = sqlite3WithAdd(pParse, 0, [-5].minor.yy0, yymsp[-4].minor.yy14,

Re: [sqlite] "Common Table Expression"

will be part of SQLite 2.8.3. I'm not familiar with CTE, I didn't try it yet, just had a quick glance at the code. I'm wondering if there isn't a #define missing here (see patch below): Regards, Jan Nijtmans Index: src/sqliteInt.h ==

[sqlite] [ANNOUNCE] Updated: sqlite3-3.8.2-3 for Cygwin/Cygwin64

ot;SQLite3 temporary filename collision in worker processes": See: <https://www.mail-archive.com/sqlite-users@sqlite.org/msg81284.html> Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite 2013 retrospective

to all. Seconded: Happy New Year to all. Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

SQLite bug is already fixed here: <http://www.sqlite.org/src/info/830629d31d> so next fossil version should be OK. Thanks! Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

ems. For most situation, indeed this .exe should work fine. Still I'm sure that Jari Aalto (Cygwin's fossil maintainer) will be interested to know what's the problem. I regularly compile Fossil on Cygwin, and I don't see the problems you mention. Anyway, Thanks for your report!

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

;sqlite3 -vfs win32-longpath" which uses the win32 API in stead of the cygwin API to open the file. Does this make a difference? Regards, Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.2-2 for Cygwin/Cygwin64

length from 512 to 4096 for all VFS's except "win32". * New VFS "unix-namedsem". * Since the dll is compiled with -DSQLITE_ENABLE_EXPLAIN_COMMENTS, the .expain command now gives more useful output than in earlier releas

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.2-1 (beta, as test package) for Cygwin/Cygwin64

sion 3.8.2-1! -- Jan Nijtmans ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Visual Studio 2013 Issue - GetVersionEx deprecated

2013/11/4 Jan Nijtmans: > 2013/11/4 Simon Slavin: >> On 4 Nov 2013, at 6:32am, David de Regt <dav...@mylollc.com> wrote: >>> In Visual Studio 2013, which uses the Windows 8.1 Platform SDK, they've >>> marked GetVersionEx as deprecated, trying to supercede it

  1   2   >