Method test_sql_native_query_05

tests/test_sql_query.py:3129–3141

(self)

            await self.assert_sql_query_result('SELECT 1 AS a, 2 AS a', [])

    async def test_sql_native_query_05(self):
        # `a` would be duplicated,
        # so second and third instance are prefixed with rel var name
        await self.assert_sql_query_result(
            '''
            WITH
              x(a) AS (VALUES (1::int)),
              y(a) AS (VALUES (1::int + 1::int)),
              z(a) AS (VALUES (1::int + 1::int + 1::int))
            SELECT * FROM x, y JOIN z u ON TRUE::bool
            ''',
            [{'a': 1, 'y_a': 2, 'u_a': 3}],
        )

    async def test_sql_native_query_06(self):
        await self.assert_sql_query_result(