doctrine/archived-orm
1
0
Fork 0
mirror of https://github.com/doctrine/orm.git synced 2026-03-24 06:52:09 +01:00
Code Issues 5.3k Packages Projects Releases 100 Wiki Activity

DDC-111: Failing tests: DQL Bug in combination with Oracle #137

New Issue
Closed
opened 2026-01-22 12:28:17 +01:00 by admin · 8 comments
admin commented 2026-01-22 12:28:17 +01:00
Owner
Copy Link

Originally created by @doctrinebot on GitHub (Nov 4, 2009).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user @beberlei:

I have several tests failing with the following exceptions.

It seems there is some wrong SQL being generated, the SQL query for the first test using Oracle is said to be:

SELECT c0*.id AS id0, c0_.status AS status1, c0_.username AS username2, c0_.name AS name3 FROM cms_users c0_ WHERE c0*.username =

The DQL for this query is:

select u from Doctrine\Tests\Models\CMS\CmsUser u where u.username = 'gblanco'

I guess there is some problem with oracle quoting then.

The exceptions are:

1) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testAddToCollectionDoesNotInitialize
PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:375
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:374

2) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testSetSetAssociationWithGetReference
PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:375
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:426

3) Doctrine\Tests\ORM\Functional\SingleTableInheritanceTest::testCRUD
PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/SingleTableInheritanceTest.php:55

4) Doctrine\Tests\ORM\Functional\ClassTableInheritanceTest::testCRUD
PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:629
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/MultiTableUpdateExecutor.php:151
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/ClassTableInheritanceTest.php:80

5) Doctrine\Tests\ORM\Functional\ClassTableInheritanceTest::testSelfReferencingOneToOne
PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/ClassTableInheritanceTest.php:162

6) Doctrine\Tests\ORM\Functional\QueryTest::testSimpleQueries
PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/QueryTest.php:44

7) Doctrine\Tests\ORM\Functional\OneToOneSelfReferentialAssociationTest::testLazyLoadsAssociation
PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/OneToOneSelfReferentialAssociationTest.php:73
Originally created by @doctrinebot on GitHub (Nov 4, 2009). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user @beberlei: I have several tests failing with the following exceptions. It seems there is some wrong SQL being generated, the SQL query for the first test using Oracle is said to be: ``` SELECT c0*.id AS id0, c0_.status AS status1, c0_.username AS username2, c0_.name AS name3 FROM cms_users c0_ WHERE c0*.username = ``` The DQL for this query is: ``` select u from Doctrine\Tests\Models\CMS\CmsUser u where u.username = 'gblanco' ``` I guess there is some problem with oracle quoting then. The exceptions are: ``` 1) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testAddToCollectionDoesNotInitialize PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:375 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:374 2) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testSetSetAssociationWithGetReference PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:375 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:426 3) Doctrine\Tests\ORM\Functional\SingleTableInheritanceTest::testCRUD PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/SingleTableInheritanceTest.php:55 4) Doctrine\Tests\ORM\Functional\ClassTableInheritanceTest::testCRUD PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:629 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/MultiTableUpdateExecutor.php:151 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/ClassTableInheritanceTest.php:80 5) Doctrine\Tests\ORM\Functional\ClassTableInheritanceTest::testSelfReferencingOneToOne PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/ClassTableInheritanceTest.php:162 6) Doctrine\Tests\ORM\Functional\QueryTest::testSimpleQueries PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/QueryTest.php:44 7) Doctrine\Tests\ORM\Functional\OneToOneSelfReferentialAssociationTest::testLazyLoadsAssociation PDOException: SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/OneToOneSelfReferentialAssociationTest.php:73 ```
admin added the Bug label 2026-01-22 12:28:17 +01:00
admin closed this issue 2026-01-22 12:28:18 +01:00
admin commented 2026-01-22 12:28:19 +01:00
Author
Owner
Copy Link

@doctrinebot commented on GitHub (Nov 4, 2009):

Comment created by @beberlei:

I can update the exception with more information given DDC-112:


1) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testAddToCollectionDoesNotInitialize
Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

