E_op0889

[martin.bowes]

Hi All.

In the following SQL the table val_time is a vectorwise table.

Why is it that when I do:
declare global temporary table session.My_Select as select
max(packet_id) as max_packet
from val_time
on commit preserve rows with norecovery

I get error: E_OP0889 Eqc is not available
at a CO node.

However, all is sweetness and light if I add the ', structure = vectorwise' to the above query.

Martin Bowes

[zelaine]

What version of VectorWise are you using? Starting in 1.5 VectorWise, the default table structure is VectorWise, so whether or not you explicitly specify "with structure = vectorwise" should yield the same result.

The fact that doesn't seem to be the case seems to imply that you're using an older version of the product.

BTW, I can reproduce your problem using the latest development build if I explicitly tack on ", structure=heap", which would be the equivalent of what I think you're actually doing in your version of the product.

[zelaine]

For Ingres folks, I've logged the problem as Mantis 2567.

[martin.bowes]

Originally Posted by zelaine

What version of VectorWise are you using? Starting in 1.5 VectorWise, the default table structure is VectorWise, so whether or not you explicitly specify "with structure = vectorwise" should yield the same result.

The fact that doesn't seem to be the case seems to imply that you're using an older version of the product.

BTW, I can reproduce your problem using the latest development build if I explicitly tack on ", structure=heap", which would be the equivalent of what I think you're actually doing in your version of the product.

VW1.6, but I always set result_structure=heap in the config.dat...I find that leaving the default setting of vectorwise causes too much grief in all my existing supporting code.

Marty

[clada01]

Testing issue 2567 in both 2.02 and candidate 2.5, it appears to be fixed.