Error at Select with Limit and Offset (7.6.03.15)

[thomasschulz2]

Hi List,

when executing a query like "select * from testtable limit 1,1", I always get the error "[-9045]: System error: BD Root check".

I can easily reproduce it with creating a table with one field, insert three rows and then select with limit 1,1. Without offset everything works fine.

In the PTS system I found no entry for this behavior.

MaxDB version: 7.6.03.15 on 64bit linux.

A test with the older version 7.6.00.37 using the old syntax (without comma) leads to the same error.

Regards,

Thomas

[Former Member · Accepted solution]

Hi,

now I can tell you, that starting with version 7.6.06.01 (please do not ask, when you will be able to download it) the error -9045 can be avoided even without FOR REUSE.

Sorry for any inconveniences.

I hope you will not struggle over further problems in this context.

With our tests after the first version of change we had to find out, that -9206 arose in sqlcli when using FOR REUSE. Hopefully your application will not handle the interface as sqlcli does.

Elke