Your question has been forwarded to the sqlite-users@sqlite.org mailing list.
On Mar 10, 2010, at 4:29 AM, bibo lv wrote: > Hi: > I use sqlite as an open source in my software。When virtual > table is used, > it is not the same as 'real table'. For example the sql : > "select * from (select * from table1 where obj = 'a'), (select * > from table2 where obj = 'b')" > when table1 and table2 are real tables, the result shows as we > expect, unfortunately when > they are virtual tables using fts3 to create, the result is not > right. > Further more, when i debug fts3 with sql -- > 1."select * from virtual_table where a = ''1' and b ='2'" > 2."select * from virtual_table where a = ''1' or b ='2'" > i can not fetch the values of a and b using 1 but fail using 2 in > xFilter. > Can you tell me how can i deal with the problems. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users