How can I limit results from queries

[Former Member]

Hello,

i'd like to limit a sentence of sql  :

select * from gp limit 0,10

This is not possible in Maxdb. Please ¿ Is there any solution for Maxdb ?

thanks,

My regards,

[former_member188883 · Accepted solution]

Hi Isidre,

The command looks ok to me. What is the issue you facing this statement.

Regards,

Deepak Kori

[Former Member]

Hello Deepak,

escuse me,

if you try this command :

select * from gp limit 10,10

it show me 20 (0...20) registers and it's incorrect. In mysql show 10 registers (11...20)

¿ Is there any solution ?

Regards,

ipascualc

[thomasschulz2]

Hello ipascualc,

which version do you use? With version 7.6 your statement works as expected (tested with >= 7.6.03.15).

Regards,

Thomas

[Former Member]

Hello Thomas,

I've the version of Maxdb 7.6.03.10

please said me if this statement work fine with this version.

Regards,

Ipascualc

[Former Member]

Hi Thomas,

excuse me, I've had a incorrect answer.

the version of Database is Maxdb 7.6.06.24 64 bits and the Database Manager is Maxdb 7.6.03.10

Regards,

ipascualc

[thomasschulz2]

Hi ipascualc,

sorry, but we don't ever use 7.6.03.10.

Are there any reasons against updating to a newer version of the 7.6 line? This would be always a good idea, because there are a lot of bugs fixed (actual community version: 7.6.06.24).

Regards,

Thomas

[Former Member]

Hi Thomas,

Yes, but before i've had an incorrect answer for you.

The version of my Database is Maxdb 7.6.06.24 64 bits and the Database Manager is Maxdb 7.6.03.10 and the Sql Studio is 7.6.03.10

Regards,

ipascualc

[former_member188883]

Hi Isidre,

Did you try the select command using different table ?

Post the results with another table

Regards,

Deepak Kori

[thorsten_zielke]

Hello ipascualc,

I suppose you are using the MaxDB connect mode 'internal'. I have tried myself and got the same incorrect result when connecting with 'internal' mode.

However, MaxDB in SAP R/3 environments always runs with connect mode 'Oracle' for compatibility reasons (except the jdbc connect).

In short: connect MaxDB with 'Oracle' mode and it should work (at least it returned the expected result with 7.7.07.39 on my PC...).

I will create a PTS bug ticket to have this fixed for the 'internal mode'.

Thorsten

Message was edited by: Thorsten Zielke

edit:

Bug tracking PTS for MaxDB 7.6.06 is PTS1250564