With queries:
1. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params:
2. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: '12', 'developer', 'gblanco', 'Guilherme'
3. SQL: 'INSERT INTO cms*phonenumbers (phonenumber, user*id) VALUES (?, ?)' Params:
4. SQL: 'INSERT INTO cms*phonenumbers (phonenumber, user*id) VALUES (?, ?)' Params: '100', '12'
5. SQL: 'INSERT INTO cms*phonenumbers (phonenumber, user*id) VALUES (?, ?)' Params: '101', '12'
6. SQL: 'INSERT INTO cms*phonenumbers (phonenumber, user*id) VALUES (?, ?)' Params: '102', '12'
7. SQL: 'SELECT c0*.id AS id0, c0_.status AS status1, c0_.username AS username2, c0_.name AS name3 FROM cms_users c0_ WHERE c0*.username = ' Params:

Trace:
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:375
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:374


/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235

2) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testSetSetAssociationWithGetReference
Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

With queries:
1. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params:
2. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: '13', 'developer', 'gblanco', 'Guilherme'
3. SQL: 'INSERT INTO cms*addresses (id, country, zip, city, user*id) VALUES (?, ?, ?, ?, ?)' Params:
4. SQL: 'INSERT INTO cms*addresses (id, country, zip, city, user*id) VALUES (?, ?, ?, ?, ?)' Params: '2', 'Germany', '12345', 'Berlin', ''
5. SQL: 'SELECT id, country, zip, city, user*id FROM cms*addresses WHERE id = ?' Params:
6. SQL: 'UPDATE cms*addresses SET user*id = ? WHERE id = ?' Params: '13', '2'
7. SQL: 'SELECT c0*.id AS id0, c0_.status AS status1, c0_.username AS username2, c0_.name AS name3, c1_.id AS id4, c1_.country AS country5, c1_.zip AS zip6, c1_.city AS city7, c1_.user_id AS user_id8 FROM cms_users c0_ INNER JOIN cms_addresses c1_ ON c0_.id = c1_.user_id WHERE c0*.username = ' Params:

Trace:
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:375
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:426


/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235

3) Doctrine\Tests\ORM\Functional\SingleTableInheritanceTest::testCRUD
Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

With queries:
1. SQL: 'CREATE TABLE ParentEntity (id NUMBER(10) NOT NULL, DATA VARCHAR2(255) NOT NULL, discr VARCHAR2(4000) NOT NULL, "number" NUMBER(10) DEFAULT NULL, related*entity*id NUMBER(10) DEFAULT NULL, PRIMARY KEY(id))' Params:
2. SQL: 'CREATE TABLE RelatedEntity (id NUMBER(10) NOT NULL, name VARCHAR2(50) NOT NULL, PRIMARY KEY(id))' Params:
3. SQL: 'CREATE SEQUENCE ParentEntity*id*seq START WITH 1 INCREMENT BY 20' Params:
4. SQL: 'CREATE SEQUENCE RelatedEntity*id*seq START WITH 1 INCREMENT BY 20' Params:
5. SQL: 'ALTER TABLE ParentEntity ADD FOREIGN KEY (related*entity*id) REFERENCES RelatedEntity(id)' Params:
6. SQL: 'SELECT ParentEntity*id*seq.nextval FROM DUAL' Params:
7. SQL: 'SELECT RelatedEntity*id*seq.nextval FROM DUAL' Params:
8. SQL: 'INSERT INTO RelatedEntity (id, name) VALUES (?, ?)' Params:
9. SQL: 'INSERT INTO RelatedEntity (id, name) VALUES (?, ?)' Params: '1', 'theRelatedOne'
10. SQL: 'INSERT INTO ParentEntity (id, DATA, "number", related*entity*id, discr) VALUES (?, ?, ?, ?, ?)' Params:
11. SQL: 'INSERT INTO ParentEntity (id, DATA, "number", related*entity*id, discr) VALUES (?, ?, ?, ?, ?)' Params: '2', 'thedata', '1234', '1', 'child'
12. SQL: 'INSERT INTO ParentEntity (id, DATA, discr) VALUES (?, ?, ?)' Params:
13. SQL: 'INSERT INTO ParentEntity (id, DATA, discr) VALUES (?, ?, ?)' Params: '1', 'foobar', 'parent'
14. SQL: 'SELECT p0*.id AS id0, p0_.DATA AS DATA1, p0_."number" AS number2, p0_.related_entity_id AS related_entity_id3, p0_.discr AS discr4 FROM ParentEntity p0_ WHERE p0_.discr IN (, ) ORDER BY p0*.DATA ASC' Params:

Trace:
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/SingleTableInheritanceTest.php:55


/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235

4) Doctrine\Tests\ORM\Functional\ClassTableInheritanceTest::testCRUD
Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

With queries:
1. SQL: 'SELECT company*persons_id*seq.nextval FROM DUAL' Params:
2. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params:
3. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: '1', 'Roman S. Borschel', '', 'person'
4. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params:
5. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params:
6. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: '2', 'Guilherme Blanco', '', 'employee'
7. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '2', '100000', 'IT'
8. SQL: 'SELECT c0*.id AS id0, c0_.name AS name1, c1_.title AS title2, c1_.car_id AS car_id3, c2_.salary AS salary4, c2_.department AS department5, c0_.discr AS discr6, c0_.spouse_id AS spouse_id7 FROM company_persons c0_ LEFT JOIN company_managers c1_ ON c0_.id = c1_.id LEFT JOIN company_employees c2_ ON c0_.id = c2_.id ORDER BY c0*.name DESC' Params:
9. SQL: 'SELECT c0*.id AS id0, c0_.name AS name1, c1_.salary AS salary2, c1_.department AS department3, c2_.title AS title4, c2_.car_id AS car_id5, c0_.discr AS discr6, c0_.spouse_id AS spouse_id7 FROM company_employees c1_ INNER JOIN company_persons c0_ ON c1_.id = c0_.id LEFT JOIN company_managers c2_ ON c1_.id = c2*.id' Params:
10. SQL: 'CREATE GLOBAL TEMPORARY TABLE company*persons_id*tmp (id NUMBER(10) NOT NULL, PRIMARY KEY(id))' Params:
11. SQL: 'INSERT INTO company*persons_id_tmp (id) SELECT t0.id FROM company_employees t0 INNER JOIN company_persons c0_ ON t0.id = c0_.id LEFT JOIN company_managers c1_ ON t0.id = c1_.id WHERE c0*.name =  AND t0.salary = ?' Params: '100000'

Trace:
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:629
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/MultiTableUpdateExecutor.php:151
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/ClassTableInheritanceTest.php:80


/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235

5) Doctrine\Tests\ORM\Functional\ClassTableInheritanceTest::testSelfReferencingOneToOne
Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

With queries:
1. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params:
2. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: '6', 'Mary Smith', '', 'person'
3. SQL: 'INSERT INTO company*managers (id, title, car*id) VALUES (?, ?, ?)' Params:
4. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params:
5. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params:
6. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: '5', 'John Smith', '6', 'manager'
7. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '5', '100000', 'IT'
8. SQL: 'INSERT INTO company*managers (id, title, car*id) VALUES (?, ?, ?)' Params: '5', 'CTO', ''
9. SQL: 'UPDATE company*persons SET spouse*id = ? WHERE id = ?' Params: '5', '6'
10. SQL: 'SELECT c0*.id AS id0, c0_.name AS name1, c1_.title AS title2, c1_.car_id AS car_id3, c2_.salary AS salary4, c2_.department AS department5, c3_.id AS id6, c3_.name AS name7, c4_.title AS title8, c4_.car_id AS car_id9, c5_.salary AS salary10, c5_.department AS department11, c0_.discr AS discr12, c0_.spouse_id AS spouse_id13, c3_.discr AS discr14, c3_.spouse_id AS spouse_id15 FROM company_persons c0_ LEFT JOIN company_managers c1_ ON c0_.id = c1_.id LEFT JOIN company_employees c2_ ON c0_.id = c2_.id INNER JOIN company_persons c3_ ON c0_.spouse_id = c3_.id LEFT JOIN company_managers c4_ ON c3_.id = c4_.id LEFT JOIN company_employees c5_ ON c3_.id = c5_.id WHERE c0*.name = ' Params:

Trace:
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/ClassTableInheritanceTest.php:162


/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235

6) Doctrine\Tests\ORM\Functional\QueryTest::testSimpleQueries
Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

With queries:
1. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params:
2. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: '18', 'developer', 'gblanco', 'Guilherme'
3. SQL: 'SELECT c0*.id AS id0, c0_.status AS status1, c0_.username AS username2, c0_.name AS name3, UPPER(c0_.name) AS sclr4 FROM cms_users c0_ WHERE c0*.username = ' Params:

Trace:
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/QueryTest.php:44


/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235

7) Doctrine\Tests\ORM\Functional\OneToOneSelfReferentialAssociationTest::testLazyLoadsAssociation
Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression
 (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142)

With queries:
1. SQL: 'INSERT INTO ecommerce*customers (id, name, mentor*id) VALUES (?, ?, ?)' Params:
2. SQL: 'INSERT INTO ecommerce*customers (id, name, mentor*id) VALUES (?, ?, ?)' Params: '14', 'Luke Skywalker', ''
3. SQL: 'INSERT INTO ecommerce*customers (id, name, mentor*id) VALUES (?, ?, ?)' Params: '15', 'Obi-wan Kenobi', ''
4. SQL: 'UPDATE ecommerce*customers SET mentor*id = ? WHERE id = ?' Params: '15', '14'
5. SQL: 'SELECT e0*.id AS id0, e0_.name AS name1, e0_.mentor_id AS mentor_id2 FROM ecommerce_customers e0_ WHERE e0*.name = ' Params:

Trace:
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489
/home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337
/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/OneToOneSelfReferentialAssociationTest.php:73


