On 2015-03-06 03:19 PM, Richard Hipp wrote:
> Yikes! Actually (1) cannot be determined for normal (non-virtual)
> tables either because the value could be a BLOB even if the column
> affinity is TEXT. And so the current LIKE optimization is not valid
> *ever*. See ticket https://www.sqlite.org/
Nachricht-
Von: R.Smith [mailto:rsmith at rsweb.co.za]
Gesendet: Freitag, 06. M?rz 2015 14:25
An: sqlite-users at mailinglists.sqlite.org
Betreff: Re: [sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite
with 'like'
On 2015-03-06 03:19 PM, Richard Hipp wrote:
> Yikes
On Fri, Mar 6, 2015 at 1:21 PM, Hick Gunter wrote:
> And then there remain to be considered the effects of the pragma
> CASE_SENSITIVE_LIKE
>
Good point.
But that's no different from the case when an application overrides the
LIKE behavior via a custom function, and the vtable can similarly dec
BestIndex Bug in system.data.sqlite/sqlite
with 'like'
On Fri, Mar 6, 2015 at 10:12 AM, R.Smith wrote:
> On 2015-03-06 09:42 AM, Dominique Devienne wrote:
>
>> On Thu, Mar 5, 2015 at 7:45 PM, Richard Hipp wrote:
>>
>>
>>> The LIKE operator can be overrid
On 2015-03-06 09:42 AM, Dominique Devienne wrote:
> On Thu, Mar 5, 2015 at 7:45 PM, Richard Hipp wrote:
>
>>
>> The LIKE operator can be overridden by the application to mean
>> anything the application wants - it is not compelled to follow
>> standard SQL semantics. For that reason, virtual ta
On Fri, Mar 6, 2015 at 10:12 AM, R.Smith wrote:
> On 2015-03-06 09:42 AM, Dominique Devienne wrote:
>
>> On Thu, Mar 5, 2015 at 7:45 PM, Richard Hipp wrote:
>>
>>
>>> The LIKE operator can be overridden by the application to mean
>>> anything the application wants - it is not compelled to follow
On Thu, Mar 5, 2015 at 7:45 PM, Richard Hipp wrote:
> On 3/5/15, Mike Nicolino wrote:
> > I'm using System.Data.SQLite version 1.0.95.0 and have what appears to
> be a
> > bug with Virtual Tables. Queries using 'like' in the where clause are
> not
> > getting the like clause passed to BestIndex
On 3/6/15, Dominique Devienne wrote:
>
> Sure. But SQLite knows whether LIKE is overriden by the application or not,
> so shouldn't it only hide LIKE from the virtual table when it detects it,
> instead of wholesale preventing the vtable from optimizing the "normal
> semantic" LIKE case?
It's mor
ly.
MikeN
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jay Kreibich
Sent: Thursday, March 05, 2015 10:55 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Virtual Table BestIn
ite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp
Sent: Thursday, March 05, 2015 10:46 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite
with
I'm using System.Data.SQLite version 1.0.95.0 and have what appears to be a bug
with Virtual Tables. Queries using 'like' in the where clause are not getting
the like clause passed to BestIndex as a query constraint. Specifically:
- Simple query: select * from foo where name like 'a%
On 3/5/15, Mike Nicolino wrote:
> Incidentally, this used to 'work' in a much older version of SQLite, though
> the semantics may not have been correct in all cases. Version 3.7.7.1,
> ended up transforming like to of pair of constraints in the "like 'a%'" case
> which were passed to BestIndex.
>
On 3/5/15, Mike Nicolino wrote:
> I'm using System.Data.SQLite version 1.0.95.0 and have what appears to be a
> bug with Virtual Tables. Queries using 'like' in the where clause are not
> getting the like clause passed to BestIndex as a query constraint.
> Specifically:
>
>
> - Simple qu
On Mar 5, 2015, at 12:30 PM, Mike Nicolino
wrote:
> I'm using System.Data.SQLite version 1.0.95.0 and have what appears to be a
> bug with Virtual Tables. Queries using 'like' in the where clause are not
> getting the like clause passed to BestIndex as a query constraint.
> Specifically:
>
14 matches
Mail list logo
