{"action":"opened","issue":{"url":"https://api.github.com/repos/basho/riak/issues/935","repository_url":"https://api.github.com/repos/basho/riak","labels_url":"https://api.github.com/repos/basho/riak/issues/935/labels{/name}","comments_url":"https://api.github.com/repos/basho/riak/issues/935/comments","events_url":"https://api.github.com/repos/basho/riak/issues/935/events","html_url":"https://github.com/basho/riak/issues/935","id":310706637,"number":935,"title":"riak-ts: can't delete keys","user":{"login":"jamesruan","id":110096,"avatar_url":"https://avatars2.githubusercontent.com/u/110096?v=4","gravatar_id":"","url":"https://api.github.com/users/jamesruan","html_url":"https://github.com/jamesruan","followers_url":"https://api.github.com/users/jamesruan/followers","following_url":"https://api.github.com/users/jamesruan/following{/other_user}","gists_url":"https://api.github.com/users/jamesruan/gists{/gist_id}","starred_url":"https://api.github.com/users/jamesruan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jamesruan/subscriptions","organizations_url":"https://api.github.com/users/jamesruan/orgs","repos_url":"https://api.github.com/users/jamesruan/repos","events_url":"https://api.github.com/users/jamesruan/events{/privacy}","received_events_url":"https://api.github.com/users/jamesruan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-03T06:13:28Z","updated_at":"2018-04-03T06:13:28Z","closed_at":null,"author_association":"NONE","body":"I'm using a ts 1.5.2.\r\n\r\n`select * from logv2 where time > '2018-03-15 00:00' and time < '2018-04-15 00:00' and type = 'log'`\r\n\r\n```\r\n[1522235100839, \"go logger client\", \"log\", \"[DEBUG]\", \"test log debug\"], \r\n[1522235100880, \"go logger client\", \"log\", \"[TRACE]\", \"test log trace\"], \r\n[1522235100919, \"go logger client\", \"log\", \"[INFO ]\", \"test log info\"], \r\n...\r\n```\r\n`delete from logv2 where time > '2018-03-15 00:00' and time < '2018-04-15 00:00' and type = 'log'`\r\n```\r\n500 Internal Server Error trying to execute query \r\n\r\nServer error: {1009, Unable to get delete key: \\\"Invalid clause {'<',<<\\\\\\\"time\\\\\\,{integer,1523750400000}}\\\\nInvalid clause {'>',<<\\\\\\\"time\\\\\\,{integer,1521072059999}}\\\\n\\\"}\r\n```\r\n\r\n`describe logv2`\r\n\r\n```\r\n[\"time\", \"timestamp\", false, 2, 2, 1, \"d\", []], \r\n[\"source\", \"varchar\", false, [], \r\n3, [], \r\n[], \r\n[]], \r\n[\"type\", \"varchar\", false, 1, 1, [], \r\n[], \r\n[]], \r\n[\"subtype\", \"varchar\", false, [], \r\n4, [], \r\n[], \r\n[]], \r\n[\"text\", \"blob\", false, [], \r\n[], \r\n[], \r\n[], \r\n```\r\n\r\n"}}
{"actor":{"display_login":"jamesruan"}}