/home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235
@doctrinebot commented on GitHub (Nov 4, 2009): Comment created by @beberlei: I can update the exception with more information given [DDC-112](http://www.doctrine-project.org/jira/browse/DDC-112): ``` 1) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testAddToCollectionDoesNotInitialize Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) With queries: 1. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: 2. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: '12', 'developer', 'gblanco', 'Guilherme' 3. SQL: 'INSERT INTO cms*phonenumbers (phonenumber, user*id) VALUES (?, ?)' Params: 4. SQL: 'INSERT INTO cms*phonenumbers (phonenumber, user*id) VALUES (?, ?)' Params: '100', '12' 5. SQL: 'INSERT INTO cms*phonenumbers (phonenumber, user*id) VALUES (?, ?)' Params: '101', '12' 6. SQL: 'INSERT INTO cms*phonenumbers (phonenumber, user*id) VALUES (?, ?)' Params: '102', '12' 7. SQL: 'SELECT c0*.id AS id0, c0_.status AS status1, c0_.username AS username2, c0_.name AS name3 FROM cms_users c0_ WHERE c0*.username = ' Params: Trace: /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:375 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:374 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235 2) Doctrine\Tests\ORM\Functional\BasicFunctionalTest::testSetSetAssociationWithGetReference Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) With queries: 1. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: 2. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: '13', 'developer', 'gblanco', 'Guilherme' 3. SQL: 'INSERT INTO cms*addresses (id, country, zip, city, user*id) VALUES (?, ?, ?, ?, ?)' Params: 4. SQL: 'INSERT INTO cms*addresses (id, country, zip, city, user*id) VALUES (?, ?, ?, ?, ?)' Params: '2', 'Germany', '12345', 'Berlin', '' 5. SQL: 'SELECT id, country, zip, city, user*id FROM cms*addresses WHERE id = ?' Params: 6. SQL: 'UPDATE cms*addresses SET user*id = ? WHERE id = ?' Params: '13', '2' 7. SQL: 'SELECT c0*.id AS id0, c0_.status AS status1, c0_.username AS username2, c0_.name AS name3, c1_.id AS id4, c1_.country AS country5, c1_.zip AS zip6, c1_.city AS city7, c1_.user_id AS user_id8 FROM cms_users c0_ INNER JOIN cms_addresses c1_ ON c0_.id = c1_.user_id WHERE c0*.username = ' Params: Trace: /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:375 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/BasicFunctionalTest.php:426 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235 3) Doctrine\Tests\ORM\Functional\SingleTableInheritanceTest::testCRUD Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) With queries: 1. SQL: 'CREATE TABLE ParentEntity (id NUMBER(10) NOT NULL, DATA VARCHAR2(255) NOT NULL, discr VARCHAR2(4000) NOT NULL, "number" NUMBER(10) DEFAULT NULL, related*entity*id NUMBER(10) DEFAULT NULL, PRIMARY KEY(id))' Params: 2. SQL: 'CREATE TABLE RelatedEntity (id NUMBER(10) NOT NULL, name VARCHAR2(50) NOT NULL, PRIMARY KEY(id))' Params: 3. SQL: 'CREATE SEQUENCE ParentEntity*id*seq START WITH 1 INCREMENT BY 20' Params: 4. SQL: 'CREATE SEQUENCE RelatedEntity*id*seq START WITH 1 INCREMENT BY 20' Params: 5. SQL: 'ALTER TABLE ParentEntity ADD FOREIGN KEY (related*entity*id) REFERENCES RelatedEntity(id)' Params: 6. SQL: 'SELECT ParentEntity*id*seq.nextval FROM DUAL' Params: 7. SQL: 'SELECT RelatedEntity*id*seq.nextval FROM DUAL' Params: 8. SQL: 'INSERT INTO RelatedEntity (id, name) VALUES (?, ?)' Params: 9. SQL: 'INSERT INTO RelatedEntity (id, name) VALUES (?, ?)' Params: '1', 'theRelatedOne' 10. SQL: 'INSERT INTO ParentEntity (id, DATA, "number", related*entity*id, discr) VALUES (?, ?, ?, ?, ?)' Params: 11. SQL: 'INSERT INTO ParentEntity (id, DATA, "number", related*entity*id, discr) VALUES (?, ?, ?, ?, ?)' Params: '2', 'thedata', '1234', '1', 'child' 12. SQL: 'INSERT INTO ParentEntity (id, DATA, discr) VALUES (?, ?, ?)' Params: 13. SQL: 'INSERT INTO ParentEntity (id, DATA, discr) VALUES (?, ?, ?)' Params: '1', 'foobar', 'parent' 14. SQL: 'SELECT p0*.id AS id0, p0_.DATA AS DATA1, p0_."number" AS number2, p0_.related_entity_id AS related_entity_id3, p0_.discr AS discr4 FROM ParentEntity p0_ WHERE p0_.discr IN (, ) ORDER BY p0*.DATA ASC' Params: Trace: /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/SingleTableInheritanceTest.php:55 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235 4) Doctrine\Tests\ORM\Functional\ClassTableInheritanceTest::testCRUD Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) With queries: 1. SQL: 'SELECT company*persons_id*seq.nextval FROM DUAL' Params: 2. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: 3. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: '1', 'Roman S. Borschel', '', 'person' 4. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: 5. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: 6. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: '2', 'Guilherme Blanco', '', 'employee' 7. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '2', '100000', 'IT' 8. SQL: 'SELECT c0*.id AS id0, c0_.name AS name1, c1_.title AS title2, c1_.car_id AS car_id3, c2_.salary AS salary4, c2_.department AS department5, c0_.discr AS discr6, c0_.spouse_id AS spouse_id7 FROM company_persons c0_ LEFT JOIN company_managers c1_ ON c0_.id = c1_.id LEFT JOIN company_employees c2_ ON c0_.id = c2_.id ORDER BY c0*.name DESC' Params: 9. SQL: 'SELECT c0*.id AS id0, c0_.name AS name1, c1_.salary AS salary2, c1_.department AS department3, c2_.title AS title4, c2_.car_id AS car_id5, c0_.discr AS discr6, c0_.spouse_id AS spouse_id7 FROM company_employees c1_ INNER JOIN company_persons c0_ ON c1_.id = c0_.id LEFT JOIN company_managers c2_ ON c1_.id = c2*.id' Params: 10. SQL: 'CREATE GLOBAL TEMPORARY TABLE company*persons_id*tmp (id NUMBER(10) NOT NULL, PRIMARY KEY(id))' Params: 11. SQL: 'INSERT INTO company*persons_id_tmp (id) SELECT t0.id FROM company_employees t0 INNER JOIN company_persons c0_ ON t0.id = c0_.id LEFT JOIN company_managers c1_ ON t0.id = c1_.id WHERE c0*.name = AND t0.salary = ?' Params: '100000' Trace: /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:629 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/MultiTableUpdateExecutor.php:151 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/ClassTableInheritanceTest.php:80 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235 5) Doctrine\Tests\ORM\Functional\ClassTableInheritanceTest::testSelfReferencingOneToOne Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) With queries: 1. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: 2. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: '6', 'Mary Smith', '', 'person' 3. SQL: 'INSERT INTO company*managers (id, title, car*id) VALUES (?, ?, ?)' Params: 4. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: 5. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: 6. SQL: 'INSERT INTO company*persons (id, name, spouse*id, discr) VALUES (?, ?, ?, ?)' Params: '5', 'John Smith', '6', 'manager' 7. SQL: 'INSERT INTO company_employees (id, salary, department) VALUES (?, ?, ?)' Params: '5', '100000', 'IT' 8. SQL: 'INSERT INTO company*managers (id, title, car*id) VALUES (?, ?, ?)' Params: '5', 'CTO', '' 9. SQL: 'UPDATE company*persons SET spouse*id = ? WHERE id = ?' Params: '5', '6' 10. SQL: 'SELECT c0*.id AS id0, c0_.name AS name1, c1_.title AS title2, c1_.car_id AS car_id3, c2_.salary AS salary4, c2_.department AS department5, c3_.id AS id6, c3_.name AS name7, c4_.title AS title8, c4_.car_id AS car_id9, c5_.salary AS salary10, c5_.department AS department11, c0_.discr AS discr12, c0_.spouse_id AS spouse_id13, c3_.discr AS discr14, c3_.spouse_id AS spouse_id15 FROM company_persons c0_ LEFT JOIN company_managers c1_ ON c0_.id = c1_.id LEFT JOIN company_employees c2_ ON c0_.id = c2_.id INNER JOIN company_persons c3_ ON c0_.spouse_id = c3_.id LEFT JOIN company_managers c4_ ON c3_.id = c4_.id LEFT JOIN company_employees c5_ ON c3_.id = c5_.id WHERE c0*.name = ' Params: Trace: /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/ClassTableInheritanceTest.php:162 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235 6) Doctrine\Tests\ORM\Functional\QueryTest::testSimpleQueries Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) With queries: 1. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: 2. SQL: 'INSERT INTO cms_users (id, status, username, name) VALUES (?, ?, ?, ?)' Params: '18', 'developer', 'gblanco', 'Guilherme' 3. SQL: 'SELECT c0*.id AS id0, c0_.status AS status1, c0_.username AS username2, c0_.name AS name3, UPPER(c0_.name) AS sclr4 FROM cms_users c0_ WHERE c0*.username = ' Params: Trace: /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/QueryTest.php:44 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235 7) Doctrine\Tests\ORM\Functional\OneToOneSelfReferentialAssociationTest::testLazyLoadsAssociation Exception: [PDOException] SQLSTATE[HY000]: General error: 936 OCIStmtExecute: ORA-00936: missing expression (/tmp/pear/download/PDO*OCI-1.0/oci*statement.c:142) With queries: 1. SQL: 'INSERT INTO ecommerce*customers (id, name, mentor*id) VALUES (?, ?, ?)' Params: 2. SQL: 'INSERT INTO ecommerce*customers (id, name, mentor*id) VALUES (?, ?, ?)' Params: '14', 'Luke Skywalker', '' 3. SQL: 'INSERT INTO ecommerce*customers (id, name, mentor*id) VALUES (?, ?, ?)' Params: '15', 'Obi-wan Kenobi', '' 4. SQL: 'UPDATE ecommerce*customers SET mentor*id = ? WHERE id = ?' Params: '15', '14' 5. SQL: 'SELECT e0*.id AS id0, e0_.name AS name1, e0_.mentor_id AS mentor_id2 FROM ecommerce_customers e0_ WHERE e0*.name = ' Params: Trace: /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/DBAL/Connection.php:606 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:42 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/Query.php:197 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:489 /home/benny/code/php/wsnetbeans/Doctrine/trunk/lib/Doctrine/ORM/AbstractQuery.php:337 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/ORM/Functional/OneToOneSelfReferentialAssociationTest.php:73 /home/benny/code/php/wsnetbeans/Doctrine/trunk/tests/Doctrine/Tests/OrmFunctionalTestCase.php:235 ```
admin commented 2026-01-22 12:28:20 +01:00
Author
Owner
Copy Link

@doctrinebot commented on GitHub (Nov 5, 2009):

Comment created by romanb:

If this was introduced by the refactorings of guilherme this either needs to be reverted or fixed asap.

I think all these tests ran fine on oracle before.

Does anyone know at which revision these issues started to appear?

@doctrinebot commented on GitHub (Nov 5, 2009): Comment created by romanb: If this was introduced by the refactorings of guilherme this either needs to be reverted or fixed asap. I think all these tests ran fine on oracle before. Does anyone know at which revision these issues started to appear?
admin commented 2026-01-22 12:28:20 +01:00
Author
Owner
Copy Link

@doctrinebot commented on GitHub (Nov 5, 2009):

Comment created by @beberlei:

I think the tests were failing before the refactoring, i had them run with this problems before i did the svn update. I am not 100% sure though :-)

