{"action":"closed","issue":{"url":"https://api.github.com/repos/JuliaDB/ODBC.jl/issues/104","labels_url":"https://api.github.com/repos/JuliaDB/ODBC.jl/issues/104/labels{/name}","comments_url":"https://api.github.com/repos/JuliaDB/ODBC.jl/issues/104/comments","events_url":"https://api.github.com/repos/JuliaDB/ODBC.jl/issues/104/events","html_url":"https://github.com/JuliaDB/ODBC.jl/issues/104","id":113334936,"number":104,"title":"Error while using \"SHOW\" keyword in a query","user":{"login":"bmharsha","id":5441491,"avatar_url":"https://avatars.githubusercontent.com/u/5441491?v=3","gravatar_id":"","url":"https://api.github.com/users/bmharsha","html_url":"https://github.com/bmharsha","followers_url":"https://api.github.com/users/bmharsha/followers","following_url":"https://api.github.com/users/bmharsha/following{/other_user}","gists_url":"https://api.github.com/users/bmharsha/gists{/gist_id}","starred_url":"https://api.github.com/users/bmharsha/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bmharsha/subscriptions","organizations_url":"https://api.github.com/users/bmharsha/orgs","repos_url":"https://api.github.com/users/bmharsha/repos","events_url":"https://api.github.com/users/bmharsha/events{/privacy}","received_events_url":"https://api.github.com/users/bmharsha/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-26T11:23:06Z","updated_at":"2015-10-30T06:40:02Z","closed_at":"2015-10-30T06:40:02Z","body":" Below queries are generating an error, when ODBC.jl is connected to MySQL database\r\n\r\n```\r\n\"show columns from table_name;\"\r\n\"show databases;\"\r\n\"show tables;\"\r\n```\r\n\r\nExact error message can be found below\r\n\r\n```\r\nERROR: MethodError: `convert` has no method matching convert(::Type{Ptr{UInt16}}, ::Array{UInt16,1})\r\nThis may have arisen from a call to the constructor Ptr{UInt16}(...),\r\nsince type constructors fall back to convert methods.\r\nClosest candidates are:\r\n  call{T}(::Type{T}, ::Any)\r\n  convert{T}(::Type{Ptr{T}}, ::UInt64)\r\n  convert{T}(::Type{Ptr{T}}, ::Int64)\r\n  ...\r\n in ODBCCopy! at /home/myusername/.julia/v0.4/ODBC/src/backend.jl:149\r\n in ODBCFetchDataFrame at /home/myusername/.julia/v0.4/ODBC/src/backend.jl:180\r\n in query at /home/myusername/.julia/v0.4/ODBC/src/userfacing.jl:58\r\n in query at /home/myusername/.julia/v0.4/ODBC/src/userfacing.jl:42\r\n```\r\n\r\nThese errors occur only when the query is returning  a non-empty dataset . For example, if you have an empty database and you execute query ```\"show tables;\"``` , you won't get this error.\r\n\r\n\r\nSystem information\r\n\r\nDatabase = MySQL 5.6.19\r\nJulia = 0.4 stable version\r\nOS = Ubuntu 14.04"}}