Skip to content

Tests are failing on MySQL 8.0 #61

@howyi

Description

@howyi

CREATE

CREATE TABLE `tbl_country2` (
  `country_id` int(11) NOT NULL COMMENT 'Country id',
  `country_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT 'Country Name',
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='Country table'

SHOW CREATE TABLE

expected

CREATE TABLE `tbl_country2` (
  `country_id` int(11) NOT NULL COMMENT 'Country id',
  `country_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT 'Country Name',
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='Country table'

actual

CREATE TABLE `tbl_country2` (
  `country_id` int NOT NULL COMMENT 'Country id',
  `country_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT 'Country Name',
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='Country table'

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions