diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/interval.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/interval.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/interval.out 2024-04-02 00:56:34.470201000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/interval.out 2024-04-02 00:59:54.113276000 +0000 @@ -12,46 +12,10 @@ ( '10:55:08' ), ( '178000000 years' ) ; -CREATE INDEX idx_interval ON test_interval USING gin (i); -SELECT * FROM test_interval WHERE i<'08:55:08'::interval ORDER BY i; - i --------------------------- - @ 178000000 years ago - @ 3 hours 55 mins 8 secs - @ 4 hours 55 mins 8 secs - @ 5 hours 55 mins 8 secs -(4 rows) - -SELECT * FROM test_interval WHERE i<='08:55:08'::interval ORDER BY i; - i --------------------------- - @ 178000000 years ago - @ 3 hours 55 mins 8 secs - @ 4 hours 55 mins 8 secs - @ 5 hours 55 mins 8 secs - @ 8 hours 55 mins 8 secs -(5 rows) - -SELECT * FROM test_interval WHERE i='08:55:08'::interval ORDER BY i; - i --------------------------- - @ 8 hours 55 mins 8 secs -(1 row) - -SELECT * FROM test_interval WHERE i>='08:55:08'::interval ORDER BY i; - i ---------------------------- - @ 8 hours 55 mins 8 secs - @ 9 hours 55 mins 8 secs - @ 10 hours 55 mins 8 secs - @ 178000000 years -(4 rows) - -SELECT * FROM test_interval WHERE i>'08:55:08'::interval ORDER BY i; - i ---------------------------- - @ 9 hours 55 mins 8 secs - @ 10 hours 55 mins 8 secs - @ 178000000 years -(3 rows) - +WARNING: terminating connection because of crash of another server process +DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. +HINT: In a moment you should be able to reconnect to the database and repeat your command. +server closed the connection unexpectedly + This probably means the server terminated abnormally + before or while processing the request. +connection to server was lost diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/macaddr.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/macaddr.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/macaddr.out 2024-04-02 00:56:34.470245000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/macaddr.out 2024-04-02 00:59:54.122148000 +0000 @@ -1,51 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_macaddr ( - i macaddr -); -INSERT INTO test_macaddr VALUES - ( '22:00:5c:03:55:08' ), - ( '22:00:5c:04:55:08' ), - ( '22:00:5c:05:55:08' ), - ( '22:00:5c:08:55:08' ), - ( '22:00:5c:09:55:08' ), - ( '22:00:5c:10:55:08' ) -; -CREATE INDEX idx_macaddr ON test_macaddr USING gin (i); -SELECT * FROM test_macaddr WHERE i<'22:00:5c:08:55:08'::macaddr ORDER BY i; - i -------------------- - 22:00:5c:03:55:08 - 22:00:5c:04:55:08 - 22:00:5c:05:55:08 -(3 rows) - -SELECT * FROM test_macaddr WHERE i<='22:00:5c:08:55:08'::macaddr ORDER BY i; - i -------------------- - 22:00:5c:03:55:08 - 22:00:5c:04:55:08 - 22:00:5c:05:55:08 - 22:00:5c:08:55:08 -(4 rows) - -SELECT * FROM test_macaddr WHERE i='22:00:5c:08:55:08'::macaddr ORDER BY i; - i -------------------- - 22:00:5c:08:55:08 -(1 row) - -SELECT * FROM test_macaddr WHERE i>='22:00:5c:08:55:08'::macaddr ORDER BY i; - i -------------------- - 22:00:5c:08:55:08 - 22:00:5c:09:55:08 - 22:00:5c:10:55:08 -(3 rows) - -SELECT * FROM test_macaddr WHERE i>'22:00:5c:08:55:08'::macaddr ORDER BY i; - i -------------------- - 22:00:5c:09:55:08 - 22:00:5c:10:55:08 -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/macaddr8.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/macaddr8.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/macaddr8.out 2024-04-02 00:56:34.470290000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/macaddr8.out 2024-04-02 00:59:54.130817000 +0000 @@ -1,51 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_macaddr8 ( - i macaddr8 -); -INSERT INTO test_macaddr8 VALUES - ( '22:00:5c:03:55:08:01:02' ), - ( '22:00:5c:04:55:08:01:02' ), - ( '22:00:5c:05:55:08:01:02' ), - ( '22:00:5c:08:55:08:01:02' ), - ( '22:00:5c:09:55:08:01:02' ), - ( '22:00:5c:10:55:08:01:02' ) -; -CREATE INDEX idx_macaddr8 ON test_macaddr8 USING gin (i); -SELECT * FROM test_macaddr8 WHERE i<'22:00:5c:08:55:08:01:02'::macaddr8 ORDER BY i; - i -------------------------- - 22:00:5c:03:55:08:01:02 - 22:00:5c:04:55:08:01:02 - 22:00:5c:05:55:08:01:02 -(3 rows) - -SELECT * FROM test_macaddr8 WHERE i<='22:00:5c:08:55:08:01:02'::macaddr8 ORDER BY i; - i -------------------------- - 22:00:5c:03:55:08:01:02 - 22:00:5c:04:55:08:01:02 - 22:00:5c:05:55:08:01:02 - 22:00:5c:08:55:08:01:02 -(4 rows) - -SELECT * FROM test_macaddr8 WHERE i='22:00:5c:08:55:08:01:02'::macaddr8 ORDER BY i; - i -------------------------- - 22:00:5c:08:55:08:01:02 -(1 row) - -SELECT * FROM test_macaddr8 WHERE i>='22:00:5c:08:55:08:01:02'::macaddr8 ORDER BY i; - i -------------------------- - 22:00:5c:08:55:08:01:02 - 22:00:5c:09:55:08:01:02 - 22:00:5c:10:55:08:01:02 -(3 rows) - -SELECT * FROM test_macaddr8 WHERE i>'22:00:5c:08:55:08:01:02'::macaddr8 ORDER BY i; - i -------------------------- - 22:00:5c:09:55:08:01:02 - 22:00:5c:10:55:08:01:02 -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/inet.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/inet.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/inet.out 2024-04-02 00:56:34.470019000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/inet.out 2024-04-02 00:59:54.139290000 +0000 @@ -1,51 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_inet ( - i inet -); -INSERT INTO test_inet VALUES - ( '1.2.3.4/16' ), - ( '1.2.4.4/16' ), - ( '1.2.5.4/16' ), - ( '1.2.6.4/16' ), - ( '1.2.7.4/16' ), - ( '1.2.8.4/16' ) -; -CREATE INDEX idx_inet ON test_inet USING gin (i); -SELECT * FROM test_inet WHERE i<'1.2.6.4/16'::inet ORDER BY i; - i ------------- - 1.2.3.4/16 - 1.2.4.4/16 - 1.2.5.4/16 -(3 rows) - -SELECT * FROM test_inet WHERE i<='1.2.6.4/16'::inet ORDER BY i; - i ------------- - 1.2.3.4/16 - 1.2.4.4/16 - 1.2.5.4/16 - 1.2.6.4/16 -(4 rows) - -SELECT * FROM test_inet WHERE i='1.2.6.4/16'::inet ORDER BY i; - i ------------- - 1.2.6.4/16 -(1 row) - -SELECT * FROM test_inet WHERE i>='1.2.6.4/16'::inet ORDER BY i; - i ------------- - 1.2.6.4/16 - 1.2.7.4/16 - 1.2.8.4/16 -(3 rows) - -SELECT * FROM test_inet WHERE i>'1.2.6.4/16'::inet ORDER BY i; - i ------------- - 1.2.7.4/16 - 1.2.8.4/16 -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/cidr.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/cidr.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/cidr.out 2024-04-02 00:56:34.469785000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/cidr.out 2024-04-02 00:59:54.147068000 +0000 @@ -1,51 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_cidr ( - i cidr -); -INSERT INTO test_cidr VALUES - ( '1.2.3.4' ), - ( '1.2.4.4' ), - ( '1.2.5.4' ), - ( '1.2.6.4' ), - ( '1.2.7.4' ), - ( '1.2.8.4' ) -; -CREATE INDEX idx_cidr ON test_cidr USING gin (i); -SELECT * FROM test_cidr WHERE i<'1.2.6.4'::cidr ORDER BY i; - i ------------- - 1.2.3.4/32 - 1.2.4.4/32 - 1.2.5.4/32 -(3 rows) - -SELECT * FROM test_cidr WHERE i<='1.2.6.4'::cidr ORDER BY i; - i ------------- - 1.2.3.4/32 - 1.2.4.4/32 - 1.2.5.4/32 - 1.2.6.4/32 -(4 rows) - -SELECT * FROM test_cidr WHERE i='1.2.6.4'::cidr ORDER BY i; - i ------------- - 1.2.6.4/32 -(1 row) - -SELECT * FROM test_cidr WHERE i>='1.2.6.4'::cidr ORDER BY i; - i ------------- - 1.2.6.4/32 - 1.2.7.4/32 - 1.2.8.4/32 -(3 rows) - -SELECT * FROM test_cidr WHERE i>'1.2.6.4'::cidr ORDER BY i; - i ------------- - 1.2.7.4/32 - 1.2.8.4/32 -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/text.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/text.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/text.out 2024-04-02 00:56:34.470508000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/text.out 2024-04-02 00:59:54.152286000 +0000 @@ -1,44 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_text ( - i text -); -INSERT INTO test_text VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz'); -CREATE INDEX idx_text ON test_text USING gin (i); -SELECT * FROM test_text WHERE i<'abc' ORDER BY i; - i ------ - a - ab - abb -(3 rows) - -SELECT * FROM test_text WHERE i<='abc' ORDER BY i; - i ------ - a - ab - abb - abc -(4 rows) - -SELECT * FROM test_text WHERE i='abc' ORDER BY i; - i ------ - abc -(1 row) - -SELECT * FROM test_text WHERE i>='abc' ORDER BY i; - i ------ - abc - axy - xyz -(3 rows) - -SELECT * FROM test_text WHERE i>'abc' ORDER BY i; - i ------ - axy - xyz -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/varchar.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/varchar.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/varchar.out 2024-04-02 00:56:34.470867000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/varchar.out 2024-04-02 00:59:54.175295000 +0000 @@ -1,44 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_varchar ( - i varchar -); -INSERT INTO test_varchar VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz'); -CREATE INDEX idx_varchar ON test_varchar USING gin (i); -SELECT * FROM test_varchar WHERE i<'abc'::varchar ORDER BY i; - i ------ - a - ab - abb -(3 rows) - -SELECT * FROM test_varchar WHERE i<='abc'::varchar ORDER BY i; - i ------ - a - ab - abb - abc -(4 rows) - -SELECT * FROM test_varchar WHERE i='abc'::varchar ORDER BY i; - i ------ - abc -(1 row) - -SELECT * FROM test_varchar WHERE i>='abc'::varchar ORDER BY i; - i ------ - abc - axy - xyz -(3 rows) - -SELECT * FROM test_varchar WHERE i>'abc'::varchar ORDER BY i; - i ------ - axy - xyz -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/char.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/char.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/char.out 2024-04-02 00:56:34.469741000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/char.out 2024-04-02 00:59:54.196736000 +0000 @@ -1,44 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_char ( - i "char" -); -INSERT INTO test_char VALUES ('a'),('b'),('c'),('d'),('e'),('f'); -CREATE INDEX idx_char ON test_char USING gin (i); -SELECT * FROM test_char WHERE i<'d'::"char" ORDER BY i; - i ---- - a - b - c -(3 rows) - -SELECT * FROM test_char WHERE i<='d'::"char" ORDER BY i; - i ---- - a - b - c - d -(4 rows) - -SELECT * FROM test_char WHERE i='d'::"char" ORDER BY i; - i ---- - d -(1 row) - -SELECT * FROM test_char WHERE i>='d'::"char" ORDER BY i; - i ---- - d - e - f -(3 rows) - -SELECT * FROM test_char WHERE i>'d'::"char" ORDER BY i; - i ---- - e - f -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bytea.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/bytea.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bytea.out 2024-04-02 00:56:34.469700000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/bytea.out 2024-04-02 00:59:54.221684000 +0000 @@ -1,46 +1,2 @@ -set enable_seqscan=off; --- ensure consistent test output regardless of the default bytea format -SET bytea_output TO escape; -CREATE TABLE test_bytea ( - i bytea -); -INSERT INTO test_bytea VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz'); -CREATE INDEX idx_bytea ON test_bytea USING gin (i); -SELECT * FROM test_bytea WHERE i<'abc'::bytea ORDER BY i; - i ------ - a - ab - abb -(3 rows) - -SELECT * FROM test_bytea WHERE i<='abc'::bytea ORDER BY i; - i ------ - a - ab - abb - abc -(4 rows) - -SELECT * FROM test_bytea WHERE i='abc'::bytea ORDER BY i; - i ------ - abc -(1 row) - -SELECT * FROM test_bytea WHERE i>='abc'::bytea ORDER BY i; - i ------ - abc - axy - xyz -(3 rows) - -SELECT * FROM test_bytea WHERE i>'abc'::bytea ORDER BY i; - i ------ - axy - xyz -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bit.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/bit.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bit.out 2024-04-02 00:56:34.469528000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/bit.out 2024-04-02 00:59:54.227942000 +0000 @@ -1,44 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_bit ( - i bit(3) -); -INSERT INTO test_bit VALUES ('001'),('010'),('011'),('100'),('101'),('110'); -CREATE INDEX idx_bit ON test_bit USING gin (i); -SELECT * FROM test_bit WHERE i<'100'::bit(3) ORDER BY i; - i ------ - 001 - 010 - 011 -(3 rows) - -SELECT * FROM test_bit WHERE i<='100'::bit(3) ORDER BY i; - i ------ - 001 - 010 - 011 - 100 -(4 rows) - -SELECT * FROM test_bit WHERE i='100'::bit(3) ORDER BY i; - i ------ - 100 -(1 row) - -SELECT * FROM test_bit WHERE i>='100'::bit(3) ORDER BY i; - i ------ - 100 - 101 - 110 -(3 rows) - -SELECT * FROM test_bit WHERE i>'100'::bit(3) ORDER BY i; - i ------ - 101 - 110 -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/varbit.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/varbit.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/varbit.out 2024-04-02 00:56:34.470824000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/varbit.out 2024-04-02 00:59:54.239928000 +0000 @@ -1,44 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_varbit ( - i varbit -); -INSERT INTO test_varbit VALUES ('001'),('010'),('011'),('100'),('101'),('110'); -CREATE INDEX idx_varbit ON test_varbit USING gin (i); -SELECT * FROM test_varbit WHERE i<'100'::varbit ORDER BY i; - i ------ - 001 - 010 - 011 -(3 rows) - -SELECT * FROM test_varbit WHERE i<='100'::varbit ORDER BY i; - i ------ - 001 - 010 - 011 - 100 -(4 rows) - -SELECT * FROM test_varbit WHERE i='100'::varbit ORDER BY i; - i ------ - 100 -(1 row) - -SELECT * FROM test_varbit WHERE i>='100'::varbit ORDER BY i; - i ------ - 100 - 101 - 110 -(3 rows) - -SELECT * FROM test_varbit WHERE i>'100'::varbit ORDER BY i; - i ------ - 101 - 110 -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/numeric.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/numeric.out 2024-04-02 00:56:34.470425000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/numeric.out 2024-04-02 00:59:54.249554000 +0000 @@ -1,44 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_numeric ( - i numeric -); -INSERT INTO test_numeric VALUES (-2),(-1),(0),(1),(2),(3); -CREATE INDEX idx_numeric ON test_numeric USING gin (i); -SELECT * FROM test_numeric WHERE i<'1'::numeric ORDER BY i; - i ----- - -2 - -1 - 0 -(3 rows) - -SELECT * FROM test_numeric WHERE i<='1'::numeric ORDER BY i; - i ----- - -2 - -1 - 0 - 1 -(4 rows) - -SELECT * FROM test_numeric WHERE i='1'::numeric ORDER BY i; - i ---- - 1 -(1 row) - -SELECT * FROM test_numeric WHERE i>='1'::numeric ORDER BY i; - i ---- - 1 - 2 - 3 -(3 rows) - -SELECT * FROM test_numeric WHERE i>'1'::numeric ORDER BY i; - i ---- - 2 - 3 -(2 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/enum.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/enum.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/enum.out 2024-04-02 00:56:34.469878000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/enum.out 2024-04-02 00:59:54.258110000 +0000 @@ -1,63 +1,2 @@ -set enable_seqscan=off; -CREATE TYPE rainbow AS ENUM ('r','o','y','g','b','i','v'); -CREATE TABLE test_enum ( - i rainbow -); -INSERT INTO test_enum VALUES ('v'),('y'),('r'),('g'),('o'),('i'),('b'); -CREATE INDEX idx_enum ON test_enum USING gin (i); -SELECT * FROM test_enum WHERE i<'g'::rainbow ORDER BY i; - i ---- - r - o - y -(3 rows) - -SELECT * FROM test_enum WHERE i<='g'::rainbow ORDER BY i; - i ---- - r - o - y - g -(4 rows) - -SELECT * FROM test_enum WHERE i='g'::rainbow ORDER BY i; - i ---- - g -(1 row) - -SELECT * FROM test_enum WHERE i>='g'::rainbow ORDER BY i; - i ---- - g - b - i - v -(4 rows) - -SELECT * FROM test_enum WHERE i>'g'::rainbow ORDER BY i; - i ---- - b - i - v -(3 rows) - -explain (costs off) SELECT * FROM test_enum WHERE i>='g'::rainbow ORDER BY i; - QUERY PLAN ------------------------------------------------ - Sort - Sort Key: i - -> Bitmap Heap Scan on test_enum - Recheck Cond: (i >= 'g'::rainbow) - -> Bitmap Index Scan on idx_enum - Index Cond: (i >= 'g'::rainbow) -(6 rows) - --- make sure we handle the non-evenly-numbered oid case for enums -create type e as enum ('0', '2', '3'); -alter type e add value '1' after '0'; -create table t as select (i % 4)::text::e from generate_series(0, 100000) as i; -create index on t using gin (e); +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/uuid.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/uuid.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/uuid.out 2024-04-02 00:56:34.470783000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/uuid.out 2024-04-02 00:59:54.265367000 +0000 @@ -1,104 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_uuid ( - i uuid -); -INSERT INTO test_uuid VALUES - ( '00000000-0000-0000-0000-000000000000' ), - ( '299bc99f-2f79-4e3e-bfea-2cbfd62a7c27' ), - ( '6264af33-0d43-4337-bf4e-43509b8a4be8' ), - ( 'ce41c936-6acb-4feb-8c91-852a673e5a5c' ), - ( 'd2ce731f-f2a8-4a2b-be37-8f0ba637427f' ), - ( 'ffffffff-ffff-ffff-ffff-ffffffffffff' ) -; -CREATE INDEX idx_uuid ON test_uuid USING gin (i); -SELECT * FROM test_uuid WHERE i<'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - i --------------------------------------- - 00000000-0000-0000-0000-000000000000 - 299bc99f-2f79-4e3e-bfea-2cbfd62a7c27 - 6264af33-0d43-4337-bf4e-43509b8a4be8 -(3 rows) - -SELECT * FROM test_uuid WHERE i<='ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - i --------------------------------------- - 00000000-0000-0000-0000-000000000000 - 299bc99f-2f79-4e3e-bfea-2cbfd62a7c27 - 6264af33-0d43-4337-bf4e-43509b8a4be8 - ce41c936-6acb-4feb-8c91-852a673e5a5c -(4 rows) - -SELECT * FROM test_uuid WHERE i='ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - i --------------------------------------- - ce41c936-6acb-4feb-8c91-852a673e5a5c -(1 row) - -SELECT * FROM test_uuid WHERE i>='ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - i --------------------------------------- - ce41c936-6acb-4feb-8c91-852a673e5a5c - d2ce731f-f2a8-4a2b-be37-8f0ba637427f - ffffffff-ffff-ffff-ffff-ffffffffffff -(3 rows) - -SELECT * FROM test_uuid WHERE i>'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - i --------------------------------------- - d2ce731f-f2a8-4a2b-be37-8f0ba637427f - ffffffff-ffff-ffff-ffff-ffffffffffff -(2 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_uuid WHERE i<'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - QUERY PLAN ------------------------------------------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_uuid - Recheck Cond: (i < 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) - -> Bitmap Index Scan on idx_uuid - Index Cond: (i < 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_uuid WHERE i<='ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - QUERY PLAN -------------------------------------------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_uuid - Recheck Cond: (i <= 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) - -> Bitmap Index Scan on idx_uuid - Index Cond: (i <= 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_uuid WHERE i='ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - QUERY PLAN ------------------------------------------------------------------------- - Bitmap Heap Scan on test_uuid - Recheck Cond: (i = 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) - -> Bitmap Index Scan on idx_uuid - Index Cond: (i = 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) -(4 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_uuid WHERE i>='ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - QUERY PLAN -------------------------------------------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_uuid - Recheck Cond: (i >= 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) - -> Bitmap Index Scan on idx_uuid - Index Cond: (i >= 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_uuid WHERE i>'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid ORDER BY i; - QUERY PLAN ------------------------------------------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_uuid - Recheck Cond: (i > 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) - -> Bitmap Index Scan on idx_uuid - Index Cond: (i > 'ce41c936-6acb-4feb-8c91-852a673e5a5c'::uuid) -(6 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/name.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/name.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/name.out 2024-04-02 00:56:34.470386000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/name.out 2024-04-02 00:59:54.272239000 +0000 @@ -1,97 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_name ( - i name -); -INSERT INTO test_name VALUES ('a'),('ab'),('abc'),('abb'),('axy'),('xyz'); -CREATE INDEX idx_name ON test_name USING gin (i); -SELECT * FROM test_name WHERE i<'abc' ORDER BY i; - i ------ - a - ab - abb -(3 rows) - -SELECT * FROM test_name WHERE i<='abc' ORDER BY i; - i ------ - a - ab - abb - abc -(4 rows) - -SELECT * FROM test_name WHERE i='abc' ORDER BY i; - i ------ - abc -(1 row) - -SELECT * FROM test_name WHERE i>='abc' ORDER BY i; - i ------ - abc - axy - xyz -(3 rows) - -SELECT * FROM test_name WHERE i>'abc' ORDER BY i; - i ------ - axy - xyz -(2 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_name WHERE i<'abc' ORDER BY i; - QUERY PLAN ---------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_name - Recheck Cond: (i < 'abc'::name) - -> Bitmap Index Scan on idx_name - Index Cond: (i < 'abc'::name) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_name WHERE i<='abc' ORDER BY i; - QUERY PLAN ----------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_name - Recheck Cond: (i <= 'abc'::name) - -> Bitmap Index Scan on idx_name - Index Cond: (i <= 'abc'::name) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_name WHERE i='abc' ORDER BY i; - QUERY PLAN ---------------------------------------- - Bitmap Heap Scan on test_name - Recheck Cond: (i = 'abc'::name) - -> Bitmap Index Scan on idx_name - Index Cond: (i = 'abc'::name) -(4 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_name WHERE i>='abc' ORDER BY i; - QUERY PLAN ----------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_name - Recheck Cond: (i >= 'abc'::name) - -> Bitmap Index Scan on idx_name - Index Cond: (i >= 'abc'::name) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_name WHERE i>'abc' ORDER BY i; - QUERY PLAN ---------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_name - Recheck Cond: (i > 'abc'::name) - -> Bitmap Index Scan on idx_name - Index Cond: (i > 'abc'::name) -(6 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/bool.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-04-02 00:56:34.469587000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/bool.out 2024-04-02 00:59:54.282875000 +0000 @@ -1,133 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_bool ( - i boolean -); -INSERT INTO test_bool VALUES (false),(true),(null); -CREATE INDEX idx_bool ON test_bool USING gin (i); -SELECT * FROM test_bool WHERE i=true ORDER BY i; - i ---- - t -(1 row) - -SELECT * FROM test_bool WHERE i>true ORDER BY i; - i ---- -(0 rows) - -SELECT * FROM test_bool WHERE i=false ORDER BY i; - i ---- - f - t -(2 rows) - -SELECT * FROM test_bool WHERE i>false ORDER BY i; - i ---- - t -(1 row) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i Bitmap Heap Scan on test_bool - Recheck Cond: (i < true) - -> Bitmap Index Scan on idx_bool - Index Cond: (i < true) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i<=true ORDER BY i; - QUERY PLAN -------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bool - Recheck Cond: (i <= true) - -> Bitmap Index Scan on idx_bool - Index Cond: (i <= true) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i=true ORDER BY i; - QUERY PLAN -------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bool - Recheck Cond: i - -> Bitmap Index Scan on idx_bool - Index Cond: (i = true) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>=true ORDER BY i; - QUERY PLAN -------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bool - Recheck Cond: (i >= true) - -> Bitmap Index Scan on idx_bool - Index Cond: (i >= true) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i; - QUERY PLAN -------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bool - Recheck Cond: (i > true) - -> Bitmap Index Scan on idx_bool - Index Cond: (i > true) -(6 rows) - --- probably sufficient to check just this one: -EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i=false ORDER BY i; - QUERY PLAN -------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bool - Recheck Cond: (NOT i) - -> Bitmap Index Scan on idx_bool - Index Cond: (i = false) -(6 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket? diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bpchar.out /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/bpchar.out --- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bpchar.out 2024-04-02 00:56:34.469640000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gin-running/regress/results/bpchar.out 2024-04-02 00:59:54.313754000 +0000 @@ -1,109 +1,2 @@ -set enable_seqscan=off; -CREATE TABLE test_bpchar ( - i char(10) -); -INSERT INTO test_bpchar VALUES ('a'),('ab'),('abc'),('abc '),('abb'),('axy'),('xyz'),('xyz '); -CREATE INDEX idx_bpchar ON test_bpchar USING gin (i); -SELECT * FROM test_bpchar WHERE i<'abc' ORDER BY i; - i ------------- - a - ab - abb -(3 rows) - -SELECT * FROM test_bpchar WHERE i<='abc' ORDER BY i; - i ------------- - a - ab - abb - abc - abc -(5 rows) - -SELECT * FROM test_bpchar WHERE i='abc' ORDER BY i; - i ------------- - abc - abc -(2 rows) - -SELECT * FROM test_bpchar WHERE i='abc ' ORDER BY i; - i ------------- - abc - abc -(2 rows) - -SELECT * FROM test_bpchar WHERE i>='abc' ORDER BY i; - i ------------- - abc - abc - axy - xyz - xyz -(5 rows) - -SELECT * FROM test_bpchar WHERE i>'abc' ORDER BY i; - i ------------- - axy - xyz - xyz -(3 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i<'abc' ORDER BY i; - QUERY PLAN ------------------------------------------------ - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bpchar - Recheck Cond: (i < 'abc'::bpchar) - -> Bitmap Index Scan on idx_bpchar - Index Cond: (i < 'abc'::bpchar) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i<='abc' ORDER BY i; - QUERY PLAN ------------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bpchar - Recheck Cond: (i <= 'abc'::bpchar) - -> Bitmap Index Scan on idx_bpchar - Index Cond: (i <= 'abc'::bpchar) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i='abc' ORDER BY i; - QUERY PLAN ------------------------------------------ - Bitmap Heap Scan on test_bpchar - Recheck Cond: (i = 'abc'::bpchar) - -> Bitmap Index Scan on idx_bpchar - Index Cond: (i = 'abc'::bpchar) -(4 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i>='abc' ORDER BY i; - QUERY PLAN ------------------------------------------------- - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bpchar - Recheck Cond: (i >= 'abc'::bpchar) - -> Bitmap Index Scan on idx_bpchar - Index Cond: (i >= 'abc'::bpchar) -(6 rows) - -EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i>'abc' ORDER BY i; - QUERY PLAN ------------------------------------------------ - Sort - Sort Key: i - -> Bitmap Heap Scan on test_bpchar - Recheck Cond: (i > 'abc'::bpchar) - -> Bitmap Index Scan on idx_bpchar - Index Cond: (i > 'abc'::bpchar) -(6 rows) - +psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory + Is the server running locally and accepting connections on that socket?