If I execute
SELECT codigo, tipo, emissao, valor, mes ,ano FROM ficha WHERE tipom = 'N' and ano = '2006' and mes < '3' and tipo = ' 2'
I get a ResultSet which includes a row with codigo = '94223028', but if I execute
SELECT codigo, tipo, emissao, valor, mes ,ano FROM ficha WHERE tipom = 'N' and ano = '2006' and mes < '3' and tipo = ' 2' and codigo = '94223028'
a get an empty ResultSet. "codigo" is a NUMERIC(8,0) column.
FICHA has the following indices (each line lists one index):
codigo
str(ano,4)+str(mes,2)+str(codigo,8)+str(tipo,3)
str(codigo,8)+str(ano,4)+str(mes,2)+tipom
tipom+str(ano,4)+str(mes,2)+str(codigo,8)+str(tipo,3)
str(tipo,3)+dtos(data)
numbco
str(tipo,3)+dtos(emissao)
|
Try
run once
REINDEX ALL ON ficha;
then your query should be ok.
|
Main
webmaster@hxtt.com