Alex Peshkov wrote:

> I think that before talking about implementation details it's good to
> decide what we want from that implementation.
>
> An example:
>
> create table t(f1 int, f2 int, f3 int);
> commit;
> insert into t values(1, 2, 2);
> insert into t values(1, 3, 3);
> REPLACE INTO t(f1, f2) VALUES(1, 4) MATCHING(f1) RETURNING(f1, f2, f3);
>
> What will be returned in singleton case - 1,4,2 or 1,4,3 ?
>

Statement failed, SQLCODE = -811
multiple rows in singleton select


Adriano