MySQL Bugs: #28748: "Select" returning one value too few

Bug #28748	"Select" returning one value too few
Submitted:	29 May 2007 15:24	Modified:	18 Jun 2007 13:51
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.17	OS:	Solaris (x86)
Assigned to:	Ramil Kalimullin	CPU Architecture:	Any

Description:
The following test failure occurs since 5.1.17-beta,
just the report is delayed.

It is specific to machines running Solaris (= Sun compiler) on an x86 CPU.

-------------------------------------------------------
*** r/func_in.result
--- r/func_in.reject
***************
*** 434,440
  (0x8000040000000001);
  SELECT HEX(a) FROM t2 WHERE a IN (0xBB3C3E98175D33C8, 42);
  HEX(a)
- BB3C3E98175D33C8
  SELECT HEX(a) FROM t2 WHERE a IN
  (0xBB3C3E98175D33C8,
  0x7fffffffffffffff,
--- 434,439
***************
*** 443,449
  0x8000000000000401,
  42);
  HEX(a)
- BB3C3E98175D33C8
  7FFFFFFFFFFFFEFF
  7FFFFFFFFFFFFFEF
  7FFFFFFFFFFFFFFE
--- 442,447
***************
*** 453,459
  8000000000000002
  8000000000000300
  8000000000000400
- 8000000000000401
  SELECT HEX(a) FROM t2 WHERE a IN (0x7fffffffffffffff,0x8000000000000001);
  HEX(a)
  7FFFFFFFFFFFFFFF
--- 451,456
-------------------------------------------------------

How to repeat:
Found by running the test suite in release builds.

Suggested fix:
Maybe it should  first be tried on with a gcc build on Solaris/x86.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/28457

ChangeSet@1.2530, 2007-06-09 17:13:33+05:00, ramil@mysql.com +2 -0
  Fix for bug #28748: "Select" returning one value too few
  
  Problem: we may get unexpected results comparing [u]longlong values as doubles.
  Fix: adjust the test to use integer comparators.
  Note: it's not a real fix, we have to implement some new comparators 
  to completely solve the original problem (see my comment in the bug report).

Pushed into 5.0.44

Pushed into 5.1.20-beta

Noted in 5.0.44, 5.1.20 changelogs.

Removed changelog entries; this was a test case change only.