Skip to content

"Number" in field name translate to wrong field name #3

@crysanthus

Description

@crysanthus

If a field name includes the word 'Number', it gets converted to the wrong field name.

-- MySQL
DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees` (
  `employeeNumber` int(11) NOT NULL,
  `lastName` varchar(50) NOT NULL,
  `firstName` varchar(50) NOT NULL,
  `isActive` tinyint(1) DEFAULT '1',
  `extension` varchar(10) NOT NULL,
  `email` varchar(100) NOT NULL,
  `officeCode` varchar(10) NOT NULL,
  `reportsTo` int(11) DEFAULT NULL,
  `jobTitle` varchar(50) NOT NULL,
  PRIMARY KEY (`employeeNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- converted sqlite
DROP TABLE IF EXISTS `employees`;
CREATE TABLE `employees` (
`employeTEXT  NOT NULL,
`lastName` TEXT NOT NULL,
`firstName` TEXT NOT NULL,
`isActive` tinyINTEGER DEFAULT '1',
`extension` TEXT NOT NULL,
`email` TEXT NOT NULL,
`officeCode` TEXT NOT NULL,
`reportsTo` INTEGER DEFAULT NULL,
`jobTitle` TEXT NOT NULL,
PRIMARY KEY (`employeeNumber`)
);

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions