search

Segfault-Inc / Multicorn

Data Access Library
https://multicorn.org/
PostgreSQL License
697 stars 145 forks source link

multicorn_planner_test: Accept output variation from PostgreSQL 12.4 #258

Closed df7cb closed 3 years ago

df7cb commented 3 years ago

Net change:

--- test-3.3/expected/multicorn_planner_test.out    2020-08-18 12:53:14.401240141 +0200
+++ test-3.3/expected/multicorn_planner_test_1.out  2020-08-18 13:18:42.803529729 +0200
@@ -31,7 +31,7 @@
 explain select * from testmulticorn m1 inner join testmulticorn m2 on m1.test1 = m2.test1;
                                      QUERY PLAN
 -------------------------------------------------------------------------------------
- Nested Loop  (cost=20.00..806.05 rows=2 width=128)
+ Nested Loop  (cost=20.00..806.05 rows=20 width=128)
    Join Filter: ((m1.test1)::text = (m2.test1)::text)
    ->  Foreign Scan on testmulticorn m1  (cost=10.00..400.00 rows=20 width=20)
    ->  Materialize  (cost=10.00..400.10 rows=20 width=20)

Tested on PG 12.4, 11.9, 10.14, 9.6.19, and 9.5.23 and Python 3.8 (not on 2.7, but should work)

rdunklau commented 3 years ago

Nice, I didn't know about this feature from the test framework.

Thanks for both PRs.