We found an error within join handling with generated columns like yours (a+b as no1). This will be fixed with next version.
There is another question: You wrote: <snip> Note how we want to match two fields concatenated from one table against one field from another table. Doing this directly didn't seem to work, ... </snip> What do you mean. What error code/message results? Best regard, Gert SAP Labs Berlin > -----Original Message----- > From: Noah J SILVA [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 29. Mai 2003 23:03 > To: [EMAIL PROTECTED] > Cc: James ROBIE > Subject: SQL Query bring down DB instance > > > Hi, > > I have three questions: > > The first concerns a query against two views bring down our > test database: > the query looks something like: > > create view view1 as > select a+b as no1, c as no2, d as no3 from table1 > > select * from view1, table2 where > view1.no1=table2.key > > Note how we want to match two fields concatenated from one > table against > one field from another table. Doing this directly didn't > seem to work, so > we came up with the idea to use a view. This seems to bring > down that > server instance! The full SQL is below. (I can supply the > complete table > definition if needed). > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
