diff options
| author | unknown <dlenev@mysql.com> | 2005-01-28 10:22:50 +0300 |
|---|---|---|
| committer | unknown <dlenev@mysql.com> | 2005-01-28 10:22:50 +0300 |
| commit | 8cac2c0562ec5460368be91602b329ddce653d0d (patch) | |
| tree | 654d19586759f3b5343d53fba8af67eb8e5ce42f /mysql-test/r/timezone2.result | |
| parent | a6bfe13c6f4fc2e0c2bebea8a295a445aa5765e8 (diff) | |
| parent | bf89dc063a6576cb08f2da29c8f505846965590b (diff) | |
| download | mariadb-git-8cac2c0562ec5460368be91602b329ddce653d0d.tar.gz | |
Manual merge of fixes for bugs #7899 "CREATE TABLE .. SELECT .. and
CONVERT_TZ() function does not work well together" and bug #7705
"CONVERT_TZ() crashes with subquery/WHERE on index column" in 5.0
tree.
mysql-test/r/timezone2.result:
Auto merged
mysql-test/t/timezone2.test:
Auto merged
sql/item_timefunc.cc:
Auto merged
sql/item_timefunc.h:
Auto merged
sql/set_var.h:
Auto merged
sql/set_var.cc:
Manual merge.
sql/sql_lex.cc:
Ignoring changes in st_lex::unlink_first_table()/link_first_table_back()
made in 4.1 since they are not applicable to 5.0.
sql/tztime.cc:
Manual merge.
Diffstat (limited to 'mysql-test/r/timezone2.result')
| -rw-r--r-- | mysql-test/r/timezone2.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/timezone2.result b/mysql-test/r/timezone2.result index 919f4ee5d3e..5ef06ae363b 100644 --- a/mysql-test/r/timezone2.result +++ b/mysql-test/r/timezone2.result @@ -305,3 +305,11 @@ delete from mysql.db where user like 'mysqltest\_%'; delete from mysql.tables_priv where user like 'mysqltest\_%'; flush privileges; drop table t1, t2; +select convert_tz('2005-01-14 17:00:00', 'UTC', custTimeZone) from (select 'UTC' as custTimeZone) as tmp; +convert_tz('2005-01-14 17:00:00', 'UTC', custTimeZone) +2005-01-14 17:00:00 +create table t1 select convert_tz(NULL, NULL, NULL); +select * from t1; +convert_tz(NULL, NULL, NULL) +NULL +drop table t1; |