node-clickhouse icon indicating copy to clipboard operation
node-clickhouse copied to clipboard

Query SQL comment prefix query report error

Open KsssAlleria opened this issue 4 years ago • 1 comments

For example SQL:
--admin SELECT date_time, app_id FROM basic.basic_day_all limit 2` execute SQL to return underfind,

Query source code is found to be a problem with this code:

if (chQuery.match (/^(?:SELECT|WITH|SHOW|DESC|DESCRIBE|EXISTS\s+TABLE)/i)) {
	if (!options.format)
		options.format = options.dataObjects ? 'JSON' : 'JSONCompact';
} else if (chQuery.match (/^INSERT/i)) {
      //
} 

I hope the author can help repair it, TK~

KsssAlleria avatar Jan 25 '21 03:01 KsssAlleria

Same issue, hope fixed quickly. @apla

HelloKevinTian avatar Feb 23 '21 10:02 HelloKevinTian