java.sql.BatchUpdateException: Batch entry 0 INSERT INTO TMPTT2_1 VALUES ('5') was aborted

Hi GridSQL Team,

I'm encoutering an error when I try to set
xdb.use_load_for_step=false

the query statement is select count(*) from t1;

the error msg is:
java.sql.BatchUpdateException: Batch entry 0 INSERT INTO TMPTT2_1 VALUES ('5') was aborted. Call getNextException to see the cause.
...

when i execute getNextException, the extra msg is:
java.sql.SQLException: ERROR: relation "tmptt2_1" does not exist.

Can you tell me how to solve it.

Thanks.

Looks like a bug, we will look into this.
Why do you want to set xdb.use_load_for_step=false?
This would significantly decrease performance when running complex queries.

I appreciate your directions. I set it just for digging.

This probably made its way in as a regression issue because it is so much worse for performance that we don't ever run it with this option anymore, including in our regression tests.

Regards,

Mason

This has been fixed in CVS:

http://forums.enterprisedb.com/posts/list/2158.page