connect 'jdbc:derby:test;create=true';

create table simple_tab (
	x integer
);

insert into simple_tab values (1);

create view simple_acos_view as (
	select acos(x) y from simple_tab
);

create view simple_asin_view as (
	select asin(x) y from simple_tab
);

create view simple_atan_view as (
	select atan(x) y from simple_tab
);

create view simple_cos_view as (
	select cos(x) y from simple_tab
);

create view simple_sin_view as (
	select sin(x) y from simple_tab
);

create view simple_tan_view as (
	select tan(x) y from simple_tab
);

create view simple_degrees_view as (
	select degrees(x) y from simple_tab
);

create view simple_radians_view as (
	select radians(x) y from simple_tab
);

create view simple_exp_view as (
	select exp(x) y from simple_tab
);

create view simple_log_view as (
	select log(x) y from simple_tab
);

create view simple_log10_view as (
	select log10(x) y from simple_tab
);

create view simple_ceiling_view as (
	select ceiling(x) y from simple_tab
);

create view simple_floor_view as (
	select floor(x) y from simple_tab
);

create view simple_abs_view as (
	select abs(x) y from simple_tab
);

create view simple_sqrt_view as (
	select sqrt(x) y from simple_tab
);
