summaryrefslogtreecommitdiff
path: root/mysql-test/t/cast.test
Commit message (Collapse)AuthorAgeFilesLines
* Fix for bug #6914 "Problems using time()/date() output in expressions".dlenev@brandersnatch.localdomain2004-12-301-0/+10
| | | | | | When we cast datetime value to DATE (TIME) type we should throw away its time (date) part. This was not done properly if CAST() function was used in datetime expressions.
* Bug #5228 ORDER BY CAST(enumcol) sorts incorrectly under certain conditionsbar@mysql.com2004-09-071-0/+13
|
* 1. New data types, from the user point of view:bar@bar.intranet.mysql.r18.ru2004-03-261-2/+2
| | | | | | | | | | | BINARY(N) and VARBIBARY(N) 2. More 4.0 compatibility and more BINARY keyword consistency: 2a. CREATE TABLE a (a CHAR(N) BINARY) is now synonym for CREATE TABLE a (a CHAR(N) COLLATE xxxx_bin) 2b. SELECT BINARY x is still synonin for SELECT x COLLATE xxxxx_bin.
* Bug 2701: Function CHARSET() inconsistencybar@bar.intranet.mysql.r18.ru2004-02-111-2/+0
| | | | | CONVERT3 was removed, it was for test purposes, and rather harmful.
* Added --compact to mysqlbinlogmonty@mysql.com2004-02-091-0/+9
| | | | | | | | | | Fixed output from mysqlbinlog when using --skip-comments Fixed warnings from valgrind Fixed ref_length when used with HEAP tables More efficent need_conversion() Fixed error handling in UPDATE with not updateable tables Fixed bug in null handling in CAST to signed/unsigned
* Fix for a bug #2422, where CONVERT(expr, cast) was masked bySinisa@sinisa.nasamreza.org2004-01-221-0/+1
| | | | CONVERT(expr, expr, expr);
* Bug 2202: CAST from binary to char still returns a binary stringbar@bar.intranet.mysql.r18.ru2003-12-251-0/+13
|
* added code covarage for functions convert(), nullif(), crc32(), ↵bell@sanja.is.com.ua2003-10-301-0/+1
| | | | | | | | 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)
* CAST(expr AS CHAR(10)) is now working bar@bar.mysql.r18.ru2003-08-211-0/+41
|
* mysqlshow and mysqldump now send their vharacter set to serverbar@bar.mysql.r18.ru2003-05-301-0/+1
| | | | character_set_results is now the same with character_set_client by default
* CAST(expr AS char) now supports character set with conversion:bar@bar.mysql.r18.ru2003-05-281-0/+9
| | | | SELECT CAST(_latin1'string' AS CHAR CHARACTER SET latin2)
* Fixing crashing bugs as reported in bugs database Sinisa@sinisa.nasamreza.org2003-03-281-0/+1
| | | | #195
* Fixing a bug #195Sinisa@sinisa.nasamreza.org2003-03-271-0/+1
| | | | Fixing UNION's popping up in slow query log
* Added new ANSI functions LOCALTIME, LOCALTIMESTAMP and CURRENT_USERmonty@mashka.mysql.fi2002-11-241-0/+22
Added CEIL as an alias for CEILING Cleaned up CHECK constraint handling. (We don't anymore require braces after CHECK) Added casting to CHAR.