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.
--
Christian Ullrich Registrierter Linux-User #125183
"There's nothing we can't face -- except for Bun-bun..."
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
