|
| 1 | +/* |
| 2 | + * ------------------------------------------- |
| 3 | + * NOTE: This test behaves differenly on < 11 because planner now turns |
| 4 | + * Row(Const, Const) into just Const of record type, apparently since 3decd150 |
| 5 | + * ------------------------------------------- |
| 6 | + */ |
1 | 7 | \set VERBOSITY terse |
2 | 8 | SET search_path = 'public'; |
3 | 9 | CREATE EXTENSION pg_pathman; |
@@ -160,42 +166,38 @@ SELECT *, tableoid::REGCLASS FROM test_exprs.composite; |
160 | 166 | (3 rows) |
161 | 167 |
|
162 | 168 | EXPLAIN (COSTS OFF) SELECT * FROM test_exprs.composite WHERE (a, b)::test_exprs.composite < (21, 0)::test_exprs.composite; |
163 | | -QUERY PLAN |
164 | | ----------------------------------------------------------------------------------------------- |
| 169 | + QUERY PLAN |
| 170 | +------------------------------------------------------------------------------------ |
165 | 171 | Append |
166 | 172 | -> Seq Scan on composite_1 |
167 | 173 | -> Seq Scan on composite_2 |
168 | 174 | -> Seq Scan on composite_3 |
169 | | - Filter: (ROW(a, b)::test_exprs.composite <ROW(21, '0'::text)::test_exprs.composite) |
| 175 | + Filter: (ROW(a, b)::test_exprs.composite <'(21,0)'::test_exprs.composite) |
170 | 176 | (5 rows) |
171 | 177 |
|
172 | 178 | EXPLAIN (COSTS OFF) SELECT * FROM test_exprs.composite WHERE (a, b) < (21, 0)::test_exprs.composite; |
173 | | -QUERY PLAN |
174 | | ------------------------------------------------------------------------- |
| 179 | + QUERY PLAN |
| 180 | +-------------------------------------------------------------- |
175 | 181 | Append |
176 | 182 | -> Seq Scan on composite_1 |
177 | | - Filter: (ROW(a, b) <ROW(21, '0'::text)::test_exprs.composite) |
| 183 | + Filter: (ROW(a, b) <'(21,0)'::test_exprs.composite) |
178 | 184 | -> Seq Scan on composite_2 |
179 | | - Filter: (ROW(a, b) <ROW(21, '0'::text)::test_exprs.composite) |
| 185 | + Filter: (ROW(a, b) <'(21,0)'::test_exprs.composite) |
180 | 186 | -> Seq Scan on composite_3 |
181 | | - Filter: (ROW(a, b) <ROW(21, '0'::text)::test_exprs.composite) |
| 187 | + Filter: (ROW(a, b) <'(21,0)'::test_exprs.composite) |
182 | 188 | -> Seq Scan on composite_4 |
183 | | - Filter: (ROW(a, b) <ROW(21, '0'::text)::test_exprs.composite) |
| 189 | + Filter: (ROW(a, b) <'(21,0)'::test_exprs.composite) |
184 | 190 | (9 rows) |
185 | 191 |
|
186 | 192 | EXPLAIN (COSTS OFF) SELECT * FROM test_exprs.composite WHERE (a, b)::test_exprs.composite < (21, 0); |
187 | | - QUERY PLAN |
188 | | ----------------------------------------------------------------- |
| 193 | +QUERY PLAN |
| 194 | +---------------------------------------------------------------------- |
189 | 195 | Append |
190 | 196 | -> Seq Scan on composite_1 |
191 | | - Filter: (ROW(a, b)::test_exprs.composite < ROW(21, 0)) |
192 | 197 | -> Seq Scan on composite_2 |
193 | | - Filter: (ROW(a, b)::test_exprs.composite < ROW(21, 0)) |
194 | 198 | -> Seq Scan on composite_3 |
195 | | - Filter: (ROW(a, b)::test_exprs.composite < ROW(21, 0)) |
196 | | - -> Seq Scan on composite_4 |
197 | | - Filter: (ROW(a, b)::test_exprs.composite < ROW(21, 0)) |
198 | | -(9 rows) |
| 199 | + Filter: (ROW(a, b)::test_exprs.composite < '(21,0)'::record) |
| 200 | +(5 rows) |
199 | 201 |
|
200 | 202 | DROP TABLE test_exprs.composite CASCADE; |
201 | 203 | NOTICE: drop cascades to 5 other objects |
|