Daniel Serodio | 2006-07-04 13:23:00.0 | |
| 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) | ||
HXTT Support | 2006-07-04 19:32:40.0 | |
| Try
run once REINDEX ALL ON ficha; then your query should be ok. | ||