Ah sorry didn't realize. I would just link to the test from your ticket for now, the fellows are probably in a better position to determine how to treat this bug.
On Mon, Oct 10, 2022 at 8:47 AM Ion Alberdi <ion.albe...@pricemoov.com> wrote: > Great, thanks Adam! FYI the test is already on django's Test suite > (https://github.com/pricemoov/django/pull/2/files) > Would you like me to open a PR in Django or should I wait for the fix of > the test being developed first? > > > Le lun. 10 oct. 2022 à 09:39, 'Adam Johnson' via Django developers > (Contributions to Django itself) <django-developers@googlegroups.com> a > écrit : > >> Yes please create a ticket. If you’re feeling brave, try to adapt your >> test into Django’s test suite (here: >> https://github.com/django/django/blob/84206607d6bfd61e7f7a88b51163ffd4153e3b5a/tests/postgres_tests/test_array.py#L212 >> )! >> >> On Sun, Oct 9, 2022 at 11:49 AM Ion Alberdi <ion.albe...@pricemoov.com> >> wrote: >> >>> Hello to all, >>> >>> a unit test added at >>> https://github.com/pricemoov/django/pull/2 >>> shows that the exact filter on a full "NULL nested array" currently >>> fails. >>> (the commit messages shows how to reproduce the error). >>> >>> More precisely, the error is >>> "django.db.utils.DataError: invalid input syntax for type integer: >>> "{NULL,NULL}" >>> >>> LINE 1: ...ullableintegerarraymodel"."field_nested" = >>> (ARRAY['{NULL,NUL..." >>> >>> and seems to be due to the query being generated as >>> "...ARRAY['{NULL,NULL}']..." >>> instead of "...ARRAY[ARRAY[NULL,NULL]]..." >>> >>> I wonder whether this is due to django or psycopg2. Indeed, the bug is >>> not reproduced >>> if at least one of the element in the nested array is not null. >>> >>> Is the bug worth creating a ticket? >>> >>> Best regards, >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Django developers (Contributions to Django itself)" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to django-developers+unsubscr...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/django-developers/bad3435e-1299-4b1d-b701-7881e111ec90n%40googlegroups.com >>> <https://groups.google.com/d/msgid/django-developers/bad3435e-1299-4b1d-b701-7881e111ec90n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "Django developers (Contributions to Django itself)" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/django-developers/4OvbN0EUUsM/unsubscribe >> . >> To unsubscribe from this group and all its topics, send an email to >> django-developers+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/django-developers/CAMyDDM1Rs%3DxZjChzqU3qj6YttB3atLX7bhGuURd0-3v_OitK0g%40mail.gmail.com >> <https://groups.google.com/d/msgid/django-developers/CAMyDDM1Rs%3DxZjChzqU3qj6YttB3atLX7bhGuURd0-3v_OitK0g%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > > > -- > [image: img] <https://signitic.app/linkc/L3B5SXlwV0U-L3A4PQ> > > > *Ion Alberdi* > > > [image: img] <https://signitic.app/linkc/L3B5SXlwV0U-L1pzPQ> [image: img] > <https://signitic.app/linkc/L3B5SXlwV0U-L3A4PQ> [image: img] > <https://signitic.app/linkc/L3B5SXlwV0U-L1pRPQ> [image: img] > <https://signitic.app/linkc/L3B5SXlwV0U-L1pnPQ> [image: img] > <https://signitic.app/linkc/L3B5SXlwV0U-L1prPQ> > > -- > You received this message because you are subscribed to the Google Groups > "Django developers (Contributions to Django itself)" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to django-developers+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-developers/CANbgw4B81hwFvRhCVQpm%3DPg%3D_ZJikTVKKhAaXa%2B7rPpw8%3DoVEw%40mail.gmail.com > <https://groups.google.com/d/msgid/django-developers/CANbgw4B81hwFvRhCVQpm%3DPg%3D_ZJikTVKKhAaXa%2B7rPpw8%3DoVEw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django developers (Contributions to Django itself)" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-developers+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-developers/CAMyDDM19RVNqA0OiDqpwdNq0SD_uPCGr8Gz4XiWQFEqd4EZ90A%40mail.gmail.com.
