summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
diff options
context:
space:
mode:
authorunknown <gluh@mysql.com/eagle.(none)>2007-10-10 14:22:21 +0500
committerunknown <gluh@mysql.com/eagle.(none)>2007-10-10 14:22:21 +0500
commita90f04230efb9f1448660e0f13bc28cdee6f5123 (patch)
tree2fba2635ffe4db5be311f1eb909017f78a3f9272 /mysql-test/r/view.result
parented3604e8cfea2b023fbcbdb9ba0de52a44b209a6 (diff)
downloadmariadb-git-a90f04230efb9f1448660e0f13bc28cdee6f5123.tar.gz
after merge fix
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r--mysql-test/r/view.result12
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');