summaryrefslogtreecommitdiff
path: root/sql/item_create.cc
Commit message (Collapse)AuthorAgeFilesLines
* Fix for bug #30200: mysqlbinlog.test: connection_id() not restored under ↵ramil/ram@mysql.com/ramil.myoffice.izhnet.ru2007-08-021-1/+0
| | | | | | | | | | ps-protocol Problem: thd->thread_specific_used flag is not set executing a statement containig connection_id() function using PS protocol, that leads to improper binlog event creation. Fix: set the flag in the Item_func_connection_id::fix_fields().
* Fix for bug #29928: INSERT ... VALUES(connection_id(), ...) incorrect ramil/ram@mysql.com/ramil.myoffice.izhnet.ru2007-08-011-1/+3
| | | | | | | | | | restores from mysqlbinlog out Problem: using "mysqlbinlog | mysql" for recoveries the connection_id() result may differ from what was used when issuing the statement. Fix: if there is a connection_id() in a statement, write to binlog SET pseudo_thread_id= XXX; before it and use the value later on.
* Fixed bug #29415.igor@olga.mysql.com2007-07-071-0/+12
| | | | | | | | The cast operation ignored the cases when the precision and/or the scale exceeded the limits, 65 and 30 respectively. No errors were reported in these cases. For some queries this may lead to an assertion abort. Fixed by throwing errors for such cases.
* Bug #28897 UUID() returns non-unique values when query cache is enableddkatz@damien-katzs-computer.local2007-06-131-0/+1
| | | | Removed the ability to cache queries containing "UUID()".
* Bug #27921 View ignores precision for CAST()holyfoot/hf@mysql.com/hfmain.(none)2007-05-101-5/+11
| | | | Item_decimal_typecast::print properly implemented
* Many files:kent@mysql.com/kent-amd64.(none)2006-12-231-2/+1
| | | | Changed header to GPL version 2 only
* Bug#16172 DECIMAL data type processed incorrectlygluh@mysql.com/gluh.(none)2006-08-081-1/+8
| | | | issue an error in case of DECIMAL(M,N) if N > M
* Bug#20570: CURRENT_USER() in a VIEW with SQL SECURITY DEFINER returnskroki@mysql.com2006-07-021-6/+0
| | | | | | | | | invoker name The bug was fixed similar to how context switch is handled in Item_func_sp::execute_impl(): we store pointer to current Name_resolution_context in Item_func_current_user class, and use its Security_context in Item_func_current_user::fix_fields().
* Bug#16461: connection_id() does not work properly inside triggerkroki@mysql.com2006-04-121-8/+2
| | | | | | | | | | | | CONNECTION_ID() was implemented as a constant Item, i.e. an instance of Item_static_int_func class holding value computed at creation time. Since Items are created on parsing, and trigger statements are parsed on table open, the first connection to open a particular table would effectively set its own CONNECTION_ID() inside trigger statements for that table. Re-implement CONNECTION_ID() as a class derived from Item_int_func, and compute connection_id on every call to fix_fields().
* Fixed BUG#12963, BUG#13000: wrong VIEW creation with DAYNAME(),aivanov@mysql.com2005-09-141-3/+3
| | | | DAYOFWEEK(), and WEEKDAY().
* Fix for BUG#12335 (SP replication) : New binlogging strategy for stored ↵sergefp@mysql.com2005-08-251-0/+5
| | | | | | | PROCEDUREs/FUNCTIONs. "Interleaved SPs execution is now binlogged properly, "SELECT spfunc()" is binlogged too. The known remaining issue is binlogging/replication of "a routine is deleted while it is executed" scenario.
* Fix cases where SLEEP() calls would get optimized away or cached. (Bug #12689)jimw@mysql.com2005-08-191-0/+1
|
* Add SLEEP(seconds) function, which always returns 0 after the givenjimw@mysql.com2005-08-111-0/+5
| | | | number of seconds (which can include microseconds). (Bug #6760)
* stop evaluation constant functions in WHERE (BUG#4663)bell@sanja.is.com.ua2005-07-161-10/+2
| | | | correct value of CURRENT_USER() in SP with "security definer" (BUG#7291)
* Merge mdk10.(none):/home/reggie/bk/mysql-4.1reggie@mdk10.(none)2005-04-111-0/+1
|\ | | | | | | into mdk10.(none):/home/reggie/bk/mysql-5.0
| * Merging fix for bug #9796 "Query Cache caches queries with CURRENT_USER()dlenev@brandersnatch.localdomain2005-04-111-1/+1
| | | | | | | | function" into 4.1 tree.
| * Merge mysql.com:/home/dlenev/src/mysql-4.0-bg9796dlenev@mysql.com2005-04-111-0/+1
| |\ | | | | | | | | | into mysql.com:/home/dlenev/src/mysql-4.1-merges
| | * Fix for bug #9796 "Query Cache caches queries with CURRENT_USER()dlenev@mysql.com2005-04-111-0/+1
| | | | | | | | | | | | | | | | | | | | | function". We should not cache queries using CURRENT_USER() function as we do it for some other functions, e.g. USER() function.
* | | Mergebar@mysql.com2005-03-051-1/+1
|\ \ \ | |/ /
| * | type_blob.result, func_system.result, func_str.result, ctype_collate.result:bar@mysql.com2005-03-041-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | fixing test results accordingly. func_system.test: New test that illegal mix of collations does not happen anymore. item_strfunc.h: safe_charset_converter() was added for system constants. item_strfunc.cc: safe_charset_converter() was added for system constants. item_func.cc, item.h, item.cc: Bug#8291: Illegal collation mix with USER() function. After discussion with PeterG and Serge, a new coercibility level for "system constants" was introduced, between COERRIBLE and IMPLICIT. Thus: SELECT col1 = USER() FROM t1; - is done according to col1 collation. SELECT 'string' = USER(); - is done according to USER() collation. At the same time, "nagg" and "strong" members were removed as unused. item_create.cc: Version is a system constant too.
* | | Precision Math implementationhf@deer.(none)2005-02-091-2/+5
| | |
* | | Merge serg.mylan:/usr/home/serg/Abk/mysql-4.1serg@serg.mylan2005-01-261-2/+3
|\ \ \ | |/ / | | | | | | into serg.mylan:/usr/home/serg/Abk/mysql-5.0
| * | innobase/include/univ.iserg@serg.mylan2005-01-261-2/+3
| | | | | | | | | | | | remove a change that broke the test
* | | mergedserg@serg.mylan2005-01-241-8/+5
|\ \ \ | |/ /
| * | fixes/cleanups according to Coverity reportserg@serg.mylan2005-01-241-8/+5
| | |
* | | Merge with 4.1 to get in latest bug fixesmonty@mysql.com2004-11-041-1/+4
|\ \ \ | |/ /
| * | A fix according to Monty's request:bar@mysql.com2004-10-291-1/+4
| | | | | | | | | | | | | | | "uint *errors" is now a non-optional parameter in String:copy() and copy_and_convert().
* | | Merge with 4.1monty@mysql.com2004-09-061-5/+0
|\ \ \ | |/ / | | | | | | | | | (Includes merge of arena code in 4.1 and 5.0)
| * | Fix for bug #4508 "CONVERT_TZ() function with new time zone as param crashes ↵dlenev@brandersnatch.localdomain2004-08-101-5/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | 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.
* | | items for functions which is converted to constants internally to support ↵bell@sanja.is.com.ua2004-08-241-10/+12
| | | | | | | | | | | | its correct printing added (BUG#4663)
* | | Merge with 4.1.3-betamonty@mysql.com2004-07-071-2/+7
|\ \ \ | |/ /
| * | Fixed BUG#3486: FOUND_ROWS() fails inside stored procedure [and prepared ↵pem@mysql.comhem.se2004-06-221-1/+1
| | | | | | | | | | | | statement].
| * | WL#1264 "Per-thread time zone support infrastructure".dlenev@brandersnatch.localdomain2004-06-181-0/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.
| * | Allocate memory when a character set is requested:bar@mysql.com2004-06-111-1/+1
| | | | | | | | | | | | | | | | | | - For simple character sets: from_uni convertion table. - For UCA: alternative weight arrays. Use mbminlen instead of MY_CS_NONTEXT
* | | Merge 4.1 -> 5.0.pem@mysql.com2004-04-071-3/+14
|\ \ \ | |/ /
| * | Merge bk-internal:/home/bk/mysql-4.1/serg@serg.mylan2004-03-051-0/+5
| |\ \ | | | | | | | | | | | | into serg.mylan:/usr/home/serg/Abk/mysql-4.1
| | * | UNHEX() functionserg@serg.mylan2004-03-041-0/+5
| | | |
| * | | Merge bk-internal.mysql.com:/home/bk/mysql-4.1monty@mashka.mysql.fi2004-03-041-0/+1
| |\ \ \ | | |/ / | |/| | | | | | into mashka.mysql.fi:/home/my/mysql-4.1
| | * | Optimized GIS functionsmonty@mashka.mysql.fi2004-03-041-0/+1
| | | |
| * | | my_gethwaddr() for linux/freebsdserg@serg.mylan2004-02-271-3/+8
| |/ / | | | | | | | | | UUID() function
* | | Merge 4.1 into 5.0.pem@mysql.com2004-02-101-0/+2
|\ \ \ | |/ /
| * | SCRUM:hf@deer.(none)2004-01-151-0/+2
| | | | | | | | | | | | | | | WL#1163 (Making spatial code optional) Pack of changes to do in sql/ code.
* | | Merge mysql.com:/home/psergey/mysql-5.0-latest-pullsergefp@mysql.com2003-12-201-2/+2
|\ \ \ | | | | | | | | | | | | into mysql.com:/dbdata/psergey/mysql-5.0-imerge-unique
| * \ \ Merging lex-pointer change from 4.1 to 5.0.pem@mysql.com2003-12-191-2/+2
| |\ \ \ | | |/ /
| | * | THD::lex now points to THD::main_lex like in 5.0konstantin@oak.local2003-12-191-7/+7
| | | | | | | | | | | | | | | | All tests pass (client_test included)
* | | | Numerous small fixes to index_merge read time estimates codesergefp@mysql.com2003-12-201-4/+0
|/ / /
* | | post-merge fixesgluh@gluh.mysql.r18.ru2003-12-081-5/+0
|\ \ \
| * | | WL#530&531: TIMESTAMPADD, TIMESTAMPDIFF functionsgluh@gluh.mysql.r18.ru2003-12-081-5/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Syntax for TIMESTAMPADD: TIMESTAMPADD(interval, integer_expression, datetime_expression) interval:= FRAC_SECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR Supported SQL_TSI_ prefix (like SQL_TSI_SECOND) Syntax for TIMESTAMPDIFF: TIMESTAMPDIFF(interval, datetime_expression1, datetime_expression2) interval:= FRAC_SECOND | SECOND | MINUTE | HOUR | DAY | WEEK | MONTH | QUARTER | YEAR Supported SQL_TSI_ prefix (like SQL_TSI_SECOND)
* | | | Merging 4.1->5.0.pem@mysql.com2003-11-191-7/+7
|\ \ \ \ | |_|/ / |/| | |
| * | | Merging 4.1->5.0pem@mysql.com2003-10-221-7/+7
| |\ \ \ | | |/ /
View Lorry Controller Status