interval type fields not supported
- 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