and, or doesn't work in DQL #5950

New Issue

Closed

opened 2026-01-22 15:22:59 +01:00 by admin · 10 comments

admin commented 2026-01-22 15:22:59 +01:00

Owner

Copy Link

Originally created by @winnilein on GitHub (Apr 12, 2018).

I migrate a mysql db to sqlAnywhere(sqla) to test my app developed with Doctrine2.

Acces to sqla works,
DQL like

$query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng );

$query->setParameters(array(
'lng' => 'DE'
));

$result = $query->getResult();

also runs funny.

$query = $em->createQuery('SELECT e FROM countries e WHERE e.connum = :num );

$query->setParameters(array(
'num' => '4'
));

$result = $query->getResult();

also no problems!

BUT!

$query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng AND e.connum = :num');

$query->setParameters(array(
'lng' => 'DE',
'num' => '4',
));

$result = $query->getResult();

doesn't work!!

$result = empty!

with operator OR it's the same problem!

Any idea!

Originally created by @winnilein on GitHub (Apr 12, 2018). I migrate a mysql db to sqlAnywhere(sqla) to test my app developed with Doctrine2. Acces to sqla works, DQL like $query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng ); $query->setParameters(array( 'lng' => 'DE' )); $result = $query->getResult(); also runs funny. $query = $em->createQuery('SELECT e FROM countries e WHERE e.connum = :num ); $query->setParameters(array( 'num' => '4' )); $result = $query->getResult(); also no problems! ## BUT! $query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng AND e.connum = :num'); $query->setParameters(array( 'lng' => 'DE', 'num' => '4', )); $result = $query->getResult(); doesn't work!! $result = empty! with operator OR it's the same problem! Any idea! # #

admin closed this issue 2026-01-22 15:23:00 +01:00

admin commented 2026-01-22 15:23:01 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Apr 12, 2018):

What's the executed SQL query? Can you run that manually and verify the output? Also make sure the parameter types match.

@Ocramius commented on GitHub (Apr 12, 2018): What's the executed SQL query? Can you run that manually and verify the output? Also make sure the parameter types match.

admin commented 2026-01-22 15:23:01 +01:00

Author

Owner

Copy Link

@winnilein commented on GitHub (Apr 13, 2018):

Interactive sql works!

But if i change my test-pgm to this ..

look at the sql statement!

SELECT e FROM countries e WHERE e.conlng = :lng or e.connum = :num

and the result in the sceenshot.

It woorks with an OR operator??!

I'm very irritated !

@winnilein commented on GitHub (Apr 13, 2018): Interactive sql works!  But if i change my test-pgm to this ..  look at the sql statement! ## SELECT e FROM countries e WHERE e.conlng = :lng or e.connum = :num and the result in the sceenshot. It woorks with an OR operator??! ## I'm very irritated !

admin commented 2026-01-22 15:23:01 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Apr 13, 2018):

SELECT e FROM countries e WHERE e.conlng = :lng or e.connum = :num

Is this the same SQL statement that the ORM runs?
Use a DebugStack logger to see if the SQL statement is the same.

The one difference I noticed is that sometimes your parameters are string, sometimes int: try looking for differences there as well as in the executed SQL string.

I'm very irritated !

This is not a support hotline: if you need to get irritated over volunteers helping you out, you can instead hire somebody to help you out, and be (contractually) allowed to be irritated instead.

@Ocramius commented on GitHub (Apr 13, 2018): > `SELECT e FROM countries e WHERE e.conlng = :lng or e.connum = :num` Is this the same SQL statement that the ORM runs? Use a [`DebugStack`](https://github.com/doctrine/dbal/blob/0f23ed9ba28db2b392eeaaf5938ce804e52084b9/lib/Doctrine/DBAL/Logging/DebugStack.php) logger to see if the SQL statement is the same. The one difference I noticed is that sometimes your parameters are `string`, sometimes `int`: try looking for differences there as well as in the executed SQL string. > I'm very irritated ! This is not a support hotline: if you need to get irritated over volunteers helping you out, you can instead hire somebody to help you out, and be (contractually) allowed to be irritated instead.

admin commented 2026-01-22 15:23:02 +01:00

Author

Owner

Copy Link

@winnilein commented on GitHub (Apr 13, 2018):

The result ofDebugStack!?

@winnilein commented on GitHub (Apr 13, 2018):  The result ofDebugStack!?

admin commented 2026-01-22 15:23:03 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Apr 13, 2018):

@winnilein can you expand on params and types there?

@Ocramius commented on GitHub (Apr 13, 2018): @winnilein can you expand on `params` and `types` there?

admin commented 2026-01-22 15:23:03 +01:00

Author

Owner

Copy Link

@winnilein commented on GitHub (Apr 13, 2018):

@winnilein commented on GitHub (Apr 13, 2018): 

admin commented 2026-01-22 15:23:03 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Apr 13, 2018):

Both are bound as string there - can you try passing in an integer and running the SQL statement manually with either string or int, and see if there is a difference?

@Ocramius commented on GitHub (Apr 13, 2018): Both are bound as `string` there - can you try passing in an integer and running the SQL statement manually with either `string` or `int`, and see if there is a difference?

admin commented 2026-01-22 15:23:04 +01:00

Author

Owner

Copy Link

@winnilein commented on GitHub (Apr 13, 2018):

native sql..

and the result of my script..

my script..

<?php
include "Bootstrap.php";
require_once 'Entities/countries.php';
error_reporting(E_ALL);

$stack = new \Doctrine\DBAL\Logging\DebugStack();
$stack->enabled;
$em->getConfiguration()->setSQLLogger($stack);

$query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng AND e.connum = :num');

$LNG = 'DE';
$NUM = 4;

  $query->setParameters(array(
    'lng' => $LNG,
    'num' => $NUM,
            ));
 

$result = $query->getResult();
        
            if (!$result) {
            
                echo 'Noting found!';
                
            
            } else {
        
                foreach ($result as $row) {
                    $TXT=$row->getContxt();
                    echo $TXT;   
                }     
     
            }    
            
      echo '<pre>';
\Doctrine\Common\Util\Debug::dump($stack, 5);      

@winnilein commented on GitHub (Apr 13, 2018): native sql..  and the result of my script..  my script.. ``` <?php include "Bootstrap.php"; require_once 'Entities/countries.php'; error_reporting(E_ALL); $stack = new \Doctrine\DBAL\Logging\DebugStack(); $stack->enabled; $em->getConfiguration()->setSQLLogger($stack); $query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng AND e.connum = :num'); $LNG = 'DE'; $NUM = 4; $query->setParameters(array( 'lng' => $LNG, 'num' => $NUM, )); $result = $query->getResult(); if (!$result) { echo 'Noting found!'; } else { foreach ($result as $row) { $TXT=$row->getContxt(); echo $TXT; } } echo '<pre>'; \Doctrine\Common\Util\Debug::dump($stack, 5); ```

admin commented 2026-01-22 15:23:04 +01:00

Author

Owner

Copy Link

@winnilein commented on GitHub (Apr 13, 2018):

For your entertainment..

$query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng AND e.connum = :num');

$NUM = 4;

result ->

and now !

$query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng or e.connum = :num');

$NUM = '4';

result..

f****** web apps
i think i continue programming midrange applications

@winnilein commented on GitHub (Apr 13, 2018): ## For your entertainment.. `$query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng AND e.connum = :num');` `$NUM = 4;` result ->  ## and now ! `$query = $em->createQuery('SELECT e FROM countries e WHERE e.conlng = :lng or e.connum = :num');` ` $NUM = '4';` result..  f****** web apps i think i continue programming midrange applications

admin commented 2026-01-22 15:23:05 +01:00

Author

Owner

Copy Link

@Ocramius commented on GitHub (Apr 13, 2018):

Closing: nobody's spare time is worth following up on this attitude.

If you don't have the willpower to contribute to this conversation in a constructive way, then please consider hiring somebody doing it for you instead.

@Ocramius commented on GitHub (Apr 13, 2018): Closing: nobody's spare time is worth following up on this attitude. If you don't have the willpower to contribute to this conversation in a constructive way, then please consider hiring somebody doing it for you instead.

Sign in to join this conversation.

No Branch/Tag Specified

Branches Tags

3.6.x

2.20.x

dependabot/github_actions/2.20.x/doctrine/dot-github/dot-github/workflows/composer-lint.yml-14.0.0

3.7.x

4.0.x

2.21.x

old-prototype-3.x

3.6.2

3.6.1

3.6.0

2.20.9

3.5.8

3.5.7

3.5.6

3.5.5

2.20.8

3.5.4

3.5.3

2.20.7

3.5.2

2.20.6

3.5.1

3.5.0

3.4.4

3.4.3

3.4.2

2.20.5

3.4.1

3.4.0

3.3.4

2.20.4

3.3.3

2.20.3

3.3.2

2.20.2

3.3.1

2.20.1

3.3.0

3.2.3

2.20.0

2.19.8

3.2.2

2.19.7

3.2.1

2.19.6

3.2.0

3.1.4

3.1.3

2.19.5

3.1.2

2.19.4

3.1.1

2.19.3

2.19.2

2.19.1

3.1.0

2.19.0

3.0.3

2.18.3

3.0.2

2.18.2

3.0.1

2.18.1

3.0.0

2.18.0

2.17.5

3.0.0-RC1

2.17.4

2.17.3

2.17.2

2.17.1

3.0.0-beta2

2.17.0

2.16.3

3.0.0-beta1

2.16.2

2.16.1

2.16.0

2.15.5

2.15.4

2.15.3

2.15.2

2.15.1

2.15.0

2.14.3

2.14.2

2.14.1

2.14.0

2.13.5

2.13.4

2.13.3

2.13.2

2.13.1

2.13.0

2.12.4

2.12.3

2.12.2

2.12.1

2.12.0

2.11.3

2.11.2

2.11.1

2.11.0

2.10.5

2.10.4

2.10.3

2.10.2

2.10.1

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.5

2.8.4

2.8.3

2.8.2

2.8.1

2.8.0

2.7.5

2.7.4

v2.7.3

v2.7.2

v2.7.1

v2.7.0

v2.6.6

v2.6.5

v2.6.4

v2.6.3

v2.6.2

v2.6.1

v2.6.0

v2.5.14

v2.5.13

v2.5.12

v2.5.11

v2.5.10

v2.5.9

v2.5.8

v2.5.7

v2.5.6

v2.5.5

v2.5.4

v2.5.3

v2.5.2

v2.4.8

v2.5.1

v2.5.0

v2.5.0-RC2

v2.5.0-RC1

v2.5.0-beta1

v2.5.0-alpha2

v2.5.0-alpha1

v2.4.7

v2.4.6

v2.4.5

v2.4.4

v2.4.3

v2.3.6

v2.4.2

2.3.5

v2.4.1

v2.4.0

2.4.0-RC2

2.4.0-RC1

2.4.0-BETA2

2.3.4

2.3.3

2.4.0-BETA1

2.3.2

2.3.1

2.3.0

2.3.0-RC4

2.3.0-RC3

2.3.0-RC2

2.2.3

2.3.0-RC1

2.3.0-BETA1

2.1.7

2.2.2

2.2.1

2.1.6

2.2.0

2.2.0-RC1

2.2.0-BETA2

2.2.0-BETA1

2.1.5

2.1.4

2.1.3

2.1.2

2.1.1

2.0.7

2.1.0

2.1.0RC3

2.1.0RC2

2.1.0RC1

2.0.6

2.1.0BETA1

2.0.5

2.0.4

2.0.3

2.0.2

2.0.1

2.0.0

2.0.0RC2

2.0.0RC1

2.0.0-BETA4

2.0.0-BETA3

2.0.0-BETA2

2.0.0-BETA1

Labels

Clear labels

BC Break

Bug

Can't Fix

Deprecation

Documentation

DQL

Duplicate

Failing Test

Hacktoberfest

Improvement

Improvement

Incomplete

Invalid

Missing Tests

New Feature

PR Created

pull-request

Mirrored from GitHub Pull Request

Question

Regression

Status: Waiting feedback

Waiting feedback

WIP

Won't Fix

No Label

Milestone

No items

No Milestone

Projects

Clear projects

No project

Assignees

Clear assignees

admin

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5950