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:11:33 +0200 |
| commit | 405c8363362063542e9e79beac53c8437d389520 (patch) | |
| tree | b280ca6837befc565465b5d4a610803af11fc8c1 /docs/internals/contributing/writing-code | |
| parent | 34a68c2cbea837b81cd9ab6bc91563416612157c (diff) | |
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.
Diffstat (limited to 'docs/internals/contributing/writing-code')
0 files changed, 0 insertions, 0 deletions