<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/postgresql.git/src/test/regress/expected/text.out, branch master</title>
<subtitle>git.postgresql.org: git/postgresql.git
</subtitle>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/'/>
<entry>
<title>Rearrange core regression tests to reduce cross-script dependencies.</title>
<updated>2022-02-08T20:30:38+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2022-02-08T20:30:38+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=cc50080a828dd4791b43539f5a0f976e535d147c'/>
<id>cc50080a828dd4791b43539f5a0f976e535d147c</id>
<content type='text'>
The idea behind this patch is to make it possible to run individual
test scripts without running the entire core test suite.  Making all
the scripts completely independent would involve a massive rewrite,
and would probably be worse for coverage of things like concurrent DDL.
So this patch just does what seems practical with limited changes.

The net effect is that any test script can be run after running
limited earlier dependencies:
* all scripts depend on test_setup
* many scripts depend on create_index
* other dependencies are few in number, and are documented in
  the parallel_schedule file.

To accomplish this, I chose a small number of commonly-used tables
and moved their creation and filling into test_setup.  Later scripts
are expected not to modify these tables' data contents, for fear of
affecting other scripts' results.  Also, our former habit of declaring
all C functions in one place is now gone in favor of declaring them
where they're used, if that's just one script, or in test_setup if
necessary.

There's more that could be done to remove some of the remaining
inter-script dependencies, but significantly more-invasive changes
would be needed, and at least for now it doesn't seem worth it.

Discussion: https://postgr.es/m/1114748.1640383217@sss.pgh.pa.us
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
The idea behind this patch is to make it possible to run individual
test scripts without running the entire core test suite.  Making all
the scripts completely independent would involve a massive rewrite,
and would probably be worse for coverage of things like concurrent DDL.
So this patch just does what seems practical with limited changes.

The net effect is that any test script can be run after running
limited earlier dependencies:
* all scripts depend on test_setup
* many scripts depend on create_index
* other dependencies are few in number, and are documented in
  the parallel_schedule file.

To accomplish this, I chose a small number of commonly-used tables
and moved their creation and filling into test_setup.  Later scripts
are expected not to modify these tables' data contents, for fear of
affecting other scripts' results.  Also, our former habit of declaring
all C functions in one place is now gone in favor of declaring them
where they're used, if that's just one script, or in test_setup if
necessary.

There's more that could be done to remove some of the remaining
inter-script dependencies, but significantly more-invasive changes
would be needed, and at least for now it doesn't seem worth it.

Discussion: https://postgr.es/m/1114748.1640383217@sss.pgh.pa.us
</pre>
</div>
</content>
</entry>
<entry>
<title>Clean up ancient test style</title>
<updated>2020-12-15T21:03:39+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter@eisentraut.org</email>
</author>
<published>2020-12-15T20:54:06+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=c06d6aa4c35177655e0fd4acaca888a73c3f9845'/>
<id>c06d6aa4c35177655e0fd4acaca888a73c3f9845</id>
<content type='text'>
Many older tests where written in a style like

    SELECT '' AS two, i.* FROM INT2_TBL

where the first column indicated the number of expected result rows.
This has gotten increasingly out of date, as the test data fixtures
have expanded, so a lot of these were wrong and misleading.  Moreover,
this style isn't really necessary, since the psql output already shows
the number of result rows.

To clean this up, remove all those extra columns.

Discussion: https://www.postgresql.org/message-id/flat/1a25312b-2686-380d-3c67-7a69094a999f%40enterprisedb.com
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Many older tests where written in a style like

    SELECT '' AS two, i.* FROM INT2_TBL

where the first column indicated the number of expected result rows.
This has gotten increasingly out of date, as the test data fixtures
have expanded, so a lot of these were wrong and misleading.  Moreover,
this style isn't really necessary, since the psql output already shows
the number of result rows.

To clean this up, remove all those extra columns.

