Hi all,
I'm having -9005 (BD Illegal key) failure as I try to execute the
update statements with the following structure:
UPDATE <table> SET <table_field>=<correlated subselect> WHERE
<condition_on_some_table_field>
For instance the following query confuses the SQL parser:
"UPDATE
partners p SET personal_prediction = (SELECT DISTINCTclassificationpredictionid FROM emailclassification cp WHERE
cp.classificationpredictionid=190 AND cp.partnerid = p.id) WHERE p.id
> 0 AND p.id <= 421865 "
This statement is valid UPDATE statement and works fine with SAPDB
v.7.4.3.14
As I switched to SAP DB 7.4.3.17 (which I built from sources) I
experienced this problem. I didn't find any way to rewrite the query to
avoid this error. (But updateable view with the same condition works
fine).
The most weird thing about it is the problem doesn't occur if the
database was created with SAP DB 7.4.3.14 and when the query runs
with 7.4.3.17
Is there a PTS record for the problem. I failed to find anything that looks
like this.
Thanks in advance,
Dmitri Lyssenko,
Nuix Pty. Ltd.
Yahoo! Plus - For a better Internet experience
