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

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

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

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

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

Re: [sqlite] PRAGMA case_sensitive_like

Chris Locke wrote: > Is there a reason for it being write only? This pragma just installs a different LIKE() function, and there is no easy mechanism to read the function pointer back. Regards, Clemens ___ sqlite-users mailing list

Re: [sqlite] PRAGMA case_sensitive_like

Thanks J - not entirely sure how that's helpful - I know how to call the pragma, but I was enquiring as to whether there was a way of reading a write-only pragma (which sounds nonsense now that I've written that down!!) Thanks, Chris On Thu, Aug 16, 2018 at 3:16 PM J Decker wrote: >

Re: [sqlite] PRAGMA case_sensitive_like

[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of J Decker Sent: Thursday, August 16, 2018 10:16 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] PRAGMA case_sensitive_like ... looks like , from the docs, ` pragma *case_sensitive_like` should rteturn

Re: [sqlite] PRAGMA case_sensitive_like

https://www.sqlite.org/pragma.html#pragma_pragma_list A pragma can take either zero or one argument. The argument is may be either in parentheses or it may be separated from the pragma name by an equal sign. The two syntaxes yield identical results. In many pragmas, the argument is a boolean. The

[sqlite] PRAGMA case_sensitive_like

While the pragma *case_sensitive_like *can be set, there doesn't seem to be a way to read it. Is there a reason for it being write only? A hacky workaround is to use the SQL, "select 'x' like 'X' ", but is there a better way? ___ sqlite-users mailing

[sqlite] PRAGMA case_sensitive_like doesn't work

tes W2 DNVFWDR82J|DAWSON P7BWH9N705|H. Packard Y57SUQJX86|J.Michale.Chanel 2KK7N5QJLH|J.W. Bush 9Y1P3E02OR|Jack L5M0PO2YMU|John.Smego 5RU68C4KRY|dragongirl 66XDASL6YK|lisa CGF9F3BNXE|michel-Jackson i found the result is case_sensitive; i tried PRAGMA case_sensitive_like = 0; but it doesn't work; sqlite&g

[sqlite] PRAGMA case_sensitive_like

Hi I am writing a wrapper around version 3.2.8 taken from the starkit , I have implemented and unit tested execution of queries and commands. I am now providing methods for the various PRAGMAs. I have implemented and successfully unit tested PRAGMAs such as auto_vacuum and count_changes. I