summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_str.test
Commit message (Collapse)AuthorAgeFilesLines
* Create 'main' test directory and move 't' and 'r' thereMichael Widenius2018-03-291-1918/+0
|
* Merge 10.2 into bb-10.2-extMarko Mäkelä2017-12-141-9/+21
|\
| * Merge 10.1 into 10.2Marko Mäkelä2017-12-141-1/+12
| |\
| | * Merge 10.0 into 10.1Marko Mäkelä2017-12-121-1/+12
| | |\
| | | * MDEV-12681 Wrong VIEW results for CHAR(0xDF USING latin1)Alexander Barkov2017-11-151-0/+12
| | | |
* | | | MDEV-13555 Assertion `!item->null_value' failed in Type_handler::Item_send_strAlexander Barkov2017-08-171-0/+12
| | | |
* | | | MDEV-12803 Improve function parameter data type controlAlexander Barkov2017-05-291-1/+1
| | | |
* | | | MDEV-12783 : sql_mode=ORACLE: Functions LENGTH() and LENGTHB()halfspawn2017-05-181-0/+5
| | | |
* | | | MDEV-12685 Oracle-compatible function CHR()halfspawn2017-05-081-0/+10
| | | |
* | | | MDEV-12658 Make the third parameter to LPAD and RPAD optionalhalfspawn2017-05-031-1/+52
| | | |
* | | | MDEV-12592 Illegal mix of collations with the HEX functionAlexander Barkov2017-04-271-0/+20
| | | | | | | | | | | | | | | | Fixing repertoire for HEX() from MY_REPERTOIRE_EXTENDED to MY_REPERTOIRE_ASCII.
* | | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2017-02-271-2/+2
|\ \ \ \ | |/ / /
| * | | MDEV-7635: Update tests to adapt to the new default sql_modeNirbhay Choubey2017-02-101-2/+2
| |/ /
* | | Merge remote-tracking branch 'origin/10.2' into bb-10.2-extAlexander Barkov2016-12-301-0/+18
|\ \ \ | |/ /
| * | MDEV-10864 Wrong result for WHERE .. (f2=COMPRESS('test') OR ↵Alexander Barkov2016-09-221-0/+12
| | | | | | | | | | | | f2=COMPRESS('TEST'))
| * | MDEV-10425 Assertion `collation.derivation == DERIVATION_IMPLICIT' failed in ↵Alexander Barkov2016-09-221-0/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Item_func_conv_charset::fix_length_and_dec() MDEV-10850 Wrong result for WHERE .. (f2=TO_BASE64('test') OR f2=TO_BASE64('TEST')) Problem N1: MDEV-10425 Item_func_{md5|sha|sha2}::fix_length_and_dec() changed args[0]->collation to force binary comparison in args[0]->eq(). It was done to treat e.g. MD5('a') and MD5('A') as different values. It is wrong for a Item_func_xxx to modify its arguments. Item_func_conv_charset did not expect that and crashed on assert. Problem N2: MDEV-10850 Item_func_to_base64, Item_func_password, Item_func_hex are also case sensitive hash functions, but they did not compare their arguments as binary. Solution: - Removing the code changing args[0]->collation - Introducing Item_str_ascii_checksum_func as a common parent for Item_func_{md5|sha|sha2|password|hex|to_base64} and overriding its eq() method to compare arguments binary.
* | | An after-fix for MDEV-11478: fixing the error codeAlexander Barkov2016-12-291-1/+1
| | |
* | | MDEV-11478 Result data type aggregation for pluggable data typesAlexander Barkov2016-12-291-0/+2
|/ /
* | MDEV-9332 Bug after upgrade to 10.1.10Alexander Barkov2016-01-271-0/+10
| |
* | MDEV-8806 Numeric CAST produce different warnings for strings literals vs ↵Alexander Barkov2015-09-251-2/+7
| | | | | | | | functions
* | MDEV-8369 Unexpected impossible WHERE for a condition on a ZEROFILL fieldAlexander Barkov2015-09-111-0/+21
| | | | | | | | | | Disable IDENTITY_SUBST propagation for ZEROFILL columns, as discussed with Sergei.
* | MDEV-6066: Merge new defaults from 5.6 and 5.7 (defaults changed, QC can be ↵Oleksandr Byelkin2015-09-041-1/+8
| | | | | | | | stopped with no-zero size)
* | MDEV-8281 aes_decrypt crashes in block_crypt()Sergei Golubchik2015-06-271-0/+1
|/ | | | fix aes_decrypt of yassl to support zero-length input
* MDEV-6044 MySQL BUG#12735829 - SPACE() FUNCTION WARNING REFERS TO REPEAT() ↵Alexander Barkov2014-09-041-0/+23
| | | | | | | IN ER_WARN_ALLOWED_PACKET_OVERFLOWED Merged from 5.6
* 5.5.39 mergeSergei Golubchik2014-08-071-0/+5
|\
| * mysql-5.5.39 mergeSergei Golubchik2014-08-021-0/+5
| |\ | | | | | | | | | | | | | | | | | | ~40% bugfixed(*) applied ~40$ bugfixed reverted (incorrect or we're not buggy) ~20% bugfixed applied, despite us being not buggy (*) only changes in the server code, e.g. not cmakefiles
* | | MDEV-6046: MySQL Bug#11766684 59851: UNINITIALISED VALUE IN ↵unknown2014-06-041-0/+12
| | | | | | | | | | | | ITEM_FUNC_LIKE::SELECT_OPTIMIZE WITH SUBQUERY AND
* | | 5.5 mergeSergei Golubchik2014-05-091-0/+28
|\ \ \ | |/ /
| * | Merge from 5.3Alexander Barkov2014-04-211-0/+28
| |\ \
| | * | MDEV-6045 MySQL Bug#11829861 - SUBSTRING_INDEX() RESULTS "OMIT" CHARACTER ↵Alexander Barkov2014-04-211-0/+27
| | | | | | | | | | | | | | | | WHEN USED INSIDE LOWER()
| | * | 5.2 mergeSergei Golubchik2014-03-161-2/+4
| | |\ \
| | | * \ mysql-5.1.73 mergeSergei Golubchik2014-03-151-2/+4
| | | |\ \
* | | | | | Merging TO_BASE64() and FROM_BASE64() from MySQL-5.6Alexander Barkov2013-09-231-0/+115
|/ / / / /
* | | | | mysql-5.5.33 mergeSergei Golubchik2013-09-061-4/+4
|\ \ \ \ \ | | |_|_|/ | |/| | |
| * | | | merge 5.1 => 5.5Tor Didriksen2013-07-011-2/+4
| |\ \ \ \ | | | |_|/ | | |/| |
| | * | | Bug#58165: "my_empty_string" gets modified and causes LOAD DATA to fail andTor Didriksen2013-07-011-2/+4
| | | | | | | | | | | | | | | | | | | | | | | | | Cleanup test case (left outfile in data dir)
* | | | | fix an old bug where dd_frm_type() could incorrectly determine the table typeSergei Golubchik2013-08-281-0/+4
| | | | | | | | | | | | | | | | | | | | | | | | | for dynamic engines (because it only looked at the one-byte code, not at the full engine name).
* | | | | mysql-5.5.31 mergeSergei Golubchik2013-05-071-0/+12
|\ \ \ \ \ | |/ / / /
* | | | | 5.3 mergeSergei Golubchik2013-03-271-0/+18
|\ \ \ \ \ | | |_|/ / | |/| | |
| * | | | 5.2 mergeSergei Golubchik2013-03-261-0/+7
| |\ \ \ \ | | | |_|/ | | |/| |
| | * | | MDEV-4289 Assertion `0' fails in make_sortkey with GROUP_CONCAT, MAKE_SET, ↵Sergei Golubchik2013-03-181-0/+7
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | GROUP BY Item_func_make_set wasn't taking into account the first argument when calculating maybe_null. sql/item_strfunc.cc: rewrite Item_func_make_set, removing separate storage of the first argument sql/item_strfunc.h: rewrite Item_func_make_set, removing separate storage of the first argument
| * | | | 5.2 mergeSergei Golubchik2013-01-281-0/+11
| |\ \ \ \ | | |/ / /
| | * | | MDEV-759 lp:998340 - Valgrind complains on simple selects containing ↵Sergei Golubchik2013-01-251-0/+11
| | | |/ | | |/| | | | | | | | | | | | | | | | | expression DAY(FROM_UNIXTIME(-1)) check item->null_value before using the result of item->val_int()
* | | | MDEV-4272 fix.unknown2013-03-141-5/+13
| | | | | | | | | | | | | | | | Incorrect NULL value handling in Item_func_conv_charset fixed.
* | | | mysql-5.5.28Sergei Golubchik2012-10-161-0/+11
|\ \ \ \ | | |_|/ | |/| |
* | | | merge with mysql-5.5.21Sergei Golubchik2012-03-091-0/+39
|\ \ \ \ | |/ / /
| * | | Bug#13359121 LARGE NUMBERS, /STRINGS/DTOA.C:662Tor Didriksen2012-01-251-0/+39
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug#12985021 SIMPLE QUERY WITH DECIMAL NUMBERS TAKE AN When parsing the fractional part of a string which is to be converted to double, we can stop after a few digits: the extra digits will not contribute to the actual result anyways. mysql-test/r/func_str.result: New tests. mysql-test/t/func_str.test: New tests. strings/dtoa.c: The problem was s2b() multiplying and adding hundreds-of-thousands of ever smaller fractions.
* | | | mysql-5.5 mergeSergei Golubchik2012-01-161-0/+5
|\ \ \ \ | |/ / /
| * | | merge mysql-5.5->mysql-5.5-securityGeorgi Kodinov2011-10-121-0/+19
| |\ \ \
| * | | | Bug11764310 - 57132: CONV FUNCTION CRASHES, NEGATIVE ARGUMENT TO MEMCPY Kristofer Pettersson2011-09-061-0/+5
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Failure to check the return state of a longlong2str() call caused a crash. This could happen if a user executed the sql function CONV() with certain parameters. The patch fixes the issue by checking that the returned pointer isn't NULL.