Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitd1e6368

Browse files
author
Thomas G. Lockhart
committed
Clean up header for uniform appearance throughout tests.
1 parent67ac380 commitd1e6368

24 files changed

+53
-34
lines changed

‎src/test/regress/input/misc.source

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,6 @@
11
--
22
-- MISC
3+
--
34

45
--
56
-- BTREE

‎src/test/regress/sql/alter_table.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,5 @@
11
--
2+
-- ALTER_TABLE
23
-- add attribute
34
--
45

‎src/test/regress/sql/btree_index.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
--
2-
--btree index
3-
-- test retrieval of min/max keys for each
2+
--BTREE_INDEX
3+
-- test retrieval of min/max keys for each index
44
--
55

66
SELECT b.*

‎src/test/regress/sql/case.sql

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,5 @@
11
--
2-
-- case.sql
3-
--
2+
-- CASE
43
-- Test the case statement
54
--
65

‎src/test/regress/sql/errors.sql

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,6 @@
11
--
2-
--errors.source
2+
--ERRORS
33
--
4-
-- $Header: /cvsroot/pgsql/src/test/regress/sql/errors.sql,v 1.2 1997/05/22 00:17:24 scrappy Exp $
5-
64

75
-- bad in postquel, but ok in postsql
86
select1

‎src/test/regress/sql/hash_index.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,8 @@
11
--
2-
--hash index
2+
--HASH_INDEX
33
-- grep 843938989 hash.data
44
--
5+
56
SELECT hash_i4_heap.*
67
WHEREhash_i4_heap.random=843938989;
78

‎src/test/regress/sql/join.sql

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,5 @@
11
--
2-
-- join.sql
3-
--
2+
-- JOIN
43
-- Test join clauses
54
--
65

‎src/test/regress/sql/limit.sql

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,5 @@
11
--
2+
-- LIMIT
23
-- Check the LIMIT/OFFSET feature of SELECT
34
--
45

‎src/test/regress/sql/plpgsql.sql

Lines changed: 5 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,6 @@
1-
-- ************************************************************
2-
-- *
3-
-- * Tables for the patchfield test of PL/pgSQL
4-
-- *
5-
-- * $Header: /cvsroot/pgsql/src/test/regress/sql/plpgsql.sql,v 1.1 1998/10/01 03:38:45 scrappy Exp $
6-
-- *
7-
-- ************************************************************
1+
--
2+
-- PLPGSQL
3+
--
84

