Some additional testcases: create temporary view vtext as select * from text order by x; select max(x) as max_from_view from vtext; ┌───────────────┐ │ max_from_view │ ├───────────────┤ │ 8 │ └───────────────┘ Add a line 0,0 to test.csv: select max(x) from text; Now max = 0 ..... Repeat with a line 9,9: select max(x) from text; Now max = 9 .....