Lampager\Cake\Test\TestCase\Database\SqliteCompilerTest::testUnion()

Complexity

Conditions	1
Paths	1

Size

Total Lines	32
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	0

<?php
    public function testUnion()
    {
        $posts = TableRegistry::getTableLocator()->get('Posts');

        $expected = '
            SELECT
                *
            FROM
                (
                    SELECT
                        Posts.* AS "Posts__*"
                    FROM
                        posts Posts
                    ORDER BY
                        modified ASC
                )
            UNION ALL
            SELECT
                *
            FROM
                (
                    DATETIME(\'now\')
                )
        ';

        $actual = $posts->find()
            ->select(['*'])
            ->orderAsc('modified')
            ->unionAll($posts->query()->func()->now())

$posts->query()->func()->now() of type Cake\Database\Expression\FunctionExpression is incompatible with the type Cake\Database\Query|string expected by parameter $query of Cake\Database\Query::unionAll().

            ->sql();

        $this->assertSqlEquals($expected, $actual);
    }