CURRENT_TEST: main.plugin_load CURRENT_TEST: main.plugin CURRENT_TEST: main.fulltext_plugin CURRENT_TEST: main.udf CURRENT_TEST: main.udf_query_cache CURRENT_TEST: main.ctype_filesystem CURRENT_TEST: main.lowercase_utf8 CURRENT_TEST: main.ctype_ldml The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ldml.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_ucs2.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ldml.test at line 2 reason: Test needs character set 'ucs2_general_ci' CURRENT_TEST: main.date_formats CURRENT_TEST: main.ctype_latin1_de CURRENT_TEST: main.ctype_ucs2_def The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ucs2_def.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_ucs2.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ucs2_def.test at line 2 reason: Test needs character set 'ucs2_general_ci' CURRENT_TEST: main.bug47671 CURRENT_TEST: main.events_bugs CURRENT_TEST: main.events_restart CURRENT_TEST: main.events_logs_tests CURRENT_TEST: main.show_check CURRENT_TEST: main.ps CURRENT_TEST: main.log_tables CURRENT_TEST: main.log_state CURRENT_TEST: main.innodb_ignore_builtin CURRENT_TEST: main.init_file CURRENT_TEST: main.myisam-blob CURRENT_TEST: main.key_cache CURRENT_TEST: main.union CURRENT_TEST: main.mysql_client_test CURRENT_TEST: main.status CURRENT_TEST: main.multi_statement CURRENT_TEST: main.named_pipe The test '/home/mariadb/repos/maria/trunk/mysql-test/t/named_pipe.test' is not supported by this installation Detected in file ./include/windows.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/named_pipe.test at line 5 reason: Need windows CURRENT_TEST: maria.maria-recover CURRENT_TEST: main.shm The test '/home/mariadb/repos/maria/trunk/mysql-test/t/shm.test' is not supported by this installation Detected in file ./include/windows.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/shm.test at line 4 reason: Need windows CURRENT_TEST: main.warnings CURRENT_TEST: main.skip_log_bin CURRENT_TEST: main.partition_disabled The test '/home/mariadb/repos/maria/trunk/mysql-test/t/partition_disabled.test' is not supported by this installation Detected in file /home/mariadb/repos/maria/trunk/mysql-test/t/partition_disabled.test at line 7 reason: Test requires: 'disabled_partition' CURRENT_TEST: main.warnings_engine_disabled The test '/home/mariadb/repos/maria/trunk/mysql-test/t/warnings_engine_disabled.test' is not supported by this installation Detected in file /home/mariadb/repos/maria/trunk/mysql-test/t/warnings_engine_disabled.test at line 7 reason: Test requires: 'true' CURRENT_TEST: main.variables-notembedded CURRENT_TEST: main.lowercase_mixed_tmpdir CURRENT_TEST: main.lowercase_view CURRENT_TEST: parts.partition_mgm_lc1_archive The test '/home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc1_archive.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc1_archive.test at line 15 reason: Test requires: 'have_partition' CURRENT_TEST: parts.partition_mgm_lc1_memory The test '/home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc1_memory.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc1_memory.test at line 15 reason: Test requires: 'have_partition' CURRENT_TEST: parts.partition_mgm_lc1_myisam The test '/home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc1_myisam.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc1_myisam.test at line 15 reason: Test requires: 'have_partition' CURRENT_TEST: parts.partition_mgm_lc2_archive The test '/home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc2_archive.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc2_archive.test at line 15 reason: Test requires: 'have_partition' CURRENT_TEST: parts.partition_mgm_lc2_memory The test '/home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc2_memory.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc2_memory.test at line 15 reason: Test requires: 'have_partition' CURRENT_TEST: parts.partition_mgm_lc2_myisam The test '/home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc2_myisam.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_mgm_lc2_myisam.test at line 15 reason: Test requires: 'have_partition' CURRENT_TEST: main.lowercase_table CURRENT_TEST: main.lowercase_table_grant CURRENT_TEST: main.lowercase_table_qcache CURRENT_TEST: main.partition_open_files_limit The test '/home/mariadb/repos/maria/trunk/mysql-test/t/partition_open_files_limit.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/partition_open_files_limit.test at line 2 reason: Test requires: 'have_partition' CURRENT_TEST: parts.partition_repair_myisam The test '/home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_repair_myisam.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_repair_myisam.test at line 3 reason: Test requires: 'have_partition' CURRENT_TEST: parts.partition_recover_myisam The test '/home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_recover_myisam.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/suite/parts/t/partition_recover_myisam.test at line 9 reason: Test requires: 'have_partition' CURRENT_TEST: main.old-mode CURRENT_TEST: main.no-threads CURRENT_TEST: main.grant3 CURRENT_TEST: main.bug46080 CURRENT_TEST: main.init_connect CURRENT_TEST: main.count_distinct2 CURRENT_TEST: main.multi_update_tiny_hash CURRENT_TEST: main.order_fill_sortbuf CURRENT_TEST: main.multi_update2 CURRENT_TEST: main.skip_grants CURRENT_TEST: main.udf_skip_grants CURRENT_TEST: main.flush2 CURRENT_TEST: main.mysqldump-no-binlog CURRENT_TEST: main.skip_name_resolve CURRENT_TEST: maria.maria-preload CURRENT_TEST: main.partition The test '/home/mariadb/repos/maria/trunk/mysql-test/t/partition.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/partition.test at line 12 reason: Test requires: 'have_partition' CURRENT_TEST: main.partition_not_windows The test '/home/mariadb/repos/maria/trunk/mysql-test/t/partition_not_windows.test' is not supported by this installation Detected in file ./include/have_partition.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/partition_not_windows.test at line 4 reason: Test requires: 'have_partition' CURRENT_TEST: main.sysdate_is_now CURRENT_TEST: main.temp_table CURRENT_TEST: main.long_tmpdir CURRENT_TEST: binlog.binlog_base64_flag ERROR: --base64-output=never specified, but binlog contains a Table_map event which must be printed in base64. CURRENT_TEST: binlog.binlog_old_versions CURRENT_TEST: main.1st CURRENT_TEST: main.alias CURRENT_TEST: main.almost_full CURRENT_TEST: main.alter_table CURRENT_TEST: main.analyse CURRENT_TEST: main.analyze CURRENT_TEST: main.ansi CURRENT_TEST: main.archive_bitfield The test '/home/mariadb/repos/maria/trunk/mysql-test/t/archive_bitfield.test' is not supported by this installation Detected in file ./include/have_archive.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/archive_bitfield.test at line 2 reason: Test requires: 'true' CURRENT_TEST: main.archive_gis The test '/home/mariadb/repos/maria/trunk/mysql-test/t/archive_gis.test' is not supported by this installation Detected in file ./include/have_archive.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/archive_gis.test at line 2 reason: Test requires: 'true' CURRENT_TEST: main.auto_increment CURRENT_TEST: main.backup CURRENT_TEST: main.bench_count_distinct CURRENT_TEST: main.bigint CURRENT_TEST: main.binary CURRENT_TEST: main.bool CURRENT_TEST: main.bootstrap CURRENT_TEST: main.bulk_replace CURRENT_TEST: main.case CURRENT_TEST: main.cast CURRENT_TEST: main.change_user CURRENT_TEST: main.check CURRENT_TEST: main.client_xml CURRENT_TEST: main.comments CURRENT_TEST: main.compare CURRENT_TEST: main.compress CURRENT_TEST: main.constraints CURRENT_TEST: main.contributors CURRENT_TEST: main.count_distinct CURRENT_TEST: main.create CURRENT_TEST: main.create-uca CURRENT_TEST: main.create_not_windows CURRENT_TEST: main.csv CURRENT_TEST: main.csv_alter_table CURRENT_TEST: main.csv_not_null CURRENT_TEST: main.ctype_ascii CURRENT_TEST: main.ctype_big5 The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_big5.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_big5.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_big5.test at line 2 reason: Test needs character set 'big5_chinese_ci' CURRENT_TEST: main.ctype_collate CURRENT_TEST: main.ctype_cp1250_ch The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_cp1250_ch.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_cp1250_ch.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_cp1250_ch.test at line 2 reason: Test needs character set 'cp1250_czech_cs' CURRENT_TEST: main.ctype_cp1251 CURRENT_TEST: main.ctype_create CURRENT_TEST: main.ctype_eucjpms The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_eucjpms.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_eucjpms.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_eucjpms.test at line 2 reason: Test needs character set 'eucjpms_japanese_ci' CURRENT_TEST: main.ctype_euckr The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_euckr.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_euckr.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_euckr.test at line 2 reason: Test needs character set 'euckr_korean_ci' CURRENT_TEST: main.ctype_filename CURRENT_TEST: main.ctype_gb2312 The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_gb2312.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_gb2312.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_gb2312.test at line 2 reason: Test needs character set 'gb2312_chinese_ci' CURRENT_TEST: main.ctype_gbk The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_gbk.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_gbk.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_gbk.test at line 2 reason: Test needs character set 'gbk_chinese_ci' CURRENT_TEST: main.ctype_hebrew CURRENT_TEST: main.ctype_latin1 CURRENT_TEST: main.ctype_latin2 CURRENT_TEST: main.ctype_latin2_ch The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_latin2_ch.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_latin2_ch.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_latin2_ch.test at line 2 reason: Test needs character set 'latin2_czech_cs' CURRENT_TEST: main.ctype_many The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_many.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_ucs2.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_many.test at line 2 reason: Test needs character set 'ucs2_general_ci' CURRENT_TEST: main.ctype_mb CURRENT_TEST: main.ctype_recoding CURRENT_TEST: main.ctype_sjis The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_sjis.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_sjis.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_sjis.test at line 2 reason: Test needs character set 'sjis_japanese_ci' CURRENT_TEST: main.ctype_tis620 The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_tis620.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_tis620.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_tis620.test at line 2 reason: Test needs character set 'tis620_thai_ci' CURRENT_TEST: main.ctype_uca The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_uca.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_ucs2.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_uca.test at line 2 reason: Test needs character set 'ucs2_general_ci' CURRENT_TEST: main.ctype_ucs The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ucs.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_ucs2.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ucs.test at line 2 reason: Test needs character set 'ucs2_general_ci' CURRENT_TEST: main.ctype_ujis The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ujis.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_ujis.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ujis.test at line 2 reason: Test needs character set 'ujis_japanese_ci' CURRENT_TEST: main.ctype_ujis_ucs2 The test '/home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ujis_ucs2.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_ujis.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/ctype_ujis_ucs2.test at line 2 reason: Test needs character set 'ujis_japanese_ci' CURRENT_TEST: main.ctype_utf8 CURRENT_TEST: main.ddl_i18n_koi8r CURRENT_TEST: main.ddl_i18n_utf8 CURRENT_TEST: main.debug_sync The test '/home/mariadb/repos/maria/trunk/mysql-test/t/debug_sync.test' is not supported by this installation Detected in file ./include/have_debug_sync.inc at line 4 included from /home/mariadb/repos/maria/trunk/mysql-test/t/debug_sync.test at line 21 reason: Test requires: 'have_debug_sync' CURRENT_TEST: main.default CURRENT_TEST: main.delayed CURRENT_TEST: main.delete CURRENT_TEST: main.derived CURRENT_TEST: main.dirty_close CURRENT_TEST: main.distinct CURRENT_TEST: main.drop CURRENT_TEST: main.empty_table CURRENT_TEST: main.errors CURRENT_TEST: main.events_1 CURRENT_TEST: main.events_2 CURRENT_TEST: main.events_embedded The test '/home/mariadb/repos/maria/trunk/mysql-test/t/events_embedded.test' is not supported by this installation Detected in file ./include/is_embedded.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/events_embedded.test at line 2 reason: Test requires: 'is_embedded' CURRENT_TEST: main.events_grant CURRENT_TEST: main.events_microsec CURRENT_TEST: main.events_scheduling CURRENT_TEST: main.exampledb The test '/home/mariadb/repos/maria/trunk/mysql-test/t/exampledb.test' is not supported by this installation Detected in file ./include/have_exampledb.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/exampledb.test at line 6 reason: Test requires: 'true' CURRENT_TEST: main.execution_constants CURRENT_TEST: main.explain CURRENT_TEST: main.fix_priv_tables CURRENT_TEST: main.flush CURRENT_TEST: main.flush_table CURRENT_TEST: main.foreign_key CURRENT_TEST: main.fulltext CURRENT_TEST: main.fulltext2 CURRENT_TEST: main.fulltext3 The test '/home/mariadb/repos/maria/trunk/mysql-test/t/fulltext3.test' is not supported by this installation Detected in file ./include/have_collation.inc at line 2 included from ./include/have_gbk.inc at line 3 included from /home/mariadb/repos/maria/trunk/mysql-test/t/fulltext3.test at line 2 reason: Test needs character set 'gbk_chinese_ci' CURRENT_TEST: main.fulltext_cache CURRENT_TEST: main.fulltext_distinct CURRENT_TEST: main.fulltext_left_join CURRENT_TEST: main.fulltext_multi CURRENT_TEST: main.fulltext_order_by CURRENT_TEST: main.fulltext_update CURRENT_TEST: main.fulltext_var CURRENT_TEST: main.func_compress CURRENT_TEST: main.func_concat CURRENT_TEST: main.func_crypt CURRENT_TEST: main.func_date_add CURRENT_TEST: main.func_default CURRENT_TEST: main.func_encrypt_nossl CURRENT_TEST: main.func_equal CURRENT_TEST: main.func_gconcat CURRENT_TEST: main.func_group CURRENT_TEST: main.func_if --- /home/mariadb/repos/maria/trunk/mysql-test/r/func_if.result 2010-02-19 11:40:23.087790884 -0800 +++ /home/mariadb/repos/maria/trunk/mysql-test/r/func_if.reject 2010-02-19 12:40:31.530666212 -0800 @@ -99,14 +99,14 @@ INSERT INTO t1 VALUES (1,1110000000,'Day 1'),(2,1111000000,'Day 2'),(3,1112000000,'Day 3'); SELECT id, IF(date IS NULL, '-', FROM_UNIXTIME(date, '%d-%m-%Y')) AS date_ord, text FROM t1 ORDER BY date_ord ASC; id date_ord text -1 05-03-2005 Day 1 +1 04-03-2005 Day 1 2 16-03-2005 Day 2 3 28-03-2005 Day 3 SELECT id, IF(date IS NULL, '-', FROM_UNIXTIME(date, '%d-%m-%Y')) AS date_ord, text FROM t1 ORDER BY date_ord DESC; id date_ord text 3 28-03-2005 Day 3 2 16-03-2005 Day 2 -1 05-03-2005 Day 1 +1 04-03-2005 Day 1 DROP TABLE t1; CREATE TABLE t1 (a CHAR(10)); INSERT INTO t1 VALUES ('aaa'), (NULL), (''), ('bbb'); mysqltest: Result content mismatch