[sqlite] BestIndex problem

2015-05-22 Thread Emmanouil Karvounis
Thank you so much for your answers, we managed to do what we wanted. Best, Manos Stamatis On 21 May 2015 at 21:42, Dan Kennedy wrote: > On 05/21/2015 10:20 PM, Emmanouil Karvounis wrote: > >> Greetings, >> >> We are having an issue with BestIndex in our Virtual Table implementation. >> Allow

[sqlite] BestIndex problem

2015-05-22 Thread Dan Kennedy
On 05/21/2015 10:20 PM, Emmanouil Karvounis wrote: > Greetings, > > We are having an issue with BestIndex in our Virtual Table implementation. > Allow us to illustrate the problem with a simple example. > > We create a virtual table named 'vt' that conceptually has 3 columns > "value1, value2,

[sqlite] BestIndex problem

2015-05-21 Thread Emmanouil Karvounis
Greetings, We are having an issue with BestIndex in our Virtual Table implementation. Allow us to illustrate the problem with a simple example. We create a virtual table named 'vt' that conceptually has 3 columns "value1, value2, value3" and then we want to execute the following queries: 1)

[sqlite] BestIndex problem

2015-05-21 Thread Hick Gunter
f flag xEof => return TRUE -Urspr?ngliche Nachricht- Von: Emmanouil Karvounis [mailto:manosk at di.uoa.gr] Gesendet: Donnerstag, 21. Mai 2015 17:21 An: sqlite-users at mailinglists.sqlite.org Cc: Stamatios Christoforidis Betreff: [sqlite] BestIndex problem Greetings, We are h