summaryrefslogtreecommitdiff
path: root/mysql-test/r/index_intersect_innodb.result
Commit message (Collapse)AuthorAgeFilesLines
* fix main.index_intersect_innodb failure on trusty-amd64Sergei Golubchik2016-09-211-2/+2
|
* MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be ↵Oleksandr Byelkin2015-09-041-1/+1
| | | | stopped with no-zero size)
* MDEV-5244: Make extended_keys=ON by default in 10.0Sergey Petrunya2014-02-251-8/+8
| | | | | | | | | - Change the default flag value to ON. - Update the testcases to be run extended_keys=ON: = trivial test result updates = If extended_keys setting makes a difference for a testcase, run the testcase with extended_keys=off. There were only a few such cases - Update to vcol_select_innodb looks like a worse plan but it will be gone in 10.0.
* pbxt suite is now a main-pbxt overlaySergei Golubchik2012-02-291-4/+4
|
* merge with 5.3Sergei Golubchik2011-10-191-2/+2
| | | | | | | | | | | | | sql/sql_insert.cc: CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. ****** CREATE ... IF NOT EXISTS may do nothing, but it is still not a failure. don't forget to my_ok it. sql/sql_table.cc: small cleanup ****** small cleanup
* Fixed compiler warnings and test cases problems found by buildbotMichael Widenius2011-05-111-1/+1
| | | | | | | | | | | | | | | | | | | | | | mysql-test/r/dyncol.result: Updated test results mysql-test/r/index_intersect.result: Updated results mysql-test/r/index_intersect_innodb.result: Updated results mysql-test/t/dyncol.test: Added replace_result for floating point results that are different on windows Added round() around a result to get same result on all platforms. mysql-test/t/index_intersect.test: Added replace_result to fix that index_merge may put key names in different order. mysys/ma_dyncol.c: Fixed compiler warnings on Solaris sql/key.cc: Fixed compiler warnings on Solaris sql/mysqld.cc: Fixed compiler warning on windows support-files/compiler_warnings.supp: Suppressed an unintersting warning on Solaris
* Fixed LP bug #754521.Igor Babaev2011-04-271-0/+7
| | | | | | | | | | | The function test_quick_select by mistake did not update the value of table->quick_condition_rows for index intersection scans though the specification explicitly required to do so from any table access plan once the plan provided a better upper bound for the number of rows selected from the table. It resulted in a bogus, usually very big number saved as the cost of the table access. This, in its turn, in many cases forced the optimizer to make a bad choice of the execution plan for join queries.
* Fixed compiler warnings and some test failures found by buildbotMichael Widenius2011-02-231-22/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | dbug/dbug.c: Fixed compiler warnings on windows mysql-test/r/index_intersect_innodb.result: Don't print number of rows as this varies mysql-test/suite/funcs_1/r/processlist_val_no_prot.result: Update to use new State mysql-test/suite/handler/heap.result: Update results mysql-test/suite/handler/heap.test: Changed key used in test as the key 'b' will not guarantee order of the two last elements (as the key value is the same) mysql-test/suite/pbxt/r/lock_multi.result: Update to use new State mysql-test/t/index_intersect.test: Don't print number of rows as this varies mysql-test/valgrind.supp: Added suppression for linux mysys/hash.c: Fixed compiler warnings on windows plugin/handler_socket/handlersocket/database.cpp: Fixed compiler warnings sql-common/client_plugin.c: Changed variable to define to avoid compiler warnings when variable is not used sql-common/my_time.c: Initialize all my_time elements to avoid compiler warnings storage/oqgraph/ha_oqgraph.cc: Use right function (to avoid compiler warning) storage/pbxt/src/table_xt.cc: Initialize variables (to avoid compiler warnings)
* Fixed typo that caused printing 'range' instead of 'index_merge' as the typeIgor Babaev2011-01-221-22/+22
| | | | | of sort_intersect scans.
* MergeIgor Babaev2010-12-271-31/+28
|
* Post-review fixes.Igor Babaev2010-12-221-79/+69
|
* Fixed LP bug#684086.Igor Babaev2010-12-051-0/+33
| | | | | | | | | If a primary key was used in the index intersection for an InnoDB database the size of the memory allocated for the best index intersection plan was one element less than it was needed. That could cause a memory overwrite and a crash as a result of it.
* Changed the queries of index_intersect.test to ensure platform Igor Babaev2010-12-031-224/+319
| | | | | | | | | independent execution plans. Fixed a bug in Unique::unique_add that caused a crash for a query from index_intersect_innodb on some platforms. Fixed two bugs in opt_range.cc that led to the choice of not the cheapest plans for index intersections.
* MWL #21: "index_merge: non-ROR intersection".Igor Babaev2010-12-011-0/+923
The second (final) patch.