diff options
| author | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-04-29 18:46:06 +0500 |
|---|---|---|
| committer | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-04-29 18:46:06 +0500 |
| commit | 95f51da26013aa962e5e8648e5bcad8bebc06b4e (patch) | |
| tree | 305dac52043ee4eb275a83ea81b31c318a9e874c /mysql-test/r/join.result | |
| parent | 2031f55751dad44950252ab711cde893b3bce674 (diff) | |
| download | mariadb-git-95f51da26013aa962e5e8648e5bcad8bebc06b4e.tar.gz | |
merging fix
Diffstat (limited to 'mysql-test/r/join.result')
| -rw-r--r-- | mysql-test/r/join.result | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index 840a92dcce2..b132c8b2e4c 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -847,19 +847,4 @@ select '^^: The above should be ~= 20 + cost(select * from t1). Value less than Z ^^: The above should be ~= 20 + cost(select * from t1). Value less than 20 is an error drop table t1, t2; -CREATE TABLE t1 (ID INTEGER, Name VARCHAR(50)); -CREATE TABLE t2 (Test_ID INTEGER); -CREATE VIEW v1 (Test_ID, Description) AS SELECT ID, Name FROM t1; -CREATE TABLE tv1 SELECT Description AS Name FROM v1 JOIN t2 -USING (Test_ID); -DESCRIBE tv1; -Field Type Null Key Default Extra -Name varchar(50) YES NULL -CREATE TABLE tv2 SELECT Description AS Name FROM v1 JOIN t2 -ON v1.Test_ID = t2.Test_ID; -DESCRIBE tv2; -Field Type Null Key Default Extra -Name varchar(50) YES NULL -DROP VIEW v1; -DROP TABLE t1,t2,tv1,tv2; End of 5.0 tests. |