doctrine / dbal

    /**

     * @group DBAL-442

     */

    public function testSelectWithMultipleFromAndJoins()

    {

        $qb = new QueryBuilder($this->conn);

        $qb->select('DISTINCT u.id')

            ->from('users', 'u')

            ->from('articles', 'a')

            ->innerJoin('u', 'permissions', 'p', 'p.user_id = u.id')

            ->innerJoin('a', 'comments', 'c', 'c.article_id = a.id')

            ->where('u.id = a.user_id')

            ->andWhere('p.read = 1');

        self::assertEquals('SELECT DISTINCT u.id FROM users u INNER JOIN permissions p ON p.user_id = u.id, articles a INNER JOIN comments c ON c.article_id = a.id WHERE (u.id = a.user_id) AND (p.read = 1)', $qb->getSQL());

    }

    /**

     * @group DBAL-774

        self::assertEquals("SELECT id, name FROM users WHERE awesome=9001", (string) $qb);

    }

    public function testComplexSelectWithoutTableAliases()

    {

        $qb = new QueryBuilder($this->conn);

        $qb->select('DISTINCT users.id')

            ->from('users')

            ->from('articles')

            ->innerJoin('users', 'permissions', 'p', 'p.user_id = users.id')

            ->innerJoin('articles', 'comments', 'c', 'c.article_id = articles.id')

            ->where('users.id = articles.user_id')

            ->andWhere('p.read = 1');

        self::assertEquals('SELECT DISTINCT users.id FROM users INNER JOIN permissions p ON p.user_id = users.id, articles INNER JOIN comments c ON c.article_id = articles.id WHERE (users.id = articles.user_id) AND (p.read = 1)', $qb->getSQL());

    }

    public function testComplexSelectWithSomeTableAliases()

    {