#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
> 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()
> }}}
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()
}}}
Is it a problem of Django or I should find problem in psycopg?
--
--
Ticket URL: <https://code.djangoproject.com/ticket/27808#comment:2>
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/069.014a73f80ee343815c77d635582825ba%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
