{"action":"created","issue":{"url":"https://api.github.com/repos/qorelanguage/qore/issues/1360","repository_url":"https://api.github.com/repos/qorelanguage/qore","labels_url":"https://api.github.com/repos/qorelanguage/qore/issues/1360/labels{/name}","comments_url":"https://api.github.com/repos/qorelanguage/qore/issues/1360/comments","events_url":"https://api.github.com/repos/qorelanguage/qore/issues/1360/events","html_url":"https://github.com/qorelanguage/qore/issues/1360","id":184421925,"number":1360,"title":"SqlUtil: failing Oracle pseudo-columns test on DB versions below 12","user":{"login":"gamato","id":480379,"avatar_url":"https://avatars.githubusercontent.com/u/480379?v=3","gravatar_id":"","url":"https://api.github.com/users/gamato","html_url":"https://github.com/gamato","followers_url":"https://api.github.com/users/gamato/followers","following_url":"https://api.github.com/users/gamato/following{/other_user}","gists_url":"https://api.github.com/users/gamato/gists{/gist_id}","starred_url":"https://api.github.com/users/gamato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gamato/subscriptions","organizations_url":"https://api.github.com/users/gamato/orgs","repos_url":"https://api.github.com/users/gamato/repos","events_url":"https://api.github.com/users/gamato/events{/privacy}","received_events_url":"https://api.github.com/users/gamato/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/qorelanguage/qore/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-10-21T07:57:12Z","updated_at":"2016-10-21T11:29:55Z","closed_at":null,"body":"We have a failing SqlUtil test on Oracle < ver.12:\r\n\r\n```\r\nERROR: pseudo-columns: 0 assertions\r\nUnexpected exception: DBI:ORACLE:OCI-ERROR at /Users/mato/Projects/Qore/src/qore/qlib/SqlUtil.qm:11388\r\n-----\r\n\t>> System exception: /Users/mato/Projects/Qore/src/qore/qlib/SqlUtil.qm:11388: DBI:ORACLE:OCI-ERROR: omquser@oracle11_2/orcl: QorePreparedStatement::exec(): ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.\r\n\t>> call stack:\r\n\t>>   Datasource::vselectRow() called at /Users/mato/Projects/Qore/src/qore/qlib/SqlUtil.qm:11388 (builtin function)\r\n\t>>   AbstractTable::selectRow() called at ./OracleSqlUtil.qtest:188 (user function)\r\n\t>>   OracleTest::testPseudoColumns() called at /Users/mato/Projects/Qore/src/qore/qlib/QUnit.qm:420 (user function)\r\n\t>>   call_function_args() called at /Users/mato/Projects/Qore/src/qore/qlib/QUnit.qm:420 (builtin function)\r\n-----\r\n```"},"comment":{"url":"https://api.github.com/repos/qorelanguage/qore/issues/comments/255358042","html_url":"https://github.com/qorelanguage/qore/issues/1360#issuecomment-255358042","issue_url":"https://api.github.com/repos/qorelanguage/qore/issues/1360","id":255358042,"user":{"login":"gamato","id":480379,"avatar_url":"https://avatars.githubusercontent.com/u/480379?v=3","gravatar_id":"","url":"https://api.github.com/users/gamato","html_url":"https://github.com/gamato","followers_url":"https://api.github.com/users/gamato/followers","following_url":"https://api.github.com/users/gamato/following{/other_user}","gists_url":"https://api.github.com/users/gamato/gists{/gist_id}","starred_url":"https://api.github.com/users/gamato/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gamato/subscriptions","organizations_url":"https://api.github.com/users/gamato/orgs","repos_url":"https://api.github.com/users/gamato/repos","events_url":"https://api.github.com/users/gamato/events{/privacy}","received_events_url":"https://api.github.com/users/gamato/received_events","type":"User","site_admin":false},"created_at":"2016-10-21T11:29:55Z","updated_at":"2016-10-21T11:29:55Z","body":"This is generated SQL:\r\n```\r\nselect * from (select /*+ first_rows(1) */ a.*, rownum rnum from (select rowid, omquser.oracle_test.* from /*+ first_rows(1) */ omquser.oracle_test where rownum <= %v) a where rownum <= %v)\"\r\n```\r\nNow the issue is more obvious."}}
{"actor":{"display_login":"gamato"}}