Icon View Incident Report

Serious Serious
Reported By: Andrew Vaz
Reported On: 12/21/2000
For: Version 2.06 Build 1
# 708 Queries and Filters on Tables Using a Non-English or ANSI Language Driver Return Incorrect Results

The following query doesn't work if the field AtnDtAtend is a secondary index. (I'm sending you two tables that i've run here, the no index one works ok, while the one with the datetime field as a secondary index doesn't work at all). If you give a look on the table, you'll see that there is a bunch of data that meet's the condition. When I stripped the field AtnDtAtend from a secondary index, the query worked. I think that DateTime field are permitted as secondary indexes aren't they? I've put this field as a secondary index because I'm working with some 250000 rows of data at a time. Run the query with the tables i've sent you. I'm using brazilian protuguese here and the date format is dd/mm/yy.

SELECT
   Atendim.IdAtend, Atendim.IdFilialAtn,Atendim.AtnAno,
   Atendim.AtnDtAtend, Atendim.IdConv
FROM Atendim
WHERE   (Atendim.AtnDtAtend >  '01/10/2000')



Resolution Resolution
Fixed Problem on 12/23/2000 in version 2.07 build 1
Image