Greetings.

Today I went to build a new version of sqlite3.exe for Windows (using cygwin, which is my normal method), and it builds, but when I run the fresh built sqlite3.exe, it aborts promptly.

14:09:00.91>sqlite3
SQLite version 3.47.0 2024-10-08 17:27:00
Enter ".help" for usage hints.

14:12:16.78>

Since I had not built it in a while, I found out that the last check-in that I am able to build is f0c5a86f. The next version (0b83e8f1), although it completes ok, the executable aborts without error. I don't know what happened, so any help would be greatly appreciated. I build the sqlite3.exe for Windows using cygwin, and this command:

./configure --enable-all --prefix=/usr && make install && i686-w64-mingw32-gcc -shared -DFOR_WIN10 -DSQLITE_ENABLE_FTS5 -static-libgcc sqlite3.c -o sqlite3.dll && x86_64-w64-mingw32-gcc -DSQLITE_ENABLE_FTS5 -DFOR_WIN10 shell.c -o sqlite3.exe sqlite3.c

Let me know if you need anything to get this fixed. By the way, the latest trunk check-in (6364a2f0) also has the problem.

It does build the cygwin sqlite3 tool correctly:

$ sqlite3
-- Loading resources from /home/E608313/.sqliterc
SQLite version 3.47.0 2024-10-08 17:27:00
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

Thanks for the support.

I found out that the last check-in that I am able to build is f0c5a86f. The next version (0b83e8f1), although it completes ok, the executable aborts without error.

0b83e8f1 doesn't make any sense as the breaking point because it modified only one of the Emscripten-specific files by adding an #if 0 block, so there's literally zero code difference for your case between those versions. My suspicion is that if you do a "make clean" between each of your builds to ensure that you haven't gotten any mis-built files, a different culprit will appear.

It does build the cygwin sqlite3 tool correctly:

Are you saying that cross-compilation from cygwin to Windows is what's failing but cygwin-for-cygwin is working?

Hi Stephan.

Are you saying that cross-compilation from cygwin to Windows is what's failing but cygwin-for-cygwin is working?

Correct. The cygwin build works great. The cross-compilation from cygwin to Windows fails. I even tried the command by-itself:

 x86_64-w64-mingw32-gcc -DSQLITE_ENABLE_FTS5 -DFOR_WIN10 shell.c -o sqlite3.exe sqlite3.c

I wish there was an error or something.

The cygwin build works great. The cross-compilation from cygwin to Windows fails.

There's no way for me to reproduce this (for lack of the OS) but i can say, with 100% confidence, that the culprit checkin you have identified (0b83e8f1) cannot possibly be the culprit because it has literally zero effect on any build (it's just a single #if 0'd-out block of code (which has since been removed altogether, along with the rest of the long double bits)). If you can identify the checkin in which the cross-compilation misbehavior first appeared, we can possibly get it resolved before the 3.47 release.

... i can say, with 100% confidence, that the culprit checkin you have identified (0b83e8f1) cannot possibly be the culprit ...

I didn't think so either, but that one failed. the previous one worked. (Or so, I think.) I am trying to find out where the problem lies with a different computer (win11).

I didn't think so either, but that one failed. the previous one worked.

i recommend doing "make clean" between the builds, if you aren't already. If that still exhibits the misbehavior, you can get an even cleaner rebuild with:

$ fossil clean -x # will wipe out ALL files which are not an SCM-tracked part of that checkout
# If you aren't using fossil then instead do:
$ make distclean
$ ./configure ...
$ make

There's simply no way on earth that that particular checkin in affecting the build, so my suspicion is stale build artifacts being left over and confusing the results.

Sorry about the tardiness. Work and home stuff got in the way.

i recommend doing "make clean" between the builds, if you aren't already.

I do, only when I am going to repeat the configure script. However, the way that I cross-compile the SQLite tool is by following these steps:

- downloading the trunk tar.gz file (I.e. SQLite-da750e39.tar.gz)
- run 'tar xvf SQLite-da750e39.tar.gz'
- cd into the created folder (SQLite-da750e39)
- running './configure'
- then 'make install'
- then 'i686-w64-mingw32-gcc -shared -DFOR_WIN10 -DSQLITE_ENABLE_FTS5 -static-libgcc sqlite3.c -o sqlite3.dll' to create the sqlite3.dll for Windows 10/11
- then 'x86_64-w64-mingw32-gcc -DSQLITE_ENABLE_FTS5 -DFOR_WIN10 shell.c -o sqlite3.exe sqlite3.c' to create a x64 sqlite3.exe for Windows 10/11

