NOT IN handled incorrectly with tuples for dialects that do not support tuple syntax

Description

Query:

update Entity set date = :now where id not in (:ids)

is translated to:

update Entity set date=? where (id1<>? and id2<>? or id3<>?) and (id1<>? and id2<>? or id3<>?)

Should be:

update Entity set date=? where (id1<>? or id2<>? or id3<>?) and (id1<>? or id2<>? or id3<>?)

Environment

None

Activity

Show:
Gail Badner
March 18, 2016, 1:01 AM

I could not reproduce this in 5.0 branch or master.

Assignee

Gail Badner

Reporter

Łukasz Kwestarz

Fix versions

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure