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]
