summaryrefslogtreecommitdiff
path: root/mysql-test/r/case.result
Commit message (Collapse)AuthorAgeFilesLines
* Mergesergefp@mysql.com2005-06-231-0/+15
|\
| * Fix for BUG#10151: In Item_func_case::find_item don't assume that parameter ↵sergefp@mysql.com2005-06-201-0/+15
| | | | | | | | str != &(this->str_value)
| * 1. Item now uses my_charset_bin by default,bar@mysql.com2005-01-181-6/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | not default_charset_into. It fixes the problem that in some cases numbers where treated as CHAR(N), not as BINARY(N), e.g. wrong 'charsetnr' when sent to the client side. 2. IFNULL didn't aggregate argument charsets and collations, so IFNULL(1,'a') produced a CHAR(N). Now produces a BINARY(N). 3. SELECT PROCEDURE ANALIZE now returns BINARY columns, which is much better than it worked previously: CHAR with the default character set. But in the future it's worth to fix the fields 'Field_name' and 'Optimal_fieldtype' to use UTF8, and 'Min_value' and 'Max_value' to inherit their charsets from the original items. But it is not important, and BINARY(N) is OK for now. 4. Tests were fixed accordingly. No new tests were made, as the old onces cover everything.
* | item_func.h:igor@igor-inspiron.creware.com2005-06-021-0/+17
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed bug #9939: a wrong conversion of arguments for functions COALESCE and IFNULL. The str_op virtual method was added into Item_func_numhybrid. item_func.cc: Fixed bug #9939: a wrong conversion of arguments for functions COALESCE and IFNULL. The str_op virtual method was added into Item_func_numhybrid. item_cmpfunc.h, item_cmpfunc.cc: Fixed bug #9939: a wrong conversion of arguments for functions COALESCE and IFNULL. Item_func_coalesce and Item_func_ifnull now inherit from a modified Item_func_numhybrid. case.test, case.result: Added test cases for bug #9939.
* | Tests and results fixed with last precision/decimal related modificationsholyfoot@hf-ibm.(none)2005-05-061-5/+5
| |
* | Precision Math implementationhf@deer.(none)2005-02-091-9/+15
| |
* | After-merge clean-upbar@mysql.com2005-01-181-6/+6
| |
* | Update results for new varchar handlingmonty@mysql.com2004-12-071-10/+10
| | | | | | | | | | Fixed compiler warnings String results in CREATE ... SELECT are now created as CHAR(0), VARCHAR(X) or TEXT() depending on item->max_length
* | fixed open_and_lock_tables result processing (all open_and_lock_tables revision)bell@sanja.is.com.ua2004-08-311-1/+1
| | | | | | | | | | fixed printing of COLLATE operation (BUG#5155)
* | mark subquery in the FROM clause like derived and quoate all identifiers ↵bell@sanja.is.com.ua2004-07-201-1/+1
|/ | | | (BUG#4609)
* fixed flags of printed querybell@sanja.is.com.ua2004-05-131-3/+3
|
* WorkLog#1323antony@ltantony.rdg.cyberkinetica.homeunix.net2003-12-101-2/+2
| | | | Deprecate the use of TYPE=... Preferred syntax is ENGINE=
* Merge key cache structures to onemonty@mysql.com2003-11-201-9/+11
| | | | Fixed compiler warnings (IRIX C compiler and VC++)
* CLIENT_MULTI_QUERIES -> CLIENT_MULTI_STATEMENTSmonty@mashka.mysql.fi2003-11-181-2/+2
| | | | | | | | | | New multi-key-cache handling. This was needed becasue the old one didn't work reliable with MERGE tables. ALTER TABLE table_name ... CHARACTER SET ... now changes all char/varchar/text columns to the given character set (One must use ALTER TABLE ... DEFAULT CHARACTER SET ... to change the default character set) Fixed that have_compress is detected properly (fixes problems with func_compress.test on platforms without zlib) New syntax for CACHE INDEX ('keys' is optional if no index name is given and one mentions the key cache name only ones) Removed compiler warnings Added mysql_set_server_option() to allow clients like PHP to easaily set/reset the multi-statement flag.
* added code covarage for functions convert(), nullif(), crc32(), ↵bell@sanja.is.com.ua2003-10-301-0/+18
| | | | | | | | is_used_lock(), char_lengtrh(), bit_xor() added string length for more speed made code covarage for print() method of Item fixed printability of some items (SCRUM) (WL#1274)
* Some fixes in CASE.bar@bar.mysql.r18.ru2003-07-181-2/+44
| | | | Test suit was extended to conver various arguments mixes.
* COALESCE now aggregates its argument types in this way:bar@bar.mysql.r18.ru2003-07-141-0/+21
| | | | | | if some of the arguments is STRING_RESULT the STRING_RESULT else if some of the arguments is REAL_RESULT then REAL_RESULT else INT_RESULT
* Merge with 4.0.8monty@mashka.mysql.fi2003-01-031-0/+8
|\
| * Test cleanupmonty@mashka.mysql.fi2002-12-261-2/+1
| |
| * Update of test resultsmonty@mashka.mysql.fi2002-12-261-0/+5
| |
| * Merge with 3.23:monty@mashka.mysql.fi2002-12-211-0/+4
| |\ | | | | | | | | | | | | Remove duplicate casedn_str() in mysql_change_db() Fix for null handling in CASE
| | * fix for a bug in CASE ...WHEN ...Sinisa@sinisa.nasamreza.org2002-12-161-0/+4
| | |
* | | rename of net_pkg.cc to protocol.ccmonty@mashka.mysql.fi2002-12-111-2/+2
|/ / | | | | | | | | Class for sending data from server to client (Protocol) This handles both the old ( <= 4.0 ) protocol and then new binary protocol that is used for prepared statements.
* | client/mysqlmanagerc.csasha@mysql.sashanet.com2001-09-271-0/+23
|/ | | | | | | | | | | | | | added support for quiet increased line buffer size client/mysqltest.c fixed memory leak added query logging to result file added error message logging to result file added enable_query_log/disable_query_log mysql-test/mysql-test-run.sh converted tests to use mysqlmanager Updated test results
* New myisamchk option --sort-recovermonty@donna.mysql.com2001-01-311-0/+8
| | | | | | | | Allow delete of crashed MyISAM tables Fixed bug when BLOB was first part of key Fixed bug when using result from CASE in GROUP BY Fixed core-dump bug in monthname() Optimized calling of check_db_name()
* Added support for hex strings to mysqlimportmonty@donna.mysql.com2000-12-281-0/+34
A lot of new tests to mysqltest Fixed bug with BDB tables and autocommit
View Lorry Controller Status