Thread

Re: triggers regression tests.

Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-01-12T04:52:01Z

> Are we sure the new expected/triggers.out is correct?

No.

> The query..
>
> QUERY: insert into fkeys values (70, '5', 1);
> and
> QUERY: insert into fkeys values (70, '5', 1);
>
> should be triggering...
>
> QUERY: create trigger check_fkeys_pkey_exist
>         before insert or update on fkeys
>         for each row
>         execute procedure
>         check_primary_key ('fkey1', 'fkey2', 'pkeys', 'pkey1', 'pkey2');
>
> and failing because 70 does not exist in pkeys.
>
> I think the old triggers.out was correct.
>
> Keith.
>
> BTW the results I'm getting now check OK against the old expected out file.
>     (CVS snapshot about 2 hours ago.)

Well, I'll try with a fresh snapshot. Don't know why I'm getting a different
result...

                                              - Tom