summaryrefslogtreecommitdiff
path: root/sql/item_func.cc
Commit message (Collapse)AuthorAgeFilesLines
* cleanup: comments referring to non-extistent Item classesSergei Golubchik2014-12-041-2/+2
|
* MDEV-4018 : Feature Request: microseconds in GET_LOCK()Nirbhay Choubey2014-11-301-1/+1
| | | | | Updated MDL_context's lock methods to accept double precision lock_wait_timeout.
* MDEV-5231: Per query variables from Percona Server (rewritten)Oleksandr Byelkin2014-11-111-1/+1
|
* Merge 10.0.14 into 10.1Sergei Golubchik2014-10-151-55/+46
|\
| * MDEV-6616 Server crashes in my_hash_first if shutdown is performed when ↵Sergei Golubchik2014-09-061-2/+6
| | | | | | | | | | | | | | FLUSH LOGS is running master_info_index becomes zero during shutdown. check that it's valid (under a mutex) before dereferencing.
| * 5.5.39 mergeSergei Golubchik2014-08-071-53/+40
| |\
| | * 5.3 mergeSergei Golubchik2014-08-011-52/+39
| | |\
| | | * MDEV-4511 Assertion `scale <= precision' fails on GROUP BY TIMEDIFF with ↵Alexander Barkov2014-07-281-52/+39
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | incorrect types MDEV-6302 Wrong result set when using GROUP BY FROM_UNIXTIME(...)+0 Fixed.
| | * | Merge 5.3->5.5Alexander Barkov2014-07-231-1/+1
| | |\ \ | | | |/
| | | * MDEV-5750 Assertion `ltime->year == 0' fails on a query with EXTRACT ↵Alexander Barkov2014-07-231-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | DAY_MINUTE and TIME column Item_func_min_max::get_date() did not clear ltime->year when returning a TIME value.
* | | | cleanup: galera merge, simple changesSergei Golubchik2014-10-011-4/+5
| | | |
* | | | MDEV-6247: Merge 10.0-galera to 10.1.Jan Lindström2014-08-261-1/+13
|/ / / | | | | | | | | | | | | | | | | | | | | | | | | Merged lp:maria/maria-10.0-galera up to revision 3879. Added a new functions to handler API to forcefully abort_transaction, producing fake_trx_id, get_checkpoint and set_checkpoint for XA. These were added for future possiblity to add more storage engines that could use galera replication.
* | | 5.5.38 mergeSergei Golubchik2014-06-061-6/+10
|\ \ \ | |/ /
| * | Merge 5.3->5.5Alexander Barkov2014-06-041-1/+3
| |\ \ | | |/
| | * MDEV-4858 Wrong results for a huge unsigned value inserted into a TIME columnAlexander Barkov2014-06-041-1/+3
| | | | | | | | | | | | | | | | | | | | | MDEV-6099 Bad results for DATE_ADD(.., INTERVAL 2000000000000000000.0 SECOND) MDEV-6097 Inconsistent results for CAST(int,decimal,double AS DATETIME) MDEV-6100 No warning on CAST(9000000 AS TIME)
| | * 5.2 mergeSergei Golubchik2014-03-161-3/+10
| | |\
| | | * 5.1 mergeSergei Golubchik2014-03-161-3/+17
| | | |\
| | | | * mysql-5.1.73 mergeSergei Golubchik2014-03-151-3/+17
| | | | |\
| * | | | \ mysql-5.5.38 mergeSergei Golubchik2014-06-031-5/+7
| |\ \ \ \ \
| | * | | | | BUG#17994219: CREATE TABLE .. SELECT PRODUCES INVALID STRUCTURE,Nisha Gopalakrishnan2014-04-281-4/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | BREAKS RBR Analysis: -------- A table created using a query of the format: CREATE TABLE t1 AS SELECT REPEAT('A',1000) DIV 1 AS a; breaks the Row Based Replication. The query above creates a table having a field of datatype 'bigint' with a display width of 3000 which is beyond the maximum acceptable value of 255. In the RBR mode, CREATE TABLE SELECT statement is replicated as a combination of CREATE TABLE statement equivalent to one the returned by SHOW CREATE TABLE and row events for rows inserted. When this CREATE TABLE event is executed on the slave, an error is reported: Display width out of range for column 'a' (max = 255) The following is the output of 'SHOW CREATE TABLE t1': CREATE TABLE t1(`a` bigint(3000) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1; The problem is due to the combination of two facts: 1) The above CREATE TABLE SELECT statement uses the display width of the result of DIV operation as the display width of the column created without validating the width for out of bound condition. 2) The DIV operation incorrectly returns the length of its first argument as the display width of its result; thus allowing creation of a table with an incorrect display width of 3000 for the field. Fix: ---- This fix changes the DIV operation implementation to correctly evaluate the display width of its result. We check if DIV's results estimated width crosses maximum width for integer value (21) and if yes set it to this maximum value. This patch also fixes fixes maximum display width evaluation for DIV function when its first argument is in UCS2.
* | | | | | | Moving implementation of INET_ATON() INET_NTOA() intoAlexander Barkov2014-05-301-55/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | separate files item_inetfunc.h and item_inetfunc.cc.
* | | | | | | fix a bad merge, causing a crash of fulltext.test in --ps-protocolmariadb-10.0.11Sergei Golubchik2014-05-101-2/+1
| | | | | | |
* | | | | | | 5.5 mergeSergei Golubchik2014-05-091-4/+24
|\ \ \ \ \ \ \ | |/ / / / / /
| * | | | | | An after-fix for MDEV-6146 Can't mix (latin1_swedish_ci,NUMERIC) and ↵Alexander Barkov2014-04-291-2/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (utf8_unicode_ci,IMPLICIT) for MATCH The original patch broke "mtr --ps fulltext".
| * | | | | | MDEV-6146 Can't mix (latin1_swedish_ci,NUMERIC) and ↵Alexander Barkov2014-04-231-2/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | (utf8_unicode_ci,IMPLICIT) for MATCH
* | | | | | | MDEV-5849 MySQL bug#12602983 - User without privilege on routine can ↵Sergei Golubchik2014-03-201-9/+23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | discover its existence by executing "select non_existing_func();" or by "call non_existing_proc()" add or move privilege checks before existence checks
* | | | | | | MDEV-5781 Item_sum_std::val_real(): Assertion `nr >= 0.0' fails on query ↵Alexander Barkov2014-03-231-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | with STDDEV_POP, ROUND and variable
* | | | | | | MDEV-5314 - Compiling fails on OSX using clangSergey Vojtovich2014-02-191-3/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This is port of fix for MySQL BUG#17647863. revno: 5572 revision-id: jon.hauglid@oracle.com-20131030232243-b0pw98oy72uka2sj committer: Jon Olav Hauglid <jon.hauglid@oracle.com> timestamp: Thu 2013-10-31 00:22:43 +0100 message: Bug#17647863: MYSQL DOES NOT COMPILE ON OSX 10.9 GM Rename test() macro to MY_TEST() to avoid conflict with libc++.
* | | | | | | Merge MariaDB 10.0-base to 10.0.unknown2014-02-101-0/+28
|\ \ \ \ \ \ \
| * \ \ \ \ \ \ Merge of MDEV-4984, MDEV-4726, and MDEV-5636 into 10.0-base.unknown2014-02-101-0/+28
| |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MDEV-4984: Implement MASTER_GTID_WAIT() and @@LAST_GTID. MDEV-4726: Race in mysql-test/suite/rpl/t/rpl_gtid_stop_start.test MDEV-5636: Deadlock in RESET MASTER
| | * | | | | | | MDEV-4984: Implement MASTER_GTID_WAIT() and @@LAST_GTID.unknown2014-02-071-0/+28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MASTER_GTID_WAIT() is similar to MASTER_POS_WAIT(), but works with a GTID position rather than an old-style filename/offset. @@LAST_GTID gives the GTID assigned to the last transaction written into the binlog. Together, the two can be used by applications to obtain the GTID of an update on the master, and then do a MASTER_GTID_WAIT() for that position on any read slave where it is important to get results that are caught up with the master at least to the point of the update. The implementation of MASTER_GTID_WAIT() is implemented in a way that tries to minimise the performance impact on the SQL threads, even in the presense of many waiters on single GTID positions (as from @@LAST_GTID).
* | | | | | | | | 10.0-base mergeSergei Golubchik2014-02-031-5/+7
|\ \ \ \ \ \ \ \ \ | |/ / / / / / / /
| * | | | | | | | 5.5 mergeSergei Golubchik2014-02-011-5/+7
| |\ \ \ \ \ \ \ \ | | |/ / / / / / / | |/| / / / / / / | | |/ / / / / /
| | * | | | | | Merge 5.3 -> 5.5Alexander Barkov2014-01-271-5/+7
| | |\ \ \ \ \ \ | | | | |/ / / / | | | |/| | | |
| | | * | | | | MDEV-5458 RQG hits 'sql/tztime.cc:799: my_time_t sec_since_epoch(...):Alexander Barkov2014-01-271-5/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Assertion `mon > 0 && mon < 13' failed.'
* | | | | | | | MDEV-5574 Set AUTO_INCREMENT below max value of column.Sergei Golubchik2014-02-011-2/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Update InnoDB to 5.6.14 Apply MySQL-5.6 hack for MySQL Bug#16434374 Move Aria-only HA_RTREE_INDEX from my_base.h to maria_def.h (breaks an assert in InnoDB) Fix InnoDB memory leak
* | | | | | | | 10.0-base mergeSergei Golubchik2013-12-161-0/+2
|\ \ \ \ \ \ \ \ | |/ / / / / / /
| * | | | | | | 5.5 mergeSergei Golubchik2013-11-231-0/+2
| |\ \ \ \ \ \ \ | | |/ / / / / /
| | * | | | | | Merge 5.3->5.5Alexander Barkov2013-11-211-0/+2
| | |\ \ \ \ \ \ | | | |/ / / / /
| | | * | | | | MDEV-4859 Wrong value and data type of "SELECT MAX(time_column) + 1 FROM t1"Alexander Barkov2013-11-211-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed.
* | | | | | | | MDEV-4243 [PATCH] Warnings/errors while compiling with clangSergei Golubchik2013-11-281-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | fix the code to compile with clang. fix warnings too. include/probes_mysql_nodtrace.h: clang++ doesn't like numeric _constants_ being used in || (it suspects that the intention was | ). Boolean constants are ok. sql/hostname.cc: only used in DBUG_ASSERT sql/item.cc: str_to_time and str_to_datetime return bool, not MYSQL_TIMESTAMP_xxx sql/item_func.cc: str_to_datetime_with_warn() returns bool, not MYSQL_TIMESTAMP_xxx storage/cassandra/CMakeLists.txt: CMAKE_CXX_FLAGS can be empty storage/connect/odbconn.cpp: HWND is void* storage/connect/user_connect.h: deprecated on FreeBSD and unused anyway storage/connect/value.cpp: bad characters inside. unused. storage/spider/spd_trx.cc: clang++ warns that memset will also overwrite vtbl. it might be as well a good idea, as it asserts that the object will only be used as a storage. silence the warning.
* | | | | | | | Merge 10.0-base -> 10.0Alexander Barkov2013-10-151-0/+10
|\ \ \ \ \ \ \ \ | |/ / / / / / /
| * | | | | | | Merge 5.5->10.0-baseIgor Babaev2013-10-131-0/+10
| |\ \ \ \ \ \ \ | | |/ / / / / /
| | * | | | | | Merge 5.3-5.5Igor Babaev2013-10-131-0/+10
| | |\ \ \ \ \ \ | | | |/ / / / /
| | | * | | | | Fixed bug mdev-5105.Igor Babaev2013-10-101-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The bug caused a memory overwrite in the function update_ref_and_keys() It happened due to a wrong value of SELECT_LEX::cond_count. This value historically was calculated by the fix_fields method. Now the logic of calling this method became too complicated and, as a result, this value is calculated not always correctly. The patch changes the way how and when the values of SELECT_LEX::cond_count and of SELECT_LEX::between_count are calculated. The new code does it just at the beginning of update_ref_and_keys().
* | | | | | | | merge 10.0-base -> 10.0unknown2013-09-261-14/+11
|\ \ \ \ \ \ \ \ | |/ / / / / / /
| * | | | | | | merge 5.5 -> 10.0-baseunknown2013-09-251-14/+11
| |\ \ \ \ \ \ \ | | |/ / / / / /
| | * | | | | | merge 5.3 -> 5.5unknown2013-09-251-14/+11
| | |\ \ \ \ \ \ | | | |/ / / / /
| | | * | | | | MDEV-5039: incorrect Item_func_regex::update_used_tables()unknown2013-09-251-14/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Other fix of maybe_null problem and revert of revno: 3608 "MDEV-3873 & MDEV-3876 & MDEV-3912 : Wrong result (extra rows) with ALL subquery from a MERGE view."
* | | | | | | | 10.0-base merge.Sergei Golubchik2013-09-211-45/+209
|\ \ \ \ \ \ \ \ | |/ / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | Partitioning/InnoDB changes are *not* merged (they'll come from 5.6) TokuDB does not compile (not updated to 10.0 SE API)