Hi, I found that limit and offset queries don't work properly with parameters because of different order in parameters list and ClickHouse LIMIT ?, ? query.
Simple example:
Such query
Schema |> limit(^limit) |> offset(^offset) |> Repo.all()
generates such sql:
SELECT ... FROM "schema" LIMIT ?, ?
with parameters: [limit, offset] and final query will be like this SELECT ... FROM "schema" LIMIT #{limit}, #{offset}, but should be SELECT ... FROM "schema" LIMIT #{offset}, #{limit}
I think this is regression of #7 PR.
Hi, I found that
limitandoffsetqueries don't work properly with parameters because of different order in parameters list and ClickHouseLIMIT ?, ?query.Simple example:
Such query
generates such sql:
with parameters:
[limit, offset]and final query will be like thisSELECT ... FROM "schema" LIMIT #{limit}, #{offset}, but should beSELECT ... FROM "schema" LIMIT #{offset}, #{limit}I think this is regression of #7 PR.