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

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.17.0
    • None
    • core
    • None
    • 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

          Unassigned Unassigned
          zhengzi zhengzi
          Votes:
          0 Vote for this issue
          Watchers:
          2 Start watching this issue

          Dates

            Created:
            Updated: