On Mon, 27 Aug 2007 13:33:11 -0400, Dimitri Shvorob
>.. The warning is easy to reproduce, e.g. with
>create table test as select *
>WARNING: This CREATE TABLE statement recursively references the target
>table. A consequence of this is a possible data integrity problem.
>Normally, I would take a SAS warning seriously - ignoring this one, however,
>I've never really run into data integrity problems of any obvious,
My experience is the same.
>Can anyone offer insight, or a counter-example?
See http://support.sas.com/techsup/unotes/SN/012/012062.html for an explanation.
I would prefer to have such apparently (but not actually) recursive
references accepted in CREATE TABLE statements. To me, that's no different than
. . .
The cited note says that such "references used in update operations, can
return incorrect results", so they *should*be disallowed in UPDATE
statements. I'm not sure about DELETE and INSERT statements.