334
334
# Test types of data for create select with functions
337
create table t1(a int,b int,c int unsigned,d date,e char,f datetime,g time,h blob);
337
create table t1(a int,b int,c int,d date,e char,f datetime,g time,h blob);
338
338
insert into t1(a)values(1);
339
339
insert into t1(a,b,c,d,e,f,g,h)
340
340
values(2,-2,2,'1825-12-14','a','2003-1-1 3:2:1','4:3:2','binary data');
341
341
select * from t1;
343
343
ifnull(b,cast(-7 as signed)) as b,
344
ifnull(c,cast(7 as unsigned)) as c,
344
ifnull(c,cast(7 as)) as c,
345
345
ifnull(d,cast('2000-01-01' as date)) as d,
346
346
ifnull(e,cast('b' as char)) as e,
347
347
ifnull(f,cast('2000-01-01' as datetime)) as f,
356
356
ifnull(b,cast(-7 as signed)) as b,
357
ifnull(c,cast(7 as unsigned)) as c,
357
ifnull(c,cast(7 as)) as c,
358
358
ifnull(d,cast('2000-01-01' as date)) as d,
359
359
ifnull(e,cast('b' as char)) as e,
360
360
ifnull(f,cast('2000-01-01' as datetime)) as f,
added
removed
tests/t/create.test
