diff options
author | unknown <gluh@mysql.com/eagle.(none)> | 2007-10-10 14:22:21 +0500 |
---|---|---|
committer | unknown <gluh@mysql.com/eagle.(none)> | 2007-10-10 14:22:21 +0500 |
commit | a90f04230efb9f1448660e0f13bc28cdee6f5123 (patch) | |
tree | 2fba2635ffe4db5be311f1eb909017f78a3f9272 /mysql-test/r/view.result | |
parent | ed3604e8cfea2b023fbcbdb9ba0de52a44b209a6 (diff) | |
download | mariadb-git-a90f04230efb9f1448660e0f13bc28cdee6f5123.tar.gz |
after merge fix
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r-- | mysql-test/r/view.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 7ec3e136c14..60c3ff68e67 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2711,16 +2711,16 @@ CREATE VIEW v1 AS SELECT (year(test_date)-year(DOB)) AS Age FROM t1 HAVING Age < 75; SHOW CREATE VIEW v1; -v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select (year(`t1`.`test_date`) - year(`t1`.`DOB`)) AS `Age` from `t1` having (`Age` < 75) +View Create View character_set_client collation_connection +v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select (year(`t1`.`test_date`) - year(`t1`.`DOB`)) AS `Age` from `t1` having (`Age` < 75) latin1 latin1_swedish_ci SELECT (year(test_date)-year(DOB)) AS Age FROM t1 HAVING Age < 75; Age -42 -38 -set timestamp=1136066400; +43 +39 SELECT * FROM v1; Age -42 -38 +43 +39 DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a char(6) DEFAULT 'xxx'); |