• unknown's avatar
    Better bugfix for "HAVING when refering to RAND()" (Bug #8216) · 8bbefca5
    unknown authored
    Ensure that references in HAVING, ORDER BY or GROUP BY are calculated after fields in SELECT.
    This will ensure that any reference to these has a valid value.
    Generalized the code for split_sum_func()
    
    
    BitKeeper/etc/ignore:
      added support-files/ndb-config-2-node.ini
    mysql-test/r/group_by.result:
      More complicated test to assure that rand() is only calulated once
    mysql-test/r/user_var.result:
      Back to old results :(  (ok but not perfect)
    mysql-test/t/group_by.test:
      More complicated test to assure that rand() is only calulated once
    sql/item.cc:
      Better bugfix for "HAVING when refering to RAND()"
      This will ensure that when refering to things like RAND() in HAVING through an alias we will not recalculate that rand() value in the HAVING part but use the value in the row
      Generalize split_sum_func()
    sql/item.h:
      Better bugfix for "HAVING when refering to RAND()"
      T
    sql/item_cmpfunc.cc:
      Better bugfix for "HAVING when refering to RAND()"
      Use generalized split_sum_func2() function
    sql/item_func.cc:
      Better bugfix for "HAVING when refering to RAND()"
      Use generalized split_sum_func2() function
    sql/item_row.cc:
      Better bugfix for "HAVING when refering to RAND()"
      Use generalized split_sum_func2() function
    sql/item_strfunc.cc:
      Better bugfix for "HAVING when refering to RAND()"
      Use generalized split_sum_func2() function
    sql/sql_list.h:
      Add functions to concatenate lists
    sql/sql_select.cc:
      Better bugfix for "HAVING when refering to RAND()"
      Ensure that references in HAVING, ORDER BY or GROUP BY are calculated after fields in SELECT.
      This will ensure that any reference to these has a valid value.
    8bbefca5
group_by.test 22.5 KB