Doctrine DBAL

Quoting is not supported in pdo_odbc driver

Details

  • Type: Bug Bug
  • Status: Resolved Resolved
  • Priority: Major Major
  • Resolution: Can't Fix
  • Affects Version/s: 2.0.3
  • Fix Version/s: None
  • Component/s: Drivers
  • Labels:
    None
  • Environment:
    System Windows NT 5.1 build 2600 (Windows XP Professional Service Pack 3) i586
    Compiler MSVC6 (Visual C++ 6.0)
    Apache Version Apache/2.2.17 (Win32) PHP/5.3.5

Description

trying to execute this dql:

SELECT p FROM my\namespace\entities\PQR p WHERE p.razon = 'TEL'

it built this native sql (iseries)

SELECT t0_.SGNUMÑ AS SGNUMÑ0, t0_.SGCAUS AS SGCAUS1, t0_.SGREAS AS SGREAS2 FROM SGMASTL7 t0_ WHERE t0_.SGCAUS =

because pdo is created with odbc[1], quote method[2] is not supported, and Doctrine/DBAL/Connection.php#quote()[3] method returns an empty value for <'TEL'> expression, so Database throws a Syntax error. It should be support for drivers which doesn't have implemented quote() method.

[1] with odbc: $pdo = new PDO("odbc:MY_ODBC_NAME", "USER", "PASSWORD");
[2] http://php.net/manual/en/pdo.quote.php
[3] https://github.com/doctrine/dbal/blob/2.0.3/lib/Doctrine/DBAL/Connection.php#L520

Activity

Ascending order - Click to sort in descending order
John Arevalo made changes -
Field Original Value New Value
Description trying to execute this dql:

SELECT p FROM my\namespace\entities\PQR p WHERE p.razon = 'TEL'

it built this native sql (iseries)

SELECT t0_.SGNUMÑ AS SGNUMÑ0, t0_.SGCAUS AS SGCAUS1, t0_.SGREAS AS SGREAS2 FROM SGMASTL7 t0_ WHERE t0_.SGCAUS =

because pdo is created with odbc[1], quote method[2] is not supported, and Doctrine/DBAL/Connection.php#quote()[3] method returns an empty value for <'TEL'> expression, so Database throws a Syntax error. It should be support for drivers which doesn't have implemented quote() method.

[1] with odbc: $pdo = new PDO("odbc:MY_ODBC_NAME", "USER", "PASSWORD");
[2] http://php.net/manual/en/pdo.quote.php
[3]https://github.com/doctrine/dbal/blob/2.0.3/lib/Doctrine/DBAL/Connection.php#L520 		trying to execute this dql:

SELECT p FROM my\namespace\entities\PQR p WHERE p.razon = 'TEL'

it built this native sql (iseries)

SELECT t0_.SGNUMÑ AS SGNUMÑ0, t0_.SGCAUS AS SGCAUS1, t0_.SGREAS AS SGREAS2 FROM SGMASTL7 t0_ WHERE t0_.SGCAUS =

because pdo is created with odbc[1], quote method[2] is not supported, and Doctrine/DBAL/Connection.php#quote()[3] method returns an empty value for <'TEL'> expression, so Database throws a Syntax error. It should be support for drivers which doesn't have implemented quote() method.

[1] with odbc: $pdo = new PDO("odbc:MY_ODBC_NAME", "USER", "PASSWORD");
[2] http://php.net/manual/en/pdo.quote.php
[3] https://github.com/doctrine/dbal/blob/2.0.3/lib/Doctrine/DBAL/Connection.php#L520
John Arevalo made changes -
Comment [ fixing url ]
Benjamin Eberlei made changes -
Status Open [ 1 ] Resolved [ 5 ]
Resolution Can't Fix [ 7 ]
Benjamin Eberlei made changes -
Workflow jira [ 12487 ] jira-feedback2 [ 17705 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 17705 ] jira-feedback3 [ 20060 ]

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    John Arevalo
Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: