Phalcon\Test\Unit\Mvc\Model\Query\BuilderTest::testIssue701 PHP Method

    public function testIssue701()
    {
        $this->specify("Query Builders don't work with mixed integer and string placeholders", function () {
            $di = $this->di;
            $builder = new Builder();
            $phql = $builder->setDi($di)->from(Robots::class)->leftJoin(RobotsParts::class, "Robots.id = RobotsParts.robots_id")->leftJoin(Parts::class, "Parts.id = RobotsParts.parts_id")->where("Robots.id > :1: AND Robots.id < :2:", [1 => 0, 2 => 1000]);
            $params = $phql->getQuery()->getBindParams();
            expect($params[1])->equals(0);
            expect($params[2])->equals(1000);
            $phql->andWhere("Robots.name = :name:", ["name" => "Voltron"]);
            $params = $phql->getQuery()->getBindParams();
            expect($params[1])->equals(0);
            expect($params[2])->equals(1000);
            expect($params["name"])->equals("Voltron");
        });
    }