#34861: KeyTextTransform incompatible with GeneratedField
-------------------------------------+-------------------------------------
Reporter: Paolo | Owner: nobody
Melchiorre |
Type: Bug | Status: new
Component: Database | Version: 5.0
layer (models, ORM) |
Severity: Release | Keywords: field, database,
blocker | generated, output_field
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Broken SQL code generated when KeyTextTransform is used in GeneratedField
expression
**Steps**
Steps to reproduce the error.
**Model**
{{{#!python
from django.db import models
from django.db.models.fields.json import KT
class Response(models.Model):
data = models.JSONField(default=dict)
status = models.GeneratedField(
db_persist=True,
expression=KT("data__status"),
output_field=models.PositiveSmallIntegerField(),
)
}}}
**Migration**
{{{#!bash
$ python3 -m manage makemigrations
Migrations for 'https':
https/migrations/0001_initial.py
- Create model Response
$ python -m manage sqlmigrate https 0001
}}}
{{{#!sql
BEGIN;
--
-- Create model Response
--
CREATE TABLE "https_response" (
"id" bigint NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
"data" jsonb NOT NULL,
"status" smallint GENERATED ALWAYS AS (None("data")) STORED
);
COMMIT;
}}}
**Traceback**
{{{#!bash
$ python -m manage migrate https 0001
}}}
{{{#!python
Operations to perform:
Target specific migration: 0001_initial, from https
Running migrations:
Applying https.0001_initial...Traceback (most recent call last):
File "/home/paulox/Projects/generatedfield/.venv/lib/python3.11/site-
packages/django/db/backends/utils.py", line 99, in _execute
return self.cursor.execute(sql)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/paulox/Projects/generatedfield/.venv/lib/python3.11/site-
packages/psycopg/cursor.py", line 737, in execute
raise ex.with_traceback(None)
psycopg.errors.SyntaxError: syntax error at or near "("
LINE 1: ... NULL, "status" smallint GENERATED ALWAYS AS (None("data")) ...
^
}}}
**Queryset**
Using KeyTextTransform in a query instead generates a correct SQL code.
{{{#!pycon
>>> from django.db.models.fields.json import KT
>>> from https.models import Response
>>> str(Response.objects.values_list(KT("data__status")).query)
'SELECT ("https_response"."data" ->> status) AS "keytexttransform1" FROM
"geometricfigures_response"'
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/34861>
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/0107018ab9c3605e-c051c4a2-0bce-4bf3-8e5b-9fe0477360a5-000000%40eu-central-1.amazonses.com.
