Skip to site navigation (Press enter)

RE: sql_recreateindex "".""."" RETURNS ERROR ....

Becker, Holger Fri, 12 Aug 2005 09:28:32 -0700

Kevin Wilson wrote:

> 
> -24988,ERR_SQL: sql error
> -24300,SQL error (100): Row not found
>  
> maxdb v7.5.0.23
> dbmgui v7.5.0.18
> 
> 
> After doing a select with order by on the default serial 
> primary key column
> the results only sort in ascending order when I specify descending. I
> attempted to rebuild the serial index for the table but I 
> receive the above
> error when doing so. I also tried to rebuild a different 
> index in the table
> and received the same result.
> 
> Anyone have a prognosis?

Hi,

we had some bugs with a new implemented feature in 7.5 
wich should use primary key or index to get rows in
reverse order of this key or index.

Please update to newest version in 7.5 or disable this feature 
by setting database parameter OPTIMIZE_FETCH_REVERSE to NO.

Kind regards
Holger

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

  • Previous message
  • View by thread
  • View by date
  • Next message

Reply via email to

The Mail Archive
  • The Mail Archive home
  • maxdb - all messages
  • maxdb - about the list
  • Expand
  • Previous message
  • Next message
  • The Mail Archive home
  • Add your mailing list
  • FAQ
  • Support
  • Privacy
  • 235EE6AC8AE9264CBF763FC6749E270102AC2F0F@dewdfe22.wdf.sap.corp