{"action":"created","issue":{"url":"https://api.github.com/repos/Kozea/Multicorn/issues/30","labels_url":"https://api.github.com/repos/Kozea/Multicorn/issues/30/labels{/name}","comments_url":"https://api.github.com/repos/Kozea/Multicorn/issues/30/comments","events_url":"https://api.github.com/repos/Kozea/Multicorn/issues/30/events","html_url":"https://github.com/Kozea/Multicorn/issues/30","id":21224670,"number":30,"title":"WARNING:  unsupported expression for extractClauseFrom","user":{"login":"johnmudd","id":755393,"avatar_url":"https://avatars.githubusercontent.com/u/755393?v=3","gravatar_id":"","url":"https://api.github.com/users/johnmudd","html_url":"https://github.com/johnmudd","followers_url":"https://api.github.com/users/johnmudd/followers","following_url":"https://api.github.com/users/johnmudd/following{/other_user}","gists_url":"https://api.github.com/users/johnmudd/gists{/gist_id}","starred_url":"https://api.github.com/users/johnmudd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/johnmudd/subscriptions","organizations_url":"https://api.github.com/users/johnmudd/orgs","repos_url":"https://api.github.com/users/johnmudd/repos","events_url":"https://api.github.com/users/johnmudd/events{/privacy}","received_events_url":"https://api.github.com/users/johnmudd/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2013-10-18T15:07:12Z","updated_at":"2015-08-08T14:16:23Z","closed_at":null,"body":"I was wondering how more complex WHERE clauses would be handled. I see they're not. That's understandable.\r\n\r\nWhat's the best way to suppress the WARNING and DETAIL messages for this specific situation? Is there a way to log the original SQL statement rather than the DETAIL message?\r\n\r\nCan you tell me more about what is and is not supported?\r\n\r\nThanks, \r\nJohn\r\n\r\n```\r\n$ echo 'select * from shipping WHERE residential = 1 or delivery = 1;' | psql rx30_db\r\nWARNING:  unsupported expression for extractClauseFrom\r\nDETAIL:  {BOOLEXPR :boolop or :args ({OPEXPR :opno 532 :opfuncid 158 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 19 :vartype 21 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 19 :location 29} {CONST :consttype 23 :consttypmod -1 :constcollid 0 :constlen 4 :constbyval true :constisnull false :location 43 :constvalue 4 [ 1 0 0 0 ]}) :location 41} {OPEXPR :opno 532 :opfuncid 158 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 6 :vartype 21 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 6 :location 48} {CONST :consttype 23 :consttypmod -1 :constcollid 0 :constlen 4 :constbyval true :constisnull false :location 59 :constvalue 4 [ 1 0 0 0 ]}) :location 57}) :location -1}\r\nWARNING:  unsupported expression for extractClauseFrom\r\nDETAIL:  {BOOLEXPR :boolop or :args ({OPEXPR :opno 532 :opfuncid 158 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 19 :vartype 21 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 19 :location 29} {CONST :consttype 23 :consttypmod -1 :constcollid 0 :constlen 4 :constbyval true :constisnull false :location 43 :constvalue 4 [ 1 0 0 0 ]}) :location 41} {OPEXPR :opno 532 :opfuncid 158 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 6 :vartype 21 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 6 :location 48} {CONST :consttype 23 :consttypmod -1 :constcollid 0 :constlen 4 :constbyval true :constisnull false :location 59 :constvalue 4 [ 1 0 0 0 ]}) :location 57}) :location -1}\r\n ctdel | reference | pat_storeid | pat_key | packaged | delivery | lastupdate | name | add1 | add2 | city | state | zip | phone | email_present | email | iteminfo | weight | residential | yes | no | spare\r\n-------+-----------+-------------+---------+----------+----------+------------+------+------+------+------+-------+-----+-------+---------------+-------+----------+--------+-------------+-----+----+-------\r\n(0 rows)\r\n\r\n$ \r\n```"},"comment":{"url":"https://api.github.com/repos/Kozea/Multicorn/issues/comments/128986088","html_url":"https://github.com/Kozea/Multicorn/issues/30#issuecomment-128986088","issue_url":"https://api.github.com/repos/Kozea/Multicorn/issues/30","id":128986088,"user":{"login":"komamitsu","id":59043,"avatar_url":"https://avatars.githubusercontent.com/u/59043?v=3","gravatar_id":"","url":"https://api.github.com/users/komamitsu","html_url":"https://github.com/komamitsu","followers_url":"https://api.github.com/users/komamitsu/followers","following_url":"https://api.github.com/users/komamitsu/following{/other_user}","gists_url":"https://api.github.com/users/komamitsu/gists{/gist_id}","starred_url":"https://api.github.com/users/komamitsu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/komamitsu/subscriptions","organizations_url":"https://api.github.com/users/komamitsu/orgs","repos_url":"https://api.github.com/users/komamitsu/repos","events_url":"https://api.github.com/users/komamitsu/events{/privacy}","received_events_url":"https://api.github.com/users/komamitsu/received_events","type":"User","site_admin":false},"created_at":"2015-08-08T14:16:23Z","updated_at":"2015-08-08T14:16:23Z","body":"@rdunklau Why does Multicorn show the warning message when using `OR` operator despite the query seems to be able to handle `OR` operator properly?\r\n\r\n```\r\npostgres=# select * from csvtest where year = 2000 or make = 'Ford';\r\nWARNING:  unsupported expression for extractClauseFrom\r\nDETAIL:  {BOOLEXPR :boolop or :args ({OPEXPR :opno 1752 :opfuncid 1718 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 1 :vartype 1700 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location 28} {CONST :consttype 1700 :consttypmod -1 :constcollid 0 :constlen -1 :constbyval false :constisnull false :location -1 :constvalue 8 [ 32 0 0 0 0 -128 -48 7 ]}) :location 33} {OPEXPR :opno 98 :opfuncid 67 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 100 :args ({RELABELTYPE :arg {VAR :varno 1 :varattno 2 :vartype 1043 :vartypmod -1 :varcollid 100 :varlevelsup 0 :varnoold 1 :varoattno 2 :location 43} :resulttype 25 :resulttypmod -1 :resultcollid 100 :relabelformat 2 :location -1} {CONST :consttype 25 :consttypmod -1 :constcollid 100 :constlen -1 :constbyval false :constisnull false :location 50 :constvalue 8 [ 32 0 0 0 70 111 114 100 ]}) :location 48}) :location -1}\r\nWARNING:  unsupported expression for extractClauseFrom\r\nDETAIL:  {BOOLEXPR :boolop or :args ({OPEXPR :opno 1752 :opfuncid 1718 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 1 :vartype 1700 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location 28} {CONST :consttype 1700 :consttypmod -1 :constcollid 0 :constlen -1 :constbyval false :constisnull false :location -1 :constvalue 8 [ 32 0 0 0 0 -128 -48 7 ]}) :location 33} {OPEXPR :opno 98 :opfuncid 67 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 100 :args ({RELABELTYPE :arg {VAR :varno 1 :varattno 2 :vartype 1043 :vartypmod -1 :varcollid 100 :varlevelsup 0 :varnoold 1 :varoattno 2 :location 43} :resulttype 25 :resulttypmod -1 :resultcollid 100 :relabelformat 2 :location -1} {CONST :consttype 25 :consttypmod -1 :constcollid 100 :constlen -1 :constbyval false :constisnull false :location 50 :constvalue 8 [ 32 0 0 0 70 111 114 100 ]}) :location 48}) :location -1}\r\n year |  make   | model  | length \r\n------+---------+--------+--------\r\n 1997 | Ford    | E350   |   2.34\r\n 2000 | Mercury | Cougar |   2.38\r\n(2 rows)\r\n```\r\n\r\n"}}