delta/postgresql.git/src/test/regress/sql/name.sql, branch master

Clean up ancient test style

2020-12-15T21:03:39+00:00

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

Introduce parse_ident()

2016-03-18T15:16:14+00:00

SQL-layer function to split qualified identifier into array parts.

Author: Pavel Stehule with minor editorization by me and Jim Nasby

Add a "USING" clause to DELETE, which is equivalent to the FROM clause

2005-04-07T01:51:41+00:00

in UPDATE. We also now issue a NOTICE if a query has _any_ implicit
range table entries -- in the past, we would only warn about implicit
RTEs in SELECTs with at least one explicit RTE.

As a result of the warning change, 25 of the regression tests had to
be updated. I also took the opportunity to remove some bogus whitespace
differences between some of the float4 and float8 variants. I believe
I have correctly updated all the platform-specific variants, but let
me know if that's not the case.

Original patch for DELETE ... USING from Euler Taveira de Oliveira,
reworked by Neil Conway.

Changes to documentation and the regression tests for the default

2002-09-07T18:39:05+00:00

NAMEDATALEN of 64.

Kris Jurka

Change NAMEDATALEN to 64, INDEX_MAX_KEYS/MAX_FUNC_ARGS to 32, per discussion on hackers.

2002-08-13T20:40:44+00:00

Clean up syntax to use SQL92-ish type coersion

2000-01-04T16:21:02+00:00

 rather than the Postgres "::" notation.
All of these tests have been completely inspected and give correct results.

Add Darren's char2-16 files.

1998-04-27T13:50:03+00:00

Remove name.* files.

1998-04-08T02:32:52+00:00

Back out char2-char16 removal. Add later.

1998-04-07T18:14:38+00:00

Merge rename name page into alter table. Fix UNION with DISTINCT

1998-03-31T04:44:35+00:00

or ORDER BY bug.