Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-28540

SQL++ Alignment: Result for AVG( DISTINCT int_field1 ) are incorrect in analytics.

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • analytics
    • 5.5.0-2079
    • Untriaged
    • No
    • CX Sprint 96, CX Sprint 97

    Description

      Analytics Query:

      SELECT AVG( DISTINCT int_field1 ) FROM  simple_table_db_83597457_simple_table_shadow   WHERE  bool_field1    GROUP BY   int_field1 , decimal_field1 ,  primary_key_id , varchar_field1 , char_field1 ,  bool_field1    ;
      

      SQL Query:

      mysql> SELECT AVG( DISTINCT int_field1 ) FROM  simple_table   WHERE  bool_field1    GROUP BY   int_field1 , decimal_field1 ,  primary_key_id , varchar_field1 , char_field1 ,  bool_field1    ;
      

      Attachments

        1. backup.zip
          69 kB
        2. data.json
          291 kB
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            dmitry.lychagin Dmitry Lychagin (Inactive)
            ritesh.agarwal Ritesh Agarwal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty