Isaac Raway <[EMAIL PROTECTED]> wrote: > > > > CREATE TABLE t1(a UNIQUE, b UNIQUE, c DEFAULT 3); > > INSERT INTO t1 VALUES(1,1,1); > > INSERT INTO t1 VALUES(2,2,2); > > REPLACE INTO t1(a,b) VALUES(1,2); > > SELECT c FROM t1; > > > >The statement sequence above should generate a single row of > >result. The current implementation returns 3. What would you > >have it return instead? > > > If I'm not mistaken the SELECT would actually return 3 twice: > > +-+ > |3| > +-+ > |3| > +-+ >
Try it. -- D. Richard Hipp <[EMAIL PROTECTED]>
