[MDEV-13617] tokudb_parts tests failed in buildbot Created: 2017-08-22  Updated: 2017-08-22  Resolved: 2017-08-22

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.3
Fix Version/s: 10.3.1

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None


 Description   

tokudb_parts.part_supported_sql_func_tokudb, partition_alter2_1_1_tokudb, partition_alter2_1_2_tokudb, partition_alter1_1_2_tokudb, partition_alter1_1_tokudb failed with "Result length mismatch" http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest-big/builds/1161/steps/test_2/logs/stdio

tokudb_parts.part_supported_sql_func_tokudb w2 [ fail ]
        Test ended at 2017-08-21 23:29:06
 
CURRENT_TEST: tokudb_parts.part_supported_sql_func_tokudb
--- /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/part_supported_sql_func_tokudb.result	2017-08-20 14:24:55.000000000 -0400
+++ /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/part_supported_sql_func_tokudb.reject	2017-08-21 23:29:05.618693633 -0400
@@ -2318,7 +2318,7 @@
   `col1` int(11) DEFAULT NULL
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
  PARTITION BY LIST (`colint`)
-SUBPARTITION BY HASH (`col1` % 10)
+SUBPARTITION BY HASH (`col1` MOD 10)
 SUBPARTITIONS 5
 (PARTITION `p0` VALUES IN (1,2,3,4,5,6,7,8,9,10) ENGINE = TokuDB,
  PARTITION `p1` VALUES IN (11,12,13,14,15,16,17,18,19,20) ENGINE = TokuDB,
 
mysqltest: Result length mismatch

tokudb_parts.partition_alter1_1_2_tokudb w2 [ fail ]
        Test ended at 2017-08-21 23:39:43
 
CURRENT_TEST: tokudb_parts.partition_alter1_1_2_tokudb
--- /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter1_1_2_tokudb.result	2017-08-20 14:24:55.000000000 -0400
+++ /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter1_1_2_tokudb.reject	2017-08-21 23:39:42.419002751 -0400
@@ -1067,7 +1067,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
+ PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -3084,7 +3084,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int2` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -3592,7 +3592,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int2`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -5081,7 +5081,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
+ PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -7098,7 +7098,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int2` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -7606,7 +7606,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int2`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -9128,7 +9128,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
+ PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -11209,7 +11209,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int2` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -11733,7 +11733,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int2`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -13270,7 +13270,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
+ PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -15351,7 +15351,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int2` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -15875,7 +15875,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int2`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -17384,7 +17384,7 @@
   PRIMARY KEY (`f_int2`,`f_int1`),
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
+ PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -19405,7 +19405,7 @@
   PRIMARY KEY (`f_int2`,`f_int1`),
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int2` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -19914,7 +19914,7 @@
   PRIMARY KEY (`f_int2`,`f_int1`),
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int2`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -21406,7 +21406,7 @@
   PRIMARY KEY (`f_int1`,`f_int2`),
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
+ PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -23427,7 +23427,7 @@
   PRIMARY KEY (`f_int1`,`f_int2`),
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int2` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -23936,7 +23936,7 @@
   PRIMARY KEY (`f_int1`,`f_int2`),
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int2`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -25428,7 +25428,7 @@
   PRIMARY KEY (`f_int1`,`f_int2`),
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST ((`f_int1` + `f_int2`) % 4)
+ PARTITION BY LIST ((`f_int1` + `f_int2`) MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -27449,7 +27449,7 @@
   PRIMARY KEY (`f_int1`,`f_int2`),
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int2` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -27958,7 +27958,7 @@
   PRIMARY KEY (`f_int1`,`f_int2`),
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int2`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
 
mysqltest: Result length mismatch

tokudb_parts.partition_alter1_1_tokudb   w2 [ fail ]
        Test ended at 2017-08-21 23:50:26
 
CURRENT_TEST: tokudb_parts.partition_alter1_1_tokudb
--- /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter1_1_tokudb.result	2017-08-20 14:24:55.000000000 -0400
+++ /mnt/buildbot/build/mariadb-10.3.1/storage/tokudb/mysql-test/tokudb_parts/r/partition_alter1_1_tokudb.reject	2017-08-21 23:50:25.295140189 -0400
@@ -1385,7 +1385,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (`f_int1` % 4)
+ PARTITION BY LIST (`f_int1` MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -3404,7 +3404,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int1` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -3912,7 +3912,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int1`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -5401,7 +5401,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (`f_int1` % 4)
+ PARTITION BY LIST (`f_int1` MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -7420,7 +7420,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int1` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -7928,7 +7928,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   PRIMARY KEY (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int1`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -9450,7 +9450,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (`f_int1` % 4)
+ PARTITION BY LIST (`f_int1` MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -11533,7 +11533,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int1` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -12057,7 +12057,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int1`,`f_int2`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int1`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
@@ -13594,7 +13594,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (`f_int1` % 4)
+ PARTITION BY LIST (`f_int1` MOD 4)
 (PARTITION `part_3` VALUES IN (-3) ENGINE = TokuDB,
  PARTITION `part_2` VALUES IN (-2) ENGINE = TokuDB,
  PARTITION `part_1` VALUES IN (-1) ENGINE = TokuDB,
@@ -15677,7 +15677,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 3))
+ PARTITION BY LIST (abs(`f_int1` MOD 3))
 SUBPARTITION BY HASH (`f_int1` + 1)
 (PARTITION `part1` VALUES IN (0)
  (SUBPARTITION `sp11` ENGINE = TokuDB,
@@ -16201,7 +16201,7 @@
   `f_charbig` varchar(1000) DEFAULT NULL,
   UNIQUE KEY `uidx1` (`f_int2`,`f_int1`)
 ) ENGINE=TokuDB DEFAULT CHARSET=latin1
- PARTITION BY LIST (abs(`f_int1` % 2))
+ PARTITION BY LIST (abs(`f_int1` MOD 2))
 SUBPARTITION BY KEY (`f_int1`)
 SUBPARTITIONS 3
 (PARTITION `part1` VALUES IN (0) ENGINE = TokuDB,
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2017-08-22 ]

The code change was intentional

commit 9d853230077a97db819abc69a9197ab0b5f5aff2
Author: Alexander Barkov <bar@mariadb.org>
Date:   Mon Aug 14 11:12:17 2017 +0400
 
    MDEV-13500 sql_mode=ORACLE: can't create a virtual column with function MOD
    
    Fixing Item_func_mod::print() to print "arg1 MOD arg2" instea of "arg1 % arg2"

Apparently, test results need to be fixed.

Comment by Alexander Barkov [ 2017-08-22 ]

Pushed into bb-10.2-ext and 10.3.

Generated at Thu Feb 08 08:07:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.