summaryrefslogtreecommitdiff
path: root/mysql-test
Commit message (Collapse)AuthorAgeFilesLines
* BUG#14480: post-fix: use the default field value from CREATE list too. sergefp@mysql.com2005-11-092-0/+18
|
* Merge mysql.com:/home/psergey/mysql-4.1-bug13814sergefp@mysql.com2005-11-082-0/+36
|\ | | | | | | into mysql.com:/home/psergey/mysql-4.1-nov08-push
| * Fix for BUG#13814: in mi_pack_key(), when processing NULL value for TINYBLOB ↵sergefp@mysql.com2005-10-282-0/+36
| | | | | | | | | | | | key segment, do advance the source pointer over 2 bytes that specify value length.
* | Merge mysql.com:/home/psergey/mysql-4.1-bug14480sergefp@mysql.com2005-11-082-2/+130
|\ \ | | | | | | | | | into mysql.com:/home/psergey/mysql-4.1-nov08-push
| * | BUG#14480, attempt2: In CREATE ... SELECT ..., don't count the same field twicesergefp@mysql.com2005-11-072-2/+130
| | | | | | | | | | | | when calculating table->null_fields.
* | | Fix Bug#14672 Bug in deletionpetr@mysql.com2005-11-062-0/+46
| | |
* | | Fix Bug#13894 Server crashes on update of CSV tablepetr@mysql.com2005-11-052-0/+38
| | |
* | | Merge ua141d10.elisa.omakaista.fi:/home/my/bk/mysql-4.0jani@ua141d10.elisa.omakaista.fi2005-11-031-3/+3
|\ \ \ | | | | | | | | | | | | into ua141d10.elisa.omakaista.fi:/home/my/bk/mysql-4.1
| * | | Changed mysql-test-run to correspond to the one in 5.0 tree.jani@ua141d10.elisa.omakaista.fi2005-11-031-2/+2
| | | |
* | | | Merge bk@192.168.21.1:mysql-4.1holyfoot@mysql.com2005-11-033-2/+19
|\ \ \ \ | | | | | | | | | | | | | | | into mysql.com:/home/hf/work/mysql-4.1.14183
| * \ \ \ Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-4.1evgen@moonbone.local2005-11-012-0/+17
| |\ \ \ \ | | | | | | | | | | | | | | | | | | into moonbone.local:/work/14186-bug-4.1-mysql
| | * | | | Fix bug#14186 select datefield is null not updatedevgen@moonbone.local2005-10-282-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Date field was declared as not null, thus expression 'datefield is null' was always false. For SELECT special handling of such cases is used. There 'datefield is null' converted to 'datefield eq "0000-00-00"'. In mysql_update() before creation of select added remove_eq_conds() call. It makes some optimization of conds and in particular performs conversion from 'is null' to 'eq'. Also remove_eq_conds() makes some evaluation of conds and if it founds that conds is always false then update statement is not processed further. All this allows to perform some update statements process faster due to optimized conds, and not wasting resources if conds known to be false.
| * | | | | Review of new pushed codemonty@mysql.com2005-11-011-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Removed wrong fix for bug #14009 (use of abs() on null value causes problems with filesort) Mark that add_time(), time_diff() and str_to_date() can return null values
* | | | | | Fix for bug #14183 (ctype_cp983.test fails with the embedded server)hf@deer.(none)2005-11-014-39/+54
|/ / / / /
* | | | | Merge bk@192.168.21.1:/usr/home/bk/mysql-4.1hf@deer.(none)2005-10-312-0/+9
|\ \ \ \ \ | |_|_|/ / |/| | | | | | | | | into deer.(none):/home/hf/work/mysql-4.1.12839
| * | | | Fix for bug #12839 (Endian support is absurd)hf@deer.(none)2005-09-212-0/+9
| | | | |
* | | | | Merge bk-internal:/home/bk/mysql-4.1jimw@mysql.com2005-10-284-1/+41
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | into mysql.com:/home/jimw/my/mysql-4.1-clean
| * \ \ \ \ Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-4.1patg@krsna.patg.net2005-10-284-1/+41
| |\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | into krsna.patg.net:/home/patg/mysql-build/mysql-4.1
| | * \ \ \ \ Merge pgalbraith@bk-internal.mysql.com:/home/bk/mysql-4.1patg@krsna.patg.net2005-10-264-1/+41
| | |\ \ \ \ \ | | | |_|/ / / | | |/| | | | | | | | | | | into krsna.patg.net:/home/patg/mysql-build/mysql-4.1
| | | * | | | BUG# 12123patg@krsna.patg.net2005-10-254-1/+41
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Made change to mysqlimport to set character_set_database to binary to make importing various charsets/columns work correctly.
* | | | | | | Merge mysql.com:/home/jimw/my/mysql-4.1-13796jimw@mysql.com2005-10-281-0/+1
|\ \ \ \ \ \ \ | |/ / / / / / |/| | | | | | | | | | | | | into mysql.com:/home/jimw/my/mysql-4.1-clean
| * | | | | | Force a server restart for the not_embedded_server test to satisfyjimw@mysql.com2005-10-131-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | conditions of its first test. (Bug #13796)
* | | | | | | Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1sergefp@mysql.com2005-10-282-0/+19
|\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/psergey/mysql-4.1-bug14139
| * | | | | | | BUG#14139: When handling "CREATE TABLE(field_X type_spec,...) SELECT smth AS ↵sergefp@mysql.com2005-10-262-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | field_X, ...." avoid multiplying length of field_X by charset->mbmaxlen twice when calculating space required for field_X in the new table.
* | | | | | | | Fix bug #14138 ROLLUP and PROCEDURE ANALYSE() hang server evgen@moonbone.local2005-10-282-0/+51
| |_|_|_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Procedure analyse() redefines select's fields_list. setup_copy_fields() assumes that fields_list is a part of all_fields_list. Because select have only 3 columns and analyse() redefines it to have 10 columns, int overrun in setup_copy_fields() occurs and server goes to almost infinite loop. Because fields_list used not only to send data ad fields types, it's wrong to allow procedure redefine it. This patch separates select's fileds_list and procedure's one. Now if procedure is present, copy of fields_list is created in procedure_fields_list and it is used for sending data and fields.
* | | | | | | Merge mysql.com:/home/jimw/my/mysql-4.1-14009jimw@mysql.com2005-10-2726-9/+384
|\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/jimw/my/mysql-4.1-clean
| * | | | | | | select.result:evgen@moonbone.local2005-10-271-8/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | After merge fix
| * | | | | | | Manually mergedevgen@moonbone.local2005-10-272-0/+17
| |\ \ \ \ \ \ \ | | | |_|_|_|_|/ | | |/| | | | |
| | * | | | | | Merge mysql.com:/Users/kent/mysql/bk/mysql-4.0-build-threadkent@mysql.com2005-10-251-0/+17
| | |\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/Users/kent/mysql/bk/mysql-4.0
| | * | | | | | | Fix bug #13855 select distinct with group by caused server crashevgen@moonbone.local2005-10-142-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | DISTINCT wasn't optimized away and caused creation of tmp table in wrong case. This result in integer overrun and running out of memory. Fix backported from 4.1. Now if optimizer founds that in result be only 1 row it removes distinct.
| * | | | | | | | Merge abarkov@bk-internal.mysql.com:/home/bk/mysql-4.1bar@mysql.com2005-10-272-0/+44
| |\ \ \ \ \ \ \ \ | | |_|_|_|_|/ / / | |/| | | | | | | | | | | | | | | | into mysql.com:/usr/home/bar/mysql-4.1.b13347
| | * | | | | | | Bug#13347: empty result from query with like and cp1250 charsetbar@mysql.com2005-10-252-0/+44
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ctype-win1250ch.c: Like range prefix tables were wrong. ctype_cp1250_ch.result, ctype_cp1250_ch.test: Adding test case.
| * | | | | | | | mysql-test-run.pl:kent@mysql.com2005-10-261-3/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added MTR_BUILD_THREAD to control the port range
| * | | | | | | | Merge kboortz@bk-internal.mysql.com:/home/bk/mysql-4.1kent@mysql.com2005-10-255-2/+38
| |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/Users/kent/mysql/bk/mysql-4.1
| | * \ \ \ \ \ \ \ Merge mysql.com:/home/jimw/my/mysql-4.1-12925jimw@mysql.com2005-10-251-2/+2
| | |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/jimw/my/mysql-4.1-clean
| | | * | | | | | | | Fix incorrect casts in my_getopt code that capped the maximum of longlongjimw@mysql.com2005-10-251-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | options to the wrong value. (Bug #12925)
| | * | | | | | | | | Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-4.1evgen@moonbone.local2005-10-252-0/+16
| | |\ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into moonbone.local:/work/14016-bug-4.1-mysql
| | | * | | | | | | | | Fix bug #14016 date_format() 2nd parameter was compared using case insensitive evgen@moonbone.local2005-10-252-0/+16
| | | | |/ / / / / / / | | | |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | collation By default constant strings in second parameter of date_time() have case insensitive collation. Because of this expressions date_format(f,'%m') and date_format(f,'%M') wrongly becomes equal, which results in choosing wrong column to sort by. Now if second parameter of date_format() is constant then it's collation is changed to case sensitive.
| | * | | | | | | | | Fix bug#13392 Wrong VALUES() behaviour in INSERT SELECT with ON DUPLICATEevgen@moonbone.local2005-10-252-0/+20
| | |/ / / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | VALUES() can only refer to table insert going to. But Item_insert_value::fix_fields() were passing to it's arg full table list, This results in finding second column which shouldn't be found, and failing with error about ambiguous field. Item_insert_value::fix_fields() now passes only first table of full table list.
| * | | | | | | | | Merge mysql.com:/Users/kent/mysql/bk/mysql-4.0-build-threadkent@mysql.com2005-10-251-0/+19
| |\ \ \ \ \ \ \ \ \ | | |/ / / / / / / / | |/| | | / / / / / | | | |_|/ / / / / | | |/| | | | | | into mysql.com:/Users/kent/mysql/bk/mysql-4.1
| | * | | | | | | Makefile.am:kent@mysql.com2005-10-251-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Option to set environment variable MTR_BUILD_THREAD to a small number, from what mysql-test-run calculate port numbers that will not conflict with other runs with different thread num
| * | | | | | | | Added more tests for new UPDATE ... ORDER BY ... LIMIT optimizationmonty@mysql.com2005-10-252-12/+32
| | | | | | | | |
| * | | | | | | | Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-4.1sergefp@mysql.com2005-10-232-0/+51
| |\ \ \ \ \ \ \ \ | | |_|_|_|/ / / / | |/| | | | | | | | | | | | | | | | into mysql.com:/home/psergey/mysql-4.1-nulls-stats-r2
| | * | | | | | | BUG#9622, stage 2, work together with fix for BUG#12232:sergefp@mysql.com2005-10-212-0/+51
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | added "nulls_ignored" index statistics collection method for MyISAM tables. (notification trigger: this is about BUG#9622).
| * | | | | | | | Fix merge of test that left out a drop table.jimw@mysql.com2005-10-212-0/+2
| | | | | | | | |
| * | | | | | | | Merge mysql.com:/home/jimw/my/mysql-4.1-11203jimw@mysql.com2005-10-213-1/+20
| |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into mysql.com:/home/jimw/my/mysql-4.1-clean
| | * | | | | | | | Fix LOAD DATA to handle having the escape and enclosed-by characterjimw@mysql.com2005-06-223-0/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | be the same. (Bug #11203)
| * | | | | | | | | Bug#13233bar@mysql.com2005-10-212-0/+18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | select distinct char(column) fails with utf8 ctype_utf8.result, ctype_utf8.test: Adding test case sql_yacc.yy: Adding new syntax. item_strfunc.h: Fixing wrong max_length calculation. Also, adding CHAR(x USING charset), for easier migrating from 4.1 to 5.0, according to Monty's suggestion.
| * | | | | | | | | Merge bk-internal.mysql.com:/home/bk/mysql-4.1msvensson@neptunus.(none)2005-10-202-0/+20
| |\ \ \ \ \ \ \ \ \ | | |_|_|_|_|_|_|/ / | |/| | | | | | | | | | | | | | | | | | into neptunus.(none):/home/msvensson/mysql/mysql-4.1
| | * | | | | | | | Merge neptunus.(none):/home/msvensson/mysql/mysql-4.1msvensson@neptunus.(none)2005-10-132-0/+20
| | |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | into neptunus.(none):/home/msvensson/mysql/bug12698/my41-bug12698