diff options
author | unknown <monty@mysql.com> | 2005-07-04 16:01:04 +0300 |
---|---|---|
committer | unknown <monty@mysql.com> | 2005-07-04 16:01:04 +0300 |
commit | 5d82b41e3adccc566b68542bf5be097ed45f5390 (patch) | |
tree | 5d98db8559f519e7aac489fe047ee7fb3f2b8d3b /mysql-test/r | |
parent | 3c82f72091d2c21519540ee5bcc3b2acadfbf198 (diff) | |
download | mariadb-git-5d82b41e3adccc566b68542bf5be097ed45f5390.tar.gz |
After merge fixes
mysql-test/r/group_by.result:
After merge fix
(Put test in same order as in 4.1)
mysql-test/t/group_by.test:
After merge fix
(Put test in same order as in 4.1)
sql/item_cmpfunc.cc:
After merge fix (+ simple fix to not allow compiler to do tail optimization)
sql/item_cmpfunc.h:
After merge fix
Diffstat (limited to 'mysql-test/r')
-rw-r--r-- | mysql-test/r/group_by.result | 56 |
1 files changed, 28 insertions, 28 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index 34a9cc4221f..64446e63e6f 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -723,6 +723,34 @@ WHERE hostname LIKE '%aol%' hostname no cache-dtc-af05.proxy.aol.com 1 DROP TABLE t1; +CREATE TABLE t1 (a int, b int); +INSERT INTO t1 VALUES (1,2), (1,3); +SELECT a, b FROM t1 GROUP BY 'const'; +a b +1 2 +SELECT DISTINCT a, b FROM t1 GROUP BY 'const'; +a b +1 2 +DROP TABLE t1; +CREATE TABLE t1 (id INT, dt DATETIME); +INSERT INTO t1 VALUES ( 1, '2005-05-01 12:30:00' ); +INSERT INTO t1 VALUES ( 1, '2005-05-01 12:30:00' ); +INSERT INTO t1 VALUES ( 1, '2005-05-01 12:30:00' ); +INSERT INTO t1 VALUES ( 1, '2005-05-01 12:30:00' ); +SELECT dt DIV 1 AS f, id FROM t1 GROUP BY f; +f id +20050501123000 1 +DROP TABLE t1; +CREATE TABLE t1 (id varchar(20) NOT NULL); +INSERT INTO t1 VALUES ('trans1'), ('trans2'); +CREATE TABLE t2 (id varchar(20) NOT NULL, err_comment blob NOT NULL); +INSERT INTO t2 VALUES ('trans1', 'a problem'); +SELECT COUNT(DISTINCT(t1.id)), LEFT(err_comment, 256) AS comment +FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY comment; +COUNT(DISTINCT(t1.id)) comment +1 NULL +1 a problem +DROP TABLE t1, t2; CREATE TABLE t1 (n int); INSERT INTO t1 VALUES (1); SELECT n+1 AS n FROM t1 GROUP BY n; @@ -752,31 +780,3 @@ aaa show warnings; Level Code Message drop table t1, t2; -CREATE TABLE t1 (a int, b int); -INSERT INTO t1 VALUES (1,2), (1,3); -SELECT a, b FROM t1 GROUP BY 'const'; -a b -1 2 -SELECT DISTINCT a, b FROM t1 GROUP BY 'const'; -a b -1 2 -DROP TABLE t1; -CREATE TABLE t1 (id INT, dt DATETIME); -INSERT INTO t1 VALUES ( 1, '2005-05-01 12:30:00' ); -INSERT INTO t1 VALUES ( 1, '2005-05-01 12:30:00' ); -INSERT INTO t1 VALUES ( 1, '2005-05-01 12:30:00' ); -INSERT INTO t1 VALUES ( 1, '2005-05-01 12:30:00' ); -SELECT dt DIV 1 AS f, id FROM t1 GROUP BY f; -f id -20050501123000 1 -DROP TABLE t1; -CREATE TABLE t1 (id varchar(20) NOT NULL); -INSERT INTO t1 VALUES ('trans1'), ('trans2'); -CREATE TABLE t2 (id varchar(20) NOT NULL, err_comment blob NOT NULL); -INSERT INTO t2 VALUES ('trans1', 'a problem'); -SELECT COUNT(DISTINCT(t1.id)), LEFT(err_comment, 256) AS comment -FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY comment; -COUNT(DISTINCT(t1.id)) comment -1 NULL -1 a problem -DROP TABLE t1, t2; |