> I've spent a bit of time looking at this, and I want to
> propose the following patchset.

Sorry about this, but I missed to add a comment in one of the
test cases for 0004 that describes the behavior of parameters
and constants that live outside of the squashed list.

The following 2 cases will result in different queryId's because
the 4th constant/parameter will be jumbled either as a type Const
or type Param.

select from tab where a in (1, 2, 3) and b = 4

select from tab where a in ($1, $2, $3) and b = $4


--
Sami

Attachment: v6-0004-Support-Squashing-of-External-Parameters.patch
Description: Binary data

Attachment: v6-0002-Enhanced-query-jumbling-squashing-tests.patch
Description: Binary data

Attachment: v6-0003-Fix-Normalization-for-squashed-query-texts.patch
Description: Binary data

Attachment: v6-0001-Fix-broken-normalization-due-to-duplicate-constan.patch
Description: Binary data

Reply via email to