Opened 4 months ago

Closed 4 months ago

Last modified 4 months ago

#6798 closed defect (fixed)

IN filtering broken on mapinfo indexed columns

Reported by: Even Rouault Owned by: Even Rouault
Priority: normal Milestone: 2.1.4
Component: OGR_SF Version: 2.0.0
Severity: normal Keywords:
Cc:

Description

Reported on the mailing list

""" Related to the attribute index: when using SQL WHERE clauses like WHERE myfield IN (1, 2, 3) on the integer field, it reports on the last one only, like if the query was WHERE myfield = 3 (while there are rows with myfield = 1 and 2 as well...)

This is happening only if using the mapinfo attribute index on 2.1 (was working on 1.x). If I manually remove the index files the query executes correctly. """

Change History (3)

comment:1 Changed 4 months ago by Even Rouault

Resolution: fixed
Status: newclosed

In 37251:

OGR SQL: fix IN filtering on MapInfo? indexed columns (2.0 regression, fixes #6798)

comment:2 Changed 4 months ago by Even Rouault

In 37252:

OGR SQL: fix IN filtering on MapInfo? indexed columns (2.0 regression, fixes #6798)

comment:3 Changed 4 months ago by Even Rouault

In 37253:

OGR SQL: fix IN filtering on MapInfo? indexed columns (2.0 regression, fixes #6798)

Note: See TracTickets for help on using tickets.