Hello, from kernel version 7.4.3.16 to ~.17 the '*' was removed as an equivalent alternative to the standard '%' wildcard in like expressions. For same reasons this had to happen quickly in the kernel and was released immediately to the public. Unfortunately SQL Studio used the '*' in its catalog manager queries. We had to release a 7.4.3.17 version of SQL Studio where the '*' was replaced with '%' quite ASAP then, and overlooked one occurrence (which you found).
thanks for reporting, we will correct this soon. Anyway, the problem you faced occurs only in a very special case of user settings : if all of the possible table types in the settings for the catalog manager are selected. (session->settings->catalog manager) . you could deselect the 'Result'. --- Markus Stausberg SAP Labs Berlin > -----Original Message----- > From: Bogdan Ene-Iordache [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 11:46 AM > To: Stausberg, Markus > Subject: RE: No objects in SQLStudio > > > Markus, > > Thanks very much for your interest. > > When I try to open the folder 'Tables' clicking on it, > nothing succedes. When I refresh > it, while being selected, I get this message: > > > ++++ Execute +++++++++++++++++++++++++++++++ > Commit: On, SQL Mode: Internal, Isolation Level: Committed > SELECT DISTINCT owner FROM domain.tables WHERE TYPE LIKE '*' AND > TABLENAME LIKE '%' > Time: 11:33:04.245 - 11:33:04.285 (00.040 sec) > > (I see a difference in LIKE between TYPE and TABLENAME, i.e. > * instead of %) > > Bogdan > > > Hello, > > > > could you turn on the 'trace all' checkbox at > > the head of the trace window ? > > This will trace all queries the catalog view generates. > > Start SQL Studio, connect, Turn it on, try to open the empty > > folders in question, turn the trace off, paste the trace into > > an email and send it to me. > > > > Marina probably thought that your problem was caused by > > using an SQL Studio Version < 7.4.3.17 to connect to > > a database instance of version >= 7.4.3.17 . > > This results in a similarly empty catalog view. > > > > --- > > > > Markus Stausberg > > SAP Labs Berlin > > > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
