|
Sorry for hitting the send key too
fast...
If I create a table with a cascade delete
referential integrity (foreign key), it shows as "on delete restrict", but it
does the cascade...
On another note:
create table TBL_PROPERTIES (
NAME varchar(64)
key,
TYPE varchar(16) not
null,
DEFAULT_VALUE
varchar(255)
)
create table TBL_USER_PROPERTIES (
USER varchar(64)
key,
PROPERTY_NAME varchar(64) key
references TBL_PROPERTIES on delete cascade,
PROPERTY_VALUE
varchar(255)
) The following query does not work:
select NAME, TYPE, PROPERTY_VALUE,
DEFAULT_VALUE
from TBL_PROPERTIES left outer join
TBL_USER_PROPERTIES
on NAME=PROPERTY_NAME and LOGIN='xxx'
but this works:
select NAME, TYPE, PROPERTY_VALUE,
DEFAULT_VALUE
from TBL_USER_PROPERTIES right outer join
TBL_PROPERTIES
on PROPERTY_NAME=NAME and LOGIN='xxx'
This appears to be an undocumented limitation of
the outer join... but there is an easy work around...
|
- RE: Small bug in SQL Studio (resend) Benoit Menendez
- RE: Small bug in SQL Studio (resend) Stausberg, Markus
