summaryrefslogtreecommitdiff
path: root/mysql-test/main/innodb_group.test
blob: 56c8d54003e3ee2b6e685a218cfc4b07e192edff (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#
# Tests involving GROUP BY, aggregate functions and InnoDB
#


--source include/have_innodb.inc

--echo #
--echo # Start of 10.1 tests
--echo #

--echo #
--echo # MDEV-10556 Assertion `0' failed in virtual void Item_sum_field::set_result_field(Field*)
--echo #

CREATE TABLE t1 (i INT) ENGINE=InnoDB;
SELECT DISTINCT STDDEV(1) FROM t1 GROUP BY i ORDER BY BENCHMARK(0, BIT_XOR(i));
DROP TABLE t1;

--echo #
--echo # End of 10.1 tests
--echo #