summaryrefslogtreecommitdiff
path: root/sql/item_timefunc.cc
Commit message (Collapse)AuthorAgeFilesLines
* cleanup: remove redundant ADDINTERVAL_PRECEDENCESergei Golubchik2020-10-231-2/+2
| | | | | expression between INTERVAL and the unit doesns not need any precedence rules, there's no ambiguity there
* Merge branch '10.1' into 10.2Oleksandr Byelkin2020-08-021-12/+12
|\
| * Code comment spellfixesIan Gilfillan2020-07-221-12/+12
| |
* | MDEV-18042 Server crashes upon adding a non-null date column under ↵Nikita Malyavin2020-07-311-4/+4
| | | | | | | | | | | | NO_ZERO_DATE with ALGORITHM=INPLACE accept table_name and db_name instead of table_share in make_truncated_value_warning
* | MDEV-21388 Wrong result of DAYNAME()=xxx in combination with ↵Alexander Barkov2019-12-241-8/+12
| | | | | | | | condition_pushdown_for_derived=on
* | Merge 10.1 into 10.2Marko Mäkelä2019-05-131-1/+1
|\ \ | |/
| * Merge branch '5.5' into 10.1Vicențiu Ciorbaru2019-05-111-1/+1
| |\
| | * Update FSF AddressVicențiu Ciorbaru2019-05-111-1/+1
| | | | | | | | | | | | * Update wrong zip-code
* | | Merge branch '10.1' into 10.2Sergei Golubchik2019-03-151-11/+7
|\ \ \ | |/ /
| * | MDEV-18626 ASAN stack-buffer-overflow in int10_to_str / make_date_time upon ↵Alexander Barkov2019-03-141-1/+1
| | | | | | | | | | | | DATE_FORMAT
| * | MDEV-14926 AddressSanitizer: heap-use-after-free in make_date_time on weird ↵Alexander Barkov2019-03-141-10/+6
| | | | | | | | | | | | combination of functions
* | | MDEV-14576 Include full name of object in message about incorrect value for ↵Alexey Botchkov2018-12-161-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | column. The error message modified. Then the TABLE_SHARE::error_table_name() implementation taken from 10.3, to be used as a name of the table in this message.
* | | Merge branch '10.1' into 10.2Sergei Golubchik2018-09-241-19/+10
|\ \ \ | |/ /
| * | Merge branch '10.0' into 10.1Sergei Golubchik2018-09-231-19/+10
| |\ \
| | * \ Merge remote-tracking branch 'origin/5.5' into 10.0Alexander Barkov2018-09-211-19/+10
| | |\ \ | | | |/
| | | * MDEV-17244 MAKETIME(900,0,0.111) returns a wrong resultAlexander Barkov2018-09-201-3/+4
| | | |
| | | * MDEV-17249 MAKETIME(-1e50,0,0) returns a wrong resultAlexander Barkov2018-09-201-16/+6
| | | |
* | | | MDEV-11071: Assertion `thd->transaction.stmt.is_empty()' failed in ↵Oleksandr Byelkin2018-06-151-20/+26
| | | | | | | | | | | | | | | | | | | | | | | | Locked_tables_list::unlock_locked_table fix_length_and_dec now return result (error/OK)
* | | | Merge remote-tracking branch 'origin/10.1' into 10.2Vicențiu Ciorbaru2018-03-161-4/+10
|\ \ \ \ | |/ / /
| * | | A 32bit cleanup for MDEV-14452 Precision in INTERVAL xxx DAY_MICROSECOND ↵Alexander Barkov2018-03-151-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | parsed wrong? "mtr func_date_add" failed on 32-bit platforms. Removing a wrong case to "long". Both values[] and log_10_int[] are arrays of "ulonglong", no cast is needed.
| * | | MDEV-14452 Precision in INTERVAL xxx DAY_MICROSECOND parsed wrong?Alexander Barkov2018-03-141-4/+10
| | | |
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-10-241-3/+12
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Sergei Golubchik2017-10-221-3/+12
| |\ \ \ | | |/ /
| | * | Merge branch '5.5' into 10.0Sergei Golubchik2017-10-181-3/+12
| | |\ \ | | | |/
| | | * MDEV-13972 crash in Item_func_sec_to_time::get_dateAlexander Barkov2017-10-101-3/+12
| | | |
* | | | MDEV-13384 - misc Windows warnings fixedVladislav Vaintroub2017-09-281-4/+4
| | | |
* | | | MDEV-13868 cannot insert 1288481126 in a timestamp column in Europe/MoscowSergei Golubchik2017-09-221-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | make insert NULL into a timestamp mark the field as having an explicit value. So that the field won't be assigned the value again in TABLE::update_default_field() make Item_func_now_local::save_in_field(timestamp_field) not to go through MYSQL_TIME - this conversion is lossy around DST change times. This fixes inserting a default value into a timestamp field.
* | | | bugfix: TIME_FORMAT() allowed some non-time format specifiersSergei Golubchik2017-09-181-2/+14
| | | | | | | | | | | | | | | | it contradicted the manual and was inconsistent
* | | | Merge 10.1 into 10.2Marko Mäkelä2017-09-171-1/+1
|\ \ \ \ | |/ / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This should also fix the MariaDB 10.2.2 bug MDEV-13826 CREATE FULLTEXT INDEX on encrypted table fails. MDEV-12634 FIXME: Modify innodb-index-online, innodb-table-online so that they will write and read merge sort files. InnoDB 5.7 introduced some optimizations to avoid using the files for small tables. Many collation test results have been adjusted for MDEV-10191.
| * | | MDEV-10191 non convertible chars convert() resulted in Null instead "?" on ↵Alexander Barkov2017-09-151-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Windows The problem was introduced by the patch for MDEV-7661, which (in addition to the fix itself) included an attempt to make CONVERT/CAST work in the same way with fields (i.e. return NULL in strict mode if a non-convertable character found). It appeared to be a bad idea and some users were affected by this behavior change. Changing CONVERT/CAST not depend on sql_mode (restoring pre-10.1.4 behavior).
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-07-081-1/+1
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Sergei Golubchik2017-07-071-1/+1
| |\ \ \ | | |/ /
| | * | Merge branch '5.5' into 10.0Sergei Golubchik2017-07-061-1/+1
| | |\ \ | | | |/
| | | * item_timefunc: identical operandsDaniel Black2017-07-031-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | CID 971836 (#1 of 1): Same on both sides (CONSTANT_EXPRESSION_RESULT) pointless_expression: The expression val != end && val != end does not accomplish anything because it evaluates to either of its identical operands, val != end.
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2017-02-101-2/+2
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Vicențiu Ciorbaru2017-01-161-2/+3
| |\ \ \ | | |/ /
| | * | Merge remote-tracking branch 'origin/5.5' into 10.0vicentiu2017-01-061-2/+3
| | |\ \ | | | |/
| | | * MDEV-10524 Assertion `arg1_int >= 0' failed in ↵Alexander Barkov2016-12-191-4/+25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Item_func_additive_op::result_precision() This change is a backport from 10.0 to 5.5 for: 1. The full patch for: MDEV-4841 Wrong character set of ADDTIME() and DATE_ADD() 9adb6e991ec87b65d04929f115d9d0c899e4ab19 2. A small fragment of: MDEV-5298 Illegal mix of collations on timestamp 03f6778d61a74bdd7d09103a16473a2a5624cf66 which overrides Item_temporal_hybrid_func::cmp_type(), and adds a new line into cache_temporal_4265.result.
* | | | Item::print(): remove redundant parenthesesSergei Golubchik2016-12-121-4/+2
| | | | | | | | | | | | | | | | | | | | by introducing new Item::precedence() method and using it to decide whether parentheses are required
* | | | store/show vcols as item->print()Sergei Golubchik2016-12-121-1/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | otherwise we'd need to store sql_mode *per vcol* (consider CREATE INDEX...) and how SHOW CREATE TABLE would support that? Additionally, get rid of vcol::expr_str, just to make sure the string is always generated and never leaked in the original form.
* | | | don't convert WEEK(x) to WEEK(x, @@default_week_format)Sergei Golubchik2016-12-121-4/+6
| | | |
* | | | MDEV-7769 MY_CHARSET_INFO refactoring# On branch 10.2Alexander Barkov2016-10-101-7/+3
| | | | | | | | | | | | | | | | Part 3 (final): removing MY_CHARSET_HANDLER::well_formed_len().
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-09-091-20/+20
|\ \ \ \ | |/ / /
| * | | MDEV-10317 EXCTACT(MINUTE_MICROSECOND) truncates dataAlexander Barkov2016-07-031-20/+20
| | | |
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-06-301-4/+2
|\ \ \ \ | |/ / /
| * | | Merge branch '10.0' into 10.1Sergei Golubchik2016-06-281-4/+2
| |\ \ \ | | |/ /
| | * | Merge branch '5.5' into bb-10.0Sergei Golubchik2016-06-211-4/+2
| | |\ \ | | | |/
| | | * MDEV-10052 Illegal mix of collations with DAYNAME(date_field)<>varchar_fieldAlexander Barkov2016-05-101-4/+2
| | | |
* | | | MDEV-7563 Support CHECK constraint as in (or close to) SQL StandardMichael Widenius2016-06-301-27/+36
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MDEV-10134 Add full support for DEFAULT - Added support for using tables with MySQL 5.7 virtual fields, including MySQL 5.7 syntax - Better error messages also for old cases - CREATE ... SELECT now also updates timestamp columns - Blob can now have default values - Added new system variable "check_constraint_checks", to turn of CHECK constraint checking if needed. - Removed some engine independent tests in suite vcol to only test myisam - Moved some tests from 'include' to 't'. Should some day be done for all tests. - FRM version increased to 11 if one uses virtual fields or constraints - Changed to use a bitmap to check if a field has got a value, instead of setting HAS_EXPLICIT_VALUE bit in field flags - Expressions can now be up to 65K in total - Ensure we are not refering to uninitialized fields when handling virtual fields or defaults - Changed check_vcol_func_processor() to return a bitmap of used types - Had to change some functions that calculated cached value in fix_fields to do this in val() or getdate() instead. - store_now_in_TIME() now takes a THD argument - fill_record() now updates default values - Add a lookahead for NOT NULL, to be able to handle DEFAULT 1+1 NOT NULL - Automatically generate a name for constraints that doesn't have a name - Added support for ALTER TABLE DROP CONSTRAINT - Ensure that partition functions register virtual fields used. This fixes some bugs when using virtual fields in a partitioning function
* | | | Merge branch '10.1' into 10.2Sergei Golubchik2016-02-251-2/+2
|\ \ \ \ | |/ / /
View Lorry Controller Status