dolthub / dolthub/pg2mysql

interval type fields not supported

Open
#51 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Shell
Stars
54
Forks
12
PR merge metrics
No merged PRs in 30d

Description

I'm not sure what these should be converted to, but internal isn't a valid type in mysql

```
$ cat test.pgsql
CREATE TABLE public.dcim_device (
id uuid NOT NULL,
created date,
diff_time interval,
);

$ perl pg2mysql.pl < test.pgsql
--
-- Generated by pg2mysql
--
set foreign_key_checks = off;
--
DROP DATABASE IF EXISTS public;
CREATE DATABASE public;
CREATE TABLE public.dcim_device (
`id` varchar(36) NOT NULL,
`created` date,
`diff_time` interval,
);
```

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce the conversion with pg2mysql.pl using the test.pgsql example and inspect how the existing uuid and date fields are handled. Determine a valid MySQL representation for the interval field, then rerun the command and verify that the generated CREATE TABLE no longer contains the unsupported interval type.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, perl, postgresql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.