mysql2sqlite icon indicating copy to clipboard operation
mysql2sqlite copied to clipboard

Supporting(ignore) descending index

Open davinwang opened this issue 4 years ago • 1 comments

Mysql (8.0) supports a descending index, while sqlite not. Currently the shell script is not generate the correct DDL for sqlite. the mysql DDL

CREATE TABLE `t_sample` (
  `event_date` date,
  UNIQUE KEY `index2` (`event_date` DESC)
}

will result in

CREATE TABLE `t_sample` (
  `event_date` date,
  UNIQUE DESC
}

davinwang avatar Aug 28 '21 02:08 davinwang

Thanks for the bug report! Could you make a PR to fix this? I'm really out of time :cry: (and clicking merge on GitHub can be made even on my smartphone :wink:).

dumblob avatar Aug 29 '21 14:08 dumblob