summaryrefslogtreecommitdiff
path: root/mysql-test/t
Commit message (Collapse)AuthorAgeFilesLines
* Fix the location of test filesElena Stepanova2019-01-041-66/+0
|
* Merge branch '10.2' into 10.3Sergei Golubchik2019-01-031-0/+66
|\
| * Merge branch '10.1' into 10.2Sergei Golubchik2019-01-031-1/+1
| |\
| | * Merge branch '10.0' into 10.1Sergei Golubchik2019-01-031-1/+1
| | |\
| | | * Merge branch '5.5' into 10.0Sergei Golubchik2019-01-031-1/+1
| | | |\
| | | | * fix the test for 2019Sergei Golubchik2019-01-021-1/+1
| | | | |
| * | | | Merge branch '10.1' into 10.2mariadb-10.2.21Sergei Golubchik2018-12-304-4/+56
| |\ \ \ \ | | |/ / /
| | * | | Merge branch '10.0' into 10.1Sergei Golubchik2018-12-294-4/+63
| | |\ \ \ | | | |/ /
| | | * | Merge branch '5.5' into 10.0Sergei Golubchik2018-12-201-4/+17
| | | |\ \ | | | | |/
| | | | * MDEV-16987 - ALTER DATABASE possible in read-only modeSergey Vojtovich2018-12-131-0/+13
| | | | | | | | | | | | | | | | | | | | Forbid ALTER DATABASE under read_only.
| | | * | MDEV-17589: Stack-buffer-overflow with indexed varchar (utf8) fieldbb-10.0-varunVarun Gupta2018-12-191-0/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Create a new constant MAX_DATA_LENGTH_FOR_KEY. Replace the value of MAX_KEY_LENGTH to also include the LENGTH and NULL BYTES of a field.
| | | * | Backported MDEV-11196(e4d10e09cf31) and MDEV-10360(8a8ba1949bf4) to 10.0Varun Gupta2018-12-191-0/+106
| | | | |
| | | * | MDEV-6453: Assertion `inited==NONE || (inited==RND && scan)' failed in ↵Varun Gupta2018-12-161-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | handler::ha_rnd_init(bool) with InnoDB, joins, AND/OR conditions The inited parameter handler is not initialised when we do a quick_select after a table scan.
| * | | | Merge 10.1 into 10.2Marko Mäkelä2018-12-211-0/+10
| |\ \ \ \ | | |/ / /
| | * | | MDEV-17975 Assertion `! is_set()' or `!is_set() || (m_status == DA_OK_BULK ↵Sergei Golubchik2018-12-201-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | && is_bulk_op())' failed upon REVOKE under LOCK TABLE open_grant_tables() returns -1/0/1, where -1 is an error, while 1 is not. Don't store it's return value in bool
| * | | | MDEV-17738 Server crashes in Item::delete_self on closing connection after ↵Alexander Barkov2018-12-211-0/+66
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | unsuccessful PS Also fixes: MDEV-17741 Assertion `thd->Item_change_list::is_empty()' failed in mysql_parse after unsuccessful PS The problem was introduced by: commit f033fbd9f2366619c52186a1a902066495539141 Changed the test case for MDEV-15571 It was later fixed, but in 10.3 only: commit ce2cf855bfc0d9c8adb64f02a7b32ddd81f9948a MDEV-16043 Assertion thd->Item_change_list::is_empty() failed in mysql_parse upon SELECT from a view reading from a versioned table This patch is a backport of ce2cf855bfc0d9c8adb64f02a7b32ddd81f9948a to 10.2
| * | | | MDEV-16110 ALTER with ALGORITHM=INPLACE breaks temporary table with virtual ↵Sergei Golubchik2018-12-201-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | columns Part two, temporary tables. Make temporary tables respect TABLE::m_needs_reopen. See also 77cd754229b
| * | | | MDEV-17755 Assertion `!table || (!table->read_set || ↵Sergei Golubchik2018-12-201-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | bitmap_is_set(table->read_set, field_index) || (!(ptr >= table->record[0] && ptr < table->record[0] + table->s->reclength)))' failed in Field_bit::val_int upon SELECT with JOIN, partitions, indexed virtual column add a test case
| * | | | MDEV-16903 Assertion `!auto_increment_field_not_null' failed in TABLE::init ↵Sergei Golubchik2018-12-201-0/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | after unsuccessful attempt to add CHECK constraint on temporary table if the CHECK constraint failed in copy_data_between_tables(), the loop was aborted prematurely and to->auto_increment_field_not_null wasn't reset.
| * | | | correct table name in CHECK failures during ALTER TABLESergei Golubchik2018-12-201-2/+0
| | | | |
| * | | | MDEV-15424: Unreasonable SQL Error (1356) on select from viewVarun Gupta2018-12-192-0/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | While printing a view containing a window function we were printing it as an Item_field object instead of an Item_window_func object. This is incorrect and this leads to us throwing an error ER_VIEW_INVALID. Fixed by adjusting the Item_ref:print function. Also made UDF function aware if there arguments have window function.
| * | | | MDEV-17676: Assertion `inited==NONE || (inited==RND && scan)' failed in ↵Varun Gupta2018-12-171-0/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | handler::ha_rnd_init While calculating distinct with the function remove_dup_with_compare, we don't have rnd_end calls when we have completed the scan over the temporary table. Added ha_rnd_end calls when we are done with the scan of the table.
| * | | | MDEV-14576 Include full name of object in message about incorrect value for ↵Alexey Botchkov2018-12-161-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | column. galera_prepared_statement test fixed.
| * | | | Merge 10.1 into 10.2Marko Mäkelä2018-12-121-0/+62
| |\ \ \ \ | | |/ / /
| | * | | Merge 10.0 into 10.1Marko Mäkelä2018-12-121-0/+62
| | |\ \ \ | | | |/ /
| | | * | MDEV-17032: Estimates are higher for partitions of a table with ↵Varun Gupta2018-12-071-0/+61
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | @@use_stat_tables= PREFERABLY The problem here is EITS statistics does not calculate statistics for the partitions of the table. So a temporary solution would be to not read EITS statistics for partitioned tables. Also disabling reading of EITS for columns that participate in the partition list of a table.
| * | | | Merge 10.1 into 10.2Marko Mäkelä2018-12-072-5/+19
| |\ \ \ \ | | |/ / /
| | * | | MDEV-17917 MTR: fixed race conditions in perfschema.socket_connect, main.connectVladislav Vaintroub2018-12-061-5/+2
| | | | |
| | * | | Merge branch '10.0' into 10.1Sergei Golubchik2018-12-061-0/+17
| | |\ \ \ | | | |/ /
| | | * | Added a testcase for mdev-17734Varun Gupta2018-12-051-0/+17
| | | | |
| * | | | MDEV-17871 Crash when running explain with CTEIgor Babaev2018-12-011-0/+39
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | When the with clause of a query contains a recursive CTE that is not used then processing of EXPLAIN for this query does not require optimization of the unit specifying this CTE. In this case if 'derived' is the TABLE_LIST object created for this CTE then derived->derived_result is NULL and any assignment to derived->derived_result->table causes a crash. After fixing this problem in the code of st_select_lex_unit::prepare() EXPLAIN for such a query worked without crashes. Yet an execution plan for the recursive CTE appeared there. The cause of this problem was an incorrect condition used in JOIN::save_explain_data_intern() that determined whether CTE was to be optimized or not. A similar condition was used in select_describe() and this patch has corrected it as well.
| * | | | MDEV-17507 Make MTR tests work for builds without Aria for temporary tablesElena Stepanova2018-11-201-0/+4
| | | | | | | | | | | | | | | | | | | | Skip tests which expectedly fail when Aria is not used for temporary tables
| * | | | MDEV-13170: Database service (MySQL) stops after update with triggerVarun Gupta2018-11-161-0/+41
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | For prepare statemtent/stored procedures we rollback the items to original ones after prepare execution in the function reinit_stmt_before_use. This rollback is done for group by, order by clauses but is not done for the window specification containing the order by and partition by clause of the window function.
| * | | | Merge branch '10.1' into 10.2Oleksandr Byelkin2018-11-151-0/+9
| |\ \ \ \ | | |/ / /
| | * | | Merge branch '10.0' into 10.1Oleksandr Byelkin2018-11-151-0/+9
| | |\ \ \ | | | |/ /
| | | * | Merge branch '5.5' into 10.0Oleksandr Byelkin2018-11-151-0/+9
| | | |\ \ | | | | |/
| | | | * MDEV-17724 Wrong result for BETWEEN 0 AND 18446744073709551615Alexander Barkov2018-11-151-0/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The fix for "MDEV-17698 MEMORY engine performance regression" previously fixed this problem. - Adding the test for MDEV-17724 - Re-recording wrong results for tests: * engines/iuds/r/insert_number * engines/iuds/r/update_delete_number which started to fail since MDEV-17698
| * | | | Merge branch '10.1' into 10.2Oleksandr Byelkin2018-11-141-0/+32
| |\ \ \ \ | | |/ / /
| | * | | Merge branch '10.0' into 10.1Oleksandr Byelkin2018-11-141-0/+30
| | |\ \ \ | | | |/ /
| | | * | fix of test suiteOleksandr Byelkin2018-11-141-1/+1
| | | | |
| | | * | MDEV-11167: InnoDB: Warning: using a partial-field key prefix in search, ↵Oleksandr Byelkin2018-11-071-0/+30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | results in assertion failure or "Can't find record" error Fix ha_rnd_init() argument (we do not doing scan but use rnd_pos)
| * | | | MDEV-16217: Assertion `!table || (!table->read_set || ↵bb-10.2-MDEV-16217Oleksandr Byelkin2018-11-142-0/+37
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | bitmap_is_set(table->read_set, field_index))' failed in Field_num::get_date - clean up DEFAULT() to work only with default value and correctly print itself. - fix of DBUG_ASSERT about fields read/write - fix of field marking for write based really on the thd->mark_used_columns flag
| * | | | MDEV-17454 JSON_VALID( '{"a":1]' ) evaluates to 1.Alexey Botchkov2018-11-121-0/+6
| | | | | | | | | | | | | | | | | | | | Produce syntax error when '{...]'.
| * | | | MDEV-12575: Server crash in AGGR_OP::put_record or in JOIN_CACHE::free or ↵Varun Gupta2018-11-103-0/+86
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Invalid write in JOIN::make_aggr_tables_info During the optimize state of a query, we come know that the result set would atmost contain one row, then for such a query we don't need to compute GROUP BY, ORDER BY and DISTINCT.
| * | | | MDEV-16174 Assertion `0' failed in ↵Alexey Botchkov2018-11-091-0/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Type_handler_string_result::make_sort_key(uchar*, Item*, const SORT_FIELD_ATTR*, Sort_param*) maybe_null should be always set to TRUE in Item_func_json_array_append::fix_length_and_dec()
| * | | | MDEV-17574 SIGSEGV or Assertion `producing_item != __null' inIgor Babaev2018-11-081-0/+27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Item_direct_view_ref::derived_field_transformer_for_where upon updating a view The condition pushed into a materialized derived / view mast be adjusted for the new context: its column references must be substituted for references to the columns of the underlying tables if the condition is pushed into WHERE. The substitution is performed by the 'transform' method. If the materialized derived is used in a mergeable view then the references to the columns of the view are represented by Item_direct_view_ref objects. The transform method first processes the item wrapped in such an object and only after this it transforms the object itself. The transformation procedure of an Item_direct_view_ref object has to know whether the item it wraps has been substituted. If so the procedure does not have to do anything. In the code before this patch it was not possible for the transformation procedure used by an Item_direct_view_ref object to find out whether a substitution for the wrapped item had happened.
| * | | | MDEV-17635 Server hangs after the query with recursive CTEIgor Babaev2018-11-071-0/+55
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This bug in the code of the function With_element::check_unrestricted_recursive() could force a recursive CTE to be executed in a non-standard compliant mode in which recursive UNION ALL could lead to an infinite execution. This problem could occur only in the case when this CTE was used by another recursive CTE at least twice.
| * | | | Merge 10.1 into 10.2Marko Mäkelä2018-11-071-0/+13
| |\ \ \ \ | | |/ / /
| | * | | Merge 10.0 into 10.1Marko Mäkelä2018-11-071-0/+13
| | |\ \ \ | | | |/ /
| | | * | Merge 5.5 into 10.0Marko Mäkelä2018-11-071-0/+13
| | | |\ \ | | | | |/
View Lorry Controller Status