summaryrefslogtreecommitdiff
path: root/mysql-test/t
Commit message (Collapse)AuthorAgeFilesLines
* Fixed bug mdev-10874.Igor Babaev2016-09-231-0/+48
| | | | | In some cases the method Window_funcs_sort::setup() did not build the sequence of sorting keys correctly.
* MDEV-10877 xxx_unicode_nopad_ci collationsAlexander Barkov2016-09-236-0/+119
|
* Merge branch '10.2' into bb-10.2-connector-c-integ-submSergei Golubchik2016-09-221-0/+38
|\
| * Allowed to use WITH clauses before SELECT in CREATE ... SELECTbb-10.2-mdev9864Igor Babaev2016-09-221-0/+38
| | | | | | | | | | and INSERT ... SELECT. Added test cases.
* | Merge branch '10.2' into bb-10.2-connector-c-integ-submSergei Golubchik2016-09-2166-89/+4344
|\ \ | |/
| * fix main.index_intersect_innodb failure on trusty-amd64Sergei Golubchik2016-09-211-0/+2
| |
| * Fixed bug mdev-10842.Igor Babaev2016-09-201-0/+32
| | | | | | | | | | In some cases the function compare_order_elements() erroneously returned CMP_EQ for not equal elements.
| * Merge branch '10.2' into bb-10.2-janSergei Golubchik2016-09-1964-111/+4450
| |\
| | * Don't increment 'Empty_queries' for queries with errors.Monty2016-09-151-0/+9
| | |
| | * Test case for fix assertion/hang in read_init_file()Monty2016-09-151-1/+1
| | |
| | * Fixed bug mdev-10785.Igor Babaev2016-09-141-1/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | The condition pushed into WHERE/HAVING of a materialized view/derived table may differ for different executions of the same prepared statement. That's why the should be ANDed with the existing WHERE/HAVING conditions only after all permanent transformations of these conditions has been performed.
| | * Merge branch '10.2' of github.com:MariaDB/server into 10.2Igor Babaev2016-09-131-0/+48
| | |\
| | | * MDEV-10779 Failing assertion lex->proc_list.elements == 0 or syntax error on ↵Alexander Barkov2016-09-131-0/+48
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PROCEDURE ANALYSE in UNION Reverting a part of the patch for "MDEV-8909union parser cleanup", as a parenthesized SELECT with PROCEDURE followed by UNION is not disallowed by the grammar (only a non-parenthesized SELECT with PROCEDURE followed by a UNION is disallowed grammatically).
| | * | Fixed bug mdev-10783.Igor Babaev2016-09-131-1/+9
| | |/ | | | | | | | | | | | | Do not push conditions into materialized views/derived tables marked with the flag 'fill_me'.
| | * Fixed bug mdev-10782.Igor Babaev2016-09-121-1/+23
| | | | | | | | | | | | | | | | | | | | | | | | This bug in the code of Item_ref::build_clone could cause corruption of items in where conditions. Also made sure that equality predicates extracted from multiple equality items to be pushed into materialized views were cloned.
| | * Merge branch '10.2' of github.com:MariaDB/server into 10.2Igor Babaev2016-09-0929-51/+765
| | |\
| | | * It is now possible to remove values multiple times from window functionsVicențiu Ciorbaru2016-09-091-6/+18
| | | | | | | | | | | | | | | | This can happen with degenerate frame definitions that are always empty.
| | | * Add min/max test cases for window functionsVicențiu Ciorbaru2016-09-091-0/+49
| | | |
| | | * MDEV-10097: Assertion `count > 0' failed in Item_sum_sum::add_helper(bool)Vicențiu Ciorbaru2016-09-091-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | When specifying a RANGE type frame that exceeds the partition size, both for the top and bottom cursors we end up removing more rows than added to the aggregate function. This happens because our TOP range cursor, which removes values from the aggregate function, would be allowed to breach partition boundaries, while the BOTTOM range cursor would not. To prevent this from happening, force the TOP range cursor to only move within the current partition, as does the BOTTOM range cursor.
| | | * MDEV-10763: Wrong result - server does not return NULL values from default ↵Oleksandr Byelkin2016-09-091-0/+20
| | | | | | | | | | | | | | | | | | | | | | | | list partition after ALTER table Fixed partition pruning for NULL value.
| | | * MDEV-10765: Wrong result - query does not retrieve values from default ↵Oleksandr Byelkin2016-09-091-0/+47
| | | | | | | | | | | | | | | | | | | | | | | | partition on a table partitioned by list columns Partial matches should be treat as not exact one.
| | | * Merge branch '10.1' into 10.2Sergei Golubchik2016-09-0926-45/+614
| | | |\
| | | | * MDEV-10017: Get unexpected `Empty Set` for correlated subquery with ↵Oleksandr Byelkin2016-08-311-0/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | aggregate functions take into account all arguments of aggregate function
| | | | * MDEV-10017: Get unexpected `Empty Set` for correlated subquery with ↵mariadb-10.1.17Oleksandr Byelkin2016-08-291-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | aggregate functions (part 1) Make aggregate function dependency visible.
| | | | * Merge branch '10.0' into 10.1Sergei Golubchik2016-08-2514-20/+323
| | | | |\
| | | | | * Merge branch 'bb-10.0-serg' into 10.0Sergei Golubchik2016-08-1412-20/+317
| | | | | |\
| | | | | | * Merge branch '5.5' into 10.0Sergei Golubchik2016-08-1012-20/+317
| | | | | | |\
| | | | | | | * MDEV-6128:[PATCH] mysqlcheck wrongly escapes '.' in table namesSergei Golubchik2016-08-081-2/+45
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | a correct fix: * store properly quoted table names in tables4repair/etc lists * tell handle_request_for_tables whether the name is aalready properly quoted * test cases for all uses of fix_table_name()
| | | | | | | * MDEV-10468 Assertion `nr >= 0.0' failed in Item_sum_std::val_real()Alexander Barkov2016-08-081-0/+6
| | | | | | | |
| | | | | | | * MDEV-10500 CASE/IF Statement returns multiple values and shifts further ↵Alexander Barkov2016-08-081-0/+25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | result values to the next column We assume all around the code that null_value==true is in sync with NULL value returned by val_str()/val_decimal(). Item_sum_sum::val_decimal() erroneously returned a non-NULL value together with null_value set to true. Fixing to return NULL instead.
| | | | | | | * MDEV-10506 Protocol::end_statement(): Assertion `0' failed upon ALTER TABLESergei Golubchik2016-08-071-0/+117
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | thd->clear_error() destroyed already existing error status
| | | | | | | * MDEV-9946: main.xtradb_mrr fails sporadicallySergei Petrunia2016-08-041-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Make the testcase stable by adding FORCE INDEX
| | | | | | | * Merge branch 'mysql/5.5' into 5.5Sergei Golubchik2016-08-033-1/+60
| | | | | | | |\ | | | | | | | | | | | | | | | | | | | | | | | | | | | without a fix for Bug#12818255 (MDEV-6581)
| | | | | | | | * BUG#23080148 - BACKPORT BUG 14653594 AND BUG 20683959 TOThayumanavar S2016-06-201-1/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MYSQL-5.5 The bug asks for a backport of bug#1463594 and bug#20682959. This is required because of the fact that if replication is enabled, master transaction can commit whereas slave can't commit due to not exact 'enviroment'. This manifestation is seen in bug#22024200.
| | | | | | | | * Bug #23279858: MYSQLD GOT SIGNAL 11 ON SIMPLE SELECTSreeharsha Ramanavarapu2016-05-241-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | NAME_CONST QUERY ISSUE: ------ Using NAME_CONST with a non-constant negated expression as value can result in incorrect behavior. SOLUTION: --------- The problem can be avoided by checking whether the argument is a constant value. The fix is a backport of Bug#12735545.
| | | | | | | | * BUG#21142859: FUNCTION UPDATING A VIEW FAILS TO FIND TABLEKarthik Kamath2016-05-181-0/+26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | THAT ACTUALLY EXISTS ANALYSIS: ========= Stored functions updating a view where the view table has a trigger defined that updates another table, fails reporting an error that the table doesn't exist. If there is a trigger defined on a table, a variable 'trg_event_map' will be set to a non-zero value after the parsed tree creation. This indicates what triggers we need to pre-load for the TABLE_LIST when opening an associated table. During the prelocking phase, the variable 'trg_event_map' will not be set for the view table. This value will be set after the processing of triggers defined on the table. During the processing of sub-statements, 'locked_tables_mode' will be set to 'LTM_PRELOCKED' which denotes that further locking of tables/functions cannot be done. This results in the other table not being locked and thus further processing results in an error getting reported. FIX: ==== During the prelocking of view, the value of 'trg_event_map' of the view is copied to 'trg_event_map' of the next table in the TABLE_LIST. This results in the locking of tables associated with the trigger as well.
| | | | | | | * | MDEV-10467 Assertion `nr >= 0.0' failed in Item_sum_std::val_real()Alexander Barkov2016-08-031-0/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Backporting MDEV-5781 from 10.0.
| | | | | | | * | MDEV-10383 Named pipes : multiple servers can listen on the same pipenameVladislav Vaintroub2016-08-021-0/+9
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Use FILE_FLAG_FIRST_PIPE_INSTANCE with the first CreateNamedPipe() call to make sure the pipe does not already exist.
| | | | | | | * | MDEV-10419: crash in mariadb 10.1.16-MariaDB-1~trustyOleksandr Byelkin2016-07-301-0/+15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed initialization and usage of THD reference in subselect engines.
| | | | | | | * | MDEV-10228: Delete missing rows with OR conditionsSergei Petrunia2016-07-271-0/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix get_quick_keys(): When building range tree from a condition in form keypart1=const AND (keypart2 < 0 OR keypart2>=0) the SEL_ARG for keypart2 represents an interval (-inf, +inf). However, the logic that sets UNIQUE_RANGE flag fails to recognize this, and sets UNIQUE_RANGE flag if (keypart1, keypart2) covered a unique key. As a result, range access executor assumes the interval can have at most one row and only reads the first row from it.
| | | | | | | * | MDEV-10316 - main.type_date fails around midnight sporadicallySergey Vojtovich2016-07-211-12/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | A better fix for MySQL Bug#41776: use hard timestamp rather than unreliable sleep.
| | | | | * | | | MDEV-10428 main.information_schema_stats fails sporadically in buildbotElena Stepanova2016-07-251-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Resultsets which contain more than one row need to be sorted
| | | | | * | | | MDEV-8569 build_table_filename() doesn't support temporary tables.Alexey Botchkov2016-07-181-0/+4
| | | | | |/ / / | | | | | | | | | | | | | | | | | | | | | | | | Temporary tables support added for RENAME and ALTER TABLE.
| | | | * | | | MDEV-10389: Query returns different results on a debug vs non-debug buildSergei Petrunia2016-07-271-0/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The problem was caused by a merged semi-join, which contained a non-merged semi-join, which used references to the top-level query in the left_expr. When moving non-merged semi-join from the subquery to its parent, do not forget to call fix_after_pullout for its Item_subselect. We need to do that specifically, because non-merged semi-joins do not have their IN-equality in the WHERE clause at this stage.
| | | | * | | | MDEV-10045: Server crashes in Time_and_counter_tracker::incr_loopsOleksandr Byelkin2016-07-221-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Do not set 'optimized' flag until whole optimization procedure is finished.
| | | | * | | | Update test results: make innodb_ext_key test stableSergei Petrunia2016-07-131-3/+7
| | | | | | | |
| | | | * | | | Merge branch '10.0' into 10.1Sergei Golubchik2016-07-136-23/+19
| | | | |\ \ \ \ | | | | | |/ / /
| | | | | * | | Merge branch '5.5' into 10.0Sergei Golubchik2016-07-121-0/+7
| | | | | |\ \ \ | | | | | | |/ /
| | | | | | * | MDEV-10318 unset params in --ps --embeddedSergei Golubchik2016-07-121-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | add a test case
| | | | | * | | MDEV-10211 postfix - in ssl.test, remove remaining SHOW STATUS LIKE 'Ssl_cipher'Vladislav Vaintroub2016-07-121-1/+0
| | | | | | | |
View Lorry Controller Status