dolthub / dolthub/doltgresql

`dolt_schema_diff`, `dolt_patch` need better support for `CREATE, ALTER TABLE` statements

Open
#1,371 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
2.1k
Forks
73
Avg merge
1d 10h
Merged PRs (30d)
129

Description

MySQL `CREATE TABLE` statements can include schema elements e.g. indexes that Postgres statements cannot. Currently we simply omit these elements when generating the `CREATE TABLE` statements for Doltgres tables. But this means that the output of `dolt_schema_diff` and `dolt_patch` are incomplete for doltgres.

The simplest solution is probably to converge on the postgres restrictions, so that we emit `CREATE TABLE` and `ALTER TABLE` statements that make sense for both dialects.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.