{"action":"created","issue":{"url":"https://api.github.com/repos/basho-labs/riak_explorer/issues/149","repository_url":"https://api.github.com/repos/basho-labs/riak_explorer","labels_url":"https://api.github.com/repos/basho-labs/riak_explorer/issues/149/labels{/name}","comments_url":"https://api.github.com/repos/basho-labs/riak_explorer/issues/149/comments","events_url":"https://api.github.com/repos/basho-labs/riak_explorer/issues/149/events","html_url":"https://github.com/basho-labs/riak_explorer/issues/149","id":175464068,"number":149,"title":"Error querying tables","user":{"login":"randysecrist","id":141339,"avatar_url":"https://avatars.githubusercontent.com/u/141339?v=3","gravatar_id":"","url":"https://api.github.com/users/randysecrist","html_url":"https://github.com/randysecrist","followers_url":"https://api.github.com/users/randysecrist/followers","following_url":"https://api.github.com/users/randysecrist/following{/other_user}","gists_url":"https://api.github.com/users/randysecrist/gists{/gist_id}","starred_url":"https://api.github.com/users/randysecrist/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/randysecrist/subscriptions","organizations_url":"https://api.github.com/users/randysecrist/orgs","repos_url":"https://api.github.com/users/randysecrist/repos","events_url":"https://api.github.com/users/randysecrist/events{/privacy}","received_events_url":"https://api.github.com/users/randysecrist/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"paultannenbaum","id":220885,"avatar_url":"https://avatars.githubusercontent.com/u/220885?v=3","gravatar_id":"","url":"https://api.github.com/users/paultannenbaum","html_url":"https://github.com/paultannenbaum","followers_url":"https://api.github.com/users/paultannenbaum/followers","following_url":"https://api.github.com/users/paultannenbaum/following{/other_user}","gists_url":"https://api.github.com/users/paultannenbaum/gists{/gist_id}","starred_url":"https://api.github.com/users/paultannenbaum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paultannenbaum/subscriptions","organizations_url":"https://api.github.com/users/paultannenbaum/orgs","repos_url":"https://api.github.com/users/paultannenbaum/repos","events_url":"https://api.github.com/users/paultannenbaum/events{/privacy}","received_events_url":"https://api.github.com/users/paultannenbaum/received_events","type":"User","site_admin":false},"assignees":[{"login":"paultannenbaum","id":220885,"avatar_url":"https://avatars.githubusercontent.com/u/220885?v=3","gravatar_id":"","url":"https://api.github.com/users/paultannenbaum","html_url":"https://github.com/paultannenbaum","followers_url":"https://api.github.com/users/paultannenbaum/followers","following_url":"https://api.github.com/users/paultannenbaum/following{/other_user}","gists_url":"https://api.github.com/users/paultannenbaum/gists{/gist_id}","starred_url":"https://api.github.com/users/paultannenbaum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paultannenbaum/subscriptions","organizations_url":"https://api.github.com/users/paultannenbaum/orgs","repos_url":"https://api.github.com/users/paultannenbaum/repos","events_url":"https://api.github.com/users/paultannenbaum/events{/privacy}","received_events_url":"https://api.github.com/users/paultannenbaum/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2016-09-07T10:09:43Z","updated_at":"2016-09-13T18:22:10Z","closed_at":null,"body":"Using the schema from #148, and inserting data using the Riak Shell:\r\n\r\n```\r\nreplay (1)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-01-01', \"Linlithgow\", 5.2, 1.01, true);\r\nreplay (2)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-02-01', \"Linlithgow\", 6.4, 1.02, true);\r\nreplay (3)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-03-01', \"Linlithgow\", 11.4, 1.15, true);\r\nreplay (4)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-03-09', \"Linlithgow\", 16.2, 0.98, true);\r\nreplay (5)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-04-15', \"Linlithgow\", 14.5, 1.0, true);\r\nreplay (6)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-01-02', \"Bo'ness\", 5.1, 1.02, true);\r\nreplay (7)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-02-01', \"Bo'ness\", 6.6, 1.07, true);\r\nreplay (8)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-03-01', \"Bo'ness\", 10.2, 1.13, true);\r\nreplay (9)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-03-07', \"Bo'ness\", 16.5, 0.99, true);\r\nreplay (10)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (1, '2016-04-15', \"Bo'ness\", 14.0, 1.01, true);\r\nreplay (11)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (2, '2016-02-14', \" Slamannan\", 9.6, 1.0, false);\r\nreplay (12)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (2, '2016-02-28', \" Slamannan\", 10.2, 1.03, false);\r\nreplay (13)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (2, '2016-03-11', \" Slamannan\", 16.3, 0.92, false);\r\nreplay (14)> INSERT INTO Exercise3 (id, time, place, temperature, pressure, atsealevel) VALUES (2, '2016-04-03', \" Slamannan\", 18.0, 0.99, false);\r\n```\r\n\r\nAnd using the following query:\r\n```SQL\r\nSELECT * FROM Exercise3 WHERE id=1 AND time >= '2015' AND time <= '2017';\r\n```\r\nYields the following explorer error:\r\n```\r\n500 Internal Server Error trying to execute query: \r\n\r\nSELECT * FROM Exercise3 WHERE id=1 AND time >= '2015' AND time <= '2017';\r\n```\r\n\r\nRunning the same from the Riak Shell:\r\n\r\n```\r\n+--+--------------------+----------+--------------------------+--------------------------+----------+\r\n|id|        time        |  place   |       temperature        |         pressure         |atsealevel|\r\n+--+--------------------+----------+--------------------------+--------------------------+----------+\r\n|1 |2016-01-01T00:00:00Z|Linlithgow|5.20000000000000017764e+00|1.01000000000000000888e+00|   true   |\r\n|1 |2016-01-02T00:00:00Z| Bo'ness  |5.09999999999999964473e+00|1.02000000000000001776e+00|   true   |\r\n|1 |2016-02-01T00:00:00Z| Bo'ness  |6.59999999999999964473e+00|1.07000000000000006217e+00|   true   |\r\n|1 |2016-02-01T00:00:00Z|Linlithgow|6.40000000000000035527e+00|1.02000000000000001776e+00|   true   |\r\n|1 |2016-03-01T00:00:00Z| Bo'ness  |1.01999999999999992895e+01|1.12999999999999989342e+00|   true   |\r\n|1 |2016-03-01T00:00:00Z|Linlithgow|1.14000000000000003553e+01|1.14999999999999991118e+00|   true   |\r\n|1 |2016-03-07T00:00:00Z| Bo'ness  |1.65000000000000000000e+01|9.89999999999999991118e-01|   true   |\r\n|1 |2016-03-09T00:00:00Z|Linlithgow|1.61999999999999992895e+01|9.79999999999999982236e-01|   true   |\r\n|1 |2016-04-15T00:00:00Z| Bo'ness  |1.40000000000000000000e+01|1.01000000000000000888e+00|   true   |\r\n|1 |2016-04-15T00:00:00Z|Linlithgow|1.45000000000000000000e+01|1.00000000000000000000e+00|   true   |\r\n+--+--------------------+----------+--------------------------+--------------------------+----------+\r\n```\r\n\r\nExpected behavior of Riak Explorer is the same query results as Riak Shell.\r\n\r\nEnvironment Setup:\r\n* Riak TS 1.4.0 EE (OS X)\r\n* Mac OSX\r\n* Riak Explorer (from Master) ->  clusters.default.riak_node = riak@127.0.0.1"},"comment":{"url":"https://api.github.com/repos/basho-labs/riak_explorer/issues/comments/246775093","html_url":"https://github.com/basho-labs/riak_explorer/issues/149#issuecomment-246775093","issue_url":"https://api.github.com/repos/basho-labs/riak_explorer/issues/149","id":246775093,"user":{"login":"paultannenbaum","id":220885,"avatar_url":"https://avatars.githubusercontent.com/u/220885?v=3","gravatar_id":"","url":"https://api.github.com/users/paultannenbaum","html_url":"https://github.com/paultannenbaum","followers_url":"https://api.github.com/users/paultannenbaum/followers","following_url":"https://api.github.com/users/paultannenbaum/following{/other_user}","gists_url":"https://api.github.com/users/paultannenbaum/gists{/gist_id}","starred_url":"https://api.github.com/users/paultannenbaum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/paultannenbaum/subscriptions","organizations_url":"https://api.github.com/users/paultannenbaum/orgs","repos_url":"https://api.github.com/users/paultannenbaum/repos","events_url":"https://api.github.com/users/paultannenbaum/events{/privacy}","received_events_url":"https://api.github.com/users/paultannenbaum/received_events","type":"User","site_admin":false},"created_at":"2016-09-13T18:22:10Z","updated_at":"2016-09-13T18:22:10Z","body":"@nan I can not reproduce on my instance.\r\n\r\nHere are the steps I took:\r\n\r\n- Started Riak TS1.4 and Explorer (master)\r\n- Started riak-shell on the 1.4 instance and inserted the data you posted above\r\n- Used the provided query in the explorer query interface (did not restart riak nor the explorer app)\r\n- Was provided with the correct query results ([screenshot](https://www.dropbox.com/s/mfjhg4e6e8wy64w/Screenshot%202016-09-13%2011.20.15.png?dl=0))\r\n\r\nThere is a chance that you could be working with an outdated binary, so I am going to package everything up and publish a new release and ask that you retest. If still experiencing, we may have to schedule a screenhero session to try and find the discrepancy.\r\n"}}
{"actor":{"display_login":"paultannenbaum"}}