{"action":"opened","issue":{"url":"https://api.github.com/repos/yandex/ClickHouse/issues/1904","repository_url":"https://api.github.com/repos/yandex/ClickHouse","labels_url":"https://api.github.com/repos/yandex/ClickHouse/issues/1904/labels{/name}","comments_url":"https://api.github.com/repos/yandex/ClickHouse/issues/1904/comments","events_url":"https://api.github.com/repos/yandex/ClickHouse/issues/1904/events","html_url":"https://github.com/yandex/ClickHouse/issues/1904","id":297127713,"number":1904,"title":"Empty values in INSERT INTO expression causes parsing exception","user":{"login":"cerealcoder","id":25597685,"avatar_url":"https://avatars0.githubusercontent.com/u/25597685?v=4","gravatar_id":"","url":"https://api.github.com/users/cerealcoder","html_url":"https://github.com/cerealcoder","followers_url":"https://api.github.com/users/cerealcoder/followers","following_url":"https://api.github.com/users/cerealcoder/following{/other_user}","gists_url":"https://api.github.com/users/cerealcoder/gists{/gist_id}","starred_url":"https://api.github.com/users/cerealcoder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cerealcoder/subscriptions","organizations_url":"https://api.github.com/users/cerealcoder/orgs","repos_url":"https://api.github.com/users/cerealcoder/repos","events_url":"https://api.github.com/users/cerealcoder/events{/privacy}","received_events_url":"https://api.github.com/users/cerealcoder/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-14T15:03:13Z","updated_at":"2018-02-14T15:03:13Z","closed_at":null,"author_association":"NONE","body":"Note: this issue is similar in nature to issue #469.\r\n\r\nWhen executing an `INSERT INTO` statement that contains a `VALUES` clause that contains multiple adjacent commas, the Clickhouse server produces the following error message in file `clickhouse/logs/clickhouse-server.err.log`:\r\n\r\n`<Error> HTTPHandler: Code: 62, e.displayText() = DB::Exception: Cannot parse expression of type String here: ,,,,,,,,,,,,,,,,,'https://tellme.social/',,), ('help','guest','2018-02-09','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:58.0) Gecko/20100101 Firefox/58.0',, e.what() = DB::Exception, Stack trace:`\r\n\r\nThe complete `INSERT INTO` statement we're using is:\r\n\r\n`INSERT INTO userActionsTemp ( action, userId, actionDate, userAgent, language, hardwareConcurrency, adBlock, hasTamperedLanguages, hasTamperedResolution, hasTamperedOS, hasTamperedBrowser, fingerprint, loginMethod, storyId, storyTagIds, shareTarget, shareFailureReason, storyFilterName, storyFilterMode, storyFilterWords, storyFilterAuthorNames, storyFilterTagIds, storyFilterPeopleNames, storyFilterExclusionTagIds, storyFilterCircaAfterDate, storyFilterCircaBeforeDate, storyReviewNumberOfStars, storyReviewTagIds, tagId, currentUrl, previousUrl, numAdsServed) VALUES ('urlTransition','guest','2018-02-09','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36','en-US',4,0,0,0,0,0,'b7e609741bcd4886d21c4d5e6ed1814f',,,,,,,,,,,,,,,,,,'https://tellme.social/',,), ('help','guest','2018-02-09','Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:58.0) Gecko/20100101 Firefox/58.0','en-US',8,1,0,0,0,0,'3cf3f888cdcd0983cbe2840133e843d3',,,,,,,,,,,,,,,,,,,,), ('storyFilterUtilize','guest','2018-02-09','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36','en-US',8,0,0,0,0,0,'209659044477415c233486a31bf4be34',,,,,,'SimpleStoryFilter','AND',,,,,,,,,,,,,)`\r\n\r\nDo you have a suggested workaround for this issue? That is, if we cannot use the standard CSV syntax to represent a null value for a string, how should we do so?\r\n"}}
{"actor":{"display_login":"cerealcoder"}}