Skip to content

Commit f9526f8

Browse files
scrappyscrappy
committed
clean up misc.source and create *individual test* files ... trying to move
away from one big massive confusing file
1 parent b63e57b commit f9526f8

File tree

4 files changed

+208
-1050
lines changed

4 files changed

+208
-1050
lines changed

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

Lines changed: 53 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,53 @@
1+
--
2+
-- btree index
3+
-- test retrieval of min/max keys for each
4+
--
5+
6+
SELECT b.*
7+
FROM bt_i4_heap b
8+
WHERE b.seqno < 1;
9+
10+
SELECT b.*
11+
FROM bt_i4_heap b
12+
WHERE b.seqno >= 9999;
13+
14+
SELECT b.*
15+
FROM bt_i4_heap b
16+
WHERE b.seqno = 4500;
17+
18+
SELECT b.*
19+
FROM bt_c16_heap b
20+
WHERE b.seqno < '1'::char16;
21+
22+
SELECT b.*
23+
FROM bt_c16_heap b
24+
WHERE b.seqno >= '9999'::char16;
25+
26+
SELECT b.*
27+
FROM bt_c16_heap b
28+
WHERE b.seqno = '4500'::char16;
29+
30+
SELECT b.*
31+
FROM bt_txt_heap b
32+
WHERE b.seqno < '1'::text;
33+
34+
SELECT b.*
35+
FROM bt_txt_heap b
36+
WHERE b.seqno >= '9999'::text;
37+
38+
SELECT b.*
39+
FROM bt_txt_heap b
40+
WHERE b.seqno = '4500'::text;
41+
42+
SELECT b.*
43+
FROM bt_f8_heap b
44+
WHERE b.seqno < '1'::float8;
45+
46+
SELECT b.*
47+
FROM bt_f8_heap b
48+
WHERE b.seqno >= '9999'::float8;
49+
50+
SELECT b.*
51+
FROM bt_f8_heap b
52+
WHERE b.seqno = '4500'::float8;
53+

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

Lines changed: 153 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,153 @@
1+
--
2+
-- hash index
3+
-- grep 843938989 hash.data
4+
--
5+
SELECT hash_i4_heap.*
6+
WHERE hash_i4_heap.random = 843938989;
7+
8+
--
9+
-- hash index
10+
-- grep 66766766 hash.data
11+
--
12+
SELECT hash_i4_heap.*
13+
WHERE hash_i4_heap.random = 66766766;
14+
15+
--
16+
-- hash index
17+
-- grep 1505703298 hash.data
18+
--
19+
SELECT hash_c16_heap.*
20+
WHERE hash_c16_heap.random = '1505703298'::char16;
21+
22+
--
23+
-- hash index
24+
-- grep 7777777 hash.data
25+
--
26+
SELECT hash_c16_heap.*
27+
WHERE hash_c16_heap.random = '7777777'::char16;
28+
29+
--
30+
-- hash index
31+
-- grep 1351610853 hash.data
32+
--
33+
SELECT hash_txt_heap.*
34+
WHERE hash_txt_heap.random = '1351610853'::text;
35+
36+
--
37+
-- hash index
38+
-- grep 111111112222222233333333 hash.data
39+
--
40+
SELECT hash_txt_heap.*
41+
WHERE hash_txt_heap.random = '111111112222222233333333'::text;
42+
43+
--
44+
-- hash index
45+
-- grep 444705537 hash.data
46+
--
47+
SELECT hash_f8_heap.*
48+
WHERE hash_f8_heap.random = '444705537'::float8;
49+
50+
--
51+
-- hash index
52+
-- grep 88888888 hash.data
53+
--
54+
SELECT hash_f8_heap.*
55+
WHERE hash_f8_heap.random = '88888888'::float8;
56+
57+
--
58+
-- hash index
59+
-- grep '^90[^0-9]' hashovfl.data
60+
--
61+
-- SELECT count(*) AS i988 FROM hash_ovfl_heap
62+
-- WHERE x = 90;
63+
64+
--
65+
-- hash index
66+
-- grep '^1000[^0-9]' hashovfl.data
67+
--
68+
-- SELECT count(*) AS i0 FROM hash_ovfl_heap
69+
-- WHERE x = 1000;
70+
71+
--
72+
-- HASH
73+
--
74+
UPDATE hash_i4_heap
75+
SET random = 1
76+
WHERE hash_i4_heap.seqno = 1492;
77+
78+
SELECT h.seqno AS i1492, h.random AS i1
79+
FROM hash_i4_heap h
80+
WHERE h.random = 1;
81+
82+
UPDATE hash_i4_heap
83+
SET seqno = 20000
84+
WHERE hash_i4_heap.random = 1492795354;
85+
86+
SELECT h.seqno AS i20000
87+
FROM hash_i4_heap h
88+
WHERE h.random = 1492795354;
89+
90+
UPDATE hash_c16_heap
91+
SET random = '0123456789abcdef'::char16
92+
WHERE hash_c16_heap.seqno = 6543;
93+
94+
SELECT h.seqno AS i6543, h.random AS c0_to_f
95+
FROM hash_c16_heap h
96+
WHERE h.random = '0123456789abcdef'::char16;
97+
98+
UPDATE hash_c16_heap
99+
SET seqno = 20000
100+
WHERE hash_c16_heap.random = '76652222'::char16;
101+
102+
--
103+
-- this is the row we just replaced; index scan should return zero rows
104+
--
105+
SELECT h.seqno AS emptyset
106+
FROM hash_c16_heap h
107+
WHERE h.random = '76652222'::char16;
108+
109+
UPDATE hash_txt_heap
110+
SET random = '0123456789abcdefghijklmnop'::text
111+
WHERE hash_txt_heap.seqno = 4002;
112+
113+
SELECT h.seqno AS i4002, h.random AS c0_to_p
114+
FROM hash_txt_heap h
115+
WHERE h.random = '0123456789abcdefghijklmnop'::text;
116+
117+
UPDATE hash_txt_heap
118+
SET seqno = 20000
119+
WHERE hash_txt_heap.random = '959363399'::text;
120+
121+
SELECT h.seqno AS t20000
122+
FROM hash_txt_heap h
123+
WHERE h.random = '959363399'::text;
124+
125+
UPDATE hash_f8_heap
126+
SET random = '-1234.1234'::float8
127+
WHERE hash_f8_heap.seqno = 8906;
128+
129+
SELECT h.seqno AS i8096, h.random AS f1234_1234
130+
FROM hash_f8_heap h
131+
WHERE h.random = '-1234.1234'::float8;
132+
133+
UPDATE hash_f8_heap
134+
SET seqno = 20000
135+
WHERE hash_f8_heap.random = '488912369'::float8;
136+
137+
SELECT h.seqno AS f20000
138+
FROM hash_f8_heap h
139+
WHERE h.random = '488912369'::float8;
140+
141+
-- UPDATE hash_ovfl_heap
142+
-- SET x = 1000
143+
-- WHERE x = 90;
144+
145+
-- this vacuums the index as well
146+
-- VACUUM hash_ovfl_heap;
147+
148+
-- SELECT count(*) AS i0 FROM hash_ovfl_heap
149+
-- WHERE x = 90;
150+
151+
-- SELECT count(*) AS i988 FROM hash_ovfl_heap
152+
-- WHERE x = 1000;
153+

0 commit comments

Comments
 (0)