Re: Test for trigger condition accessing system attributes

On 10/05/18 11:58, Ashutosh Bapat wrote:
> Hi,
> I was investigating the cases when the system attributes are accessed
> beyond the scans. After investigating set_plan_references(), I thought
> that we never access system attributes beyond scans. This lead me to
> assume that EEOP_INNER/OUTER_SYSVAR are not needed since we do not
> access system attributes from an inner or outer slot. I removed the
> defintions and code using those and ran regression. All the tests
> passed. So, I was about to conclude that my assumption is correct. But
> then looking at TriggerEnabled() I realised that we also (ab?)use
> INNER/OUTER Vars for OLD/NEW tuples for trigger condition. If the WHEN
> condition in CREATE TRIGGER command refers to a system attribute, we
> will end up having INNER/OUTER var refering a system attribute, thus
> exercising code for EEOP_INNER/OUTER_SYSVAR.
> 
> Here's patch containing a testcase exercizing that code using
> EEOP_INNER/OUTER_SYSVAR.

Pushed with some small changes. Thanks!

- Heikki