| Bug #26038 | X() value of empty NOT NULL POINT is neither NULL nor NOT NULL | ||
|---|---|---|---|
| Submitted: | 2 Feb 2007 12:27 | Modified: | 15 Mar 2007 16:27 |
| Reporter: | Peter Brodersen (Candidate Quality Contributor) | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S3 (Non-critical) |
| Version: | 5.0.32-Dotdeb_1.dotdeb.1-log, 4.1 BK, 5.1 BK | OS: | Linux (Linux) |
| Assigned to: | Ramil Kalimullin | Target Version: | |
[2 Feb 2007 13:30]
Sveta Smirnova
Thank you for the report. Verified as described.
[21 Feb 2007 11:45]
Bugs System
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/20254 ChangeSet@1.2609, 2007-02-21 14:45:19+04:00, ramil@mysql.com +6 -0 Fix for bug #26038: X() value of empty NOT NULL POINT is neither NULL nor NOT NULL Having maybe_null flag unset for geometry/spatial functions leads to wrong Item_func_isnull::val_int()'s results. Fix: set maybe_null flag and add is_null() methods.
[21 Feb 2007 12:05]
Alexander Barkov
I think the patch is ok to push.
[8 Mar 2007 21:14]
Tim Smith
pushed to 4.1.23, 5.0.38, 5.1.17
[15 Mar 2007 16:27]
Paul DuBois
Noted in 4.1.23, 5.0.38, 5.1.17 changelogs. X() IS NULL and Y() IS NULL comparisons failed when X() and Y() returned NULL.
Description: If a field of type POINT with NOT NULL constraint contains empty data, X(field) would be of type NULL, however both X(field) IS NULL and X(field) IS NOT NULL would return 0. For what it's worth, Y() behaves the same way as X(). How to repeat: CREATE TABLE geom (id int, location POINT NOT NULL); INSERT INTO geom (id) VALUES (1),(2),(3); SELECT id, location, location IS NULL, location IS NOT NULL, X(location), X(location) IS NULL, X(location) IS NOT NULL FROM geom\G *************************** 1. row *************************** id: 1 location: location IS NULL: 0 location IS NOT NULL: 1 X(location): NULL X(location) IS NULL: 0 X(location) IS NOT NULL: 0 *************************** 2. row *************************** id: 2 location: location IS NULL: 0 location IS NOT NULL: 1 X(location): NULL X(location) IS NULL: 0 X(location) IS NOT NULL: 0 *************************** 3. row *************************** id: 3 location: location IS NULL: 0 location IS NOT NULL: 1 X(location): NULL X(location) IS NULL: 0 X(location) IS NOT NULL: 0 The value of X(location) is NULL, but the value of X(location) IS NULL should be 1.