On a particular query the JDBC driver is not returning correctly sorted data. The field in question is a date field. The query is:
SELECT, CHECKOFFDATE, JobDate, CliNo, TSEXPSTART, TSEXPEND, Duration, TSSTART, TSFINISH, ACTMINS, TSSTATUS, LinkID, VaryCode
FROM WORKRECORDS
WHERE (JobDate >= {d '2007-01-01'})
AND (JobDate <= {d ;2007-01-02})
ORDER BY JobDate ASC
Sorting works fine on the other files. I'm wondering if the fact it is filtering as well as sorting on the same field is triggering a bug in the driver?
|
"Sorting works fine on the other files"
I meant to say, "Sorting works fine on the other fields" (i.e. fields, not files)
|
Try to run once "reindex all on WORKRECORDS".
|
Reindex all does not fix it - it still returns data in the incorrect order i.e. not sorted by JobDate.
What information do you guys need to debug this further?
|
You can zip and send webmaster@hxtt.com your WORKRECORDS.* sample so that we can recur your issue. You can choose ftp method too:
ftp site: ftp.hxtt.com
ftp user: anonymous@hxtt.com
ftp password: (empty)
login mode: normal (not anonymous)
ftp port:21
upload directory: incoming
After upload, you can't(HXTT can) see that upload file, but it has been upload.
Then notify us through webmaster@hxtt.com or reply simply that thread.
Then we will verify whether your db sample is invalidation.
|