diff options
| author | monty@donna.mysql.fi <> | 2001-04-21 17:12:59 +0300 |
|---|---|---|
| committer | monty@donna.mysql.fi <> | 2001-04-21 17:12:59 +0300 |
| commit | 1e3df575b93b40145ff854e30af3f443d74537b6 (patch) | |
| tree | 92c2e4e17ada35f43a9188e384c11136d46b1e7d /mysql-test/t | |
| parent | 0f37b1244b8356f32ef58245d94a3a920e047428 (diff) | |
| download | mariadb-git-1e3df575b93b40145ff854e30af3f443d74537b6.tar.gz | |
Fixed probelm with count(*) and normal functions when no matchin rows.
Changed 'lib' to 'master-data'
Fix for slow slaves
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/group_by.test | 12 | ||||
| -rwxr-xr-x | mysql-test/t/rpl000018-master.sh | 6 |
2 files changed, 15 insertions, 3 deletions
diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index edd3c1fff7e..e75841dc6d0 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -2,6 +2,7 @@ # Test of group (Failed for Lars Hoss <lh@pbm.de>) # +drop table if exists t1,t2; CREATE TABLE t1 ( spID int(10) unsigned, userID int(10) unsigned, @@ -208,3 +209,14 @@ select value,description,bug_id from t2 left join t1 on t2.program=t1.product an select value,description,COUNT(bug_id) from t2 left join t1 on t2.program=t1.product and t2.value=t1.component where program="AAAAA" group by value; drop table t1,t2; + +# +# Problem with functions and group functions when no matching rows +# + +create table t1 (foo int); +insert into t1 values (1); +select 1+1, "a",count(*) from t1 where foo in (2); +insert into t1 values (1); +select 1+1,"a",count(*) from t1 where foo in (2); +drop table t1; diff --git a/mysql-test/t/rpl000018-master.sh b/mysql-test/t/rpl000018-master.sh index 71f0f12d0c5..e570f106ec6 100755 --- a/mysql-test/t/rpl000018-master.sh +++ b/mysql-test/t/rpl000018-master.sh @@ -1,3 +1,3 @@ -rm -f $MYSQL_TEST_DIR/var/lib/master-bin.* -cp $MYSQL_TEST_DIR/std_data/master-bin.001 $MYSQL_TEST_DIR/var/lib/ -echo ./master-bin.001 > $MYSQL_TEST_DIR/var/lib/master-bin.index +rm -f $MYSQL_TEST_DIR/var/master-data/master-bin.* +cp $MYSQL_TEST_DIR/std_data/master-bin.001 $MYSQL_TEST_DIR/var/master-data/ +echo ./master-bin.001 > $MYSQL_TEST_DIR/var/master-data/master-bin.index |