• Simon Charette's avatar
    Fixed #30385 -- Restored SearchVector(config) immutability. · 405c8363
    Simon Charette yazdı
    Regression in 1a28dc38.
    
    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.
    405c8363
test_search.py 16.9 KB