FORMATing not being applied for queries which use WITH x as (SELECT 1) SELECT * FROM x.

[UnamedRus]

I do believe it happens because of this regexp.

clickhouse/index.js

Line 495 in a84d890

if (query.match(/^(select|show|exists)/i)) {

Workaround is: manually write FORMAT JSON or whatever in your query.

[TimonKK]

Hi, I published a fix for your case. Could you please upgrade the package and test it?

[xav-b]

@TimonKK thanks a ton for the fix, this seems to do the trick indeed. I used the code below that fails with version 2.4.2 with unexpected json, but works with the latest 2.4.4.

const CTE_SQL = `
WITH yolo AS (
  SELECT rand() AS a, rand(1) AS b, rand(number) AS c
  FROM numbers(3)
)

SELECT a, b, c FROM yolo
`

const OPTS = {
    url, port, ...,
    format: 'json',
}

async function main() {
  const rows = await ck.connect(OPTS).query(CTE_SQL).toPromise()
  console.log(rows)
   //  { a: 560152421, b: 3052471433, c: 25746393 },
   // { a: 3317286345, b: 3388181787, c: 2905723273 },
   // { a: 3213018093, b: 2268847078, c: 3820230708 }

}

main()