diff options
| author | unknown <kroki/tomash@moonlight.intranet> | 2006-11-16 14:19:37 +0300 |
|---|---|---|
| committer | unknown <kroki/tomash@moonlight.intranet> | 2006-11-16 14:19:37 +0300 |
| commit | a4823607f9084153c405eaef753a35de6156a31b (patch) | |
| tree | 9426ee0559bc31869b77a90a2732503b7e0210f8 /mysql-test/t/func_str.test | |
| parent | 541e9c9ac5ef31933beed881ea4171e2d7a38b97 (diff) | |
| parent | af22eb35e577ef17226faf662f2cffc4705bde26 (diff) | |
| download | mariadb-git-a4823607f9084153c405eaef753a35de6156a31b.tar.gz | |
Merge moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.0
into moonlight.intranet:/home/tomash/src/mysql_ab/mysql-5.0-bug17047
sql/item_strfunc.cc:
Auto merged
mysql-test/r/func_str.result:
Manual merge.
mysql-test/t/func_str.test:
Manual merge.
Diffstat (limited to 'mysql-test/t/func_str.test')
| -rw-r--r-- | mysql-test/t/func_str.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/func_str.test b/mysql-test/t/func_str.test index 9622de96143..83a2c0a9029 100644 --- a/mysql-test/t/func_str.test +++ b/mysql-test/t/func_str.test @@ -780,6 +780,7 @@ SELECT * FROM t1 INNER JOIN t2 ON code=id DROP TABLE t1,t2; + # # Bug #10963 # 4294967296 18446744073709551616 @@ -969,4 +970,18 @@ select lpad('hello', 18446744073709551616, '1'); select lpad('hello', -18446744073709551617, '1'); select lpad('hello', 18446744073709551617, '1'); + +# +# BUG#17047: CHAR() and IN() can return NULL without signaling NULL +# result +# +SET @orig_sql_mode = @@SQL_MODE; +SET SQL_MODE=traditional; + +SELECT CHAR(0xff,0x8f USING utf8); +SELECT CHAR(0xff,0x8f USING utf8) IS NULL; + +SET SQL_MODE=@orig_sql_mode; + + --echo End of 5.0 tests |