Bug #79797
closedTask #79652: Fix functional tests on PostgreSQL
Fix EXT:frontend functional tests on PostgreSQL
100%
Description
There were 7 failures:
1) TYPO3\CMS\Frontend\Tests\Functional\ContentObject\ContentObjectRendererTest::getQuery with data set "testing #17284: adding uid/pid for workspaces" ('tt_content', array('header,bodytext'), array('header,bodytext, `tt_content`...state`'))
Failed asserting that two strings are equal.
--- Expected
++ Actual@
@
-'header,bodytext, `tt_content`.`uid` AS `uid`, `tt_content`.`pid` AS `pid`, `tt_content`.`t3ver_state` AS `t3ver_state`'
'header,bodytext, "tt_content"."uid" AS "uid", "tt_content"."pid" AS "pid", "tt_content"."t3ver_state" AS "t3ver_state"'
/var/www/html/master.local.typo3.org/TYPO3.CMS/typo3/sysext/frontend/Tests/Functional/ContentObject/ContentObjectRendererTest.php:184
2) TYPO3\CMS\Frontend\Tests\Functional\ContentObject\ContentObjectRendererTest::getQuery with data set "testing #29783: joined tables, prefix tablename" ('tt_content', array('tt_content.header,be_users.username', 'be_users ON tt_content.cruser...rs.uid'), array('tt_content.header,be_users.us...state`'))
Failed asserting that two strings are equal.
--- Expected
++ Actual@
@
-'tt_content.header,be_users.username, `tt_content`.`uid` AS `uid`, `tt_content`.`pid` AS `pid`, `tt_content`.`t3ver_state` AS `t3ver_state`'
'tt_content.header,be_users.username, "tt_content"."uid" AS "uid", "tt_content"."pid" AS "pid", "tt_content"."t3ver_state" AS "t3ver_state"'
/var/www/html/master.local.typo3.org/TYPO3.CMS/typo3/sysext/frontend/Tests/Functional/ContentObject/ContentObjectRendererTest.php:184
3) TYPO3\CMS\Frontend\Tests\Functional\ContentObject\ContentObjectRendererTest::getWhereReturnCorrectQuery with data set #0 (array(array(array(), array())), 'tt_content', array('42', 43, 'tt_content.cruser_id=5', 'tt_content.title', 'tt_content.sorting'), 'WHERE (`tt_content`.`uid` IN ...rting`')
Failed asserting that two strings are identical.
--- Expected
+++ Actual@
@
-WHERE (`tt_content`.`uid` IN (42)) AND (`tt_content`.`pid` IN (43)) AND (tt_content.cruser_id=5) GROUP BY `tt_content`.`title` ORDER BY `tt_content`.`sorting`
+WHERE ("tt_content"."uid" IN (42)) AND ("tt_content"."pid" IN (43)) AND (tt_content.cruser_id=5) GROUP BY "tt_content"."title" ORDER BY "tt_content"."sorting"
/var/www/html/master.local.typo3.org/TYPO3.CMS/typo3/sysext/frontend/Tests/Functional/ContentObject/ContentObjectRendererTest.php:336
4) TYPO3\CMS\Frontend\Tests\Functional\ContentObject\ContentObjectRendererTest::getWhereReturnCorrectQuery with data set #1 (array(array(array('deleted', array('hidden', 'startdate', 'enddate'), 'sys_language_uid', 'l18n_parent'), array())), 'tt_content', array(42, 43, 'tt_content.cruser_id=5', 'tt_content.title', 'tt_content.sorting'), 'WHERE (`tt_content`.`uid` IN ...rting`')
Failed asserting that two strings are identical.
--- Expected
+++ Actual@
@
-WHERE (`tt_content`.`uid` IN (42)) AND (`tt_content`.`pid` IN (43)) AND (tt_content.cruser_id=5) AND (`tt_content`.`sys_language_uid` = 13) AND ((`tt_content`.`deleted` = 0) AND (`tt_content`.`hidden` = 0) AND (`tt_content`.`startdate` <= 4242) AND ((`tt_content`.`enddate` = 0) OR (`tt_content`.`enddate` > 4242))) GROUP BY `tt_content`.`title` ORDER BY `tt_content`.`sorting`
+WHERE ("tt_content"."uid" IN (42)) AND ("tt_content"."pid" IN (43)) AND (tt_content.cruser_id=5) AND ("tt_content"."sys_language_uid" = 13) AND (("tt_content"."deleted" = 0) AND ("tt_content"."hidden" = 0) AND ("tt_content"."startdate" <= 4242) AND (("tt_content"."enddate" = 0) OR ("tt_content"."enddate" > 4242))) GROUP BY "tt_content"."title" ORDER BY "tt_content"."sorting"
/var/www/html/master.local.typo3.org/TYPO3.CMS/typo3/sysext/frontend/Tests/Functional/ContentObject/ContentObjectRendererTest.php:336
5) TYPO3\CMS\Frontend\Tests\Functional\ContentObject\ContentObjectRendererTest::getWhereReturnCorrectQuery with data set #2 (array(array(array('sys_language_uid', 'l18n_parent'), array())), 'tt_content', array(42, 43, 'tt_content.cruser_id=5', 0), 'WHERE (`tt_content`.`uid` IN ..._id=5)')
Failed asserting that two strings are identical.
--- Expected
+++ Actual@
@
-WHERE (`tt_content`.`uid` IN (42)) AND (`tt_content`.`pid` IN (43)) AND (tt_content.cruser_id=5)
+WHERE ("tt_content"."uid" IN (42)) AND ("tt_content"."pid" IN (43)) AND (tt_content.cruser_id=5)
/var/www/html/master.local.typo3.org/TYPO3.CMS/typo3/sysext/frontend/Tests/Functional/ContentObject/ContentObjectRendererTest.php:336
6) TYPO3\CMS\Frontend\Tests\Functional\Page\PageRepositoryTest::previewShowsPagesFromLiveAndCurrentWorkspace
Failed asserting that '11' is identical to 11.
/var/www/html/master.local.typo3.org/TYPO3.CMS/typo3/sysext/frontend/Tests/Functional/Page/PageRepositoryTest.php:389
7) TYPO3\CMS\Frontend\Tests\Functional\Page\PageRepositoryTest::getWorkspaceVersionReturnsTheCorrectMethod
Failed asserting that '12' is identical to 12.
/var/www/html/master.local.typo3.org/TYPO3.CMS/typo3/sysext/frontend/Tests/Functional/Page/PageRepositoryTest.php:411
Updated by Gerrit Code Review almost 8 years ago
- Status changed from New to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/51764
Updated by Morton Jonuschat almost 8 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 171e2fdc337d3730bbcff46a017b2fe99a4821d0.
Updated by Riccardo De Contardi about 7 years ago
- Status changed from Resolved to Closed