diff options
| author | unknown <bar@bar.mysql.r18.ru> | 2003-07-30 14:15:25 +0500 |
|---|---|---|
| committer | unknown <bar@bar.mysql.r18.ru> | 2003-07-30 14:15:25 +0500 |
| commit | c785f09800e4e7dd91809579c724e73a3b223d94 (patch) | |
| tree | df4c09576cac4fe57abbc11b771fc656ef039ce2 /mysql-test/t/func_group.test | |
| parent | 6f2d2d4708644ebf78334ae25a8f6fc774fae8f2 (diff) | |
| download | mariadb-git-c785f09800e4e7dd91809579c724e73a3b223d94.tar.gz | |
Derivation attribute was not processed correctly
by MAX/MIN in some cases:
SELECT coercibility(max(s1)) from t1;
Subselect collation and derivation was not processed
correctly:
create table a select (select s1 from t1);
select * from t1 where s1 = (select s2 from t1);
Diffstat (limited to 'mysql-test/t/func_group.test')
| -rw-r--r-- | mysql-test/t/func_group.test | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/t/func_group.test b/mysql-test/t/func_group.test index fed19cbe07c..8a43716d854 100644 --- a/mysql-test/t/func_group.test +++ b/mysql-test/t/func_group.test @@ -355,3 +355,8 @@ insert into t1 values (1, 3); select count(*) + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ + MAX_REQ - MAX_REQ from t1 group by MAX_REQ; select Case When Count(*) < MAX_REQ Then 1 Else 0 End from t1 where t1.USR_ID = 1 group by MAX_REQ; drop table t1; + +create table t1 (a char(10)); +insert into t1 values ('a'),('b'),('c'); +select coercibility(max(a)) from t1; +drop table t1; |