The backtrace ===============
Program received signal SIGSEGV, Segmentation fault. 0x2b657288 in sqlite3Parser (yyp=0x2d401e40, yymajor=119, yyminor=..., pParse=0x2d4035c8) at sqlite3.c:106740 106740 }while( yymajor!=YYNOCODE && yypParser->yyidx>=0 ); #0 0x2b657288 in sqlite3Parser (yyp=0x2d401e40, yymajor=119, yyminor=..., pParse=0x2d4035c8) at sqlite3.c:106740 yyminorunion = { yyinit = 735636932, yy0 = { z = 0x2bd8edc4 "FROM dir_table", n = 4 }, yy4 = 735636932, yy90 = { a = 735636932, b = 0x4 }, yy118 = { pExpr = 0x2bd8edc4, zStart = 0x4 <Address 0x4 out of bounds>, zEnd = 0x2b697000 "" }, yy203 = 0x2bd8edc4, yy210 = 196 '\304', yy215 = { value = 735636932, mask = 4 }, yy259 = 0x2bd8edc4, yy292 = { pLimit = 0x2bd8edc4, pOffset = 0x4 }, yy314 = 0x2bd8edc4, yy322 = 0x2bd8edc4, yy342 = { eOperator = { z = 0x2bd8edc4 "FROM dir_table", n = 4 }, not = 728330240 }, yy384 = 0x2bd8edc4, yy387 = 0x2bd8edc4 } yyact = 21104640 yyendofinput = 0 yypParser = 0x2d401e40 #1 0x2b65a210 in sqlite3RunParser (pParse=0x2d4035c8, zSql=0x2bd8eda4 "SELECT COUNT(distinct Alb_Name) FROM dir_table", pzErrMsg=0x2bd8cbf8) at sqlite3.c:107465 nErr = 0 i = 36 pEngine = 0x2d401e40 tokenType = 119 lastTokenParsed = <value optimized out> enableLookaside = 1 '\001' db = 0x6a14b0 mxSqlLen = 1000000000 #2 0x2b65ac68 in sqlite3Prepare (db=0x6a14b0, zSql=0x2bd8eda4 "SELECT COUNT(distinct Alb_Name) FROM dir_table", nBytes=-1, saveSqlFlag=0, pReprepare=0x0, ppStmt=0x2bd8cca8, pzTail=0x0) at sqlite3.c:90212 pParse = 0x2d4035c8 zErrMsg = 0x0 rc = <value optimized out> i = <value optimized out> #3 0x2b65b468 in sqlite3LockAndPrepare (db=<value optimized out>, zSql=<value optimized out>, nBytes=-1, ppStmt=<value optimized out>, pzTail=0x0) at sqlite3.c:90304 rc = <value optimized out> #4 sqlite3_prepare (db=<value optimized out>, zSql=<value optimized out>, nBytes=-1, ppStmt=<value optimized out>, pzTail=0x0) at sqlite3.c:24831 rc = 21104640 #5 0x00466730 in sql_stmt (db=9, stmt=0xffffffc0 <Address 0xffffffc0 out of bounds>) at /localhome/user/a/b/c/d/e/f/g/h/k.c:496 errmsg = 0x0 retval = <value optimized out> __PRETTY_FUNCTION__ = "\000\000\000\000\000\000\000\000" ================ On Thu, Mar 1, 2012 at 11:42 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 03/01/2012 10:54 PM, Sreekumar TP wrote: > >> version 3.7.7.1 >> The query works on x86, but fails on MIPS processor! >> > > Are you able to post a stack trace? Ideally generated by > the gdb "where full" command. Thanks. > > Dan. > > > >> >> Sreekumar >> >> >> >> On Thu, Mar 1, 2012 at 7:00 PM, Dan Kennedy<danielk1...@gmail.com> >> wrote: >> >> On 03/01/2012 05:48 PM, Sreekumar TP wrote: >>> >>> In my system, the statement causes sqlite3parser function to crash. >>>> My compiler is mips , little endian, gcc version is 4.5.2 >>>> >>>> >>> SQLite version? 3.7.10 seems Ok here. >>> >>> Dan. >>> >>> ______________________________****_________________ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-****bin/mailman/listinfo/sqlite-****users<http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users> >>> <http://sqlite.org:8080/**cgi-bin/mailman/listinfo/**sqlite-users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> >>> > >>> >>> ______________________________**_________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> >> >> > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users