diff options
Diffstat (limited to 'mysql-test/main/union.test')
| -rw-r--r-- | mysql-test/main/union.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/union.test b/mysql-test/main/union.test index b9b38271f83..878d7118ef5 100644 --- a/mysql-test/main/union.test +++ b/mysql-test/main/union.test @@ -1470,6 +1470,21 @@ DROP VIEW v1; UNION (SELECT 2, 2); +--echo # +--echo # Bug#27197235 USER VARIABLE + UINON + DECIMAL COLUMN RETURNS +--echo # WRONG VALUES +--echo # + +let $old_charset= `SELECT @@character_set_client`; + +SET NAMES utf8; +SET @advertAcctId = 1000003; +select @advertAcctId as a from dual union all select 1.0 from dual; + +eval SET NAMES $old_charset; +SET @advertAcctId = 1000003; +select @advertAcctId as a from dual union all select 1.0 from dual; + --echo End of 5.5 tests --echo # |