Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-1629

Union All with global aggregates fails

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • None
    • COMP - Compiler
    • None

    Description

      query:

      SELECT COUNT(1)  AS one FROM items
      UNION ALL
      SELECT COUNT(1) AS one FROM items;
      

      A runtime error is thrown:

      Invalid types for casting, required type generalized-record-type: closed {
        one: UNION(INT64, NULL, MISSING)
      }
      , input type null: closed {
        one: UNION(INT64, NULL, MISSING)
      }
       [IllegalStateException]
      

      Attachments

        Activity

          People

            buyingyi Yingyi Bu
            buyingyi Yingyi Bu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: