diff options
| author | evgen@moonbone.local <> | 2005-07-12 23:24:35 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2005-07-12 23:24:35 +0400 |
| commit | bb1f81607cdacf87cb3b87d6da04b5b01a8e5b50 (patch) | |
| tree | 6b6c4daa9cac4f3d04e44c27cda81755e8aa6fee /mysql-test/r/view.result | |
| parent | e06e06ffeb8dbcd2737720be9f78c5fe75b9c0f5 (diff) | |
| parent | de016ca78a732e65f55e040f12b5461ca2c1d27d (diff) | |
| download | mariadb-git-bb1f81607cdacf87cb3b87d6da04b5b01a8e5b50.tar.gz | |
Merge
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 3fd85cc883b..f9843d40f07 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -1948,6 +1948,15 @@ s1 s2 DROP PROCEDURE p1; DROP VIEW v1; DROP TABLE t1; +create table t1 (f1 int, f2 int); +create view v1 as select f1 as f3, f2 as f1 from t1; +insert into t1 values (1,3),(2,1),(3,2); +select * from v1 order by f1; +f3 f1 +2 1 +3 2 +1 3 +drop table t1; CREATE TABLE t1 (f1 char) ENGINE = innodb; INSERT INTO t1 VALUES ('A'); CREATE VIEW v1 AS SELECT * FROM t1; |