Bug #74301 linestring_multilineString_attri_prop fails on CentOS 6, 32 bit, release build
Submitted: 9 Oct 2014 15:30 Modified: 10 Mar 2015 14:33
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: GIS Severity:S3 (Non-critical)
Version:5.7.5 OS:Linux (CentOS 6 x86)
Assigned to: CPU Architecture:Any

[9 Oct 2014 15:30] Laurynas Biveinis
Description:
linestring_multilineString_attri_prop fails on CentOS 6, 32 bit, release build.

$ uname -a
Linux vm-centos-6-32-1 2.6.32-431.17.1.el6.i686 #1 SMP Wed May 7 20:52:21 UTC 2014 i686 i686 i386 GNU/Linux

How to repeat:
cmake .. -DWITH_BOOST=foo -DDOWNLOAD_BOOST=1
..
make
..
mysql-test-run linestring_multilineString_attri_prop
..
gis.linestring_multilineString_attri_prop [ fail ]
        Test ended at 2014-10-09 18:26:38

CURRENT_TEST: gis.linestring_multilineString_attri_prop
--- /home/laurynas/percona/lp-mysql-server/mysql-server/mysql-test/suite/gis/r/linestring_multilineString_attri_prop.result	2014-10-09 17:52:36.774350000 +0300
+++ /home/laurynas/percona/lp-mysql-server/mysql-server/obj-release/mysql-test/var/log/linestring_multilineString_attri_prop.reject	2014-10-09 18:26:37.972758687 +0300
@@ -1518,7 +1518,7 @@
 1.0000000000000024e16
 select GLength(MLineFromWKB(0x0000000005000000020000000002000000035FB317E5EF3AB327E3A4B378469B67320000000000000000C0240000000000003FF05FD8ADAB9F560000000000000000000000000200000003000000000000000000000000000000000000000000000000BFF08B439581062540240000000000004341C37937E08000));
 GLength(MLineFromWKB(0x0000000005000000020000000002000000035FB317E5EF3AB327E3A4B378469B67320000000000000000C0240000000000003FF05FD8ADAB9F560000000000000000000000000200000003000000000000000000000000000000000000000000000000BFF08B4395810625402400000000000043
-NULL
+1e172
 Select GLength(LineFromText('LINESTRING(0 0,1 0,2 0, 2 1, 0 -2)'));
 GLength(LineFromText('LINESTRING(0 0,1 0,2 0, 2 1, 0 -2)'))
 6.60555127546399
[9 Oct 2014 20:20] MySQL Verification Team
Thank you for the bug report. I couldn't repeat with current source on CentOS 6.5:

Scanning dependencies of target authentication_pam
[100%] Building C object internal/plugin/pam-authentication-plugin/CMakeFiles/authentication_pam.dir/src/authentication_pam.c.o
[100%] Building C object internal/plugin/pam-authentication-plugin/CMakeFiles/authentication_pam.dir/src/parser.c.o
[100%] Building C object internal/plugin/pam-authentication-plugin/CMakeFiles/authentication_pam.dir/src/safe_getpwnam.c.o
[100%] Building C object internal/plugin/pam-authentication-plugin/CMakeFiles/authentication_pam.dir/src/safe_getgrnam.c.o
Linking C shared module authentication_pam.so
[100%] Built target authentication_pam
[miguel@tikal 5.7]$ cd mysql-test/
r                  README.stress  t
[miguel@tikal mysql-test]$ ./mysql-test-run linestring_multilineString_attri_prop
Logging: ./mysql-test-run  linestring_multilineString_attri_prop
MySQL Version 5.7.6
Checking supported features...
 - SSL connections supported
Collecting tests...
Removing old var directory...
Creating var directory '/home/miguel/5.7/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
gis.linestring_multilineString_attri_prop [ pass ]    509
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.509 of 17 seconds executing testcases

Completed: All 1 tests were successful.
[10 Oct 2014 5:52] Laurynas Biveinis
I see the bug is "Needs Feedback" but I am not sure what kind of feedback I can provide without access to 5.7.6. If you can not reproduce the issue with the current 5.7.6, then I'd check if you can indeed reproduce it with 5.7.5, if yes, close the bug, otherwise we can look further.
[10 Oct 2014 15:54] MySQL Verification Team
Thank you for the feedback. I couldn't repeat with 5.7.5 too:

[miguel@tikal mysql-test]$ ./mysql-test-run linestring_multilineString_attri_prop
Logging: ./mysql-test-run  linestring_multilineString_attri_prop
MySQL Version 5.7.5
Checking supported features...
 - SSL connections supported
Collecting tests...
Removing old var directory...
Creating var directory '/home/miguel/mysql-5.7.5-m15/mysql-test/var'...
Installing system database...

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
gis.linestring_multilineString_attri_prop [ pass ]    540
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.540 of 16 seconds executing testcases

Completed: All 1 tests were successful.

[miguel@tikal mysql-test]$ ../sql/mysqld --version
../sql/mysqld  Ver 5.7.5-m15 for Linux on x86_64 (Source distribution)
[miguel@tikal mysql-test]$ uname -a
Linux tikal.br 2.6.32-431.23.3.el6.x86_64 #1 SMP Thu Jul 31 17:20:51 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux
[miguel@tikal mysql-test]$
[10 Mar 2015 14:33] Laurynas Biveinis
Does not occur anymore with 5.7.6.