AW: Random Move-Error on 7.5.0.19

Florian Schmitz wrote:
> 
> Hi again,
> 
> we're encountering random Move Errors on 7.5.0.19 when executing
queries
> with subqueries via jdbc.
>       select value from table where foreignkey in (select foreignkey
from
> table2
> where primakey = value)
> 
> when parsing the statement trough the sqlstudio or the dbmcli, every
thing
> works fine.
> 
> latest jdbc-driver are beeing used.
> 
> someone got a clue?

Please provide some more info about those move-errors(can be found in
knldiag). The funny numbers written there have a meaning for developers
and will help to answer your question.
And if you would mind to send the real select together with the table
definitions incl. primary key / index-definitions it will perhaps help,
too.

Thank you

Elke
SAP Labs Berlin
> 
> flo
> 
> 
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:
http://lists.mysql.com/maxdb?unsub=elke.zabach@xxxxxxx


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx