[DRILL-4837] go odbc 连接drill，默认会在sql后面加上limit 0

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.6.0, 1.7.0
• Fix Version/s: Future
• Component/s: Client - ODBC

Environment

win10 odbc64bit go 1.6

• Flags: Patch, Important
• Assignee: Unassigned
• Reporter: xwinie
• Created: 09/Aug/16 06:37
• Updated: 11/Aug/16 07:29
• Resolved: 11/Aug/16 07:29

Description

hi：
我用go odbc 连接drill，默认会在sql后面加上limit 0，go语言的odbc连接其他数据库，并无此情况。
go ：
connStr := `Driver=

{MapR Drill ODBC Driver}

;
Catalog=DRILL; AuthenticationType=No Authentication; ConnectionType=Direct;
Host=192.168.10.241;
Port=31010;`

db, err := sql.Open("odbc", connStr)
if err != nil

{ panic(err) }
defer db.Close()

sql := "select * from mysqlplugin.mfm.sys_dict"

fmt.Println(sql)


rows, err := db.Query(sql)
if err != nil { panic(err) }

drill：

2016-08-09 14:12:18,989 [28568bbd-0748-9eca-8a7e-a595d7fc4ed0:foreman] INFO o.a.drill.exec.work.foreman.Foreman - Query text for query id 28568bbd-0748-9eca-8a7e-a595d7fc4ed0: SELECT * FROM (select * from mysqlplugin.mfm.sys_dict where 1=1) T LIMIT 0