diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2022-08-09 09:52:15 +0200 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2022-08-09 09:52:15 +0200 |
| commit | 75d631f333544de4487a6dd251d6f361e1d55d6b (patch) | |
| tree | 4e234afa19a458b9b0727859c53c290c683a502d /mysql-test/main/func_group.test | |
| parent | 9cbf8ccf2990f9db8d9debee42bc9213cbb04457 (diff) | |
| parent | 1d480419822b53c840de54542c1d1a0851dbe2c8 (diff) | |
| download | mariadb-git-75d631f333544de4487a6dd251d6f361e1d55d6b.tar.gz | |
Merge branch '10.7' into 10.8
Diffstat (limited to 'mysql-test/main/func_group.test')
| -rw-r--r-- | mysql-test/main/func_group.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/func_group.test b/mysql-test/main/func_group.test index 8ff3689f452..a4813cc04b8 100644 --- a/mysql-test/main/func_group.test +++ b/mysql-test/main/func_group.test @@ -1764,5 +1764,24 @@ DROP VIEW v1; DROP TABLE t1; --echo # +--echo # MDEV-23809: Server crash in JOIN_CACHE::free or ... +--echo # + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(2); +SELECT DISTINCT CASE CONVERT(EXPORT_SET(0, COLLATION(BENCHMARK(1, BIT_OR(0))),0),TIME) WHEN a THEN 1 END AS f FROM t1; +DROP TABLE t1; + + +CREATE TABLE t1 (a VARCHAR(8) NULL, b BIGINT); +INSERT INTO t1 (a,b) VALUES (NULL,NULL),('foo',NULL); +SELECT DISTINCT STRCMP((b > COLLATION(STDDEV_SAMP(15750))), a) AS f FROM t1; +DROP TABLE t1; + +CREATE TABLE t1 (a BIGINT) AS SELECT 1 AS v3 UNION SELECT FALSE ; +SELECT DISTINCT a IN ( COLLATION (AVG ('x'))) FROM t1 ; +DROP TABLE t1; + +--echo # --echo # End of 10.3 tests --echo # |