← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/func_concat.test

  • Committer: Toru Maesaka
  • Date: 2008-12-17 07:16:37 UTC
  • mto: (685.1.40 devel) (713.1.5 devel)
  • mto: This revision was merged to the branch mainline in revision 713.
  • Revision ID: dev@torum.net-20081217071637-7j9040w7lpms77r2
Removed my_time() and added error checking

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/func_concat.test
30
30
# Bug #5540: a problem with double type
31
31
#
32
32
 
33
 
create table t1 (a char(4), b double, c date, d int(4));
 
33
create table t1 (a char(4), b double, c date, d int);
34
34
insert into t1 values ('AAAA', 105, '2003-03-01', 1);
35
35
select * from t1 where concat(A,C,B,D) = 'AAAA2003-03-011051';
36
36
drop table t1;
64
64
#
65
65
# Bug#15962: CONCAT() in UNION may lead to a data trucation.
66
66
#
67
 
create table t1(f1 varchar(6)) charset=utf8;
 
67
create table t1(f1 varchar(6));
68
68
insert into t1 values ("123456");
69
69
select concat(f1, 2) a from t1 union select 'x' a from t1;
70
70
drop table t1;