Hi Kevin, the WebPTS link was wrapped by the mail tool. The correct link is as follows:
http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID=1128000 Maybe this will answer your question. Cheers, Daniel -----Original Message----- From: Kevin Wilson [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 14. April 2005 17:26 To: Becker, Holger; Alexey Gaidukov; [email protected] Subject: RE: Impossible to use views in MaxDB 7.5 and 7.6 because they can get wrong resultset I am using views and haven't experienced any ill returns. What is the problem? The WebPTS link comes up with an error. -----Original Message----- From: Becker, Holger [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 3:34 AM To: Alexey Gaidukov; [email protected] Subject: RE: Impossible to use views in MaxDB 7.5 and 7.6 because they can get wrong resultset Alexey Gaidukov wrote: > You have regestered bug > http://www.sapdb.org/webpts?wptsdetail=yes&ErrorType=0&ErrorID > =1128000. > Bug is very old. Version 7.6 is still affected. So it is > impossible to > use views in real application. Do you have any plans to fix it in 7.6 > release? Hi, sorry no time schedule by now because it's a design problem with outer joins in combination with views and so far we don't know how to solve it in the actual code base. As a workaround you could encapsulate the view in a from select. Example: select b.* , C.* from test_a a , TEST_B b, (select * from VIEW_D) C where a.id = b.id AND b.IDX = C.IDX (+)! Best regards Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
