diff options
| author | unknown <evgen@moonbone.local> | 2005-07-13 04:39:22 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-07-13 04:39:22 +0400 |
| commit | c3d276165d305e3bfd96d5ceb1607c4b74184adf (patch) | |
| tree | 1c2bd815d1b0559bfaf9fa11b9726dc81d17848b /mysql-test/r/view.result | |
| parent | 08240bbef3264d16d6084794c1d632a92f1a4e2c (diff) | |
| parent | 8c182f9734e335dc20f596e0305df599b13d533d (diff) | |
| download | mariadb-git-c3d276165d305e3bfd96d5ceb1607c4b74184adf.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0
into moonbone.local:/work/mysql-5.0-bug-11709
mysql-test/r/view.result:
Auto merged
mysql-test/t/view.test:
Auto merged
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 6d75d934cd9..7469cf45e1e 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -1953,6 +1953,16 @@ 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 view v1; +drop table t1; CREATE TABLE t1 (f1 char) ENGINE = innodb; INSERT INTO t1 VALUES ('A'); CREATE VIEW v1 AS SELECT * FROM t1; |