DoctrineExtensions/tests/Query/Sqlite/LimitTest.php at 69f0ce7f26ece298e159889bb57b30cfee43e2a1 · beberlei/DoctrineExtensions · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<?php

namespace DoctrineExtensions\Tests\Query\Sqlite;

use DoctrineExtensions\Tests\Query\SqliteTestCase;

class LimitTest extends SqliteTestCase
{
    public function testLimit(): void
    {
        $this->assertDqlProducesSql(
            'SELECT b0 FROM DoctrineExtensions\Tests\Entities\Blank b0 WHERE b0.id = LIMIT((SELECT b1 FROM DoctrineExtensions\Tests\Entities\Blank b1 ORDER BY b1.id DESC), 1)',
            'SELECT b0_.id AS id_0 FROM Blank b0_ WHERE b0_.id = (SELECT b1_.id FROM Blank b1_ ORDER BY b1_.id DESC LIMIT 1)'
        );
    }
}