Method test_sql_dml_insert_13

tests/test_sql_dml.py:302–336

(self)

        self.assertEqual(first[2], 'meeting report (new)')

    async def test_sql_dml_insert_13(self):
        # returning sublink
        await self.scon.execute('INSERT INTO "User" DEFAULT VALUES;')
        await self.scon.execute(
            '''
            INSERT INTO "Document" (title, owner_id)
            SELECT 'Report', id FROM "User" LIMIT 1
            '''
        )

        res = await self.squery_values(
            '''
            INSERT INTO "Document" as subject (title, owner_id)
            VALUES ('Report', NULL), ('Briefing', (SELECT id FROM "User"))
            RETURNING (
                SELECT COUNT(*) FROM "User" WHERE "User".id = owner_id
            ),
            (
                SELECT COUNT(*) FROM "User"
            ),
            (
                SELECT COUNT(*) FROM "Document" AS d
                WHERE subject.title = d.title
            )
            '''
        )
        self.assertEqual(
            res,
            tb.bag(
                [
                    [0, 1, 1],
                    [1, 1, 0],
                ]
            ),
        )

    async def test_sql_dml_insert_14(self):
        with self.assertRaisesRegex(