Gert,
The same thing happens when we do it directly, that is why we started
using the view in the first place:
for example:
select * from table1 as a, table2 as b
where a.k1+z.k2=b.complete_key
would just cause the DB to shut down in the same manner of the view we
sent you before.
Thank you,
Noah Silva
IS&T - Programmer Analyst
(215) 419 - 7916
"Grossmann, Gert" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/06/2003 07:18 AM
To: "'Noah J SILVA'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
cc:
Subject: RE: SQL Query bring down DB instance
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
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
