SQL syntax error - Githubissues

vanilladb / vanillacore

The core engine of VanillaDB

Apache License 2.0

194 stars 41 forks source link

SQL syntax error #14

Open johnnylu305 opened 7 years ago

johnnylu305 commented 7 years ago

sql create table tableA(id int)11111 select id from tableA 11111 Neither of them should be accepted.

kyechou commented 7 years ago

I wonder whether these queries should be accepted:

select id from tableA;
select id from tableA; select id from tableB;

I mean should it be one query per line, or should semicolons be used to denote the end of a query?

johnnylu305 commented 7 years ago

I think vanillaDB not support multiple query in one line with semicolons now.

kyechou commented 7 years ago

That's right, but I mean should it support?

johnnylu305 commented 7 years ago

I am not sure. Try to contact vanilladb@datalab.cs.nthu.edu.tw. Thx.

SLMT commented 7 years ago

@kyechou Good question !

In our current design, we do not support multiple queries in a line. Since we focus on making code easy to read, we only implement the functions that are really necessary for the system.