#33021: Migration crashes when GIN index with gin_trgm_ops is used
---------------------------------------------+-----------------------------
Reporter: AlekseiKhatkevich | Owner: nobody
Type: Bug | Status: new
Component: Migrations | Version: 3.2
Severity: Normal | Keywords: gin OpClass
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
---------------------------------------------+-----------------------------
I have an index like following:
{{{
GinIndex(
OpClass(Upper('text_id'), name='gin_trgm_ops'),
name='text_id_idx',
),
}}}
Migration file creates without any troubles on it.
sqlmigrate generates following SQL:
{{{
CREATE INDEX "text_id_idx" ON "auction_lot" USING gin ((UPPER("text_id")
gin_trgm_ops));
}}}
which obviously has one extra set of (), which causes following exception
during migration
{{{
django.db.utils.ProgrammingError: syntax error at or near "gin_trgm_ops"
LINE 1: ...dx" ON "auction_lot" USING gin ((UPPER("text_id") gin_trgm_o...
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/33021>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/060.04acc97b0ab21befffa3921c0665b46b%40djangoproject.com.
