main.null w1 [ fail ]
|
Test ended at 2016-11-02 17:13:33
|
|
CURRENT_TEST: main.null
|
--- /mnt/buildbot/build/mariadb-10.1.19/mysql-test/r/null.result 2016-11-02 14:55:24.000000000 +0200
|
+++ /mnt/buildbot/build/mariadb-10.1.19/mysql-test/r/null.reject 2016-11-02 17:13:32.000000000 +0200
|
@@ -1400,8 +1400,8 @@
|
A 0
|
SELECT CHARSET(NULLIF(a,_utf8'a' COLLATE utf8_bin)) FROM t1;
|
CHARSET(NULLIF(a,_utf8'a' COLLATE utf8_bin))
|
-latin1
|
-latin1
|
+utf8
|
+utf8
|
EXPLAIN EXTENDED SELECT NULLIF(a,_utf8'a' COLLATE utf8_bin) IS NULL AS expr FROM t1;
|
id select_type table type possible_keys key key_len ref rows filtered Extra
|
1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00
|
@@ -1556,7 +1556,7 @@
|
create table t1 (f1 varchar(10));
|
insert into t1 values ('2015-12-31');
|
select power( timestamp( nullif( '2002-09-08', f1 ) ), 24 ) from t1;
|
-ERROR 22003: DOUBLE value is out of range in 'pow(cast((case when '2002-09-08' = `test`.`t1`.`f1` then NULL else '2002-09-08' end) as datetime(6)),24)'
|
+ERROR 22003: DOUBLE value is out of range in 'pow(cast(nullif('2002-09-08',`test`.`t1`.`f1`) as datetime(6)),24)'
|
drop table t1;
|
CREATE TABLE t1 (f1 INT);
|
INSERT INTO t1 VALUES (1),(2);
|
|
mysqltest: Result length mismatch
|