[DDC-2088] [GH-485] Back ported changes of SimpleConditionalExpression Created: 19/Oct/12  Updated: 31/Dec/13  Resolved: 08/Sep/13

Status: Resolved
Project: Doctrine 2 - ORM
Component/s: None
Affects Version/s: None
Fix Version/s: None
Security Level: All

Type: Bug Priority: Major
Reporter: Benjamin Eberlei Assignee: Benjamin Eberlei
Resolution: Incomplete Votes: 0
Labels: None


This issue is created automatically through a Github pull request on behalf of sstok:

Url: https://github.com/doctrine/doctrine2/pull/485


This following query fails.

SELECT I FROM Rollerworks\Bundle\RecordFilterBundle\Tests\Fixtures\BaseBundle\Entity\ECommerce\ECommerceInvoice I WHERE ((RECORD_FILTER_FIELD_CONVERSION('invoice_customer', I.customer) BETWEEN :invoice_customer_0 AND :invoice_customer_1) AND (RECORD_FILTER_FIELD_CONVERSION('invoice_customer', I.customer) NOT BETWEEN :invoice_customer_2 AND :invoice_customer_3))

With this message.
[Syntax Error] line 0, col 306: Error: Expected =, <, <=, <>, >, >=, !=, got 'NOT'

It only happens in version 2.2, 2.3 is working as expected.

I have traced the fix to one very simple change in SimpleConditionalExpression and only seem to happen when using an custom function NOT and having nested parenthesis.

As far as I can tell its BC.

Comment by Fabio B. Silva [ 17/Mar/13 ]

More details, see 485

Comment by Doctrine Bot [ 31/Dec/13 ]

A related Github Pull-Request [GH-485] was closed:

Generated at Wed Nov 25 05:29:13 EST 2015 using JIRA 6.4.10#64025-sha1:5b8b74079161cd76a20ab66dda52747ee6701bd6.