Hi Stephen, sorry for the long response time. Now we were able to reproduce the problem and as expected the changes at set function handling were buggy. We will fix it in one of the next release for detailed information have a look at http://www.sapdb.org/webpts <http://www.sapdb.org/webpts> ?wptsdetail=yes&ErrorType=0&ErrorID=1127856 As a workaround you could disable some optimizer features for set function handling. Please execute as a normal sql command via SQLStudio or dbmcli these two commands "diagnose optimize aggregation off" and "diagnose optimize min max off". Kind regards, Holger SAP Labs Berlin
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Montag, 16. Februar 2004 18:34 To: Becker, Holger Cc: [EMAIL PROTECTED] Subject: RE: MaxDB 7.5.0.8 - select count fails where 7.5.0.5 works fine Hi Holger, I responded to this last week with my EXPLAIN output... have you had a chance to look into this? To recap, this happens only on the primary key (integer), doing a count on another field (indexed integer) works fine. Also 7.5.0.5 not having this problem, only 7.5.0.8. Thank you. Stephen Gutknecht On Mon, 9 Feb 2004 10:57 , 'Becker, Holger' <[EMAIL PROTECTED]> sent: Hi Stephen, would you mind sending me the explain output of your statement. We did in fact some changes on aggregate functions but until now there is no known bug in this area. Kind regards, Holger SAP Labs Berlin > -----Original Message----- > From: Stephen Gutknecht (SAPDB) [ <javascript:parent.opencompose('> [EMAIL > PROTECTED] <javascript:parent.opencompose([EMAIL PROTECTED],??,??,??)?> > ','','','')">[EMAIL PROTECTED] <javascript:parent.opencompose('[EMAIL > PROTECTED]','','','')> ] > Sent: Samstag, 7. Februar 2004 07:58 > To: [EMAIL PROTECTED] <javascript:parent.opencompose('[EMAIL PROTECTED]','','','')> > Subject: MaxDB 7.5.0.8 - select count fails where 7.5.0.5 works fine > > > Hi, > > On Windows 2000 - MaxDB 7.5.0 BUILD 008-123-061-548 the > following style of > SQL statement is failing: > > SELECT COUNT(fieldprimarykey) AS myCount > FROM myTable > WHERE field1='value1' > AND field2=1 > AND field3=1 > > Table structure: fieldprimarykey is a INTEGER primary key for > the field. > > Error returned by ODBC driver: > > ERROR [HY000] [MySQL MaxDB][SQLOD32 DLL][MaxDB] General > error;-9211 POS(1) > System error: KB Stack type illegal > > The knldiag on the MaxDB server shows the following error > each time this > query is executed: > > 0x69C ERR 51080 SYSERROR -9211 error: KB Stack type illegal > > The same identical database (replicated) with the same query > works fine on > 7.5.0 BUILD 005. So it appears to be a problem that was > introduced between > MaxDB 7.5.0.5 and 7.5.0.8? > > Thank you. > > Stephen Gutknecht > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] <javascript:parent.opencompose('[EMAIL > PROTECTED]','','','')> >
