Em sex., 3 de jul. de 2026 às 08:08, Ayush Tiwari < [email protected]> escreveu:
> - BY NAME requires a query source and is rejected for VALUES and DEFAULT > VALUES. BY POSITION is accepted with DEFAULT VALUES as a no-op. > Is it rejected for VALUES, even if those VALUES are named ? This one should work, doesn't it ? insert into t1 (c1, c2) by name select * from (Values (1,2)) x(c2, c1) And is missing a test for select *, right ? create table a(a int, b int, c int); create table b(b int, c int, a int); insert into a by name select * from b; regards Marcos
