#title MySQL Linked Server Bug
[[TableOfContents]]

==== 현상 ====
{{{
select * 
from openquery(mysql, '
select * from test
limit 10
')
}}}

결과
{{{
Msg 7357, Level 16, State 2, Line 1
Cannot process the object "	select * from test". The OLE DB provider "MSDASQL" for linked server "mysql" indicates that either the object has no columns or the current user does not have permissions on that object.
}}}

==== 해결 ====
개행(CR)이 있으면 안된다. 이 문서(https://bugs.mysql.com/bug.php?id=80320)에서는 tab도 안 된다고 했는데, mysql-connector-odbc-8.0.12 버전에서는 tab은 된다. 
{{{
select * 
from openquery(mysql, 'select * from test
limit 10
')
}}}