[sqlite] Can I define collation-aware SQL functions?

2015-05-16 Thread Zsbán Ambrus
On 5/15/15, Richard Hipp wrote: > No there is not. The APIs used to implement those built-in functions > are not exposed to the application-defined function interface. Understood. Thank you for the reply. -- Ambrus

[sqlite] Virtual Table query - why isn't SQLite using my indexes?

2015-05-16 Thread Eduardo Morras
On Fri, 15 May 2015 18:34:33 + Eric Hill wrote: > Thanks for your reply. > > I went as high as using (number of rows)^4, resulting in a cost of > ~440 trillion for the unindexed case, along with setting the cost to > 1 for the indexed case, and it still won't use my index. > > I'd like to

[sqlite] Please explain SQLiteConnection.GetSchema restrictionValues

2015-05-16 Thread William Drago
Thank you very much, Joe. I'll chew on this for a while and see if I can make sense of it. -Bill On 5/15/2015 11:34 PM, Joe Mistachkin wrote: > I just updated the documentation with more details, here: > > https://system.data.sqlite.org/index.html/ci/4be7ad3120577d30?sbs=0 > > -- > Joe