I think it is not important only for me, but for all who want to use xBestIndex and xFilter functions and correctly solve all possible scenarios. Is there a way I can determine in xBestIndex/xFilter a collation sequence used in constraints? - perhaps not. All I found is that if I do not solve constraints on my side, engine solves all correctly, so in my case, I do not see a problem. But there are some opensource projects using Virtual Tables solving contraints themselves (such as Spatialite) and it is not very easy to explain to users, why clause WHERE column = 'ABCabc" COLLATE NOCASE does not work, but WHERE column LIKE 'ABCabc' does.
2013/7/22 Richard Hipp <d...@sqlite.org> > On Mon, Jul 22, 2013 at 10:27 AM, Dušan Paulovič <paulo...@gisoft.cz> > wrote: > > > So, in other words, there is no way for programmers from EU to contribute > > on SQLite? > > Is there any other option? > > Is there a plan to solve xBestIndex collation issue? > > > > Actually implementing such a patch is trivial. We'll do that for you. Not > a problem. > > The real work comes in (1) testing the new features (2) documenting the new > feature, and especially (3) supporting the new feature moving forward. > These three items, and especially the third item, involve orders of > magnitude more time and effort than actually implementing the patch. > > So if having the ability to use collating sequences in virtual tables is > something that is important to you, then you have to sell the idea. You > have to convince the core team that your new feature is important and > useful and ought to be supported. > > Submitting a "proof of concept" patch might be part of your sales pitch, as > a way of showing that the feature is feasible and does not impact > performance and will be easy to support. But the patch is only a small > part of your sales pitch. You still need to convince the core team that > what you are trying to do is necessary and important and will be of benefit > to a large number of users. > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > 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