Bug #1788 The BIT_xxx() aggregate function behaviour changed in 4.1 - intentional or not?
| Submitted: | 9 Nov 2003 23:51 | Modified: | 16 Dec 2003 19:02 |
|---|---|---|---|
| Reporter: | Arjen Lentz | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 4.1 | OS: | Any (any) |
| Assigned to: | CPU Architecture: | Any |
[9 Nov 2003 23:51]
Arjen Lentz
[10 Nov 2003 1:26]
Arjen Lentz
The 4.0.13 changeset comments note: - BIT_AND() and BIT_OR() now return an unsigned 64 bit value. Looking at the current 4.0 tests in the bk tree, this is NOT the case. So perhaps this change was moved to 4.1 but the changeset comment stayed? This should also be fixed, once it's clear how things should be...
[16 Dec 2003 13:58]
Peter Gulutzan
There has been extensive discussion of this matter within MySQL. The apparently-final decision is that BIT_AND should return an unsigned number, and this fact is reflected in the manual.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.