Discussion: https://www.postgresql.org/message-id/flat/1a25312b-2686-380d-3c67-7a69094a999f%40enterprisedb.com
</pre>
</div>
</content>
</entry>
<entry>
<title>Improve plural handling in error message</title>
<updated>2017-08-23T17:56:59+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter_e@gmx.net</email>
</author>
<published>2017-08-23T17:56:59+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=237a0b87b1dc90f8789aa5441a2a11e67f46c96e'/>
<id>237a0b87b1dc90f8789aa5441a2a11e67f46c96e</id>
<content type='text'>
This does not use the normal plural handling, because no numbers appear
in the actual message.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This does not use the normal plural handling, because no numbers appear
in the actual message.
</pre>
</div>
</content>
</entry>
<entry>
<title>Make format() error messages consistent again</title>
<updated>2016-08-08T12:15:41+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter_e@gmx.net</email>
</author>
<published>2016-08-08T12:15:41+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=8a56d4e361d4566ce5d6b55f25c3f23aa44f4741'/>
<id>8a56d4e361d4566ce5d6b55f25c3f23aa44f4741</id>
<content type='text'>
07d25a964 changed only one occurrence.  Change the other one as well.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
07d25a964 changed only one occurrence.  Change the other one as well.
</pre>
</div>
</content>
</entry>
<entry>
<title>Improve error reporting in format()</title>
<updated>2016-02-11T15:11:11+00:00</updated>
<author>
<name>Teodor Sigaev</name>
<email>teodor@sigaev.ru</email>
</author>
<published>2016-02-11T15:11:11+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=07d25a964b2fb78169a4a34c6f6893736f69903a'/>
<id>07d25a964b2fb78169a4a34c6f6893736f69903a</id>
<content type='text'>
Clarify invalid format conversion type error message and add hint.

Author: Jim Nasby
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Clarify invalid format conversion type error message and add hint.

Author: Jim Nasby
</pre>
</div>
</content>
</entry>
<entry>
<title>Move checking an explicit VARIADIC "any" argument into the parser.</title>
<updated>2013-07-18T15:52:12+00:00</updated>
<author>
<name>Andrew Dunstan</name>
<email>andrew@dunslane.net</email>
</author>
<published>2013-07-18T15:52:12+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=d26888bc4d1e539a82f21382b0000fe5bbf889d9'/>
<id>d26888bc4d1e539a82f21382b0000fe5bbf889d9</id>
<content type='text'>
This is more efficient and simpler . It does mean that an untyped NULL
can no longer be used in such cases, which should be mentioned in
Release Notes, but doesn't seem a terrible loss. The workaround is to
cast the NULL to some array type.

Pavel Stehule, reviewed by Jeevan Chalke.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This is more efficient and simpler . It does mean that an untyped NULL
can no longer be used in such cases, which should be mentioned in
Release Notes, but doesn't seem a terrible loss. The workaround is to
cast the NULL to some array type.

Pavel Stehule, reviewed by Jeevan Chalke.
</pre>
</div>
</content>
</entry>
<entry>
<title>Extend format() to handle field width and left/right alignment.</title>
<updated>2013-03-15T02:56:56+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2013-03-15T02:56:56+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=73e7025bd8eed941a068f0a7a71e02dca8d38d1c'/>
<id>73e7025bd8eed941a068f0a7a71e02dca8d38d1c</id>
<content type='text'>
This change adds some more standard sprintf() functionality to format().

Pavel Stehule, reviewed by Dean Rasheed and Kyotaro Horiguchi
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This change adds some more standard sprintf() functionality to format().

Pavel Stehule, reviewed by Dean Rasheed and Kyotaro Horiguchi
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix concat() and format() to handle VARIADIC-labeled arguments correctly.</title>
<updated>2013-01-25T05:19:56+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2013-01-25T05:19:18+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=760f3c043ad4ee622b596d005ec31bb5e0322c4a'/>
<id>760f3c043ad4ee622b596d005ec31bb5e0322c4a</id>
<content type='text'>
Previously, the VARIADIC labeling was effectively ignored, but now these
functions act as though the array elements had all been given as separate
arguments.

Pavel Stehule
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Previously, the VARIADIC labeling was effectively ignored, but now these
functions act as though the array elements had all been given as separate
arguments.

Pavel Stehule
</pre>
</div>
</content>
</entry>
<entry>
<title>Message style improvements</title>
<updated>2011-07-08T04:37:04+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter_e@gmx.net</email>
</author>
<published>2011-07-08T04:37:04+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=f05c65090a964b30135236a90fc85986e0ca56a6'/>
<id>f05c65090a964b30135236a90fc85986e0ca56a6</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Message style tweaks</title>
<updated>2011-07-04T21:01:35+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter_e@gmx.net</email>
</author>
<published>2011-07-04T21:01:35+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=27af66162baed6a964466b92902accebdd5ae7c7'/>
<id>27af66162baed6a964466b92902accebdd5ae7c7</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
