Commit graph

8 commits

Author SHA1 Message Date
Julien Rouhaud
73d82eee94 Make tests more portable.
The estimated index size depends on the architecture, so just make
sure the code path is tested, without really caring of what the
estimated size is.  Thanks to Christoph Berg for the report.
2018-03-27 19:48:41 +02:00
Julien Rouhaud
79220f2c71 Fix NULL ordering for SORTBY_DESC case. Thanks to Andrew Kane for the
report and test case.
2017-09-05 06:45:31 +02:00
Julien Rouhaud
d2cfd7898f Add a hypopg_get_indexdef(oid) function 2016-11-16 23:49:27 +01:00
Julien Rouhaud
c05e2da4f7 Add support for hypothetical indexes on expression.
The estimation (size and cardinality) will probably always be very poor, the
postgres infrastructure get accurate informations by analyzing a real
index.  One consequence is that almost only Bitmap Index Scan will be
chosen by the planner.

Some simple and frequent expressions are explicitely handled (for now md5(),
lower() and uppser()), but it only impacts the estimated size, not the
selectivity.
2016-11-15 15:31:09 +01:00
Julien Rouhaud
022ac3396e Add regression test for expression indexes.
This has already been broken twice, make sure it won't happen again.
2016-06-07 20:10:04 +02:00
Julien Rouhaud
079a4f7610 Test hypopg.enabled GUC 2015-09-14 17:49:33 +02:00
Julien Rouhaud
1f211190fd Add some more tests 2015-09-03 19:02:32 +02:00
Julien Rouhaud
3bf0e6d118 Add some basic regression test. 2015-07-11 10:28:34 +02:00