- #
- # Test keywords as fields
- #
- drop table if exists t1;
- create table t1 (time time, date date, timestamp timestamp);
- insert into t1 values ("12:22:22","97:02:03","1997-01-02");
- select * from t1;
- select t1.time+0,t1.date+0,t1.timestamp+0,concat(date," ",time) from t1;
- drop table t1;