{"action":"created","issue":{"url":"https://api.github.com/repos/tidyverse/dplyr/issues/3541","repository_url":"https://api.github.com/repos/tidyverse/dplyr","labels_url":"https://api.github.com/repos/tidyverse/dplyr/issues/3541/labels{/name}","comments_url":"https://api.github.com/repos/tidyverse/dplyr/issues/3541/comments","events_url":"https://api.github.com/repos/tidyverse/dplyr/issues/3541/events","html_url":"https://github.com/tidyverse/dplyr/issues/3541","id":317606408,"number":3541,"title":"Cannot pull views (using dbplyr & RMariaDB)","user":{"login":"foundinblank","id":31513760,"avatar_url":"https://avatars3.githubusercontent.com/u/31513760?v=4","gravatar_id":"","url":"https://api.github.com/users/foundinblank","html_url":"https://github.com/foundinblank","followers_url":"https://api.github.com/users/foundinblank/followers","following_url":"https://api.github.com/users/foundinblank/following{/other_user}","gists_url":"https://api.github.com/users/foundinblank/gists{/gist_id}","starred_url":"https://api.github.com/users/foundinblank/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/foundinblank/subscriptions","organizations_url":"https://api.github.com/users/foundinblank/orgs","repos_url":"https://api.github.com/users/foundinblank/repos","events_url":"https://api.github.com/users/foundinblank/events{/privacy}","received_events_url":"https://api.github.com/users/foundinblank/received_events","type":"User","site_admin":false},"labels":[{"id":213548409,"url":"https://api.github.com/repos/tidyverse/dplyr/labels/database","name":"database","color":"eeeeee","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-04-25T12:28:31Z","updated_at":"2018-05-01T09:02:03Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nI'm unable to pull views via my RMariaDB connection. Here's an example below where I'm trying to pull a view called `video_product_lookup`, but I can replicate the issue with all other views. I can pull regular tables just fine. \r\n\r\nThanks,\r\nAdam\r\n\r\n``` r\r\n# Load packages\r\nlibrary(RMariaDB)\r\n#> Warning: package 'RMariaDB' was built under R version 3.4.4\r\nlibrary(tidyverse)\r\nlibrary(DBI)\r\nlibrary(dbplyr)\r\n#> \r\n#> Attaching package: 'dbplyr'\r\n#> The following objects are masked from 'package:dplyr':\r\n#> \r\n#>     ident, sql\r\n\r\n# Connect to database\r\nreporting <- dbConnect(RMariaDB::MariaDB(), group = \"reporting\")\r\ndbListTables(reporting) # This does list the table (view) I want to connect to\r\n#> ...        \r\n#> [67] \"video_product_lookup\"\r\n#> ...        \r\n\r\n# Get the view\r\ndf <- tbl(reporting, \"video_product_lookup\")\r\n#> Error in result_create(conn@ptr, statement, is_statement): Prepared statement needs to be re-prepared [1615]\r\n\r\n# Get the view a different way\r\ndf <- dbReadTable(reporting, \"video_product_lookup\")\r\n#> Error in result_create(conn@ptr, statement, is_statement): Prepared statement needs to be re-prepared [1615]\r\n\r\n# Get a regular table - this works fine. \r\ndf <- tbl(reporting, \"biz_orders\")\r\n```\r\n\r\nCreated on 2018-04-25 by the [reprex package](http://reprex.tidyverse.org) (v0.2.0).\r\n"},"comment":{"url":"https://api.github.com/repos/tidyverse/dplyr/issues/comments/385629385","html_url":"https://github.com/tidyverse/dplyr/issues/3541#issuecomment-385629385","issue_url":"https://api.github.com/repos/tidyverse/dplyr/issues/3541","id":385629385,"user":{"login":"foundinblank","id":31513760,"avatar_url":"https://avatars3.githubusercontent.com/u/31513760?v=4","gravatar_id":"","url":"https://api.github.com/users/foundinblank","html_url":"https://github.com/foundinblank","followers_url":"https://api.github.com/users/foundinblank/followers","following_url":"https://api.github.com/users/foundinblank/following{/other_user}","gists_url":"https://api.github.com/users/foundinblank/gists{/gist_id}","starred_url":"https://api.github.com/users/foundinblank/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/foundinblank/subscriptions","organizations_url":"https://api.github.com/users/foundinblank/orgs","repos_url":"https://api.github.com/users/foundinblank/repos","events_url":"https://api.github.com/users/foundinblank/events{/privacy}","received_events_url":"https://api.github.com/users/foundinblank/received_events","type":"User","site_admin":false},"created_at":"2018-05-01T09:02:03Z","updated_at":"2018-05-01T09:02:03Z","author_association":"NONE","body":"Nope, that doesn't work either. Trying to figure out if the view is default or non-default. (I'm pulling from MySQL dbs/tables). "}}
{"actor":{"display_login":"foundinblank"}}