dolthub / dolthub/dolt

Dolt view definitions do not match MySQL view definitions

Open
#3,004 2 comments 0 reactions 1 assignee Claimed by @zachmu View on GitHub
bug correctness ORM
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

Suppose we create the following view in both Dolt and MySQL on a database named `hi`

```SQL
create view myview as SELECT var from t;
```

Doing a `SELECT * FROM information_schema.views` and looking for the above `myview` we see the following

This the is correct MySQL output

```SQL
select `hi`.`t`.`var` AS `var` from `hi`.`t`
```

This is Dolt's incorrect output

```SQL
SELECT var from t
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.