From 6ad30c9b2d67c6ae83f33404f62d5ea621b297c3 Mon Sep 17 00:00:00 2001
From: "Sinisa@sinisa.nasamreza.org" <>
Date: Tue, 18 Jun 2002 17:38:06 +0300
Subject: Fixed some comments , plus introduced some tests so that I do not
 make some new mistakes.

---
 mysql-test/r/merge.result | 3 +++
 mysql-test/t/merge.test   | 1 +
 2 files changed, 4 insertions(+)

(limited to 'mysql-test')

diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result
index 1e657883253..f6ca2acc91c 100644
--- a/mysql-test/r/merge.result
+++ b/mysql-test/r/merge.result
@@ -470,4 +470,7 @@ CREATE TABLE t (  a int(11) NOT NULL default '0',  b int(11) NOT NULL default '0
 select max(b) from t where a = 2;
 max(b)
 NULL
+select max(b) from t1 where a = 2;
+max(b)
+1
 drop table if exists t,t1,t2;
diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test
index de26d7eb1d3..483ff316740 100644
--- a/mysql-test/t/merge.test
+++ b/mysql-test/t/merge.test
@@ -174,4 +174,5 @@ CREATE TABLE t2 (  a int(11) NOT NULL default '0',  b int(11) NOT NULL default '
 INSERT INTO t2 VALUES (1,2), (2,2);
 CREATE TABLE t (  a int(11) NOT NULL default '0',  b int(11) NOT NULL default '0',  KEY a (a,b)) TYPE=MRG_MyISAM UNION=(t1,t2);
 select max(b) from t where a = 2;
+select max(b) from t1 where a = 2;
 drop table if exists t,t1,t2;
-- 
cgit v1.2.1