Hello, I have some trouble with the testsuite. Not all tests seem to pass, and 64-bit machines have a harder time than 32-bit. Also, it does not seem well supported to have the database in a network filesystem.
Are my findings correct? Especially the conflict tests seems to fail on all platforms, is this a known problem? If so, shouldn't they be marked as known-broken or something? Some test output is attached (from 3.2.7). /Johan Linux (FC3) amd64: misc1-15.1.3...zsh: segmentation fault /pdc/vol/sqlite/src/sqlite-3.2.7/amd64_fc3/testfixture traceback: #0 0x00000033e4b6f200 in strlen () from /lib64/tls/libc.so.6 (gdb) where #0 0x00000033e4b6f200 in strlen () from /lib64/tls/libc.so.6 #1 0x000000000041cab2 in sqlite3SetString (pz=0x7fbfffcef0) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/util.c:399 #2 0x00000000004312c6 in lookupName (pParse=0x7fbfffd4a0, pDbToken=0x3300000000, pTableToken=0x44c3ea, pColumnToken=0x593858, pNC=0x0, pExpr=0x594960) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/expr.c:1009 #3 0x0000000000431791 in nameResolverStep (pArg=0x7fbfffcfd0, pExpr=0x594960) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/expr.c:1135 #4 0x0000000000430da1 in walkExprTree (pExpr=0x594960, xFunc=0x4316c0 <nameResolverStep>, pArg=0x7fbfffcfd0) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/expr.c:639 #5 0x00000000004319e9 in sqlite3ExprResolveNames (pNC=0x7fbfffcfd0, pExpr=0x594960) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/expr.c:1240 #6 0x0000000000438de6 in sqlite3SelectResolve (pParse=0x7fbfffd4a0, p=0x5989b0, pOuterNC=0x590780) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/select.c:2384 #7 0x000000000043a128 in sqlite3Select (pParse=0x7fbfffd4a0, p=0x5989b0, eDest=7, iParm=1, pParent=0x0, parentTab=0, pParentAgg=0x0, aff=0x0) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/select.c:2641 #8 0x000000000042bfb0 in sqlite3EndTable (pParse=0x7fbfffd4a0, pCons=0x0, pEnd=0x0, pSelect=0x5989b0) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/build.c:1328 #9 0x00000000004461d3 in sqlite3Parser (yyp=0x597d10, yymajor=11, yyminor= {z = 0x58d9ca ";\n ", dyn = 0, n = 1}, pParse=0xfefefefefefefeff) at parse.y:142 #10 0x000000000043cfdc in sqlite3RunParser (pParse=0x7fbfffd4a0, zSql=0x58d9a0 "\n CREATE TABLE t10 AS SELECT main.t9.c1;\n ", pzErrMsg=0x7fbfffd498) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/tokenize.c:388 #11 0x0000000000436f90 in sqlite3_prepare (db=0x57e380, zSql=0x58d9a0 "\n CREATE TABLE t10 AS SELECT main.t9.c1;\n ", nBytes=-1073754496, ppStmt=0x7fbfffd6d0, pzTail=0x7fbfffd6d8) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/prepare.c:440 #12 0x0000000000427378 in DbObjCmd (cd=0x579450, interp=0x561170, objc=46, objv=0x563e20) at /pdc/vol/sqlite/src/sqlite-3.2.7/src/tclsqlite.c:1217 #13 0x00000033e522d4c2 in TclEvalObjvInternal () from /usr/lib64/libtcl8.4.so #14 0x00000033e525403b in TclExprFloatError () from /usr/lib64/libtcl8.4.so #15 0x00000033e5257727 in TclCompEvalObj () from /usr/lib64/libtcl8.4.so #16 0x00000033e527e70d in TclObjInterpProc () from /usr/lib64/libtcl8.4.so #17 0x00000033e522d4c2 in TclEvalObjvInternal () from /usr/lib64/libtcl8.4.so #18 0x00000033e522ea5d in Tcl_EvalEx () from /usr/lib64/libtcl8.4.so #19 0x00000033e522f434 in Tcl_EvalObjEx () from /usr/lib64/libtcl8.4.so #20 0x00000033e527e00f in Tcl_UplevelObjCmd () from /usr/lib64/libtcl8.4.so #21 0x00000033e522d4c2 in TclEvalObjvInternal () from /usr/lib64/libtcl8.4.so #22 0x00000033e525403b in TclExprFloatError () from /usr/lib64/libtcl8.4.so #23 0x00000033e5257727 in TclCompEvalObj () from /usr/lib64/libtcl8.4.so #24 0x00000033e527e70d in TclObjInterpProc () from /usr/lib64/libtcl8.4.so #25 0x00000033e522d4c2 in TclEvalObjvInternal () from /usr/lib64/libtcl8.4.so #26 0x00000033e522ea5d in Tcl_EvalEx () from /usr/lib64/libtcl8.4.so #27 0x00000033e526df02 in Tcl_FSEvalFile () from /usr/lib64/libtcl8.4.so #28 0x00000033e526e03e in Tcl_EvalFile () from /usr/lib64/libtcl8.4.so #29 0x00000000004292aa in main (argc=2, argv=0x7fbffff6c8) conflict-6.2... Expected: [0 {7 6 9} 1 1] Got: [0 {7 6 9} 1 0] conflict-6.3... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.4... Ok conflict-6.5... Ok conflict-6.6... Ok conflict-6.7... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.8... Expected: [0 {7 6 9} 1 1] Got: [0 {7 6 9} 1 0] conflict-6.9... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.10... Expected: [0 {7 6 9} 1 1] Got: [0 {7 6 9} 1 0] conflict-6.11... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.12... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.13... Expected: [0 {7 6 9} 1 1] Got: [0 {7 6 9} 1 0] printf-8.1... Error: integer value too large to represent printf-8.2... Error: integer value too large to represent Tru64 UNIX (alpha): Floating point exception in printf-8.3: signal Floating point exception at [sqlite3_mprintf_scaled:716 +0xc,0x12002e2b4] z = sqlite3_mprintf(argv[1], r[0]*r[1]); (dbx) t > 0 sqlite3_mprintf_scaled(NotUsed = (nil), interp = 0x14000ee00, argc = 4, > argv = 0x11fffa178) ["/pdc/vol/sqlite/src/sqlite-3.2.7/src/test1.c":716, > 0x12002e2b4] Also: Failures on these tests: conflict-6.2 conflict-6.3 conflict-6.7 conflict-6.8 conflict-6.9 conflict-6.10 conflict-6.11 conflict-6.12 conflict-6.13 misc4-5.2 misc4.test misc5.test notnull.test null.test pager.test pager2.test pager3.test pagesize.test pragma.test printf-2.1.4.5 printf-2.2.4.5 printf-2.3.4.5 printf-2.4.4.5 printf-8.1 printf-8.2 printf.test progress.test quote.test reindex.test rollback.test rowid.test safety.test schema.test select1.test select2.test select3.test select4.test select5.test select6.test select7.test sort.test subquery.test subselect.test sync.test table-8.1 table-8.1.1 table-8.3 table-8.3.1 table-8.4 table-8.5 table-8.6 table.test tableapi.test tclsqlite.test temptable.test thread1.test tkt1435.test tkt1443.test tkt1444.test tkt1449.test trace.test trans-6.1 trans-6.3 trans-6.4 trans-6.5 trans-6.6 trans-6.7 trans-6.10 trans-6.12 trans-6.13 trans-6.14 trans-6.15 trans-6.16 trans-6.20 trans-6.21 trans-6.22 trans-6.23 trans-6.24 trans-6.25 trans-6.26 trans-6.27 trans-6.28 trans.test trigger1.test trigger2.test trigger3.test trigger4.test trigger5.test trigger6.test trigger7.test types.test types2.test types3-1.3 types3-2.3 types3.test unique.test update.test vacuum.test vacuum2.test varint.test view-3.3 view-3.4 view-3.5 view-8.1 view-8.2 view-8.3 view-8.6 view-8.7 view.test where.test where2.test NetBSD 2.1 (i386): conflict-6.2... Expected: [0 {7 6 9} 1 1] Got: [0 {7 6 9} 1 0] conflict-6.3... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.4... Ok conflict-6.5... Ok conflict-6.6... Ok conflict-6.7... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.8... Expected: [0 {7 6 9} 1 1] Got: [0 {7 6 9} 1 0] conflict-6.9... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.10... Expected: [0 {7 6 9} 1 1] Got: [0 {7 6 9} 1 0] conflict-6.11... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.12... Expected: [0 {6 7 3 9} 1 1] Got: [0 {6 7 3 9} 1 0] conflict-6.13... Expected: [0 {7 6 9} 1 1] Got: [0 {7 6 9} 1 0]