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

["xwinie (JIRA)" <ji...@apache.org>]

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)