While the following SQL statement works fine:
SELECT SUM(field) FROM table WHERE field2>='2010-10-01' AND field2<='2010-10-31';
this one produces an error:
SELECT SUM(field) FROM table WHERE field2 BETWEEN '2010-10-01' AND '2010-10-31';
with the following message:
SQLState 60000
ErrorCode 393216
and the exception being:
Error: java.lang.ArrayIndexOutOfBoundsException: 1
at com.hxtt.sql.paradox.f.a(Unknown Source)
at com.hxtt.sql.paradox.m.a(Unknown Source)
at com.hxtt.sql.q.a(Unknown Source)
at com.hxtt.sql.cm.a(Unknown Source)
at com.hxtt.sql.ay.a(Unknown Source)
at com.hxtt.sql.dk.a(Unknown Source)
at com.hxtt.sql.dk.a(Unknown Source)
at com.hxtt.sql.c2.f(Unknown Source)
at com.hxtt.sql.dk.a(Unknown Source)
at com.hxtt.sql.br.a(Unknown Source)
at com.hxtt.sql.ai.a(Unknown Source)
at com.hxtt.sql.ai.a(Unknown Source)
at com.hxtt.sql.ai.execute(Unknown Source)
Thanks.
|
I am noticing some strange behavior while quering the database using the Paradox driver. Things like some queries include a record but others don't, or record number start to change (maybe decrease) as I more queries are performed.
A reindex operation seems to solve this issue, does this mean that the Paradox driver modifies the files in any way? If so, I was not expecting this.
Regards.
Juan
|
>A reindex operation seems to solve this issue, does this mean that the Paradox
> driver modifies the files in any way?
It means that one of your index files is obsolete. HXTT Paradox won't modify your database for query sql, and will choose one suitable index from existent indices according to where clause.
|
|
What do you mean by obsolete?
|
>What do you mean by obsolete?
Whether there're other application modify that database, and doesn't maintain indices file in time?
|
This is what I am trying to understand.
Yes, the database is part of an application. However, the strange behavior occurs when the application is not running. Is it possible that the application leaves corrupt indexes? If so, how comes the application never presents this kind of problems itself?
I need to your help to understand what is going on, otherwise the information I obtain from the application is useless (since I cannot tell whether it is accurate or not).
Thanks.
|
>Is it possible that the application leaves corrupt indexes?
No corrupted. Just obsolete without the latest modification information.
>If so, how comes the application never presents this kind of problems itself?
It will reindex or doesn't utilize that obsolete index.
|
Main
webmaster@hxtt.com