@doctrinebot commented on GitHub (Nov 5, 2009): Comment created by @beberlei: I think the tests were failing before the refactoring, i had them run with this problems before i did the svn update. I am not 100% sure though :-)
admin commented 2026-01-22 12:28:21 +01:00
Author
Owner
Copy Link

@doctrinebot commented on GitHub (Nov 5, 2009):

Comment created by romanb:

These tests run fine for me on rev. 6643 where I am currently. Looks like a (serious) regression :(

I do get the same segfault issue as jon but not with the tests that fail here. These all run fine.

@doctrinebot commented on GitHub (Nov 5, 2009): Comment created by romanb: These tests run fine for me on rev. 6643 where I am currently. Looks like a (serious) regression :( I do get the same segfault issue as jon but not with the tests that fail here. These all run fine.
admin commented 2026-01-22 12:28:21 +01:00
Author
Owner
Copy Link

@doctrinebot commented on GitHub (Nov 6, 2009):

Comment created by romanb:

Can't reproduce this :(

@doctrinebot commented on GitHub (Nov 6, 2009): Comment created by romanb: Can't reproduce this :(
admin commented 2026-01-22 12:28:22 +01:00
Author
Owner
Copy Link

@doctrinebot commented on GitHub (Jan 14, 2010):

Comment created by @guilhermeblanco:

I'm the responsable of this issue! =P

@doctrinebot commented on GitHub (Jan 14, 2010): Comment created by @guilhermeblanco: I'm the responsable of this issue! =P
admin commented 2026-01-22 12:28:22 +01:00
Author
Owner
Copy Link

@doctrinebot commented on GitHub (Jan 31, 2010):

Comment created by @beberlei:

This was just with PDO, on OCI8 they run correctly. I close this and we should delete the PDO OCI8 code, its trouble! :-)

@doctrinebot commented on GitHub (Jan 31, 2010): Comment created by @beberlei: This was just with PDO, on OCI8 they run correctly. I close this and we should delete the PDO OCI8 code, its trouble! :-)
admin commented 2026-01-22 12:28:23 +01:00
Author
Owner
Copy Link

@doctrinebot commented on GitHub (Jan 31, 2010):

Issue was closed with resolution "Cannot Reproduce"

@doctrinebot commented on GitHub (Jan 31, 2010): Issue was closed with resolution "Cannot Reproduce"
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
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 Bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
admin
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#137
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?