95
createtableRoom (
106
roomnochar(8),
@@ -104,7 +100,7 @@ create unique index PHone_name on PHone using btree (slotname bpchar_ops);
104100
-- * Trigger procedures and functions for the patchfield
105101
-- * test of PL/pgSQL
106102
-- *
107-
-- * $Header: /cvsroot/pgsql/src/test/regress/sql/plpgsql.sql,v 1.1 1998/10/01 03:38:45 scrappy Exp $
103+
-- * $Header: /cvsroot/pgsql/src/test/regress/sql/plpgsql.sql,v 1.2 2000/01/06 06:41:55 thomas Exp $
108104
-- *
109105
-- ************************************************************
110106

@@ -1404,3 +1400,4 @@ insert into HSlot values ('HS', 'base.hub1', 20, '');
14041400
deletefrom HSlot;
14051401
insert into IFacevalues ('IF','notthere','eth0','');
14061402
insert into IFacevalues ('IF','orion','ethernet_interface_name_too_long','');
1403+

‎src/test/regress/sql/portals.sql

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,7 @@
11
--
2-
--portal manipulation
2+
--PORTALS
33
--
4+
45
BEGIN;
56

67
DECLARE foo1 CURSOR FORSELECT*FROM tenk1;
@@ -166,3 +167,4 @@ CLOSE foo11;
166167
CLOSE foo12;
167168

168169
end;
170+

‎src/test/regress/sql/portals_p2.sql

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,7 @@
1+
--
2+
-- PORTALS_P2
3+
--
4+
15
-- EXTEND INDEX onek2_u1_prtl WHERE onek2.unique1 <= 60;
26

37
BEGIN;
@@ -94,3 +98,4 @@ CLOSE foo24;
9498
CLOSE foo25;
9599

96100
END;
101+

‎src/test/regress/sql/random.sql

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,8 @@
11
--
2-
-- test the random function
2+
-- RANDOM
3+
-- Test the random function
34
--
5+
46
-- count the number of tuples originally
57
SELECTcount(*)FROM onek;
68

‎src/test/regress/sql/rules.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
--
2-
--rules.sql
2+
--RULES
33
-- From Jan's original setup_ruletest.sql and run_ruletest.sql
44
-- - thomas 1998-09-13
55
--

‎src/test/regress/sql/select.sql

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,7 @@
11
--
2+
-- SELECT
3+
--
4+
25
-- btree index
36
-- awk '{if($1<10){print;}else{next;}}' onek.data | sort +0n -1
47
--

‎src/test/regress/sql/select_distinct.sql

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,7 @@
1+
--
2+
-- SELECT_DISTINCT
3+
--
4+
15
--
26
-- awk '{print $3;}' onek.data | sort -n | uniq
37
--
@@ -30,4 +34,3 @@ SELECT DISTINCT two, string4, ten
3034
--
3135
SELECT DISTINCTp.ageFROM person* pORDER BY age using>;
3236

33-

‎src/test/regress/sql/select_distinct_on.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
1-
21
--
3-
--test select distinct on
2+
--SELECT_DISTINCT_ON
43
--
4+
55
SELECT DISTINCTON string4 two, string4, ten
66
FROM tmp
77
ORDER BY two using<, string4 using<, ten using<;

‎src/test/regress/sql/select_having.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
--
2-
--select_having.sql
2+
--SELECT_HAVING
33
--
44

55
-- load test data
@@ -25,3 +25,4 @@ SELECT c, max(a) FROM test_having
2525
GROUP BY cHAVINGcount(*)>2ORmin(a)=max(a);
2626

2727
DROPTABLE test_having;
28+

‎src/test/regress/sql/select_implicit.sql

Lines changed: 2 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,10 @@
11
--
2-
-- select_implicit.sql
3-
--
2+
-- SELECT_IMPLICIT
43
-- Test cases for queries with ordering terms missing from the target list.
54
-- This used to be called "junkfilter.sql".
65
-- The parser uses the term "resjunk" to handle these cases.
76
-- - thomas 1998-07-09
7+
--
88

99
-- load test data
1010
CREATETABLEtest_missing_target (aint, bint, cchar(8), dchar);
@@ -149,4 +149,3 @@ DROP TABLE test_missing_target;
149149
DROPTABLE test_missing_target2;
150150
DROPTABLE test_missing_target3;
151151

152-

‎src/test/regress/sql/select_into.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,3 +1,7 @@
1+
--
2+
-- SELECT_INTO
3+
--
4+
15
SELECT*
26
INTO TABLE tmp1
37
FROM tmp

‎src/test/regress/sql/select_views.sql

Lines changed: 3 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,8 @@
11
--
2-
-- VIEW queries
3-
--
4-
-- test the views defined in create.source
2+
-- SELECT_VIEWS
3+
-- test the views defined in CREATE_VIEWS
54
--
5+
66
SELECT*FROM street;
77

88
SELECT name,#thepath FROM iexit ORDER BY 1, 2;

‎src/test/regress/sql/subselect.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
--
2-
--Subselects
2+
--SUBSELECT
33
--
44

55
SELECT1AS oneWHERE1IN (SELECT1);

‎src/test/regress/sql/temp.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,5 @@
11
--
2+
-- TEMP
23
-- Test temp relations and indexes
34
--
45

@@ -45,3 +46,4 @@ CREATE TEMP TABLE temptest(col int);
4546
\c regression
4647

4748
SELECT*FROM temptest;
49+

‎src/test/regress/sql/transactions.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,7 @@
11
--
2-
--transaction blocks
2+
--TRANSACTIONS
33
--
4+
45
BEGIN;
56

67
SELECT*

‎src/test/regress/sql/union.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
--
2-
--union.sql
2+
--UNION
33
--
44

55
-- Simple UNION constructs

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp