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

[xwinie (JIRA)]

xwinie created DRILL-4837:
-----------------------------

             Summary: go odbc 连接drill，默认会在sql后面加上limit 0
                 Key: DRILL-4837
                 URL: https://issues.apache.org/jira/browse/DRILL-4837
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - ODBC
    Affects Versions: 1.6.0, 1.7.0
         Environment: win10    odbc64bit    go 1.6  
            Reporter: xwinie
             Fix For: Future


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




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)