These steps have worked for a long time. I don't think this is missing of files versions problem. I repeat I think.

I just downloaded the latest trunk and I am getting this error after running 'make install':

 ... [clip] /home/E608313/b/sqlite/dbug/SQLite-da750e39/ext/userauth/sqlite3userauth.h /home/E608313/b/sqlite/dbug/SQLite-da750e39/ext/rbu/sqlite3rbu.h /home/E608313/b/sqlite/dbug/SQLite-da750e39/ext/rbu/sqlite3rbu.c /home/E608313/b/sqlite/dbug/SQLite-da750e39/ext/misc/stmt.c keywordhash.h opcodes.c opcodes.h parse.c parse.h sqlite_cfg.h shell.c sqlite3.h tsrc
rm tsrc/sqlite.h.in tsrc/parse.y
tclsh8.6 /home/E608313/b/sqlite/dbug/SQLite-da750e39/tool/vdbe-compress.tcl  <tsrc/vdbe.c >vdbe.new
mv vdbe.new tsrc/vdbe.c
cp fts5.c fts5.h tsrc
touch .target_source
make: *** No rule to make target 'src-verify', needed by 'sqlite3.c'.  Stop.

E608313@HOR732978I ~/b/sqlite/dbug/SQLite-da750e39

I could provide more data, if you need it. Any idea why this happens?

I am still trying to find out the check-in that caused the problem. Thanks for the support.

make: *** No rule to make target 'src-verify', needed by 'sqlite3.c'. Stop.

This patch ought to fix that:

Index: Makefile.in
==================================================================
--- Makefile.in
+++ Makefile.in
@@ -844,11 +844,11 @@
 	$(TCLSH_CMD) $(TOP)/tool/vdbe-compress.tcl $(OPTS) <tsrc/vdbe.c >vdbe.new
 	mv vdbe.new tsrc/vdbe.c
 	cp fts5.c fts5.h tsrc
 	touch .target_source
 
-sqlite3.c:	.target_source $(TOP)/tool/mksqlite3c.tcl src-verify has_tclsh84
+sqlite3.c:	.target_source $(TOP)/tool/mksqlite3c.tcl src-verify$(BEXE) has_tclsh84
 	$(TCLSH_CMD) $(TOP)/tool/mksqlite3c.tcl $(AMALGAMATION_LINE_MACROS) $(EXTRA_SRC)
 	cp tsrc/sqlite3ext.h .
 	cp $(TOP)/ext/session/sqlite3session.h .
 
 sqlite3r.h: sqlite3.h has_tclsh84
@@ -1646,11 +1646,11 @@
 	rm -f *.dll *.lib *.exp *.def *.pc *.vsix *.so *.dylib pkgIndex.tcl
 	rm -f sqlite3_analyzer$(TEXE) sqlite3-rsync$(TEXE)
 	rm -f mptester$(TEXE) rbu$(TEXE)	srcck1$(TEXE)
 	rm -f fuzzershell$(TEXE) fuzzcheck$(TEXE) sqldiff$(TEXE) dbhash$(TEXE)
 	rm -f threadtest5$(TEXE)
-	rm -f src-verify has_tclsh*
+	rm -f src-verify$(BEXE) has_tclsh*
 
 # Removes build products and test logs.  Retains ./configure outputs.
 #
 clean:	tidy
 	rm -rf omittest* testrunner* testdir*

That will be checked in soon.

That will be checked in soon.

Thanks. So, I tried the latest check-in (8d7fe903), and there are a bunch of different errors now. At least now, there are errors. :-) I apologize for the long post, but I tried to take out some of the text not needed, IMO. Where you see a line containing [clip], there was data extracted.

