Bug #50231 | Select shows different outputs for 'bigint' column containing 'null' values | ||
---|---|---|---|
Submitted: | 11 Jan 2010 13:10 | Modified: | 15 Jan 2010 7:51 |
Reporter: | Nirbhay Choubey | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Data Types | Severity: | S3 (Non-critical) |
Version: | 5.1-bugteam | OS: | Any |
Assigned to: | Ramil Kalimullin | CPU Architecture: | Any |
Tags: | regression |
[11 Jan 2010 13:10]
Nirbhay Choubey
[11 Jan 2010 15:02]
Nirbhay Choubey
Changed the synopsis from 'invalid' to 'different outputs' as its unclear which of the 2 outputs should be considered as correct/expected output. TIME, YEAR data types show the same difference, while <, <= operators also behave similar to <>, as described in the bug.
[11 Jan 2010 23:45]
Sveta Smirnova
Thank you for the report. Verified as described.
[15 Jan 2010 5:21]
Ramil Kalimullin
couldn't repeat using the latest mysql-5.1-bugteam.