DoctrineExtensions\Tests\Query\Mysql\StringTest::testLeast PHP Method

testLeast() public method

Test case for MYSQL Comparison function LEAST.
public testLeast ( )
    public function testLeast()
    {
        $q = $this->entityManager->createQuery("SELECT LEAST(10,1,4,0.4,0.003) AS lest FROM DoctrineExtensions\\Tests\\Entities\\Blank b");
        $this->assertEquals('SELECT LEAST(10, 1, 4, 0.4, 0.003) AS sclr_0 FROM Blank b0_', $q->getSql());
        $q = $this->entityManager->createQuery("SELECT LEAST('M', 'N', 'o', 'c', 'C') AS lest FROM DoctrineExtensions\\Tests\\Entities\\Blank b");
        $this->assertEquals("SELECT LEAST('M', 'N', 'o', 'c', 'C') AS sclr_0 FROM Blank b0_", $q->getSql());
        $q = $this->entityManager->createQuery("SELECT LEAST(b.id, 15) AS lest FROM DoctrineExtensions\\Tests\\Entities\\Blank b");
        $this->assertEquals("SELECT LEAST(b0_.id, 15) AS sclr_0 FROM Blank b0_", $q->getSql());
    }