#27808: Nested ArrayField with nullable base field generates invalid SQL
----------------------------------+--------------------------------------
Reporter: Josef Kolář | Owner: (none)
Type: Bug | Status: new
Component: contrib.postgres | Version: 1.9
Severity: Normal | Resolution:
Keywords: | Triage Stage: Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
----------------------------------+--------------------------------------
Description changed by Josef Kolář:
Old description:
> When I have model
> {{{#!python
> class NestedNullableIntegerArrayModel(PostgreSQLModel):
> field = ArrayField(ArrayField(models.IntegerField(null=True)))
> }}}
> and trying to save data
> {{{#!python
> instance = NestedNullableIntegerArrayModel(field=[[None, None], [None,
> None]])
> instance.save()
> }}}
> and Django generates
> {{{#!SQL
> INSERT INTO "postgres_tests_nestednullableintegerarraymodel" ("field")
> VALUES (%s) RETURNING
> "postgres_tests_nestednullableintegerarraymodel"."id"
> }}}
New description:
When I have model
{{{#!python
class NestedNullableIntegerArrayModel(PostgreSQLModel):
field = ArrayField(ArrayField(models.IntegerField(null=True)))
}}}
and trying to save data
{{{#!python
NestedNullableIntegerArrayModel(field=[[None, None], [None, None]]).save()
}}}
and Django generates
{{{#!sql
INSERT INTO "postgres_tests_nestednullableintegerarraymodel" ("field")
VALUES (%s) RETURNING
"postgres_tests_nestednullableintegerarraymodel"."id"
}}}
with expectable params
{{{#!python
([[None, None], [None, None]], )
}}}
and this query fails in postgres on
{{{
ERROR: column "field" is of type integer[] but expression is of type
text[]
LINE 1: ...estednullableintegerarraymodel" ("field") VALUES (ARRAY['{NU...
^
HINT: You will need to rewrite or cast the expression.
}}}
**But, if I use one of values is not None, model is saved successfully:**
{{{#!python
NestedNullableIntegerArrayModel(field=[[None, None], [None, 42]]).save()
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/27808#comment:1>
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 django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/069.427dc92e8741a65d245a8afcb8928b12%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
