Christian Ullrich wrote: > When I send the query > > select count(*) from a where b in > (select c from d where e = 'f') > > to a MaxDB 7.5 (Build 008-123-061-548) server on Windows 2000 > Server, I get the message > > General error;-9211 POS(1) System error: KB Stack type illegal. > > in SQL Studio. > > The table "a" contains 4828 records, the nested query returns 2895 > records. If I limit it to a lower number, it works. > > Is this a bug in MaxDB, or can I fix it by changing a parameter? > I can also work around it by rewriting the query as a join instead > of a set operation, so it's not that critical.
We fixed a similar problem with 7.5.0.10 (for details see http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1127856). Unfortunately this release is not yet available on the download server. But as a workaround you could disable some optimization with "diagnose optimize aggregation off" executed via SQL Studio or dbmcli. If this workaround doesn't help please contact me again. Thank you for reporting this bug. Best regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