E608313@HOR732978I ~/b/sqlite/dbug/SQLite-8d7fe903
$ ./configure --enable-all --prefix=/usr && make install && i686-w64-mingw32-gcc -shared -DFOR_WIN10 -DSQLITE_ENABLE_FTS5 -static-libgcc sqlite3.c -o sqlite3.dll && x86_64-w64-mingw32-gcc -DSQLITE_ENABLE_FTS5 -DFOR_WIN10 shell.c -o sqlite3.exe sqlite3.c && cp sqlite3.exe /cygdrive/c/P/bin/
checking build system type... x86_64-pc-cygwin
checking host system type... x86_64-pc-cygwin
checking for gcc... gcc
checking whether the C compiler works... yes
[clip]
checking whether to support RTREE... yes
checking whether to support SESSION... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: creating sqlite3.pc
config.status: creating sqlite_cfg.h
config.status: executing libtool commands
sh /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/cktclsh.sh 8.4 tclsh8.6
touch has_tclsh84
tclsh8.6 /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/mkshellc.tcl >shell.c
gcc  -g -O2 -o mkkeywordhash.exe -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_GEOPOLY -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_SESSION -DSQLITE_ENABLE_PREUPDATE_HOOK   /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/mkkeywordhash.c
./mkkeywordhash.exe >keywordhash.h
gcc  -g -O2 -o lemon.exe /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/lemon.c
cp /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/lempar.c .
cp /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/parse.y .
./lemon.exe -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_GEOPOLY -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_SESSION -DSQLITE_ENABLE_PREUPDATE_HOOK   -S parse.y
cat parse.h /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/vdbe.c | tclsh8.6 /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/mkopcodeh.tcl >opcodes.h
tclsh8.6 /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/mkopcodec.tcl opcodes.h >opcodes.c
gcc  -g -O2 -o mksourceid.exe /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/mksourceid.c
tclsh8.6 /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/mksqlite3h.tcl /home/E608313/b/sqlite/dbug/SQLite-8d7fe903 >sqlite3.h
cp /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/ext/fts5/fts5parse.y .
rm -f fts5parse.h
./lemon.exe  -S fts5parse.y
tclsh8.6 /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/ext/fts5/tool/mkfts5c.tcl
cp /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/ext/fts5/fts5.h .
rm -rf tsrc
mkdir tsrc
cp -f /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/alter.c /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/analyze.c /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/attach.c /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/auth.c /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/backup.c /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/bitvec.c /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/btmutex.c
[clip]
See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.
----------------------------------------------------------------------
echo '#ifndef USE_SYSTEM_SQLITE' >tclsqlite3.c
cat sqlite3.c >>tclsqlite3.c
echo '#endif /* USE_SYSTEM_SQLITE */' >>tclsqlite3.c
cat /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/src/tclsqlite.c >>tclsqlite3.c
tclsh8.6 /home/E608313/b/sqlite/dbug/SQLite-8d7fe903/tool/buildtclext.tcl --cc "gcc" -g -O2 -DSQLITE_OS_WIN=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_GEOPOLY -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_SESSION -DSQLITE_ENABLE_PREUPDATE_HOOK
generating pkgIndex.tcl...
gcc -shared tclsqlite3.c -o libsqlite3.47.0.dll -Wl,-ltclstub8.6
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/cck9FnsH.o:tclsqlite3.c:(.text+0xe4439): undefined reference to `Tcl_UnregisterChannel'
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/cck9FnsH.o:tclsqlite3.c:(.text+0xe452a): undefined reference to `Tcl_Free'
[clip]
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/cck9FnsH.o:tclsqlite3.c:(.text+0xec8d6): undefined reference to `Tcl_CreateObjCommand'
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/cck9FnsH.o:tclsqlite3.c:(.text+0xec937): undefined reference to `Tcl_CreateObjCommand'
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/cck9FnsH.o:tclsqlite3.c:(.text+0xec960): undefined reference to `Tcl_CreateObjCommand'
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/cck9FnsH.o:tclsqlite3.c:(.text+0xec980): undefined reference to `Tcl_PkgProvideEx'
collect2: error: ld returned 1 exit status
make: *** [Makefile:1615: tclextension-install] Error 1

E608313@HOR732978I ~/b/sqlite/dbug/SQLite-8d7fe903
$

This was tried on two different cygwin systems (win10 & win11) with the same result.

win10
E608313@HOR732978I ~/b/sqlite/dbug/SQLite-8d7fe903
$ gcc --version
gcc (GCC) 11.5.0
Copyright (C) 2021 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

E608313@HOR732978I ~/b/sqlite/dbug/SQLite-8d7fe903
$ tclsh
% puts $tcl_version
8.6
%

win11
jcabrera@jicman ~/b/sqlite/dbug/SQLite-8d7fe903
$ gcc --version
gcc (GCC) 11.4.0
Copyright (C) 2021 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

jcabrera@jicman ~/b/sqlite/dbug/SQLite-8d7fe903
$ tclsh
%  puts $tcl_version
8.6
%

Should I not use the --enable-all option? It was working before. Thanks for the help.

...i can say, with 100% confidence, that the culprit checkin you have identified (0b83e8f1) cannot possibly be the culprit...

You are correct. My apologies. I copied the wrong check-in. The culprit is the next one (f97f9944). It builds for cygwin ok, but for Windows, it appears to start, but then, it aborts right after:

10:42:13.19>sqlite3
SQLite version 3.47.0 2024-09-26 13:12:19 (UTF-16 console I/O)
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .q

10:42:22.39>sqlite3
SQLite version 3.47.0 2024-09-26 18:13:10 (UTF-16 console I/O)
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .q

11:05:03.88>sqlite3
SQLite version 3.47.0 2024-09-26 19:38:34
Enter ".help" for usage hints.
                                           <------------------ No SQLite prompt
11:15:15.53>                               <------------------ DOS Command prompt

So, Dr. Hipp added an enhancement to the CLI with the new ".www" dot-command. I know that after that one, although the sqlite3.exe builds ok for the cygwin system, the build for Win10/11 aborts after starting. This is the same build on cygwin:

E608313@HOR732978I ~/b/sqlite/dbug/SQLite-8d7fe903
$ sqlite3
-- Loading resources from /home/E608313/.sqliterc
SQLite version 3.47.0 2024-09-28 19:52:38
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

Thoughts? Suggestions?

gcc -shared tclsqlite3.c -o libsqlite3.47.0.dll -Wl,-ltclstub8.6 -L/wherever/your/libtcl/is

Hmmm... I will have to figure this one out.

Please try the patch below. Let us know whether not it works.

Index: ext/misc/sqlite3_stdio.c
==================================================================
--- ext/misc/sqlite3_stdio.c
+++ ext/misc/sqlite3_stdio.c
@@ -11,11 +11,11 @@
 *************************************************************************
 **
 ** Implementation of standard I/O interfaces for UTF-8 that are missing
 ** on Windows.
 */
-#ifdef _WIN32  /* This file is a no-op on all platforms except Windows */
+#if defined(_WIN32) && !defined(__CYGWIN__)
 #ifndef _SQLITE3_STDIO_H_
 #include "sqlite3_stdio.h"
 #endif
 #undef WIN32_LEAN_AND_MEAN
 #define WIN32_LEAN_AND_MEAN

Index: ext/misc/sqlite3_stdio.h
==================================================================
--- ext/misc/sqlite3_stdio.h
+++ ext/misc/sqlite3_stdio.h
@@ -26,11 +26,11 @@
 ** also link in the accompanying sqlite3_stdio.c source file when compiling
 ** to get compatible interfaces.
 */
 #ifndef _SQLITE3_STDIO_H_
 #define _SQLITE3_STDIO_H_ 1
-#ifdef _WIN32
+#if defined(_WIN32) && !defined(__CYGWIN__)
 /**** Definitions For Windows ****/
 #include <stdio.h>
 #include <windows.h>

If the patch above compiles, then try running the following input through the resulting EXE file. Like this: "sqlite3 <multilang.txt" where the multilang.txt file is as follows. Confirm that none of the non-ASCII text gets garbled. Let us know how it goes, please.

.mode box
CREATE TABLE בראשית(
  vn INT,
  lang TEXT,
  words TEXT
);
INSERT INTO בראשית VALUES
  (1, 'en', 'In the beginning, God created the heavens and the earth'),
  (1, 'ru', 'В начале сотворил Бог небо и землю'),
  (1, 'he', 'בראשית ברא אלהים את השמים ואת הארץ'),
  (1, 'gr', 'ΕΝ ΑΡΧΗ ἐποίησεν ὁ θεὸς τὸν οὐρανὸν καὶ τὴν γῆν'),
  (1, 'th', 'ในเริ่มแรกนั้นพระเจ้าทรงเนรมิตสร้างฟ้าและแผ่นดินโลก'),
  (1, 'zh', '起初，神创造天地'),
  (1, 'ko', '태초에 하나님이 천지를 창조하시니라'),
  (1, 'ar', 'في البدء خلق الله السموات والارض');
SELECT * FROM בראשית;
CREATE VIEW v1 AS SELECT * FROM בראשית;

Please try the patch below. Let us know whether not it works.

I applied both patches to f97f9944. What follows was done after applying it and building:

jcabrera@jicman ~/b/sqlite/dbug/SQLite-f97f9944
$ patch -p0 < p1
patching file ext/misc/sqlite3_stdio.c
Reversed (or previously applied) patch detected!  Assume -R? [n] n
Apply anyway? [n] n
Skipping patch.
1 out of 1 hunk ignored -- saving rejects to file ext/misc/sqlite3_stdio.c.rej

jcabrera@jicman ~/b/sqlite/dbug/SQLite-f97f9944
$ patch -p0 < p2
patching file ext/misc/sqlite3_stdio.h
Reversed (or previously applied) patch detected!  Assume -R? [n] n
Apply anyway? [n] n
Skipping patch.
1 out of 1 hunk ignored -- saving rejects to file ext/misc/sqlite3_stdio.h.rej

