duplicated column nams is not supported in SQL statement.

XMLWordPrintableJSON

    • Type: Investigation
    • Resolution: Unresolved
    • Priority: Critical - P2
    • jdbc-3.0.7
    • Affects Version/s: None
    • Component/s: MongoSQL
    • None
    • Atlas SQL

      Summary

      when call  executeQuery(), it returns error.

      The mongo jdbc driver we use is 3.0.3.

      How to Reproduce

      we use JDBC connector, when call executeQuery() to  run a sql statement which contains duplicate name.

      e.g.

      SELECT
      city.CITY,
      city.CITY_ID,
      region.COUNTRY_ID,
      region.REGION,
      region.REGION_ID,
      city.REGION_ID
      FROM
      city,
      region
      WHERE
      ( city.REGION_ID=region.REGION_ID )

       

      it returns error "Error executing command: algebrize error: Error 3023: found duplicate document key "REGION_ID""

       

            Assignee:
            Nicholas Cioli
            Reporter:
            qin liu
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated: