PolarDB-for-PostgreSQL

1
set enable_seqscan=off;
2

3
CREATE TABLE test_bpchar (
4
	i char(10)
5
);
6

7
INSERT INTO test_bpchar VALUES ('a'),('ab'),('abc'),('abc   '),('abb'),('axy'),('xyz'),('xyz  ');
8

9
CREATE INDEX idx_bpchar ON test_bpchar USING gin (i);
10

11
SELECT * FROM test_bpchar WHERE i<'abc' ORDER BY i;
12
SELECT * FROM test_bpchar WHERE i<='abc' ORDER BY i;
13
SELECT * FROM test_bpchar WHERE i='abc' ORDER BY i;
14
SELECT * FROM test_bpchar WHERE i='abc  ' ORDER BY i;
15
SELECT * FROM test_bpchar WHERE i>='abc' ORDER BY i;
16
SELECT * FROM test_bpchar WHERE i>'abc' ORDER BY i;
17

18
EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i<'abc' ORDER BY i;
19
EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i<='abc' ORDER BY i;
20
EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i='abc' ORDER BY i;
21
EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i>='abc' ORDER BY i;
22
EXPLAIN (COSTS OFF) SELECT * FROM test_bpchar WHERE i>'abc' ORDER BY i;
23