# E141-07: Column defaults

# TODO: NAME
# statement ok
# CREATE TABLE TABLE_E141_07_01_01 ( A NAME DEFAULT CURRENT_CATALOG )

statement ok
CREATE TABLE TABLE_E141_07_02_01 ( ID INT PRIMARY KEY, A DATE DEFAULT CURRENT_DATE )

# statement ok
# CREATE TABLE TABLE_E141_07_04_01 ( A NAME DEFAULT CURRENT_ROLE )

# statement ok
# CREATE TABLE TABLE_E141_07_05_01 ( A NAME DEFAULT CURRENT_SCHEMA )

# SKIP: No need to support Permission mechanism
# statement ok
# CREATE TABLE TABLE_E141_07_06_01 ( A NAME DEFAULT CURRENT_USER )

# statement ok
# CREATE TABLE TABLE_E141_07_07_01 ( A NAME DEFAULT SESSION_USER )

# statement ok
# CREATE TABLE TABLE_E141_07_09_01 ( A NAME DEFAULT USER )

statement error
CREATE TABLE TABLE_E141_07_10_01 ( ID INT PRIMARY KEY, A TIME WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP )

statement ok
CREATE TABLE TABLE_E141_07_11_01 ( ID INT PRIMARY KEY, A TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP )

# TODO: LOCALTIME
# statement ok
# CREATE TABLE TABLE_E141_07_12_01 ( A TIME WITH TIME ZONE DEFAULT LOCALTIME )

# TODO: LOCALTIMESTAMP
# statement ok
# CREATE TABLE TABLE_E141_07_13_01 ( A TIMESTAMP WITH TIME ZONE DEFAULT LOCALTIMESTAMP )
