sqlite3 test failures

[pfein@…]

Using jmp's / my tcl thread variant from #15163, I'm seeing several test failures. I suspect these failures (esp. threaded ones) are related to #15131

Summary

Non-threaded (ie, without -DTCL_THREADS). This is just a repeated run. port clean --work was run between all iterations

sqlite_fulltest.txt: Failures on these tests: bind-4.4 bind-4.5 tcl-1.6 utf16-bind-4.4 utf16-bind-4.5 utf16-bind-6.4 utf16-bind-7.4

sqlite_fulltest2.txt: Failures on these tests: bind-4.4 bind-4.5 crash6-3.2.3 crash6-3.6.3 crash6-3.10.3 crash6-3.14.3 crash6-3.18.3 crash6-3.22.3 crash6-3.26.3 tcl-1.6 utf16-bind-4.4 utf16-bind-4.5 utf16-bind-6.4 utf16-bind-7.4

The threaded tests hang and need to be manually killed. Failures can be found by grep -v Ok

How to reproduce

1. port install tcl +threads (if you don't already have a threaded tcl)
2. Download one of the patches from #15163.
3. port build /path/to/portfile
4. chown -R yourself /path/to/work/dir/sqlite-3.5.8 . The SQLite tests do not run as root.
5. cd /path/to/work/dir/sqlite-3.5.8 && gnumake fulltest. You may want to capture the output somewhere, as it's quite verbose.

[pfein@…]

This is on Intel/Leopard 10.5.2:

pfein@airbounce:~$ uname -a
Darwin airbounce.local 9.2.2 Darwin Kernel Version 9.2.2: Tue Mar  4 21:17:34 PST 2008; root:xnu-1228.4.31~1/RELEASE_I386 i386

[pfein@…]

Looks like macports sqlite3 is outright broken; see comment:ticket:15131:9 for further confirmation.