Project

General

Profile

Actions

Bug #79797

closed

Task #79652: Fix functional tests on PostgreSQL

Fix EXT:frontend functional tests on PostgreSQL

Added by Morton Jonuschat almost 8 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Tests
Target version:
Start date:
2017-02-08
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
8
PHP Version:
7.0
Tags:
Complexity:
Is Regression:
No
Sprint Focus:
Stabilization Sprint

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

Actions #1

Updated by Morton Jonuschat almost 8 years ago

  • Parent task set to #79652
Actions #2

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

Actions #3

Updated by Morton Jonuschat almost 8 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #4

Updated by Riccardo De Contardi about 7 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF