summaryrefslogtreecommitdiff
path: root/sql
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-5438 A view can mask a table that supports discoverySergei Golubchik2013-12-133-8/+3
|
* add metadata_lock_infoKentoku SHIBA2013-12-112-2/+47
|
* add a forgotten my_afree() to make valgrind happySergei Golubchik2013-12-121-0/+1
|
* MDEV-5388 - Reduce usage of LOCK_open: unused_tablesSergey Vojtovich2013-12-125-179/+77
| | | | Removed unused_tables, find LRU object by timestamp instead.
* MDEV-4956 - Reduce usage of LOCK_open: TABLE_SHARE::tdc.used_tablesSergey Vojtovich2013-12-106-90/+91
| | | | | | | | | | - tc_acquire_table and tc_release_table do not access TABLE_SHARE::tdc.used_tables anymore - in tc_acquire_table(): release LOCK_tdc after we relase LOCK_open (saves a few CPU cycles in critical section) - in tc_release_table(): if we reached table cache threshold, evict to-be-released table without moving it to unused_tables. unused_tables must be empty at this point.
* correct old assert in add_role_user_mapping_action to match changed function ↵Sergei Golubchik2013-12-091-2/+4
| | | | | | prototypes. fix the element deleting logic for roles_mappings_hash
* remove sys_var specific restore_pluginvar_names() function,Sergei Golubchik2013-12-092-65/+76
| | | | use generic restore_ptr_backup() approach
* MDEV-4403 Attempting to use cassandra storage engine causes "service ↵Sergei Golubchik2013-12-092-4/+72
| | | | | | | | 'my_snprintf_service' interface version mismatch" When a DSO is loaded we rewrite service pointers to point to the actual service structures. But when a DSO is unloaded, we have to restore their original values, in case this DSO wasn't removed from memory on dlclose() and is later loaded again.
* remove #ifdef ENABLE_BEFORE_END_OF_MERGE_QQSergei Golubchik2013-12-092-6/+0
|
* cleanups:Sergei Golubchik2013-12-093-120/+119
| | | | | | * comments from WL#5602 in sql_acl.cc * rename global memroots in sql_acl.cc * remove the second empty lex string constant
* bugfix: incorrect buffer sizes for net_store_length()Sergei Golubchik2013-12-092-7/+7
|
* reuse new safe_net_field_length_ll function where appropriateSergei Golubchik2013-12-091-25/+10
|
* Do the partial merge of WL#5602 correctly:Sergei Golubchik2013-12-096-181/+48
| | | | | | Remove unused code (that should not have been merged) Add protocol extension (that should have been merged) Fix bugs (see pack.c)
* MDEV-5115 RBR from MySQL 5.6 to MariaDB 10.0 does not workSergei Golubchik2013-12-097-48/+236
| | | | Patially merge WL#5917, to understand v2 row events
* MDEV-5367 Server crashes in acl_authenticate on concurrent thread ↵Sergei Golubchik2013-12-011-1/+1
| | | | | | connection, FLUSH PRIVILEGES fix a copy-paste error, introduced in role refactoring
* MDEV-4243 [PATCH] Warnings/errors while compiling with clangSergei Golubchik2013-11-287-12/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | 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.
* MDEV-4955 discover of table non-existance on CREATESergei Golubchik2013-11-281-9/+19
| | | | | | | | when frm file exists, but the table does not. In recover_from_failed_open(), allow the discovery to fail without an error, when open_strategy == TABLE_LIST::OPEN_IF_EXISTS.
* MDEV-5281 Partitioning issue after upgrade from 10.0.3-1 to 10.0.5-1Sergei Golubchik2013-11-2814-117/+1099
| | | | | | | | | | merged from 5.6: Bug#14521864: MYSQL 5.1 TO 5.5 BUGS PARTITIONING Bug#16589511: MYSQL_UPGRADE FAILS TO WRITE OUT ENTIRE ALTER TABLE ... ALGORITHM= ... STATEMENT Bug#16274455: CAN NOT ACESS PARTITIONED TABLES WHEN DOWNGRADED FROM 5.6.11 TO 5.6.10 plus minor changes from 5.6, mainly comments
* typo fix in ha_partition::rnd_pos(), status wasn't updatedSergei Golubchik2013-11-271-1/+1
|
* Fix a first timestamp column in the sql-based table discoverySergei Golubchik2013-11-251-0/+1
|
* unreserve GET keywordSergei Golubchik2013-11-211-0/+1
|
* MroongaSE: addint thd_autoinc and thd_error_context plugin servicesAlexander Barkov2013-12-122-5/+55
|
* MDEV-5298 Illegal mix of collations on timestampAlexander Barkov2013-12-103-3/+10
| | | | | Fixed.
* MDEV-5297 TIME(0), TIMESTAMP(0) and DATETIME(0) are self-incompatible during ↵Alexander Barkov2013-12-061-13/+45
| | | | | | | replication (upstream) Fixed.
* MDEV-5277 - Ensure that all MySQL 5.6 options are supported by theSergey Vojtovich2013-11-253-10/+67
| | | | MariaDB 10.0 server
* MDEV-5220 - [PATCH] MariaDB 10.0.4 doesn't compile without perfschemaSergey Vojtovich2013-11-143-6/+10
| | | | | | | | | | | | Fixed the following compilation errors and test failures: - maria SE: "stage_waiting_for_a_resource" wasn't declared w/o PFS - sql_repl.h: PSI_mutex_key is not available in non-PFS builds - mysqld.cc: pfs_param is not available in non-PFS builds - mysqld.cc: init_show_explain_psi_keys() is not available in non-PFS builds - mysqld.cc: call net_before_header_psi, net_after_header_psi even if PFS is not available so that thread enters stage_init at proper time. Fixes sp-threads and a few tests in funcs_1. - myisam_file_io.opt: added missing loose prefix
* MDEV-4437 ALTER TABLE .. ADD UNIQUE INDEX IF NOT EXISTS causes syntax error.Alexey Botchkov2013-11-141-3/+3
| | | | | Added the IF NOT EXISTS option to the CONSTRAINT keyword.
* 10.0-base mergeSergei Golubchik2013-11-1318-76/+96
|\
| * 5.5. mergeSergei Golubchik2013-11-1318-73/+92
| |\
| | * 5.3 mergeSergei Golubchik2013-11-132-6/+4
| | |\
| | | * MDEV-5284 Assertion `!(*expr)->fixed' fails in replace_where_subcondition ↵Sergei Golubchik2013-11-131-4/+2
| | | | | | | | | | | | | | | | with IN suquery
| | | * MDEV-5113 Wrong result (extra row) and valgrind warnings in ↵Sergei Golubchik2013-11-121-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Item_maxmin_subselect::any_value on 2nd execution of PS with SELECT subquery When setting Item_func_not_all::test_sum_item or Item_func_not_all::test_sub_item, reset the other one to NULL - they can never be set both. When a PS is reexecuted, different executions might be optimized differently and a wrong test_su*_item might stay set from the previous execution.
| | * | MergeSergey Petrunya2013-11-131-3/+21
| | |\ \
| | | * | MDEV-5257: MIN/MAX Optimization (Select tables optimized away) does not work ↵Sergey Petrunya2013-11-121-3/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | for DateTime - MIN/MAX optimizer does a check whether a "field CMP const" comparison uses a constant that's longer than the field it is compared to. Make this check only for string columns, also compare character lengths, not byte lengths.
| | * | | MDEV-5056: Wrong result (extra rows) with materialization+semijoin, IN ↵Sergey Petrunya2013-11-131-2/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | subqueries Apply fix suggested by Igor: - When eliminate_item_equal() generates pair-wise equalities from a multi-equality, do generate a "bridge" equality between the first field inside SJM nest and the field that's first in the overall multi-equality.
| | * | | MDEV-5236 Status variables are not all listed alphabeticallySergei Golubchik2013-11-111-4/+4
| | | | | | | | | | | | | | | | | | | | sort Com_ counters. No simple fix for Binlog_ variables.
| | * | | MDEV-4824 userstats - wrong user statisticsSergei Golubchik2013-11-118-27/+27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | (and valgrind warnings) * move thd userstat initialization to the same function that was adding thd userstat to global counters. * initialize thd->start_bytes_received in THD::init (when thd->userstat_running is set)
| | * | | MDEV-5101 INFORMATION_SCHEMA.PROCESSLIST reports an incorrect value for Time ↵Sergei Golubchik2013-11-111-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | for connecting threads by convention query execution time should be 0 if its start_time is 0 (this was lost when fixing MDEV-4578)
| | * | | MDEV-5022 Strange message or wrong errno on mismatching versions of plugin ↵Sergei Golubchik2013-11-112-28/+28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | and server 1. use an appropriate errno code 2. put a comma between the errno and the error message text
| * | | | MDEV-407: Print EXPLAIN [ANALYZE] in the slow query logSergey Petrunya2013-11-121-3/+3
| | | | | | | | | | | | | | | | | | | | | | | | | - Address input from the mail list: change how EXPLAIN is formatted in the slow query log.
| * | | | Fixed bug mdev-5160.Igor Babaev2013-11-111-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | The used_tables attribute must be recalculated for the HAVING condition if the condition is applied to the rows read from a temporary table.
* | | | | merge 10-base->10.0unknown2013-11-1118-58/+160
|\ \ \ \ \ | |/ / / /
| * | | | merge 5.5->10.0-baseunknown2013-11-114-30/+64
| |\ \ \ \ | | |/ / /
| | * | | merge 5.3->5.5unknown2013-11-114-30/+64
| | |\ \ \ | | | | |/ | | | |/|
| | | * | MDEV-5153: Server crashes in Item_ref::fix_fields on 2nd execution of PS ↵unknown2013-11-113-28/+40
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | with LEFT JOIN and MERGE view or SELECT SQ 1. Transformation of row IN subquery made the same as single value. 2. replace_where_subcondition() made working on several layers of OR/AND because it called on expression before fix_fields().
| | | * | MDEV-5103: server crashed on singular Item_equalunknown2013-11-112-1/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Singular Item_equal support added. The problem was that during constant table substitution Item_equal become containing only one constant which was not supported internally.
| * | | | Merge 5.5 -> 10.0-baseAlexander Barkov2013-11-091-8/+9
| |\ \ \ \ | | |/ / /
| | * | | Merge 5.3 -> 5.5Alexander Barkov2013-11-081-8/+9
| | |\ \ \ | | | |/ / | | | | / | | | |/ | | |/|
| | | * Merge 5.2 -> 5.3Alexander Barkov2013-11-081-8/+9
| | | |\
| | | | * Merge 5.1 -> 5.2Alexander Barkov2013-11-081-8/+9
| | | | |\
View Lorry Controller Status