Re: Weird update where something != otherthing

Diogo Zulli wrote: > > Maybe this the correct behavior, but I am confused about > the statments below: > > CREATE TABLE testing ( fmsg CHAR(1) DEFAULT 'N' ); > INSERT INTO testing VALUES (NULL); > INSERT INTO testing VALUES ('Y'); > INSERT INTO testing VALUES ('X'); > INSERT INTO testing VALUE

Weird update where something != otherthing

Maybe this the correct behavior, but I am confused about the statments below: CREATE TABLE testing ( fmsg CHAR(1) DEFAULT 'N' ); INSERT INTO testing VALUES (NULL); INSERT INTO testing VALUES ('Y'); INSERT INTO testing VALUES ('X'); INSERT INTO testing VALUES ('Y'); INSERT INTO testing VALUES (