main.bigint/rpl.rpl_stm_user_variables fail on Ubuntu 15.10 Wily in release mode
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Fix Released
|
High
|
Yura Sorokin | |||
5.6 |
Invalid
|
Undecided
|
Yura Sorokin | |||
5.7 |
Invalid
|
Undecided
|
Yura Sorokin |
Bug Description
main.bigint and rpl.rpl_
The problem seems to appear when GCC >= 5.0 is used for release builds.
Related 5.6 bug:
https:/
CURRENT_TEST: main.bigint
--- /home/yura/
+++ /home/yura/
@@ -385,15 +385,15 @@
-9223372036854
select -(-(92233720368
Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr
-def -(-(92233720368
+def -(-(92233720368
-(-(9223372036
-92233720368547
+854775808
select --9223372036854
--922337203685
-92233720368547
+854775808 -854775808 854775808
select -(-922337203685
-(-92233720368
-92233720368547
+854775808 -854775808
create table t1 select -92233720368547
describe t1;
Field Type Null Key Default Extra
mysqltest: Result content mismatch
CURRENT_TEST: rpl.rpl_
--- /home/yura/
+++ /home/yura/
@@ -127,7 +127,7 @@
double -9.223372036854
float -9.22337e18
real -92233720368547
-decimal -92233720368547
+decimal -854775808.00
#### [ on slave ]
SELECT * FROM t1;
tinyint -128
@@ -143,7 +143,7 @@
double -9.223372036854
float -9.22337e18
real -92233720368547
-decimal -92233720368547
+decimal -854775808.00
######
## assertion: master and slave tables are in sync
include/
@@ -179,7 +179,7 @@
double -9.223372036854
float -9.22337e18
real -92233720368547
-decimal -92233720368547
+decimal -854775808.00
#### [ on slave ]
SELECT * FROM t1;
tinyint -128
@@ -195,7 +195,7 @@
double -9.223372036854
float -9.22337e18
real -92233720368547
-decimal -92233720368547
+decimal -854775808.00
######
## assertion: master and slave tables are in sync
include/
mysqltest: Result content mismatch
To reproduce:
cmake \
../mysql-server \
-DCMAKE_
-DBUILD_
-DFEATURE_
-DWITH_
-DENABLE_
-DWITH_
-DWITH_SSL=system
make -j4
./mysql-test/mtr main.bigint
./mysql-test/mtr rpl.rpl_
To resolve the problem, backport the fix from 5.6
commit 49329220ea0f40e 42344cef39b0d9b 72bd5f557f
Author: Tor Didriksen <email address hidden>
Date: Wed Apr 8 16:53:55 2015 +0200
Bug#20768820 MAIN.BIGINT TEST FAILS WHEN BUILT WITH GCC 5 IN RELEASE BUILD
Problem: with gcc5 in optmized mode, (- LLONG_MIN ) yields integer overflow. e15c5f6e2243c89 37af74acb7)
Fix: In ull2dec() change the loop which counts the number of decimal_digit_t's
(cherry picked from commit b37d8bcc24f82f8