On 10/18/2011 05:02 PM, Mohd Radzi Ibrahim wrote:
Hi,
This is my table schema:
CREATE VIRTUAL TABLE LocationFTS using FTS4
(
name text,
address text,
email text,
remark text,
telno text,
contact text,
isDeleted text
);
This select statement gives floating point error in both sqlite3.exe and also
my program (both my Ubuntu and Windows versions failed) :
select docid, name, address, email, remark, telNo, contact
from locationFTS
where locationFTS match 'suai plantation sdn bhd, p.o.box 730 97008 bintulu
swk, tel 2 07-6637460 ah leng 06-9766061 a3.0';
PharmacyServer.exe!GenericKedaiRuncitDB::GetLocationFTS(LocationRecord&
r) Line 147 + 0x14 bytes C++
PharmacyServer.exe!wxSQLite3Statement::ExecuteQuery(bool
transferStatementOwnership) Line 1486 + 0xc bytes C++
PharmacyServer.exe!sqlite3_step(sqlite3_stmt * pStmt) Line 62029 + 0x9
bytes C
PharmacyServer.exe!sqlite3Step(Vdbe * p) Line 61954 + 0x9 bytes
C
PharmacyServer.exe!sqlite3VdbeExec(Vdbe * p) Line 3856 + 0x30 bytes
C
PharmacyServer.exe!fts3FilterMethod(sqlite3_vtab_cursor * pCursor, int
idxNum, const char * idxStr, int nVal, Mem * * apVal) Line 51378 + 0x9 bytes
C
PharmacyServer.exe!fts3EvalStart(Fts3Cursor * pCsr) Line 52714 + 0x13
bytes C
PharmacyServer.exe!fts3EvalSelectDeferred(Fts3Cursor * pCsr, Fts3Expr *
pRoot, Fts3TokenAndCost * aTC, int nTC) Line 52634 + 0x2a bytes C
Does anybody know what's going on here?
Can you send me the database by email? Not via the list,
as it will strip the attachment.
Dan Kennedy.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
