drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "xwinie (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4837) go odbc 连接drill,默认会在sql后面加上limit 0
Date Tue, 09 Aug 2016 06:38:20 GMT
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)

Mime
View raw message