SELECT from table with a qualified namespace doesn't work as expected

cmu-db / noisepage

Self-Driving Database Management System from Carnegie Mellon University

https://noise.page

MIT License

1.74k stars 502 forks source link

SELECT from table with a qualified namespace doesn't work as expected #724

Open mbutrovich opened 4 years ago

mbutrovich commented 4 years ago

@harsh141994 fixed #706, which then exposed a new issue:

terrier=# create schema foo;
CREATE SCHEMA
terrier=# create table foo.bar (id int);
CREATE TABLE
terrier=# select * from foo.bar;
ERROR:  binding failed

I suspect the fix will be similar.

mbutrovich commented 4 years ago

DROP is broken too. Basically we should look at all the operator transformers that reference tables, and make sure we're not losing the namespace qualifier.