Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

views with same name as table, causes inf recursion #4549

Closed
jycor opened this issue Oct 13, 2022 · 2 comments
Closed

views with same name as table, causes inf recursion #4549

jycor opened this issue Oct 13, 2022 · 2 comments
Labels
bug Something isn't working good repro Easily reproducible bugs

Comments

@jycor
Copy link
Contributor

jycor commented Oct 13, 2022

We should prevent creating a view and table of the same name like MySQL:

MySQL > create table t (i int);
Query OK, 0 rows affected (0.0283 sec)
MySQL > create view t as (select * from t);
ERROR: 1050: Table 't' already exists
@timsehn timsehn added bug Something isn't working good repro Easily reproducible bugs labels Oct 13, 2022
@timsehn
Copy link
Contributor

timsehn commented Oct 13, 2022

Repro:

$ dolt init
Successfully initialized dolt data repository.
$ dolt sql -q "create table t(pk int primary key)"
$ dolt sql -q "create view t as select * from t"
$ dolt sql -q "show create table t"
error on line 1 for query show create table t: exceeded max analysis iterations (100)
exceeded max analysis iterations (100)

@jycor
Copy link
Contributor Author

jycor commented Oct 14, 2022

fix is in main

@jycor jycor closed this as completed Oct 14, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working good repro Easily reproducible bugs
Projects
None yet
Development

No branches or pull requests

2 participants