Hi All,

Just wondering if someone could give me an indication as to how to create a
new regression test, for the ADD UNIQUE stuff I did?

I intend to do a regression test during the beta, and try to produce a patch
that addresses some of the concerns Tom had with the code.

Cheers,

Chris


Wed, 17 Oct 2001 09:41:05 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Making regression tests
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Just wondering if someone could give me an indication as to how to create a
> new regression test, for the ADD UNIQUE stuff I did?

It's not hard.  Make a file in src/test/regress/sql containing test
queries, and one in src/test/regress/sql/expected containing the
expected output (which is just the *actual* output, after you've
checked it over).  Add the test name to src/test/regress/serial_schedule
and src/test/regress/parallel_schedule.

If your test needs to cater for platform-dependent source or output
then things are a little harder, but I don't see why an ADD UNIQUE
test would need that.

Actually, I don't see why you wouldn't just add some more test queries
to src/test/regress/sql/alter_table.sql and corresponding output to
src/test/regress/expected/alter_table.out.  But if you really want
a separate test file, the two _schedule files are the places that
need to know about it.

			regards, tom lane

Wed, 17 Oct 2001 01:25:36 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Making regression tests 