summaryrefslogtreecommitdiff
path: root/mysql-test/t/timezone2.test
Commit message (Collapse)AuthorAgeFilesLines
* Added end marker for tests to make future merges easiermonty@mysql.com2005-07-281-0/+2
|
* Eliminate most of the remaining hardcoded list of tests to skipjimw@mysql.com2005-03-291-68/+0
| | | | | by adding check for embedded server within tests and splitting some tests into multiple test files.
* Fix for bug #7899 "CREATE TABLE .. SELECT .. and CONVERT_TZ() functiondlenev@brandersnatch.localdomain2005-01-261-0/+17
| | | | | | | | | | | | | | | does not work well together". Now using simplier and more correct implementation of st_lex::unlink_first_table()/link_first_table_back() (It also nicely handles case when global table list is created because of implictly used time zone tables). (2nd attempt) Fix for bug #7705 "CONVERT_TZ() crashes with subquery/WHERE on index column". Implemented new approach for caching objects for constant time zone arguments. Now instead of determining whenever these arguments are constants and performing time zone lookup at fix_fields() stage, we do it on first get_date() invocation. Cleanup of global @@time_zone variable handling.
* Fix for bug #6765 "Implicit access to time zone description dlenev@brandersnatch.localdomain2004-12-091-2/+41
| | | | | | | | | | tables requires privileges for them if some table or column level grants present" (with after-review fixes). We should set SELECT_ACL for implicitly opened tables in my_tz_check_n_skip_implicit_tables() to be able to bypass privilege checking in check_grant(). Also we should exclude those tables from privilege checking in multi-update.
* Fix for bug #6116 "SET time_zone := ... requires access todlenev@brandersnatch.localdomain2004-10-211-0/+28
| | | | | | | mysql.time_zone* tables". We are excluding implicitly used time zone tables from privilege checking.
* Fix for bug #4508 "CONVERT_TZ() function with new time zone as param crashes ↵dlenev@brandersnatch.localdomain2004-08-101-0/+12
| | | | | | | | | server". Instead of trying to open time zone tables during calculation of CONVERT_TZ() function or setting of @@time_zone variable we should open and lock them with the rest of statement's table (so we should add them to global table list) and after that use such pre-opened tables for loading info about time zones.
* WL#1264 "Per-thread time zone support infrastructure".dlenev@brandersnatch.localdomain2004-06-181-0/+189
Added basic per-thread time zone functionality (based on public domain elsie-code). Now user can select current time zone (from the list of time zones described in system tables). All NOW-like functions honor this time zone, values of TIMESTAMP type are interpreted as values in this time zone, so now our TIMESTAMP type behaves similar to Oracle's TIMESTAMP WITH LOCAL TIME ZONE (or proper PostgresSQL type). WL#1266 "CONVERT_TZ() - basic time with time zone conversion function". Fixed problems described in Bug #2336 (Different number of warnings when inserting bad datetime as string or as number). This required reworking of datetime realted warning hadling (they now generated at Field object level not in conversion functions). Optimization: Now Field class descendants use table->in_use member instead of current_thd macro.