Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-26011

rocksdb.group_min_max fails in bb, result length mismatch

    XMLWordPrintable

    Details

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos74-amd64-debug/builds/6686/steps/mtr-rocksdb/logs/stdio

      rocksdb.group_min_max 'write_committed'  w3 [ fail ]
              Test ended at 2021-06-23 19:53:45
       
      CURRENT_TEST: rocksdb.group_min_max
      --- /usr/share/mysql-test/plugin/rocksdb/rocksdb/r/group_min_max.result	2021-06-23 16:52:43.000000000 +0000
      +++ /dev/shm/var/3/log/group_min_max.reject	2021-06-23 19:53:45.413086684 +0000
      @@ -2346,10 +2346,10 @@
       BB
       EXPLAIN SELECT a FROM t1 WHERE a='AA' GROUP BY a;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	ref	PRIMARY	PRIMARY	7	const	1000	Using where; Using index
      +1	SIMPLE	t1	range	PRIMARY	PRIMARY	7	NULL	501	Using where; Using index for group-by
       EXPLAIN SELECT a FROM t1 WHERE a='BB' GROUP BY a;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	ref	PRIMARY	PRIMARY	7	const	1000	Using where; Using index
      +1	SIMPLE	t1	range	PRIMARY	PRIMARY	7	NULL	501	Using where; Using index for group-by
       SELECT DISTINCT a FROM t1 WHERE a='BB';
       a
       BB
      @@ -2777,7 +2777,7 @@
       3	13
       explain extended select sql_buffer_result a, max(b)+1 from t1 where a = 0 group by a;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
      -1	SIMPLE	t1	ref	PRIMARY,index	PRIMARY	4	const	15	6.67	Using index; Using temporary
      +1	SIMPLE	t1	range	PRIMARY,index	PRIMARY	4	NULL	1	100.00	Using where; Using index for group-by; Using temporary
       Warnings:
       Note	1003	select sql_buffer_result `test`.`t1`.`a` AS `a`,max(`test`.`t1`.`b`) + 1 AS `max(b)+1` from `test`.`t1` where `test`.`t1`.`a` = 0 group by `test`.`t1`.`a`
       drop table t1;
      @@ -3505,7 +3505,7 @@
       test.t1	analyze	status	OK
       EXPLAIN SELECT MAX(c2), c1 FROM t1 WHERE c1 = 4 GROUP BY c1;
       id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
      -1	SIMPLE	t1	ref	c1	c1	5	const	28	Using index
      +1	SIMPLE	t1	range	c1	c1	5	NULL	6	Using where; Using index for group-by
       FLUSH STATUS;
       SELECT MAX(c2), c1 FROM t1 WHERE c1 = 4 GROUP BY c1;
       MAX(c2)	c1
      @@ -3513,9 +3513,9 @@
       SHOW SESSION STATUS LIKE 'Handler_read%';
       Variable_name	Value
       Handler_read_first	0
      -Handler_read_key	1
      -Handler_read_last	0
      -Handler_read_next	20
      +Handler_read_key	3
      +Handler_read_last	1
      +Handler_read_next	0
       Handler_read_prev	0
       Handler_read_retry	0
       Handler_read_rnd	0
       
      mysqltest: Result length mismatch
      

        Attachments

          Activity

            People

            Assignee:
            psergei Sergei Petrunia
            Reporter:
            alice Alice Sherepa
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.