Hello, I m trying to upgrade from sqlite-3.2.7 on SGI IRIX64 to sqlite-3.3.3
The applications using sqlite-3.2.7 (compiled with mode 64 or 32 bits) work
fine. But the upgrade to sqlite-3.3.3 coredump on 64 bits when creating
tables
with the UNIQUE, PRIMARY constraints. I did not run in this issue with the
earlier versions (sqlite-3.2.5--> sqlite-3.2.7).
May be can any one help.
thanks
Hamid
irix64% cat test.sql
CREATE TABLE t ( a INTEGER NOT NULL, b INTEGER NOT NULL, rval REAL ,
UNIQUE(a,b));
irix64% sqlite64 test.db
SQLite version 3.2.7
Enter ".help" for instructions
sqlite> .read test.sql
sqlite> .schema
CREATE TABLE t ( a INTEGER NOT NULL, b INTEGER NOT NULL, rval REAL ,
UNIQUE(a,b));
sqlite> .quit
irix64% rm test.db
irix64% ./sqlite test.db
SQLite version 3.3.3
Enter ".help" for instructions
sqlite> .read test.sql
Bus error(coredump)
irix64% rm test.db
irix64% rm core
irix64% dbx ./sqlite
dbx version 7.3.7 (96015_Nov16 MR) Nov 16 2004 07:34:16
Executable /home/afsd/hmd/tmp/sqlite-3.3.3/./sqlite
(dbx) r test.db
Process 345139655 (sqlite) started
SQLite version 3.3.3
Enter ".help" for instructions
sqlite> .read test.sql
Process 345139655 (sqlite) stopped on signal SIGBUS: Bus error (default)
at [sqlite3CreateIndex:2421 +0x18,0x1004bae8]
2421 pIndex->azColl[i] = zColl;
(dbx) where
> 0 sqlite3CreateIndex(pParse = 0xfffffff8040, pName1 = (nil), pName2
= (nil), pTblName = (nil), pList = 0x100896d0, onError = 99, pStart =
(nil), pEnd = (nil), sortOrder = 0, ifNotExist = 0)
["/home/afsd/hmd/tmp/sqlite-3.3.3/build.c":2421, 0x1004bae8]
1 yy_reduce(yypParser = 0x10090c38, yyruleno = 87)
["/home/afsd/hmd/tmp/sqlite-3.3.3/parse.y":315, 0x100390f4]
2 sqlite3Parser(yyp = 0x10090c38, yymajor = 20, yyminor = struct Token {
z = 0x1008a96a = ");"
dyn = 0
n = 1
}, pParse = 0xfffffff8040)
["/home/afsd/hmd/tmp/sqlite-3.3.3/parse.c":3218, 0x1003b820]
3 sqlite3RunParser(pParse = 0xfffffff8040, zSql = 0x1008a918 =
"CREATE TABLE t ( a INTEGER NOT NULL, b INTEGER NOT NULL, rval REAL ,
UNIQUE(a,b));", pzErrMsg = 0xfffffff8020)
["/home/afsd/hmd/tmp/sqlite-3.3.3/tokenize.c":391, 0x10037df0]
4 sqlite3_prepare(db = 0x1008a978, zSql = 0x1008a918 = "CREATE TABLE
t ( a INTEGER NOT NULL, b INTEGER NOT NULL, rval REAL ,
UNIQUE(a,b));", nBytes = -1, ppStmt = 0xfffffff8198, pzTail =
0xfffffff81b8) ["/home/afsd/hmd/tmp/sqlite-3.3.3/prepare.c":539, 0x100364e4]
5 sqlite3_exec(db = 0x1008a978, zSql = 0x1008a918 = "CREATE TABLE t (
a INTEGER NOT NULL, b INTEGER NOT NULL, rval REAL , UNIQUE(a,b));",
xCallback = 0x1000b2a0, pArg = 0xfffffffa1f8, pzErrMsg = 0xfffffff8250)
["/home/afsd/hmd/tmp/sqlite-3.3.3/legacy.c":56, 0x100759f8]
6 process_input(p = 0xfffffffa1f8, in = 0xdb31088)
["/home/afsd/hmd/tmp/sqlite-3.3.3/shell.c":1487, 0x10010130]
7 do_meta_command(zLine = 0x10089848 = ".read", p = 0xfffffffa1f8)
["/home/afsd/hmd/tmp/sqlite-3.3.3/shell.c":1219, 0x1000ed28]
8 process_input(p = 0xfffffffa1f8, in = (nil))
["/home/afsd/hmd/tmp/sqlite-3.3.3/shell.c":1456, 0x1000fe48]
The sqlite-3.2.7 and sqlite-3.3.3 are compiled
this way
rm tclsqlite.c libsqlite.a sqlite 2> /dev/null
for i in *.c
do
echo $i
cc -64 -g -c $i
done
rm shell.o
ar scru libsqlite.a *.o
cc -64 -g -o sqlite shell.c libsqlite.a
