diff options
author | Alexander Barkov <bar@mariadb.org> | 2017-08-14 11:12:17 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2017-08-14 11:12:17 +0400 |
commit | 9d853230077a97db819abc69a9197ab0b5f5aff2 (patch) | |
tree | f692c17c16849edeab2a12a586c952572a74ec09 /mysql-test/suite/parts/r/partition_basic_myisam.result | |
parent | 0f554dd0fdc54a07e38d6fd28b2f79a3dfc08713 (diff) | |
download | mariadb-git-9d853230077a97db819abc69a9197ab0b5f5aff2.tar.gz |
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"
Diffstat (limited to 'mysql-test/suite/parts/r/partition_basic_myisam.result')
-rw-r--r-- | mysql-test/suite/parts/r/partition_basic_myisam.result | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/mysql-test/suite/parts/r/partition_basic_myisam.result b/mysql-test/suite/parts/r/partition_basic_myisam.result index e32cd4394ad..3b84c0295f2 100644 --- a/mysql-test/suite/parts/r/partition_basic_myisam.result +++ b/mysql-test/suite/parts/r/partition_basic_myisam.result @@ -1007,7 +1007,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY LIST (`f_int1` % 4) + PARTITION BY LIST (`f_int1` MOD 4) (PARTITION `part_3` VALUES IN (-3) ENGINE = MyISAM, PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, @@ -2946,7 +2946,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, @@ -3434,7 +3434,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, @@ -4848,7 +4848,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, @@ -6781,7 +6781,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, @@ -7269,7 +7269,7 @@ t1 CREATE TABLE `t1` ( `f_char2` char(20) DEFAULT NULL, `f_charbig` varchar(1000) DEFAULT NULL ) ENGINE=MyISAM 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 = MyISAM, @@ -8795,7 +8795,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 - PARTITION BY LIST (`f_int1` % 4) + PARTITION BY LIST (`f_int1` MOD 4) (PARTITION `part_3` VALUES IN (-3) ENGINE = MyISAM, PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, @@ -10946,7 +10946,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, @@ -11487,7 +11487,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, @@ -13064,7 +13064,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, PARTITION `part_2` VALUES IN (-2) ENGINE = MyISAM, PARTITION `part_1` VALUES IN (-1) ENGINE = MyISAM, @@ -15209,7 +15209,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, @@ -15750,7 +15750,7 @@ t1 CREATE TABLE `t1` ( UNIQUE KEY `uidx1` (`f_int1`,`f_int2`), UNIQUE KEY `uidx2` (`f_int2`,`f_int1`) ) ENGINE=MyISAM 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 = MyISAM, |