• Adrien Crivelli's avatar
    Do not TRIM() parentheses around partial index's conditions · e5e3dbc9
    Adrien Crivelli authored
    Because PostgreSQL will return the expression with a lot of
    parentheses we cannot TRIM() them easily. It is easier and more
    correct to adapt to what PostgreSQL returns. That means the declaration
    of partial indexes must be updated as follow:
    
    Before:
    ``options={"where": "other_id IS NULL"}``
    
    After:
    ``options={"where": "(other_id IS NULL)"}``
    
    And fore more complex conditions, that would be:
    ``options={"where": "(((id IS NOT NULL) AND (other_id IS NULL)) AND (name IS NULL))"}``
    e5e3dbc9
Name
Last commit
Last update
bin Loading commit data...
docs Loading commit data...
lib Loading commit data...
tests Loading commit data...
.gitattributes Loading commit data...
.gitignore Loading commit data...
.gitmodules Loading commit data...
.travis.yml Loading commit data...
LICENSE Loading commit data...
README.md Loading commit data...
SECURITY.md Loading commit data...
UPGRADE.md Loading commit data...
build.properties Loading commit data...
build.xml Loading commit data...
composer.json Loading commit data...
phpunit.xml.dist Loading commit data...
run-all.sh Loading commit data...