primary-expression.result

INITIALIZATION
create table exp_table(id int, col1 int, col2 int, col3 float, col4 float);
SUCCESS
insert into exp_table VALUES (1, 1, 1, 1.0, 1.5);
SUCCESS
insert into exp_table VALUES (2, 2, -2, 5.5, 1.0);
SUCCESS
insert into exp_table VALUES (3, 3, 4, 5.0, 4.0);
SUCCESS

1. SELECT
select * from exp_table where 1 = 5/4;
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where col1-2 > 0;
3 | 3 | 4 | 5 | 4
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where 2+col2 < 1;
2 | 2 | -2 | 5.5 | 1
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where col1*col2 < 0;
2 | 2 | -2 | 5.5 | 1
ID | COL1 | COL2 | COL3 | COL4

select * from exp_table where 5/4 = 1;
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where 0 < col1-2;
3 | 3 | 4 | 5 | 4
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where 1.0 > 2+col2;
2 | 2 | -2 | 5.5 | 1
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where -0 < col1-col2;
2 | 2 | -2 | 5.5 | 1
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where 0 < -2+col1;
3 | 3 | 4 | 5 | 4
ID | COL1 | COL2 | COL3 | COL4

select * from exp_table where 1+1 = 2*1.0;
1 | 1 | 1 | 1 | 1.5
2 | 2 | -2 | 5.5 | 1
3 | 3 | 4 | 5 | 4
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where 5/4*8 < 4+col2*col3/2;
3 | 3 | 4 | 5 | 4
ID | COL1 | COL2 | COL3 | COL4
select * from exp_table where 5/4*8 < (4+col2)*col3/2;
3 | 3 | 4 | 5 | 4
ID | COL1 | COL2 | COL3 | COL4

select id,-(col2*(-1)+1)+(col4+2)*(col1+col3*2),(4+col2)*col3/2 from exp_table where -(col2*(-1)+1)+(col4+2)*(col1+col3*2) > (4+col2)*col3/2;
1 | 10.5 | 2.5
2 | 36 | 5.5
3 | 81 | 20
ID | -(COL2*(-1)+1)+(COL4+2)*(COL1+COL3*2) | (4+COL2)*COL3/2
select id,col1,col2,col3,col4,6-(col2*(1+col1))+(col4+2)/(1+col1*4+col3*2) from exp_table where 6-(col2*(1+col1))+(col4+2)/(1+col1*4+col3*2) > 5;
2 | 2 | -2 | 5.5 | 1 | 12.15
ID | COL1 | COL2 | COL3 | COL4 | 6-(COL2*(1+COL1))+(COL4+2)/(1+COL1*4+COL3*2)
select id,col1,col2,col3,col4,3*col1/(col2+2) from exp_table where 3*col1/(col2+2) > 1;
3 | 3 | 4 | 5 | 4 | 1.5
ID | COL1 | COL2 | COL3 | COL4 | 3*COL1/(COL2+2)
select id,3*col1/(col2+2) from exp_table where 3*col1/(col2+2)+1/0 > 1;
ID | 3*COL1/(COL2+2)
select * from exp_table where 1/0 = 1/0;
ID | COL1 | COL2 | COL3 | COL4

2. EXPRESSION ABOUT MANY TABLES
create table exp_table2(id int, col1 int);
SUCCESS
insert into exp_table2 VALUES (1, 1);
SUCCESS
insert into exp_table2 VALUES (2, 3);
SUCCESS
select exp_table.id,3*exp_table2.col1/(exp_table.col2+2) from exp_table,exp_table2 where 3*exp_table2.col1/(exp_table.col2+2)>1;
1 | 3
3 | 1.5
exp_table.ID | 3*EXP_TABLE2.COL1/(EXP_TABLE.COL2+2)