From b3dc9f65b0772b24c0cd766ec70ec019aaa512d0 Mon Sep 17 00:00:00 2001
From: "ram@gw.mysql.r18.ru" <>
Date: Wed, 15 Sep 2004 15:13:17 +0500
Subject: A fix (bug #5540: CONCAT function and 'double' type).

---
 mysql-test/t/func_concat.test | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'mysql-test/t/func_concat.test')

diff --git a/mysql-test/t/func_concat.test b/mysql-test/t/func_concat.test
index 147367a6d27..0cf1502b10e 100644
--- a/mysql-test/t/func_concat.test
+++ b/mysql-test/t/func_concat.test
@@ -25,3 +25,12 @@ FROM t1 GROUP BY new LIMIT 1;
 SELECT number, alpha, CONCAT_WS('<------------------>',number,alpha) AS new
 FROM t1 GROUP BY new LIMIT 1;
 drop table t1;
+
+#
+# Bug #5540: a problem with double type
+#
+
+create table t1 (a char(4), b double, c date, d tinyint(4));
+insert into t1 values ('AAAA', 105, '2003-03-01', 1);
+select * from t1 where concat(A,C,B,D) = 'AAAA2003-03-011051';
+drop table t1;
-- 
cgit v1.2.1