• unknown's avatar
    Post-review fixes for bug #1790 'BIT_AND() result in GROUP BY different when · a2bdd621
    unknown authored
     SQL_BIG_RESULT used':
    - BIT_AND now returns BIGINT UNSIGNED
    - in case there were no matching rows BIT_AND returns 18446744073709551615 
    (but not NULL), BIT_OR returns 0 (but not NULL). That's how Monty wants it
    and how is described in our docs.
    
    
    
    
    include/my_global.h:
      Added definition for ULONGLONG_MAX.
      This is also a check that ULL type specifier
      can be used on all supported platforms.
    mysql-test/r/func_group.result:
      bug #1790, post-review work: test results fixed
    sql/item_sum.cc:
      small cleanup
    sql/item_sum.h:
      few style fixes.
      BIT_AND and BIT_OR now are both BIGINT UNSIGNED
    a2bdd621
func_group.result 7.57 KB