[Info-ingres] The IN list of death

[Martin Bowes]

Hi All,

On II 11.0.0 (a64.lnx/100) p15330.

This was unexpected...
sql iidbdb << SQL_END > $SQL_LOG
create table dummy(
        unit_id integer4 not null not default,
        unit_status integer4 not null not default,
        changed_when ingresdate not null not default
) with nojournaling;

modify dummy to btree unique on unit_id;

insert into dummy values
        (1, 0, 'now'), (2, 0, 'now'), (3, 0, 'now');
\p\g
update dummy
set unit_status = 1, changed_when = date('now')
where unit_id in ((1, 2, 3));
\p\g
rollback
\p\g
\q
SQL_END

This gave an E_OP0082 and a stack dump.

The problem is the spare set of brackets in the IN list.

Curiously if the double bracketed list contains a single element then its fine!

Marty
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20190221/a9feb8f1/attachment.html>