Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
crysanthus opened this issue Jul 19, 2021 · 1 comment
Open

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

crysanthus opened this issue Jul 19, 2021 · 1 comment
Labels
bug Something isn't working

Comments

@crysanthus
Copy link

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`)
);
@ww9
Copy link
Owner

ww9 commented Dec 2, 2021

Hi! I am so sorry that I took this long to answer. I'll make sure GitHub notify me when someone creates an issue.

I think the best way to improve the tool is to create tests. I'll be doing that in the near future but I can't guarantee when.

I appreciate your submission. Thank you! <3

@ww9 ww9 added the bug Something isn't working label Jan 17, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants