sqlitestudio icon indicating copy to clipboard operation
sqlitestudio copied to clipboard

select from values returns first value multiple time instead of all values

Open maxima120 opened this issue 3 years ago • 0 comments

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

image

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

maxima120 avatar Jan 02 '22 14:01 maxima120