Issue Bug Closed

#102612Calling ExpressionBuilder::in and notIn with empty array or string causes SQL Error

Lina Wolf 12/06/23, 10:35 updated 07/09/24, 15:12

Description

I would suggest to test for invalid data here – same as we do with inSet

Reviews 1

History 35

  1. Lina Wolf commented 12/06/23, 10:46

    Current Exception is:

    Doctrine\DBAL\Exception\SyntaxErrorException prototype object
       message => protected "An exception occurred while executing 'UPDATE `tt_content` SET `CType` = ? W
          HERE `uid` IN ()' with params ["xyz"]:
    
    You have an err
          or in your SQL syntax; check the manual that corresponds to your MariaDB ser
          ver version for the right syntax to use near ')' at line 1" (286 chars)

    There is no unit test for this case

  2. Gerrit Code Review pushed patch set 1 for main to change 82132 status New Under Review 12/06/23, 11:13

  3. Gerrit Code Review pushed patch set 2 for main to change 82132 12/06/23, 13:20

  4. Lina Wolf commented and changed status Under Review Resolved done 0 % 100 % 12/06/23, 15:55

    Applied in changeset commit:7c6b5cc7acff9fbcef13c2a28d5997b654201a28.

  5. Benni Mack changed status Resolved Closed 07/09/24, 15:12