RE: SQL Anomaly?

Posted in 1996

Garrett Sienkiewicz — 3 Feb 96 00:08:17 -0800 — source: Informix-list mailing list archive (1991-1998)

>I ran into a problem with the following simple statement: > > delete from tmp_kontakt > where s_doknr in (select unique(s_doknr) from kontakt) One possibility is that s_doknr is a variable in the program that you have this select statement in, especially if it is a numeric variable. Assume it has a value of 1, your select statement evaluates to select unique(1) from kontaktwhich is a legal SQL statement. Garrett