A bug in regexp prevents using JSONEachRow format in INSERT queries

[vibl]

There's a bug that prevents sending an INSERT query with a JSONEachRow format:

node-clickhouse/src/clickhouse.js

Line 255 in 1d45ede

var formatRegexp = /FORMAT\s+(BlockTabSeparated|CSV|CSVWithNames|JSON|JSONCompact|JSONEachRow|Native|Null|Pretty|PrettyCompact|PrettyCompactMonoBlock|PrettyNoEscapes|PrettyCompactNoEscapes|PrettySpaceNoEscapes|PrettySpace|RowBinary|TabSeparated|TabSeparatedRaw|TabSeparatedWithNames|TabSeparatedWithNamesAndTypes|TSKV|Values|Vertical|XML)/i

There's a \b missing on each side of the parenthese group, which makes the regexp match JSON instead of JSONEachRow.

The regexp should be:

 var formatRegexp = /FORMAT\s+\b(BlockTabSeparated|CSV|CSVWithNames|JSON|JSONCompact|JSONEachRow|Native|Null|Pretty|PrettyCompact|PrettyCompactMonoBlock|PrettyNoEscapes|PrettyCompactNoEscapes|PrettySpaceNoEscapes|PrettySpace|RowBinary|TabSeparated|TabSeparatedRaw|TabSeparatedWithNames|TabSeparatedWithNamesAndTypes|TSKV|Values|Vertical|XML)\b/i; 

This fixes the issue.

I filed an issue several months ago on the @apla/node-clickhouse repo but I got no answer.

Could you correct this?

[Twixes]

Hey! Since you propose a way to fix this, we'd be super happy to take PR if you're up for it?