Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-2753

ambiguous column error when push down a query that has a sub-query after IN and a LIMIT keyword outmost to jdbc datasource

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.17.0
    • Fix Version/s: None
    • Component/s: core
    • Labels:
      None
    • Docs Text:
      when execute this sql [ select * from "aaa" where ID in ( select ID from "aaa" where NAME=2) limit 100 ] there will be an error . The error detail show in error.png . The aaa is a table in mysql database

      Attachments

      1. error.png
        45 kB
        zhengzi

        Activity

          People

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

            Dates

            • Created:
              Updated: