Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4837

go odbc 连接drill,默认会在sql后面加上limit 0

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      None
    • Environment:

      win10 odbc64bit go 1.6

    • Flags:
      Patch, Important

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              xwinie xwinie
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: