Greetings to everyone, I am developing a virtual table implementation and I would like your help.
According to the sqlite documentation, one can pass a constraint to xFilter by setting in xBestIndex the respective argvindex attribute to a positive value and this value should not coincide with the value for another constraint. When joining two virtual tables, the constraints regarding the first virtual table are considered first and then the constraints regarding the second virtual table are considered, for those records that join with the matched records of the first virtual table. Although I set positive and non-coinciding values to argvIndex in xBestIndex, xFilter is called for the first virtual table with no information about the right hand side of the constraints. On the contrary, right hand side information is present when xFilter is called for the second virtual table. Thank you. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
