Changes between Version 6 and Version 9 of Ticket #30913


Ignore:
Timestamp:
Oct 30, 2019, 4:59:25 AM (5 years ago)
Author:
Hannes Ljungberg
Comment:

PR: https://github.com/django/django/pull/11991

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #30913

    • Property Component Database layer (models, ORM)Migrations
    • Property Keywords postgresql covering index include added; db-indexes removed
    • Property Triage Stage UnreviewedAccepted
    • Property Owner changed from nobody to Hannes Ljungberg
    • Property Has patch set
  • Ticket #30913 – Description

    v6 v9  
    44CREATE INDEX idx
    55    ON t1 ( col1 )
    6      INCLUDE ( col2 )
     6    INCLUDE ( col2 );
    77}}}
    88
     
    2525    fields=['headline'],
    2626    include=['pub_date']
     27)
    2728}}}
    2829
     
    3031
    3132At the moment the only Django-supported database that can use this feature is Postgres but it's also supported by Microsoft SQL Server and IBM Db2 with the same syntax. Because of this I think it shouldn't be implemented as a postgres only feature but exposed on `BaseDatabaseSchemaEditor` to ease the adding of support when/if sqlite or mariadb/mysql get it.
    32 
    33 I have a proof of concept I'm working on and will create a PR soon if accepted.
Back to Top