{"action":"created","issue":{"url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/1165","labels_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/1165/labels{/name}","comments_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/1165/comments","events_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/1165/events","html_url":"https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/1165","id":107462789,"number":1165,"title":"Inline queries not fully supported for PostgreSQL database?","user":{"login":"yoonghm","id":4215991,"avatar_url":"https://avatars.githubusercontent.com/u/4215991?v=3","gravatar_id":"","url":"https://api.github.com/users/yoonghm","html_url":"https://github.com/yoonghm","followers_url":"https://api.github.com/users/yoonghm/followers","following_url":"https://api.github.com/users/yoonghm/following{/other_user}","gists_url":"https://api.github.com/users/yoonghm/gists{/gist_id}","starred_url":"https://api.github.com/users/yoonghm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yoonghm/subscriptions","organizations_url":"https://api.github.com/users/yoonghm/orgs","repos_url":"https://api.github.com/users/yoonghm/repos","events_url":"https://api.github.com/users/yoonghm/events{/privacy}","received_events_url":"https://api.github.com/users/yoonghm/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/labels/postgres","name":"postgres","color":"bfd4f2"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":29,"created_at":"2015-09-21T08:10:29Z","updated_at":"2015-09-25T05:34:06Z","closed_at":null,"body":"I have the following software and extension\r\n* **MediaWiki  1.25.2**\r\n* **PHP  5.6.13RC1 (fpm-fcgi)**\r\n* **PostgreSQL 9.4.4**\r\n* **Semantic MediaWiki  2.2.2**\r\n\r\nI have the following pages:\r\n\r\n**11111111A**\r\n```\r\n* [[Tutorial class is::PA11]]\r\n* [[Advisor is::Teacher_1]]\r\n* [[Category:Student]]\r\n```\r\n\r\n**22222222A**\r\n```\r\n* [[Tutorial class is::PA11]]\r\n* [[Advisor is::Teacher_1]]\r\n* [[Category:Student]]\r\n```\r\n\r\n**33333333A**\r\n```\r\n* [[Tutorial class is::PA11]]\r\n* [[Advisor is::Teacher_1]]\r\n* [[Category:Student]]\r\n```\r\n\r\n**PA11**\r\n```\r\n{{#ask: \r\n [[Category:Student]]\r\n [[Tutorial class is::PA11]]\r\n |?Advisor is\r\n}}\r\n```\r\n\r\nHowever, page **PA11** is rendered as\r\n\r\n                    | Advisor\r\n-----------------|----------------\r\n11111111A  | Teacher_1\r\n\r\n\r\nUsing debug, I can see that the query is\r\n```\r\nSELECT DISTINCT t6.smw_title     AS t,\r\n                t6.smw_namespace AS ns\r\n  FROM smw_object_ids AS t6\r\n INNER JOIN smw_fpt_inst AS t1\r\n    ON t6.smw_id = t1.s_id \r\n INNER JOIN smw_di_wikipage AS t3 \r\n    ON t1.s_id = t3.s_id \r\n WHERE (t1.o_id = '53' AND (t3.p_id = '58' AND t3.o_id = '54'))\r\n ORDER BY t6.smw_sortkey ASC LIMIT 55 OFFSET 0;\r\n```\r\n\r\nBy looking at the PostgreSQL database, I see that\r\n\r\nTable **smw_object_ids**\r\n\r\nsms_id  | smw_namespace | smw_title\r\n-----------|-------------------------|--------------\r\n    50     |        0                    |\r\n    51     |        0                    | 11111111A\r\n    52     |        0                    | Teacher_1\r\n    53     |       14                   | Student\r\n    54     |        0                    | PA11\r\n    55     |        0                    | PA11\r\n    56     |        0                    | PA11\r\n    57     |      102                  | Advisor_is\r\n    58     |      102                  | Tutorial_class_is\r\n    59     |        0                    | 22222222A\r\n    60     |        0                    | 33333333A\r\n                                        \r\nTable **smw_fpt_inst**\r\n\r\ns_id  | o_id\r\n-------|------\r\n  51  | 53\r\n\r\nTable **smw_di_wikipage**\r\n\r\ns_id  | p_id  | o_id\r\n-------|--------|-------\r\n  51  | 57     | 52\r\n  51  | 58     | 54\r\n\r\nI am wondering why pages **22222222A** and **33333333A** do not have records in **smw_fpt_inst** and **smw_di_wikipage**.\r\n"},"comment":{"url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/comments/143131084","html_url":"https://github.com/SemanticMediaWiki/SemanticMediaWiki/issues/1165#issuecomment-143131084","issue_url":"https://api.github.com/repos/SemanticMediaWiki/SemanticMediaWiki/issues/1165","id":143131084,"user":{"login":"yoonghm","id":4215991,"avatar_url":"https://avatars.githubusercontent.com/u/4215991?v=3","gravatar_id":"","url":"https://api.github.com/users/yoonghm","html_url":"https://github.com/yoonghm","followers_url":"https://api.github.com/users/yoonghm/followers","following_url":"https://api.github.com/users/yoonghm/following{/other_user}","gists_url":"https://api.github.com/users/yoonghm/gists{/gist_id}","starred_url":"https://api.github.com/users/yoonghm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yoonghm/subscriptions","organizations_url":"https://api.github.com/users/yoonghm/orgs","repos_url":"https://api.github.com/users/yoonghm/repos","events_url":"https://api.github.com/users/yoonghm/events{/privacy}","received_events_url":"https://api.github.com/users/yoonghm/received_events","type":"User","site_admin":false},"created_at":"2015-09-25T05:34:06Z","updated_at":"2015-09-25T05:34:06Z","body":"The ```sunit*``` tables were created before the test and deleted after that. Is it possible to populate these ```sunit*``` and run only this query-01-04-blob-disjunction.json but do not delete the table. Othewise, it is hard to trace. Any suggestion?"}}