--disable_abort_on_error

set sql_mode='traditional,PIPES_AS_CONCAT';
drop table if exists t1,t2,t3,t4;


CREATE TABLE t1 ( f1 BIGINT, f2 VARCHAR (5) NOT NULL);
CREATE TABLE t2 ( f1 BIGINT, f2 CHAR (5) NOT NULL);
CREATE TABLE t3 ( f1 BIGINT, f2 BIGINT NOT NULL );
CREATE TABLE t4 ( f1 BIGINT, f2 DATE NOT NULL );

SELECT TABLE_NAME, '->' || COLUMN_DEFAULT || '<-', COLUMN_DEFAULT 
from INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA= 'test' AND COLUMN_NAME= 'f2';