diff options
| author | unknown <serg@serg.mylan> | 2005-09-15 21:05:42 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2005-09-15 21:05:42 +0200 |
| commit | c7d162a23079cc7dd0d12352cd3ad071c5a9744f (patch) | |
| tree | f9eb94ebc4c5e2fd7abee5a3227abd3a7bc21016 /mysql-test/r/distinct.result | |
| parent | 997054eba11e427a87058e8aa1ac2853dd8569c7 (diff) | |
| download | mariadb-git-c7d162a23079cc7dd0d12352cd3ad071c5a9744f.tar.gz | |
bad merge fixed
mysql-test/r/insert_select.result:
duplicated test removed
mysql-test/t/insert_select.test:
duplicated test removed
Diffstat (limited to 'mysql-test/r/distinct.result')
| -rw-r--r-- | mysql-test/r/distinct.result | 8 |
1 files changed, 0 insertions, 8 deletions
diff --git a/mysql-test/r/distinct.result b/mysql-test/r/distinct.result index fa52b5c8330..00436019f85 100644 --- a/mysql-test/r/distinct.result +++ b/mysql-test/r/distinct.result @@ -464,14 +464,6 @@ 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; |