diff options
| author | Simon Charette <simon.charette@zapier.com> | 2019-04-19 02:39:25 -0400 |
|---|---|---|
| committer | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2019-04-23 08:32:36 +0200 |
| commit | 88bf635c356b4d3a47e88dc4142b90060ce3c2ef (patch) | |
| tree | 643ff97dd1a497c6606078c195f8fdcbe11a8bf0 /docs/ref/models | |
| parent | 47885278c669dd7a13a4c3ff7e58e1cbe88af385 (diff) | |
[2.2.x] Fixed #30385 -- Restored SearchVector(config) immutability.
Regression in 1a28dc3887e8d66d5e3ff08cf7fb0a6212b873e5.
The usage of CONCAT to allow SearchVector to deal with non-text fields
made the generated expression non-IMMUTABLE which prevents a functional
index to be created for it.
Using a combination of COALESCE and ::text makes sure the expression
preserves its immutability.
Refs #29582. Thanks Andrew Brown for the report, Nick Pope for the
review.
Backport of 405c8363362063542e9e79beac53c8437d389520 from master
Diffstat (limited to 'docs/ref/models')
0 files changed, 0 insertions, 0 deletions