Related recipes view tests fails on PostgreSQL and GitlabCI

Created on 5 September 2023, over 1 year ago

Problem/Motivation

When running core tests over GitlabCI using PostgreSQL, there is an error:

Drupal\Core\Database\DatabaseExceptionWrapper: Exception in Related recipes[related_recipes]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "31,22,13" LINE 5: ...recipe_category.field_recipe_category_target_id = '31,22,13'

This happens because the generated query seems to be:
(node__field_recipe_category.field_recipe_category_target_id = :node__field_recipe_category_field_recipe_category_target_id))) and the replacement pattern is [:node__field_recipe_category_field_recipe_category_target_id] => 31,22,13

Steps to reproduce

Repo: https://git.drupalcode.org/project/gitlab_ci_testbed_for_drupal_core/-/m...
Job: https://git.drupalcode.org/project/gitlab_ci_testbed_for_drupal_core/-/j...

Proposed resolution

MR

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

🐛 Bug report
Status

Closed: works as designed

Version

11.0 🔥

Component
Database 

Last updated 2 days ago

  • Maintained by
  • 🇳🇱Netherlands @daffie
Created by

🇪🇸Spain fjgarlin

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024