diff options
| author | unknown <igor@rurik.mysql.com> | 2005-08-22 09:40:10 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-08-22 09:40:10 -0700 |
| commit | b481b3b7bea67cde5a9cc00535e49f28180c6592 (patch) | |
| tree | 11a08a8d88c819a7d0d0f53aec4cc483f6e29bd6 /mysql-test/r/distinct.result | |
| parent | 0b4ec2fb427b242b2522f16b870933e10ce1a716 (diff) | |
| parent | 07e1b729dd9f6153264334c4b29a99e8daa76d2d (diff) | |
| download | mariadb-git-b481b3b7bea67cde5a9cc00535e49f28180c6592.tar.gz | |
Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-5.0
into rurik.mysql.com:/home/igor/mysql-5.0
mysql-test/r/distinct.result:
Auto merged
mysql-test/t/distinct.test:
Auto merged
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/distinct.result')
| -rw-r--r-- | mysql-test/r/distinct.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result index 00436019f85..fa52b5c8330 100644 --- a/mysql-test/r/distinct.result +++ b/mysql-test/r/distinct.result @@ -464,6 +464,14 @@ SELECT DISTINCT html,SUM(rout)/(SUM(rin)+1) as 'prod' FROM t1 GROUP BY rin; html prod 1 0.0000 drop table t1; +create table t1 (id int, dsc varchar(50)); +insert into t1 values (1, "line number one"), (2, "line number two"), (3, "line number three"); +select distinct id, IFNULL(dsc, '-') from t1; +id IFNULL(dsc, '-') +1 line number one +2 line number two +3 line number three +drop table t1; CREATE TABLE t1 (a int); INSERT INTO t1 VALUES (1),(2),(3),(4),(5); SELECT DISTINCT a, 1 FROM t1; |