{"action":"closed","issue":{"url":"https://api.github.com/repos/cznic/ql/issues/163","repository_url":"https://api.github.com/repos/cznic/ql","labels_url":"https://api.github.com/repos/cznic/ql/issues/163/labels{/name}","comments_url":"https://api.github.com/repos/cznic/ql/issues/163/comments","events_url":"https://api.github.com/repos/cznic/ql/issues/163/events","html_url":"https://github.com/cznic/ql/issues/163","id":225766380,"number":163,"title":"Confusing test case","user":{"login":"gernest","id":6039952,"avatar_url":"https://avatars1.githubusercontent.com/u/6039952?v=3","gravatar_id":"","url":"https://api.github.com/users/gernest","html_url":"https://github.com/gernest","followers_url":"https://api.github.com/users/gernest/followers","following_url":"https://api.github.com/users/gernest/following{/other_user}","gists_url":"https://api.github.com/users/gernest/gists{/gist_id}","starred_url":"https://api.github.com/users/gernest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gernest/subscriptions","organizations_url":"https://api.github.com/users/gernest/orgs","repos_url":"https://api.github.com/users/gernest/repos","events_url":"https://api.github.com/users/gernest/events{/privacy}","received_events_url":"https://api.github.com/users/gernest/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-05-02T17:33:18Z","updated_at":"2017-05-03T13:09:45Z","closed_at":"2017-05-03T13:09:45Z","body":"So, I revisited the testdata.ql file\r\n\r\nthis snippet \r\n\r\n```sql\r\n-- 1350 // https://github.com/cznic/ql/issues/155\r\nBEGIN TRANSACTION;\r\n\tCREATE TABLE t (i int);\r\n\tINSERT INTO t VALUES (1);\r\n\tINSERT INTO t VALUES (2);\r\n\tINSERT INTO t VALUES (3);\r\nCOMMIT;\r\nSELECT * FROM t WHERE EXISTS (SELECT * FROM t WHERE i == 4);\r\n|\"i\"\r\n[]\r\n```\r\n\r\n\r\nMy understanding is. The query will result in o rows which when scanned will yield  `sql.ErrNoRows` . The bavior of the above testcase is different.\r\n\r\nsince for some reason I get this \r\n\r\n```\r\n                ---- g\r\n                \"i\"\r\n                ---- e\r\n                \"i\"\r\n                []\r\n                ----\r\n```\r\n\r\nIMHO they are both correct , just some minor issue from that gave us `---g` part probably in the tests. I was not able to find a test case which returned 0 rows apart from these for #155  "}}
{"actor":{"display_login":"cznic"}}