• Adrien Crivelli's avatar
    Do not TRIM() parentheses around partial index's conditions · f1f7c9a6
    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))"}``
    f1f7c9a6
PostgreSqlSchemaManagerTest.php 14.4 KB