Skip to content

Commit ed0530c

Browse files
ildusildus
committed
fix zlib tests
1 parent 5fad6f3 commit ed0530c

File tree

1 file changed

+20
-22
lines changed

1 file changed

+20
-22
lines changed

‎src/test/regress/expected/create_cm_1.out

Lines changed: 20 additions & 22 deletions
Original file line numberDiff line numberDiff line change
@@ -20,15 +20,15 @@ CREATE ACCESS METHOD pglz1 TYPE COMPRESSION HANDLER pglzhandler;
2020
CREATE ACCESS METHOD pglz2 TYPE COMPRESSION HANDLER pglzhandler;
2121
CREATE TABLE cmaltertest (f1 TEXT COMPRESSION pglz2);
2222
SELECT acname, acattnum, acoptions FROM pg_attr_compression
23-
WHERE acrelid = 'cmaltertest'::regclass;
23+
WHERE acrelid = 'cmaltertest'::REGCLASS;
2424
acname | acattnum | acoptions
2525
--------+----------+-----------
2626
pglz2 | 1 |
2727
(1 row)
2828

2929
ALTER TABLE cmaltertest DROP COLUMN f1;
3030
SELECT acname, acattnum, acoptions FROM pg_attr_compression
31-
WHERE acrelid = 'cmaltertest'::regclass;
31+
WHERE acrelid = 'cmaltertest'::REGCLASS;
3232
acname | acattnum | acoptions
3333
--------+----------+-----------
3434
(0 rows)
@@ -59,7 +59,7 @@ SELECT pg_column_compression('cmaltertest', 'at1');
5959
(1 row)
6060

6161
SELECT acname, acattnum, acoptions FROM pg_attr_compression
62-
WHERE acrelid = 'cmaltertest'::regclass;
62+
WHERE acrelid = 'cmaltertest'::REGCLASS;
6363
acname | acattnum | acoptions
6464
--------+----------+-----------
6565
(0 rows)
@@ -125,15 +125,16 @@ CREATE TABLE cmtest(f1 TEXT);
125125
CREATE VIEW cmtest_deps AS
126126
SELECT classid, objsubid, refclassid, refobjsubid, deptype
127127
FROM pg_depend
128-
WHERE (refclassid = 4001 OR classid = 4001) AND
129-
(objid = 'cmtest'::regclass OR refobjid = 'cmtest'::regclass)
128+
WHERE (refclassid = 'pg_catalog.pg_attr_compression'::REGCLASS OR
129+
classid = 'pg_catalog.pg_attr_compression'::REGCLASS) AND
130+
(objid = 'cmtest'::REGCLASS OR refobjid = 'cmtest'::REGCLASS)
130131
ORDER by objid, refobjid;
131132
INSERT INTO cmtest VALUES(repeat('1234567890',1001));
132133
-- one normal dependency
133134
SELECT * FROM cmtest_deps;
134135
classid | objsubid | refclassid | refobjsubid | deptype
135136
---------+----------+------------+-------------+---------
136-
1259 | 1 | 4001 | 0 | n
137+
1259 | 1 | 4189 | 0 | n
137138
(1 row)
138139

139140
-- check decompression
@@ -177,8 +178,8 @@ SELECT pg_column_compression('cmtest', 'f1');
177178
SELECT * FROM cmtest_deps;
178179
classid | objsubid | refclassid | refobjsubid | deptype
179180
---------+----------+------------+-------------+---------
180-
1259 | 1 | 4001 | 0 | n
181-
4001 | 0 | 1259 | 1 | i
181+
1259 | 1 | 4189 | 0 | n
182+
4189 | 0 | 1259 | 1 | i
182183
(2 rows)
183184

184185
-- rewrite
@@ -196,15 +197,15 @@ SELECT length(f1) FROM cmtest;
196197
SELECT pg_column_compression('cmtest', 'f1');
197198
pg_column_compression
198199
-----------------------
199-
pglz2, pglz1
200+
pglz1, pglz2
200201
(1 row)
201202

202203
-- two internal dependencies
203204
SELECT * FROM cmtest_deps;
204205
classid | objsubid | refclassid | refobjsubid | deptype
205206
---------+----------+------------+-------------+---------
206-
4001 | 0 | 1259 | 1 | i
207-
4001 | 0 | 1259 | 1 | i
207+
4189 | 0 | 1259 | 1 | i
208+
4189 | 0 | 1259 | 1 | i
208209
(2 rows)
209210

210211
-- rewrite
@@ -230,7 +231,7 @@ SELECT pg_column_compression('cmtest', 'f1');
230231
SELECT * FROM cmtest_deps;
231232
classid | objsubid | refclassid | refobjsubid | deptype
232233
---------+----------+------------+-------------+---------
233-
1259 | 1 | 4001 | 0 | n
234+
1259 | 1 | 4189 | 0 | n
234235
(1 row)
235236

236237
-- no rewrites
@@ -243,9 +244,9 @@ INSERT INTO cmtest VALUES(repeat('1234567890',1006));
243244
SELECT * FROM cmtest_deps;
244245
classid | objsubid | refclassid | refobjsubid | deptype
245246
---------+----------+------------+-------------+---------
246-
1259 | 1 | 4001 | 0 | n
247-
4001 | 0 | 1259 | 1 | i
248-
4001 | 0 | 1259 | 1 | i
247+
1259 | 1 | 4189 | 0 | n
248+
4189 | 0 | 1259 | 1 | i
249+
4189 | 0 | 1259 | 1 | i
249250
(3 rows)
250251

251252
-- remove function and related event trigger
@@ -346,7 +347,7 @@ SELECT pg_column_compression('cmaltertest', 'f1');
346347
SELECT pg_column_compression('cmaltertest', 'f2');
347348
pg_column_compression
348349
-----------------------
349-
pglz, pglz2, pglz1
350+
pglz, pglz1, pglz2
350351
(1 row)
351352

352353
-- make pglz2 droppable
@@ -364,7 +365,7 @@ SELECT pg_column_compression('cmaltertest', 'f2');
364365
(1 row)
365366

366367
SELECT acname, acattnum, acoptions FROM pg_attr_compression
367-
WHERE acrelid = 'cmaltertest'::regclass OR acrelid = 'cmtest'::regclass;
368+
WHERE acrelid = 'cmaltertest'::REGCLASS OR acrelid = 'cmtest'::REGCLASS;
368369
acname | acattnum | acoptions
369370
--------+----------+-----------------------
370371
pglz1 | 1 |
@@ -380,13 +381,10 @@ CREATE TABLE zlibtest(f1 TEXT COMPRESSION zlib WITH (level 'best'));
380381
ERROR: not built with zlib support
381382
CREATE TABLE zlibtest(f1 TEXT COMPRESSION zlib);
382383
ALTER TABLE zlibtest
383-
ALTER COLUMN f1 SET COMPRESSION zlib WITH (level 'best_compression');
384+
ALTER COLUMN f1 SET COMPRESSION zlib WITH (level '9');
384385
ERROR: not built with zlib support
385386
ALTER TABLE zlibtest
386-
ALTER COLUMN f1 SET COMPRESSION zlib WITH (level 'best_speed');
387-
ERROR: not built with zlib support
388-
ALTER TABLE zlibtest
389-
ALTER COLUMN f1 SET COMPRESSION zlib WITH (level 'default');
387+
ALTER COLUMN f1 SET COMPRESSION zlib WITH (level '1');
390388
ERROR: not built with zlib support
391389
ALTER TABLE zlibtest
392390
ALTER COLUMN f1 SET COMPRESSION zlib WITH (dict 'one');

0 commit comments

Comments
 (0)