summaryrefslogtreecommitdiff
path: root/mysql-test/r
Commit message (Collapse)AuthorAgeFilesLines
* 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.
| | * | MDEV-4252 geometry query crashes server.Alexey Botchkov2013-03-181-0/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Additional fixes for possible overflows in length-related calculations in 'spatial' implementations. Checks added to the ::get_data_size() methods. max_n_points decreased to occupy less 2G size. An object of that size is practically inoperable anyway.
| | * | MDEV-4289 Assertion `0' fails in make_sortkey with GROUP_CONCAT, MAKE_SET, ↵Sergei Golubchik2013-03-181-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | GROUP BY Item_func_make_set wasn't taking into account the first argument when calculating maybe_null. sql/item_strfunc.cc: rewrite Item_func_make_set, removing separate storage of the first argument sql/item_strfunc.h: rewrite Item_func_make_set, removing separate storage of the first argument
| | * | MDEV-4252 geometry query crashes server.Alexey Botchkov2013-03-101-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The bug was found by Alyssa Milburn. If the number of points of a geometry feature read from binary representation is greater than 0x10000000, then the (uint32) (num_points * 16) will cut the higher byte, which leads to various errors. Fixed by additional check if (num_points > max_n_points).
* | | | MDEV-4292 fix.unknown2013-03-261-10/+81
| | | | | | | | | | | | | | | | Fixed printing column_get finction.
* | | | MDEV-4310 geometry function equals hangs forever.Alexey Botchkov2013-03-221-12/+29
| | | | | | | | | | | | | | | | | | | | | | | | The Geometry::get_mbr() function can return an error on a bad data. We have to check for that and act respectively.
* | | | MergeSergey Petrunya2013-03-211-0/+130
|\ \ \ \ | |_|_|/ |/| | |
| * | | MDEV-4277: Crash inside mi_killed_in_mariadb() with myisammrgSergey Petrunya2013-03-211-0/+130
| | | | | | | | | | | | | | | | | | | | - Set MI_INFO::external_ref for MyISAM tables that are parts of myisamMRG table.
* | | | MDEV-4293 Valgrind warnings (Conditional jump or move depends on ↵Sergei Golubchik2013-03-201-0/+12
|/ / / | | | | | | | | | | | | | | | uninitialised value) in remove_eq_conds on time functions with NULL argument val_int() is expected to return 0 for NULL's
* | | MDEV-4283 Assertion `scale <= precision' fails in strings/decimal.cSergei Golubchik2013-03-181-0/+12
| | | | | | | | | | | | | | | | | | | | | | | | with decimals=NOT_FIXED_DEC it is possible to have 'decimals' larger than 'max_length', it's not an error for temporal functions. But when Item_func_numhybrid converts the value to DECIMAL_RESULT, it must limit 'decimals' to be a valid scale of a decimal number.
* | | MDEV-4286 Server crashes in Protocol_text::store, stack smashing detectedSergei Golubchik2013-03-171-0/+7
| | | | | | | | | | | | | | | | | | AVG() returns a double, its max_length is reasonably limited by a double number length, even if the argument is many Kbytes long.
* | | MDEV-4281 Assertion `maybe_null && item->null_value' fails in make_sortkey ↵Sergei Golubchik2013-03-177-20/+35
| | | | | | | | | | | | | | | | | | on CASE with different return types, GROUP_CONCAT, GROUP BY Fix Item::get_date() to mark the item NULL when returning an error.
* | | Fixed bug mdev-4250.Igor Babaev2013-03-083-0/+60
| | | | | | | | | | | | | | | | | | This is a bug in the legacy code. It did not manifest itself because it was masked by other bugs that were fixed by the patches for mdev-4172 and mdev-4177.
* | | MDEV-4241 fix.unknown2013-03-061-0/+15
| | | | | | | | | | | | | | | Field_enum incorrectly inherited decimals() from Field_string. Field_enum should be always integer in numeric context.
* | | MergeIgor Babaev2013-02-281-0/+51
|\ \ \
| * | | Fixed bug mdev-4209Igor Babaev2013-02-281-0/+51
| | | | | | | | | | | | | | | | | | | | | | | | Do not include BLOB fields into the key to access the temporary table created for a materialized view/derived table. BLOB components are not allowed in keys.
View Lorry Controller Status