summaryrefslogtreecommitdiff
path: root/mysql-test/r
Commit message (Collapse)AuthorAgeFilesLines
* MDEV-4724 Some temporal functions do not preserve microsecondsAlexander Barkov2013-09-1211-117/+262
|
* MDEV-4863 COALESCE(time_or_datetime) returns wrong results in numeric contextAlexander Barkov2013-09-092-7/+111
|
* Fixed bug mdev-4996.Igor Babaev2013-09-062-1/+29
| | | | | The fix for bug mdev-4971 not always correctly set the pointers to inherited multiple equalities in objects of the Item_equal class.
* Fixed bug mdev-4971.Igor Babaev2013-08-294-1/+76
| | | | | The function propagate_new_equalities() did not updated properly the references to inherited multiple equalities.
* Fixed bug mdev-4962.Igor Babaev2013-08-292-0/+52
| | | | | | | When a non-nullable datetime field is used under an IS NULL predicate of the WHERE condition in a query with outer joins the remove_eq_conds function should check whether this field belongs to an inner table of any outer join that can be, in a general case, a nested outer join.
* Fixed bug mdev-4952Igor Babaev2013-08-262-0/+28
| | | | | | When in function remove_eq_conds() a sub-formula of the processed condition is replaced for another formula we should ensure that in the resulting formula AND/OR levels must alternate.
* Fixed bug mdev-4944.Igor Babaev2013-08-2611-9/+66
| | | | | | | | | | The patch to fix mdev-4418 turned out to be incorrect. At the substitution of single row tables in make_join_statistics() the used multiple equalities may change and references to the new multiple equalities must be updated. The function remove_eq_conds() takes care of it and it should be called right after the substitution of single row tables. Calling it after the call of make_join_statistics was a mistake.
* Fixed bug mdev-4942.Igor Babaev2013-08-232-0/+24
| | | | | Made sure that degenerate conjunctions/disjunctions are obtained from AND/OR conditions.
* MDEV-4804 Date comparing false resultAlexander Barkov2013-08-221-0/+38
|
* MDEV-4908: Assertion `((Item_cond *) cond)->functype() == ((Item_cond *) ↵unknown2013-08-212-0/+28
| | | | | | new_item)->functype()' fails on a query with IN and equal conditions, AND/OR, materialization+semijoin A new AND Item should be prepared (fix_field() call) before using.
* Fixed a bug/typo in the patch for mdev-4355, noticed after the patchIgor Babaev2013-08-201-3/+3
| | | | | | had been merged into 5.5. Corrected the result of the output from the test case for mdev 4895.
* Fix bug MDEV-4895 Valgrind warnings (Conditional jump or move depends on ↵unknown2013-08-201-0/+30
| | | | | | | | | | | | | | | uninitialised value) in Field_datetime::get_date on GREATEST(..) IS NULL Analysis: The cause of the valgrind warning was an attempt to evaluate a Field that was not yet read. The reason was that on one hand Item_func_isnotnull was marked as constant by Item_func_isnotnull::update_used_tables, and this allowed eval_const_cond() to be called. On the other hand Item_func_isnotnull::val_int() evaluated its argument as if it was not constant. Solution: The fix make sure that Item_func_isnotnull::val_int() doesn't evaluate its argument when it is constant and cannot be NULL, because the result is known in this case.
* Fixed bug mdev-4418.Igor Babaev2013-08-1612-10/+64
| | | | | | After single row substitutions there might appear new equalities. They should be properly propagated to all AND/OR levels the WHERE condition. It's done now with an additional call of remove_eq_conds().
* MergeIgor Babaev2013-08-154-4/+154
|\
| * Fixed bug mdev-4355.Igor Babaev2013-08-154-4/+154
| | | | | | | | | | | | | | | | This patch almost totally revised the patch for bug mdev-4177. The latter had too many defects. In particular, it did not propagate multiple equalities formed when merging a degenerate disjunct into underlying AND formula.
* | Merge 5.2->5.3Igor Babaev2013-08-152-4/+94
|\ \
| * \ Merge 5.1->5.2Igor Babaev2013-08-141-2/+42
| |\ \
| | * | Fixed bug mdev-4894.Igor Babaev2013-08-131-2/+42
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This a an old legacy performance bug. When a very selective range scan existed for the second table in a join, and, at the same time, there was another range condition depending on the fields of the first table, the optimizer chose a plan with 'Range checked for each record'. This plan was extremely inefficient in comparison with the regular selective range scan. As a matter of fact the range scan chosen for each record was the same as that selective range scan. Changed the test case for bug 24776 to preserve the old output for explain.
| | * | Bug #69682 - mysqld crashes after uninstall of plugin with "first" status varSergei Golubchik2013-07-061-0/+2
| | | |
* | | | MDEV-4652 Wrong result for CONCAT(GREATEST(TIME('00:00:01'),TIME('00:00:00'))Alexander Barkov2013-08-121-0/+9
| | | |
* | | | MDEV-4811 Assertion `offset < 0x1f' fails in type_and_offset_store on COLUMN_ADDunknown2013-08-011-0/+21
| | | | | | | | | | | | | | | | | | | | | | | | MDEV-4812 Valgrind warnings (Invalid write) in dynamic_column_update_many on COLUMN_ADD Fixed problem of working on wrong data (do not allow offset to out of string length).
* | | | MDEV-4653 Wrong result for CONVERT_TZ(TIME('00:00:00'),'+00:00','+7:5')Alexander Barkov2013-08-081-0/+19
| | | |
* | | | MDEV-4512 Valgrind warnings in my_long10_to_str_8bit on INTERVAL and ↵Alexander Barkov2013-08-081-0/+19
| |_|/ |/| | | | | | | | | | | | | | | | | DATE_ADD with incorrect types Fixing a typo: bit AND (&) was erroneously used instead of logical AND (&&)
* | | MDEV-4610 SQL query crashes MariaDB with derived_with_keysSergei Golubchik2013-07-051-0/+19
| | | | | | | | | | | | | | | | | | | | | MDEV-4643 MariaDB crashes consistently when trying a SELECT on VIEW with a UNION and an additional JOIN in SELECT open derived temp tables *before* trying QUICK_SELECT for them, handler::multi_range_read_info() needs an open table.
* | | MDEV-4665 crash when referencing missing function in a subquerySergei Golubchik2013-07-051-0/+6
| | | | | | | | | | | | don't ignore the return value fix_fields()
* | | MDEV-4257 Assertion `!table || (!table->read_set || ↵Sergei Golubchik2013-07-051-0/+6
| | | | | | | | | | | | | | | | | | bitmap_is_set(table->read_set, field_index))' fails on FROM subquery with fulltext search, derived_merge=on remove emtpty Item_func_match::update_used_tables() method
* | | MDEV-4667 DATE('string') incompability between mysql and mariadbSergei Golubchik2013-07-039-36/+40
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Cleanup: remove TIME_FUZZY_DATE. Introduce TIME_FUZZY_DATES which means "very fuzzy, the resulting value is only used for comparison. It can be invalid date, fine, as long as it can be compared". Updated many tests results (they're better now).
* | | MDEV-4634 Crash in CONVERT_TZAlexander Barkov2013-06-283-0/+30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Item_func_min_max::get_date() did not check the returned value against the fuzzy_date flags, so it could return a bad value to the caller that expects a good date (e.h. CONVERT_TZ). modified: mysql-test/r/type_date.result mysql-test/r/type_datetime.result mysql-test/r/type_time.result mysql-test/t/type_date.test mysql-test/t/type_datetime.test mysql-test/t/type_time.test sql/item_func.cc sql/item_timefunc.cc sql/mysql_priv.h sql/time.cc
* | | MDEV-4635 Crash in UNIX_TIMESTAMP(STR_TO_DATE('2020','%Y'))Alexander Barkov2013-06-171-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | modified: mysql-test/r/func_time.result mysql-test/t/func_time.test sql/item_timefunc.cc sql/mysql_priv.h
* | | MDEV-4651 Crash in my_decimal2decimal in a ORDER BY queryAlexander Barkov2013-06-175-10/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | modified: mysql-test/r/ps_2myisam.result mysql-test/r/ps_3innodb.result mysql-test/r/ps_4heap.result mysql-test/r/ps_5merge.result mysql-test/r/type_datetime_hires.result mysql-test/suite/maria/r/ps_maria.result mysql-test/t/type_datetime_hires.test sql/item_timefunc.h
* | | MDEV-4593: p_s: crash in simplify_joins with delete using subselect from viewunknown2013-06-061-0/+12
| | | | | | | | | | | | mysql_derived_merge_for_insert() should not be called for views or derived tables which are not put (directly or via other views) in main SELECT_LEX "join list".
* | | fixes for buildbotSergei Golubchik2013-05-211-1/+1
| | |
* | | 5.2 mergeSergei Golubchik2013-05-201-0/+8
|\ \ \ | |/ /
| * | MDEV-4462 mysqld gets SIGFPE when mysql.user table is emptySergei Golubchik2013-05-081-0/+8
| | | | | | | | | | | | avoid divison by zero
* | | MDEV-4290:unknown2013-05-031-0/+28
| | | | | | | | | | | | | | | Fix agregate function resolution in derived tables (no name resolution over a derived table border)
* | | MergeSergey Petrunya2013-05-051-1/+1
|\ \ \
| * | | MDEV-4482: main.windows test fails in buildbot with result mismatchSergey Petrunya2013-05-051-1/+1
| | | | | | | | | | | | | | | | - Rollback an earlier patch (was pushed into 5.3 instead of 5.5)
* | | | Fixed bug mdev-4336.Igor Babaev2013-05-032-0/+28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | When iterating over a list of conditions using List_iterator the function remove_eq_conds should skip all predicates that replace a condition from the list. Otherwise it can come to an infinite recursion.
* | | | Made consistent handling of the predicates of the formIgor Babaev2013-05-031-0/+16
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | <non-nullable datatime field> IS NULL in outer joins with that in inner joins. Previously such condition was transformed into the condition <non-nullable datatime field> = 0 unless the field belonged to an inner table of an outer join. In this case the predicate was interpreted as for any other field. Now if the field in the predicate <non-nullable datatime field> IS NULL belongs to an inner table of an outer join the predicate is transformed into the disjunction <non-nullable datatime field> = 0 OR <non-nullable datatime field> IS NULL. This is fully compatible with the semantics of such predicates in 5.5.
* | | | Fixed bug mdev-4274.Igor Babaev2013-04-294-1/+106
|/ / / | | | | | | | | | | | | | | | | | | | | | This bug was the result of incompleteness of the patch for bug mdev-4177. When an OR condition is simplified to a single conjunct it is merged into the embedding AND condition. Multiple equalities are also merged, and any field item involved in those equality should acquire a pointer to a the multiple equality formed by this merge.
* | | MDEV-4316 MariaDB server crash with signal 11Sergei Golubchik2013-04-061-0/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | fulltext search was initialized for all MATCH ... AGAINST items at the end of the JOIN::optimize(). But since 5.3 derived tables are initialized lazily on first use, very late in the sub_select(). Skip Item_func_match::init_search initialization if the corresponding table isn't open yet; repeat fulltext initialization for all not-yet-initialized MATCH ... AGAINST items after creating derived tables.
* | | Update tests results, mysql-test/r/windows.resultSergey Petrunya2013-04-041-1/+1
| | |
* | | MDEV-4335: Unexpected results when selecting on information_schemaSergey Petrunya2013-03-292-0/+20
| | | | | | | | | | | | | | | - When converting a subquery to a semi-join, propagate OPTION_SCHEMA_TABLE.
* | | Merge.Igor Babaev2013-03-271-1/+291
|\ \ \
| * | | Fixed bug mdev-4318.Igor Babaev2013-03-221-1/+291
| | | | | | | | | | | | | | | | | | | | | | | | In some cases, when using views the optimizer incorrectly determined possible join orders for queries with nested outer and inner joins. This could lead to invalid execution plans for such queries.
* | | | 5.2 mergeSergei Golubchik2013-03-263-1/+48
|\ \ \ \ | | |/ / | |/| |
| * | | 5.1 mergeSergei Golubchik2013-03-263-1/+48
| |\ \ \ | | | |/ | | |/|
| | * | MDEV-4295 Server crashes in get_point on a query with Area, AsBinary, ↵Alexey Botchkov2013-03-191-0/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | MultiPoint. Need to check if the number of points is 0 for the polygon.
| | * | MDEV-4296 Assertion `n_linear_rings > 0' fails in Gis_polygon::centroid_xy.Alexey Botchkov2013-03-191-0/+6
| | | | | | | | | | | | | | | | | | | | Forgotten DBUG_ASSERT should be replaced with the 'return error'.
| | * | MDEV-4269 fix.unknown2013-03-181-0/+14
| | | | | | | | | | | | | | | | Item_default_value inherited form Item_field so should create temporary table field similary.
View Lorry Controller Status