I have a content type that includes a Paragraph.
Inside this Paragraph, there's an Entity Reference field with an Entity Autocomplete widget pointing to Block content.
When I try to add a new Paragraph to the content (e.g., via the node edit form), I get a SQL error in the logs related to a malformed query.
The issue occurs when the referenced value is an empty string ("") instead of a valid ID or a null value. The backend attempts to run a query with WHERE id IN (""), which causes a fatal PostgreSQL error.
SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: ""
LINE 6: ...nload')) AND ("block_content_field_data"."id" IN ('')) AND (...
The autocomplete field handler or validation should ensure that empty string values are either:
* filtered out before querying, or
* converted to null, or
* the query should not run at all when the ID list is empty.
This will prevent malformed SQL from being sent to the database and improve compatibility, especially with PostgreSQL.
Active
1.15
Render element
The patch was sent as a MR.
Pipeline failed on composer build, not related to MR.