Re: [sqlite] PRAGMA case_sensitive_like conflicts with LIKE operator when creating an index

2019-05-01 Thread Richard Hipp
See ticket https://www.sqlite.org/src/info/a340eef47b0cad59 On 4/28/19, Manuel Rigger wrote: > Hi everyone, > > It seems that setting "PRAGMA case_sensitive_like" to either false (the > default behavior) or true results in no longer being able to use a LIKE or > GLOB clause when creating an

Re: [sqlite] PRAGMA case_sensitive_like conflicts with LIKE operator when creating an index

2019-04-30 Thread Manuel Rigger
Okay, thanks! Best, Manuel Am So., 28. Apr. 2019 um 21:02 Uhr schrieb Simon Slavin < slav...@bigfraud.org>: > On 28 Apr 2019, at 7:58pm, Manuel Rigger wrote: > > > It seems that setting "PRAGMA case_sensitive_like" to either false (the > default behavior) or true results in no longer being

Re: [sqlite] PRAGMA case_sensitive_like conflicts with LIKE operator when creating an index

2019-04-28 Thread Simon Slavin
On 28 Apr 2019, at 7:58pm, Manuel Rigger wrote: > It seems that setting "PRAGMA case_sensitive_like" to either false (the > default behavior) or true results in no longer being able to use a LIKE or > GLOB clause when creating an index. Correct. Because you cannot depend that every

[sqlite] PRAGMA case_sensitive_like conflicts with LIKE operator when creating an index

2019-04-28 Thread Manuel Rigger
Hi everyone, It seems that setting "PRAGMA case_sensitive_like" to either false (the default behavior) or true results in no longer being able to use a LIKE or GLOB clause when creating an index. For example, the example below results in "Error: non-deterministic functions prohibited in index