ModifyLimitQueryTest::testModifyLimitQuerySubSelect() fails on OracleDB

[DeepDiver1975]

[Doctrine\DBAL\Exception\SyntaxErrorException] An exception occurred while executing 'SELECT a.* FROM (SELECT *, (SELECT COUNT(*) FROM modify_limit_table) AS cnt FROM modify_limit_table) a WHERE ROWNUM <= 10':

ORA-00923: FROM keyword not found where expected

With queries:
8. SQL: 'SELECT a.* FROM (SELECT *, (SELECT COUNT(*) FROM modify_limit_table) AS cnt FROM modify_limit_table) a WHERE ROWNUM <= 10' Params: 
7. SQL: 'INSERT INTO modify_limit_table (test_int) VALUES (?)' Params: '4'
6. SQL: 'INSERT INTO modify_limit_table (test_int) VALUES (?)' Params: '3'
5. SQL: 'INSERT INTO modify_limit_table (test_int) VALUES (?)' Params: '2'
4. SQL: 'INSERT INTO modify_limit_table (test_int) VALUES (?)' Params: '1'
3. SQL: 'TRUNCATE TABLE modify_limit_table2' Params: 
2. SQL: 'TRUNCATE TABLE modify_limit_table' Params: 

Trace:
/home/deepdiver/Development/ownCloud/doctrine2/dbal/lib/Doctrine/DBAL/DBALException.php:116
/home/deepdiver/Development/ownCloud/doctrine2/dbal/lib/Doctrine/DBAL/Connection.php:832
/home/deepdiver/Development/ownCloud/doctrine2/dbal/lib/Doctrine/DBAL/Connection.php:764
/home/deepdiver/Development/ownCloud/doctrine2/dbal/tests/Doctrine/Tests/DBAL/Functional/ModifyLimitQueryTest.php:117
/home/deepdiver/Development/ownCloud/doctrine2/dbal/tests/Doctrine/Tests/DBAL/Functional/ModifyLimitQueryTest.php:108
phar:///home/deepdiver/Development/phpunit.phar/phpunit/Framework/TestCase.php:866
phar:///home/deepdiver/Development/phpunit.phar/phpunit/Framework/TestCase.php:743
phar:///home/deepdiver/Development/phpunit.phar/phpunit/Framework/TestResult.php:609
phar:///home/deepdiver/Development/phpunit.phar/phpunit/Framework/TestCase.php:699
phar:///home/deepdiver/Development/phpunit.phar/phpunit/Framework/TestSuite.php:722
phar:///home/deepdiver/Development/phpunit.phar/phpunit/Framework/TestSuite.php:722
phar:///home/deepdiver/Development/phpunit.phar/phpunit/TextUI/TestRunner.php:406
phar:///home/deepdiver/Development/phpunit.phar/phpunit/TextUI/Command.php:153
/tmp/ide-phpunit.php:294
/tmp/ide-phpunit.php:582

 /home/deepdiver/Development/ownCloud/doctrine2/dbal/tests/Doctrine/Tests/DbalFunctionalTestCase.php:73

[Ocramius]

@DeepDiver1975 I just realized that you use phpunit.phar - it is a minor issue, but please rely on ./vendor/bin/phpunit, installed as dev dependency.

[deeky666]

Not related to PHAR though. Confirmed the issue. That test class is very fragile (we know that) as it uses raw SQL and assumes it works on all platforms. We might alter the SQL though to make it more compatible.

[deeky666]

Sorry wrong issue reference.

[Ocramius]

👍

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.