summaryrefslogtreecommitdiff
path: root/mysql-test
Commit message (Collapse)AuthorAgeFilesLines
* Merge debian.(none):/M50/rowlock-5.0joerg@debian.(none)2007-07-2683-5364/+0
|\ | | | | | | into debian.(none):/M50/push-5.0
| * Remove the "row_lock" suite from the sources.joerg@debian.(none)2007-07-2683-5364/+0
| | | | | | | | For more information, see WL#3866 and the bugs numbered 28685 and 20390.
* | Merge debian.(none):/M50/mysql-5.0joerg@debian.(none)2007-07-2621-659/+402
|\ \ | | | | | | | | | into debian.(none):/M50/push-5.0
| * | Updated/fixed test and result files to 5.0.46omer@linux.site2007-07-2421-659/+402
| |/ | | | | | | | | Note datadict files do not include wrong is_updatable wrong value as a result of bug 30020.
* | Merge gleb.loc:/home/uchum/work/bk/5.0gshchepa/uchum@gleb.loc2007-07-2612-6/+593
|\ \ | | | | | | | | | into gleb.loc:/home/uchum/work/bk/5.0-opt
| * | Bug#15130: CREATE .. SELECT was denied to use advantages of the SQL_BIG_RESULT.evgen@moonbone.local2007-07-242-0/+23
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | When the SQL_BIG_RESULT flag is specified SELECT should store items from the select list in the filesort data and use them when sending to a client. The get_addon_fields function is responsible for creating necessary structures for that. But this function was allowed to do so only for SELECT and INSERT .. SELECT queries. This makes the SQL_BIG_RESULT useless for the CREATE .. SELECT queries. Now the get_addon_fields allows storing select list items in the filesort data for the CREATE .. SELECT queries.
| * | Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-optgkodinov/kgeorge@magare.gmz2007-07-232-0/+77
| |\ \ | | | | | | | | | | | | into magare.gmz:/home/kgeorge/mysql/autopush/B29644-5.0-opt
| | * | Bug #29644: alter table hangs if records locked in share mode gkodinov/kgeorge@magare.gmz2007-07-202-0/+74
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | by long running transaction On Windows opened files can't be deleted. There was a special upgraded lock mode (TL_WRITE instead of TL_WRITE_ALLOW_READ) in ALTER TABLE to make sure nobody has the table opened when deleting the old table in ALTER TABLE. This special mode was causing ALTER TABLE to hang waiting on a lock inside InnoDB. This special lock is no longer necessary as the server is closing the tables it needs to delete in ALTER TABLE. Fixed by removing the special lock. Note that this also reverses the fix for bug 17264 that deals with another consequence of this special lock mode being used.
| * | | Fixed bug #29611.igor@olga.mysql.com2007-07-222-0/+48
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | If a primary key is defined over column c of enum type then the EXPLAIN command for a look-up query of the form SELECT * FROM t WHERE c=0 said that the query was with an impossible where condition though the query correctly returned non-empty result set when the table indeed contained rows with error empty strings for column c. This kind of misbehavior was due to a bug in the function Field_enum::store(longlong,bool) that erroneously returned 1 if the the value to be stored was equal to 0. Note that the method Field_enum::store(const char *from,uint length,CHARSET_INFO *cs) correctly returned 0 if a value of the error empty string was stored.
| * | | Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-5.0-optgkodinov/kgeorge@magare.gmz2007-07-222-0/+278
| |\ \ \ | | | | | | | | | | | | | | | into magare.gmz:/home/kgeorge/mysql/autopush/B28951-5.0-opt
| | * | | Bug #28591: MySQL need not sort the records in case of gkodinov/kgeorge@magare.gmz2007-07-202-0/+278
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ORDER BY primary_key on InnoDB table Queries that use an InnoDB secondary index to retrieve data don't need to sort in case of ORDER BY primary key if the secondary index is compared to constant(s). They can also skip sorting if ORDER BY contains both the the secondary key parts and the primary key parts (in that order). This is because InnoDB returns the rows in order of the primary key for rows with the same values of the secondary key columns. Fixed by preventing temp table sort for the qualifying queries.
| * | | | Merge ibabaev@bk-internal.mysql.com:/home/bk/mysql-5.0-optigor@olga.mysql.com2007-07-212-0/+2
| |\ \ \ \ | | | | | | | | | | | | | | | | | | into olga.mysql.com:/home/igor/mysql-5.0-opt
| | * \ \ \ Merge gleb.loc:/home/uchum/work/bk/5.0-opt-29338gshchepa/uchum@gleb.loc2007-07-222-0/+2
| | |\ \ \ \ | | | | | | | | | | | | | | | | | | | | | into gleb.loc:/home/uchum/work/bk/5.0-opt
| | | * | | | sp.test, sp.result:gshchepa/uchum@gleb.loc2007-07-222-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Additional test case fix for bug #29338.
| * | | | | | Merge olga.mysql.com:/home/igor/mysql-5.0-optigor@olga.mysql.com2007-07-212-2/+64
| |\ \ \ \ \ \ | | |/ / / / / | | | | | | | | | | | | | | into olga.mysql.com:/home/igor/dev-opt/mysql-5.0-opt-bug29911
| | * | | | | Merge gleb.loc:/home/uchum/work/bk/5.0-opt-29338gshchepa/uchum@gleb.loc2007-07-222-2/+64
| | |\ \ \ \ \ | | | |/ / / / | | | | | | | | | | | | | | into gleb.loc:/home/uchum/work/bk/5.0-opt
| | | * | | | Fixed bug #29338.gshchepa/uchum@gleb.loc2007-07-192-2/+63
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Optimization of queries with DETERMINISTIC functions in the WHERE clause was not effective: sequential scan was always used. Now a SF with the DETERMINISTIC flags is treated as constant when it's arguments are constants (or a SF doesn't has arguments).
| * | | | | | Merge olga.mysql.com:/home/igor/dev-opt/mysql-4.1-opt-bug29911igor@olga.mysql.com2007-07-212-0/+45
| |\ \ \ \ \ \ | | |/ / / / / | |/| | | | | | | | | | | | into olga.mysql.com:/home/igor/dev-opt/mysql-5.0-opt-bug29911
| | * | | | | Fixed bug #29911.igor@olga.mysql.com2007-07-202-0/+45
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | This bug manifested itself for join queries with GROUP BY and HAVING clauses whose SELECT lists contained DISTINCT. It occurred when the optimizer could deduce that the result set would have not more than one row. The bug could lead to wrong result sets for queries of this type because HAVING conditions were erroneously ignored in some cases in the function remove_duplicates.
| | * | | | | Merge sita.local:/Users/tsmith/m/bk/41tsmith@sita.local2007-07-092-2/+91
| | |\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | into sita.local:/Users/tsmith/m/bk/maint/41
| | * \ \ \ \ \ Merge maint1.mysql.com:/data/localhome/tsmith/bk/41tsmith@maint1.mysql.com2007-07-042-0/+40
| | |\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | into maint1.mysql.com:/data/localhome/tsmith/bk/maint/41
| | * \ \ \ \ \ \ Merge maint1.mysql.com:/data/localhome/tsmith/bk/41tsmith@maint1.mysql.com2007-06-263-4/+12
| | |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into maint1.mysql.com:/data/localhome/tsmith/bk/maint/41
| | | * \ \ \ \ \ \ Merge bk-internal:/home/bk/mysql-4.1-maintmsvensson@pilot.(none)2007-06-193-4/+12
| | | |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into pilot.(none):/data/msvensson/mysql/mysql-4.1-maint
| * | | \ \ \ \ \ \ \ Merge gleb.loc:/home/uchum/work/bk/5.0-opt-29788gshchepa/uchum@gleb.loc2007-07-212-4/+56
| |\ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into gleb.loc:/home/uchum/work/bk/5.0-opt
| | * | | | | | | | | | Fixed bug #29788.gshchepa/uchum@gleb.loc2007-07-212-4/+56
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | After dumping triggers mysqldump copied the value of the OLD_SQL_MODE variable to the SQL_MODE variable. If the --compact option of the mysqldump was not set the OLD_SQL_MODE variable had the value of the uninitialized SQL_MODE variable. So usually the NO_AUTO_VALUE_ON_ZERO option of the SQL_MODE variable was discarded. This fix is for non-"--compact" mode of the mysqldump, because mysqldump --compact never set SQL_MODE to the value of NO_AUTO_VALUE_ON_ZERO. The dump_triggers_for_table function has been modified to restore previous value of the SQL_MODE variable after dumping triggers using the SAVE_SQL_MODE temporary variable.
* | | | | | | | | | | | Merge bk-internal.mysql.com:/home/bk/mysql-5.0kostja@bodhi.(none)2007-07-248-2/+133
|\ \ \ \ \ \ \ \ \ \ \ \ | |_|_|_|_|_|_|_|_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | into bodhi.(none):/opt/local/work/mysql-5.0-runtime
| * | | | | | | | | | | Merge bk-internal.mysql.com:/home/bk/mysql-5.0kostja@bodhi.(none)2007-07-218-2/+133
| |\ \ \ \ \ \ \ \ \ \ \ | | |/ / / / / / / / / / | |/| | | | | | | | | | | | | | | | | | | | | | into bodhi.(none):/opt/local/work/mysql-5.0-runtime
| | * | | | | | | | | | Add a test case for Bug#22427 create table if not exists + stored kostja@bodhi.(none)2007-07-182-0/+45
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | function results in inconsistent behavior. The bug itself was fixed by the patch for bug 20662.
| | * | | | | | | | | | A fix and a test case for Bug#26104 Bug on foreign key class constructor.kostja@bodhi.(none)2007-07-184-2/+37
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix the typo in the constructor. Cover a semantic check that previously never worked with a test.
| | * | | | | | | | | | Add a test case for Bug#27248 Triggers: error if insert affects temporary kostja@bodhi.(none)2007-07-182-0/+51
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | table. The bug itself is yet another manifestation of Bug 26141.
* | | | | | | | | | | | Merge kboortz@bk-internal.mysql.com:/home/bk/mysql-5.0kent@kent-amd64.(none)2007-07-2130-19/+717
|\ \ \ \ \ \ \ \ \ \ \ \ | |/ / / / / / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/kent/bk/tmp3/mysql-5.0-build
| * | | | | | | | | | | Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-optevgen@moonbone.local2007-07-202-0/+20
| |\ \ \ \ \ \ \ \ \ \ \ | | |_|/ / / / / / / / / | |/| | | | | | | | | | | | | | | | | | | | | | into moonbone.local:/mnt/gentoo64/work/29898-bug-5.0-opt-mysql
| | * | | | | | | | | | Bug#29898: Item_date_typecast::val_int doesn't reset the null_value flag.evgen@moonbone.local2007-07-202-0/+20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The Item_date_typecast::val_int function doesn't reset null_value flag. This makes all values that follows the first null value to be treated as nulls and led to a wrong result. Now the Item_date_typecast::val_int function correctly sets the null_value flag for both null and non-null values.
| * | | | | | | | | | | Merge gleb.loc:/home/uchum/work/bk/5.0gshchepa/uchum@gleb.loc2007-07-2028-19/+697
| |\ \ \ \ \ \ \ \ \ \ \ | | |/ / / / / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | into gleb.loc:/home/uchum/work/bk/5.0-opt
| | * | | | | | | | | | Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-optevgen@moonbone.local2007-07-192-0/+20
| | |\ \ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into moonbone.local:/mnt/gentoo64/work/29850-bug-5.0-opt-mysql
| | | * | | | | | | | | | Bug#29850: Wrong charset of GROUP_CONCAT result when the select employsevgen@moonbone.local2007-07-192-0/+20
| | | | |_|_|_|_|_|_|_|/ | | | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | a temporary table. The result string of the Item_func_group_concat wasn't initialized in the copying constructor of the Item_func_group_concat class. This led to a wrong charset of GROUP_CONCAT result when the select employs a temporary table. The copying constructor of the Item_func_group_concat class now correctly initializes the charset of the result string.
| | * | | | | | | | | | Merge gleb.loc:/home/uchum/work/bk/5.0gshchepa/uchum@gleb.loc2007-07-1912-8/+1172
| | |\ \ \ \ \ \ \ \ \ \ | | | |/ / / / / / / / / | | |/| / / / / / / / / | | | |/ / / / / / / / into gleb.loc:/home/uchum/work/bk/5.0-opt
| | * | | | | | | | | Merge gleb.loc:/home/uchum/work/bk/5.0-opt-28524gshchepa/uchum@gleb.loc2007-07-192-10/+36
| | |\ \ \ \ \ \ \ \ \ | | | |_|_|_|_|_|_|_|/ | | |/| | | | | | | | | | | | | | | | | | | into gleb.loc:/home/uchum/work/bk/5.0-opt
| | | * | | | | | | | Fixed bug #28524.gshchepa/uchum@gleb.loc2007-07-182-10/+36
| | | | |_|_|_|_|_|/ | | | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | For each view the mysqldump utility creates a temporary table with the same name and the same columns as the view in order to satisfy views that depend on this view. After the creation of all tables, mysqldump drops all temporary tables and creates actual views. However, --skip-add-drop-table and --compact flags disable DROP TABLE statements for those temporary tables. Thus, it was impossible to create the views because of existence of the temporary tables with the same names.
| | * | | | | | | | Extended fix for the bug#29555.evgen@moonbone.local2007-07-152-0/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The get_time_value function is added. It is used to obtain TIME values both from items the can return time as an integer and from items that can return time only as a string. The Arg_comparator::compare_datetime function now uses pointer to a getter function to obtain values to compare. Now this function is also used for comparison of TIME values. The get_value_func variable is added to the Arg_comparator class. It points to a getter function for the DATE/DATETIME/TIME comparator.
| | * | | | | | | | Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-optevgen@moonbone.local2007-07-142-0/+28
| | |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into moonbone.local:/mnt/gentoo64/work/29729-bug-5.0-opt-mysql
| | | * | | | | | | | Bug#29729: Wrong conversion error led to an empty result set.evgen@moonbone.local2007-07-142-0/+28
| | | |/ / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | The Field_newdate::store when storing a DATETIME value was returning the 'value was cut' error even if the thd->count_cuted_fields flag is set to CHECK_FIELD_IGNORE. This made range optimizr think that there is no appropriate data in the table and thus to return an empty set. Now the Field_newdate::store function returns conversion error only if the thd->count_cuted_fields flag isn't set to CHECK_FIELD_IGNORE.
| | * | | | | | | | BUG#29740: Make the test result deterministicsergefp@mysql.com2007-07-142-14/+19
| | | | | | | | | |
| | * | | | | | | | Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.0-optsergefp@pylon64.mylan2007-07-142-0/+104
| | |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/psergey/mysql-5.0-bug29740
| | | * | | | | | | | BUG#29740: Wrong query results for index_merge/union over HEAP table.sergefp@mysql.com2007-07-132-0/+104
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | - return HA_KEY_SCAN_NOT_ROR flag for HASH indexes; - Fix ha_heap::cmp_ref() to work with BTREE index scans.
| | * | | | | | | | | Merge olga.mysql.com:/home/igor/mysql-5.0-rpligor@olga.mysql.com2007-07-1353-77/+1965
| | |\ \ \ \ \ \ \ \ \ | | | | |/ / / / / / / | | | |/| | | | | | | | | | | | | | | | | | into olga.mysql.com:/home/igor/dev-opt/mysql-5.0-opt-merge
| | | * | | | | | | | Merge gleb.loc:/home/uchum/work/bk/5.0gshchepa/uchum@gleb.loc2007-07-1314-4/+417
| | | |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into gleb.loc:/home/uchum/work/bk/5.0-opt
| | | | * | | | | | | | disabled the output of the full path in tesing bug 29325gkodinov/kgeorge@magare.gmz2007-07-132-2/+2
| | | | | | | | | | | |
| | | | * | | | | | | | Bug 29325: moved the test from create_not_windows to symlink.gkodinov/kgeorge@magare.gmz2007-07-134-60/+60
| | | | | | | | | | | |
| | | | * | | | | | | | Bug#29739: Incorrect time comparison in BETWEEN.evgen@moonbone.local2007-07-122-0/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Time values were compared by the BETWEEN function as strings. This led to a wrong result in cases when some of arguments are less than 100 hours and other are greater. Now if all 3 arguments of the BETWEEN function are of the TIME type then they are compared as integers.