But, it did not work:

15:17:55.23>sqlite3
SQLite version 3.47.0 2024-09-26 19:38:34
Enter ".help" for usage hints.

I don't know where the path for the tcl library is. So, I used the "--disable-tcl" configure option, i.e.,

 ./configure --enable-all --prefix=/usr --disable-tcl && make install

And that suppressed those errors and the cygwin build works:

jcabrera@jicman ~/b/sqlite/dbug/SQLite-9b4bc5c4
$ sqlite3
SQLite version 3.47.0 2024-10-15 14:28:23
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite>

However, the cross compiled Windows built sqlite3.exe aborts:

14:18:21.09>sqlite3
SQLite version 3.47.0 2024-10-15 14:28:23
Enter ".help" for usage hints.

14:18:27.87>

By the way, I just found out that I can create a Windows 10/11 sqlite3.exe using i686-w64-mingw32-gcc (32b) version,

 i686-w64-mingw32-gcc -DSQLITE_ENABLE_FTS5 -DFOR_WIN10 shell.c -o sqlite3.exe sqlite3.c

But when I run Dr. Hipp's test, it aborts in the Arabic string. However, the same test works on the cygwin version.

Sorry for the tardy reply.

gcc -shared tclsqlite3.c -o libsqlite3.47.0.dll -Wl,-ltclstub8.6 -L/wherever/your/libtcl/is

So, what I did was to search for libtcl filenames,

$ find / -xdev -iname '*libtcl*'
/bin/libtcl8.6.dll
/lib/libtcl.dll.a
/lib/libtcl8.6.dll.a
/lib/libtclstub.a
/lib/libtclstub8.6.a
/usr/i686-w64-mingw32/sys-root/mingw/lib/dde1.4/libtcldde14.dll.a
/usr/i686-w64-mingw32/sys-root/mingw/lib/libtcl86.dll.a
/usr/i686-w64-mingw32/sys-root/mingw/lib/libtclstub86.a
/usr/i686-w64-mingw32/sys-root/mingw/lib/registry1.3/libtclregistry13.dll.a
/usr/x86_64-w64-mingw32/sys-root/mingw/lib/dde1.4/libtcldde14.dll.a
/usr/x86_64-w64-mingw32/sys-root/mingw/lib/libtcl86.dll.a
/usr/x86_64-w64-mingw32/sys-root/mingw/lib/libtclstub86.a
/usr/x86_64-w64-mingw32/sys-root/mingw/lib/reg1.3/libtclreg13.dll.a
/usr/bin/libtcl8.6.dll
/usr/lib/libtcl.dll.a
/usr/lib/libtcl8.6.dll.a
/usr/lib/libtclstub.a
/usr/lib/libtclstub8.6.a

and use these paths to run these commands (as per your suggestion):

gcc -shared tclsqlite3.c -o libsqlite3.47.0.dll -Wl,-ltclstub8.6 -L/lib
gcc -shared tclsqlite3.c -o libsqlite3.47.0.dll -Wl,-ltclstub8.6 -L/usr/lib/
gcc -shared tclsqlite3.c -o libsqlite3.47.0.dll -Wl,-ltclstub8.6 -L/usr/x86_64-w64-mingw32/sys-root/mingw/lib

Each of these manual commands resulted in the same errors previously reported:

E608313@HOR732978I ~/b/sqlite/SQLite-e904b37f
$ gcc -shared tclsqlite3.c -o libsqlite3.47.0.dll -Wl,-ltclstub8.6 -L/usr/x86_64-w64-mingw32/sys-root/mingw/lib
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/ccHziitD.o:tclsqlite3.c:(.text+0xe4439): undefined reference to `Tcl_UnregisterChannel'
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/ccHziitD.o:tclsqlite3.c:(.text+0xe452a): undefined reference to `Tcl_Free'
[clip]
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/ccHziitD.o:tclsqlite3.c:(.text+0xec960): undefined reference to `Tcl_CreateObjCommand'
/usr/lib/gcc/x86_64-pc-cygwin/11/../../../../x86_64-pc-cygwin/bin/ld: /tmp/ccHziitD.o:tclsqlite3.c:(.text+0xec980): undefined reference to `Tcl_PkgProvideEx'
collect2: error: ld returned 1 exit status

By the way, I also installed MSYS2, and the same thing happens. So, apparently the cygwin support has been damaged or discontinued. Maybe I am the only one using it. :-)