sqlitestudio
sqlitestudio copied to clipboard
select from values returns first value multiple time instead of all values
Details
If you run
select T.* from (values (1),(2),(3),(4),(5)) as T;
you get 5 rows with same value 1, instead of 1 2 3 4 5
this code works correctly:
with cte(a) as
(values (1),(2),(3),(4),(5))
select * from cte;
Operating system
windows 11 pro x64
SQLiteStudio version
v 3.3.3