Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3774

HBase - Phoenix driver evalues 'HAVING MIN/MAX/AVG(x) = null' to true

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.7.1.6_2
    • None
    • None

      Phoenix driver evaluates clause HAVING MIN/MAX/AVG(x) = null to true. This is problem for query e.g. SELECT stringnum FROM bqt1.smalla GROUP BY stringnum HAVING MIN(stringnum) = '1' as result is:

      StringNum
      <null>
      1

              rhn-engineering-shawkins Steven Hawkins
              jdurani Juraj Duráni (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: