diff options
| author | unknown <monty@mysql.com> | 2005-05-20 16:31:46 +0300 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2005-05-20 16:31:46 +0300 |
| commit | aaf5e0485cddf9c60cd79ff8318831e1c4cc85c3 (patch) | |
| tree | a164a19018cd8123a5bc94250957c3f01fc4acf2 /mysql-test/t/subselect.test | |
| parent | ccafae43da4d73b4cadc6f0a335cb4d2d797b4ae (diff) | |
| download | mariadb-git-aaf5e0485cddf9c60cd79ff8318831e1c4cc85c3.tar.gz | |
Add missing test result
mysql-test/t/subselect.test:
Add test of result
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 1b9e87f053a..2e6cea8468b 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -1828,11 +1828,12 @@ drop tables t1,t2; # CREATE TABLE t1 (EMPNUM CHAR(3)); CREATE TABLE t2 (EMPNUM CHAR(3) ); -INSERT INTO t1 VALUES ('E1'); +INSERT INTO t1 VALUES ('E1'),('E2'); INSERT INTO t2 VALUES ('E1'); DELETE FROM t1 WHERE t1.EMPNUM NOT IN (SELECT t2.EMPNUM FROM t2 WHERE t1.EMPNUM = t2.EMPNUM); +select * from t1; DROP TABLE t1,t2; |