query I
select 1
----
1

query R
select 10000.00::FLOAT + 234.567::FLOAT
----
10234.567

query R
select 100.0::DOUBLE/8.0::DOUBLE
----
12.5

query B
select 2>1
----
true

query B
select 3>4
----
false

query T
select DATE '2001-02-16'
----
2001-02-16

# FIXME: support timestamp

# query T
# select timestamp '1999-01-08 01:00:00'
# ----
# 1999-01-08 01:00:00

subtest NullType

statement ok
create table t(v1 int null)

statement ok
insert into t values(null)

query T
select * from t
----
NULL

statement ok
drop table t

subtest MultiRowsMultiColumn

statement ok
create table t(v1 int not null, v2 int not null, v3 int not null)

statement ok
insert into t values(1,4,2), (2,3,3), (3,4,4), (4,3,5)

query II rowsort
select v1,v3 from t where v2 > 3
----
1 2
3 4

statement ok
drop table t

subtest SyntaxError

statement error
SELECT * FORM dish

subtest CharArray

statement ok
create table t (name VARCHAR NOT NULL)

statement ok
insert into t values ('text1'), ('text2')

query T rowsort
select * from t
----
text1
text2

statement ok
drop table t