diff options
author | Igor Babaev <igor@askmonty.org> | 2013-11-21 15:19:25 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2013-11-21 15:19:25 -0800 |
commit | c0f31dc9f3e0a42911beb6655a40601d2fddfe8e (patch) | |
tree | eceda1a471f3179d772999bf15a77d282e226c45 /mysql-test/r/func_equal.result | |
parent | f8a6ee59acb082678cf601a10cbe9c1152748242 (diff) | |
download | mariadb-git-c0f31dc9f3e0a42911beb6655a40601d2fddfe8e.tar.gz |
Another attempt to fix bug mdev-5103.
The earlier pushed fix for the bug was incomplete. It did not remove
the main cause of the problem: the function remove_eq_conds()
removed always true multiple equalities from any conjunct, but did not
adjust the list of them stored in Item_cond_and::cond_equal.current_level.
Simplified the test case for the bug and moved it to another test file.
The fix triggered changes in EXPLAIN EXTENDED for some queries.
Diffstat (limited to 'mysql-test/r/func_equal.result')
-rw-r--r-- | mysql-test/r/func_equal.result | 43 |
1 files changed, 0 insertions, 43 deletions
diff --git a/mysql-test/r/func_equal.result b/mysql-test/r/func_equal.result index 02593529a91..f20b259191c 100644 --- a/mysql-test/r/func_equal.result +++ b/mysql-test/r/func_equal.result @@ -43,46 +43,3 @@ a 4828532208463511553 drop table t1; #End of 4.1 tests -# -# MDEV-5103: server crashed on singular Item_equal -# -CREATE TABLE `t1` ( -`tipo` enum('p','r') NOT NULL DEFAULT 'r', -`arquivo_id` bigint(20) unsigned NOT NULL DEFAULT '0', -`arquivo_md5` char(32) NOT NULL, -`conteudo` longblob NOT NULL, -`usuario` varchar(15) NOT NULL, -`datahora_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -`tipo_arquivo` varchar(255) NOT NULL, -`nome_arquivo` varchar(255) NOT NULL, -`tamanho_arquivo` bigint(20) unsigned NOT NULL DEFAULT '0', -PRIMARY KEY (`tipo`,`arquivo_id`), -UNIQUE KEY `tipo` (`tipo`,`arquivo_md5`) -) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1; -INSERT INTO `t1` (`tipo`, `arquivo_id`, `arquivo_md5`, `conteudo`, `usuario`, `datahora_gmt`, `tipo_arquivo`, `nome_arquivo`, `tamanho_arquivo`) VALUES -('r', 1, 'ad18832202b199728921807033a8a515', '', 'rspadim', '2013-10-05 13:55:50', '001_cbr643', 'CBR6431677410201314132.ret', 21306); -CREATE TABLE `t2` ( -`tipo` enum('p','r') NOT NULL DEFAULT 'p', -`arquivo_id` bigint(20) NOT NULL DEFAULT '0', -`usuario` varchar(25) NOT NULL, -`datahora` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', -`erros` longblob NOT NULL, -`importados` bigint(20) unsigned NOT NULL DEFAULT '0', -`n_importados` bigint(20) unsigned NOT NULL DEFAULT '0', -PRIMARY KEY (`tipo`,`arquivo_id`,`datahora`) -) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1; -INSERT INTO `t2` (`tipo`, `arquivo_id`, `usuario`, `datahora`, `erros`, `importados`, `n_importados`) VALUES -('r', 1, 'rspadim', '2013-10-05 14:25:30', '', 32, 0); -SELECT -arquivo_id,usuario,datahora_gmt,tipo_arquivo,nome_arquivo,tamanho_arquivo -FROM t1 AS a -WHERE datahora_gmt>='0000-00-00 00:00:00' AND -datahora_gmt<='2013-10-07 02:59:59' AND tipo='r' AND -(tipo_arquivo,arquivo_id) NOT IN -(SELECT tipo_arquivo,arquivo_id -FROM t2 -WHERE (tipo_arquivo,arquivo_id)=(a.tipo_arquivo,a.arquivo_id)) -ORDER BY arquivo_id DESC; -arquivo_id usuario datahora_gmt tipo_arquivo nome_arquivo tamanho_arquivo -drop table t2, t1; -#End of 5.3 tests |