Skip to content

Commit b29c2da

Browse files
scrappyscrappy
committed
Trying to continue breaking down the large files into smaller tests so that
debugging is a little (well, alot!) easier
1 parent f9526f8 commit b29c2da

File tree

1 file changed

+0
-223
lines changed

1 file changed

+0
-223
lines changed

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

Lines changed: 0 additions & 223 deletions
Original file line numberDiff line numberDiff line change
@@ -1,129 +1,3 @@
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-
--
73-
-- btree index
74-
-- test retrieval of min/max keys for each
75-
--
76-
77-
SELECT b.*
78-
FROM bt_i4_heap b
79-
WHERE b.seqno < 1;
80-
81-
SELECT b.*
82-
FROM bt_i4_heap b
83-
WHERE b.seqno >= 9999;
84-
85-
SELECT b.*
86-
FROM bt_i4_heap b
87-
WHERE b.seqno = 4500;
88-
89-
SELECT b.*
90-
FROM bt_c16_heap b
91-
WHERE b.seqno < '1'::char16;
92-
93-
SELECT b.*
94-
FROM bt_c16_heap b
95-
WHERE b.seqno >= '9999'::char16;
96-
97-
SELECT b.*
98-
FROM bt_c16_heap b
99-
WHERE b.seqno = '4500'::char16;
100-
101-
SELECT b.*
102-
FROM bt_txt_heap b
103-
WHERE b.seqno < '1'::text;
104-
105-
SELECT b.*
106-
FROM bt_txt_heap b
107-
WHERE b.seqno >= '9999'::text;
108-
109-
SELECT b.*
110-
FROM bt_txt_heap b
111-
WHERE b.seqno = '4500'::text;
112-
113-
SELECT b.*
114-
FROM bt_f8_heap b
115-
WHERE b.seqno < '1'::float8;
116-
117-
SELECT b.*
118-
FROM bt_f8_heap b
119-
WHERE b.seqno >= '9999'::float8;
120-
121-
SELECT b.*
122-
FROM bt_f8_heap b
123-
WHERE b.seqno = '4500'::float8;
124-
125-
126-
1271
--
1282
-- replace
1293
--
@@ -171,103 +45,6 @@ DROP TABLE temp;
17145
-- SET age = age + 3
17246
-- WHERE name = 'linda';
17347

174-
175-
--
176-
-- HASH
177-
--
178-
UPDATE hash_i4_heap
179-
SET random = 1
180-
WHERE hash_i4_heap.seqno = 1492;
181-
182-
SELECT h.seqno AS i1492, h.random AS i1
183-
FROM hash_i4_heap h
184-
WHERE h.random = 1;
185-
186-
UPDATE hash_i4_heap
187-
SET seqno = 20000
188-
WHERE hash_i4_heap.random = 1492795354;
189-
190-
SELECT h.seqno AS i20000
191-
FROM hash_i4_heap h
192-
WHERE h.random = 1492795354;
193-
194-
UPDATE hash_c16_heap
195-
SET random = '0123456789abcdef'::char16
196-
WHERE hash_c16_heap.seqno = 6543;
197-
198-
SELECT h.seqno AS i6543, h.random AS c0_to_f
199-
FROM hash_c16_heap h
200-
WHERE h.random = '0123456789abcdef'::char16;
201-
202-
UPDATE hash_c16_heap
203-
SET seqno = 20000
204-
WHERE hash_c16_heap.random = '76652222'::char16;
205-
206-
--
207-
-- this is the row we just replaced; index scan should return zero rows
208-
--
209-
SELECT h.seqno AS emptyset
210-
FROM hash_c16_heap h
211-
WHERE h.random = '76652222'::char16;
212-
213-
UPDATE hash_txt_heap
214-
SET random = '0123456789abcdefghijklmnop'::text
215-
WHERE hash_txt_heap.seqno = 4002;
216-
217-
SELECT h.seqno AS i4002, h.random AS c0_to_p
218-
FROM hash_txt_heap h
219-
WHERE h.random = '0123456789abcdefghijklmnop'::text;
220-
221-
UPDATE hash_txt_heap
222-
SET seqno = 20000
223-
WHERE hash_txt_heap.random = '959363399'::text;
224-
225-
SELECT h.seqno AS t20000
226-
FROM hash_txt_heap h
227-
WHERE h.random = '959363399'::text;
228-
229-
UPDATE hash_f8_heap
230-
SET random = '-1234.1234'::float8
231-
WHERE hash_f8_heap.seqno = 8906;
232-
233-
SELECT h.seqno AS i8096, h.random AS f1234_1234
234-
FROM hash_f8_heap h
235-
WHERE h.random = '-1234.1234'::float8;
236-
237-
UPDATE hash_f8_heap
238-
SET seqno = 20000
239-
WHERE hash_f8_heap.random = '488912369'::float8;
240-
241-
SELECT h.seqno AS f20000
242-
FROM hash_f8_heap h
243-
WHERE h.random = '488912369'::float8;
244-
245-
-- UPDATE hash_ovfl_heap
246-
-- SET x = 1000
247-
-- WHERE x = 90;
248-
249-
-- this vacuums the index as well
250-
-- VACUUM hash_ovfl_heap;
251-
252-
-- SELECT count(*) AS i0 FROM hash_ovfl_heap
253-
-- WHERE x = 90;
254-
255-
-- SELECT count(*) AS i988 FROM hash_ovfl_heap
256-
-- WHERE x = 1000;
257-
258-
--
259-
-- append
260-
-- (is tested in create.source)
261-
--
262-
263-
--
264-
-- queries to plan and execute each plannode and execnode we have
265-
--
266-
267-
--
268-
-- builtin functions
269-
--
270-
27148
--
27249
-- copy
27350
--

0 commit comments

Comments
 (0)