bug: The data type was not determined during load data #852
Description
Have you read the Contributing Guidelines on issues?
- I have read the Contributing Guidelines on issues.
Please confirm if bug report does NOT exists already ?
- I confirm there is no existing issue for this
Describe the problem
The type of the field in column A is int, and the data is A string. No error is reported when the string data is imported into column A, and the import is successful
Expected behavior
Verify data types. When data types are inconsistent, an error message is displayed
#innodb error message：ERROR 1366 (HY000): Incorrect integer value: 'ECONOMY POLISHED STEEL' for column 'P_SIZE' at row 1
How To Reproduce
##create table
CREATE TABLE IF NOT EXISTS `lineorder_flat` (
`LO_ORDERDATE` date NOT NULL COMMENT '',
`LO_ORDERKEY` int(11) NOT NULL COMMENT '',
`LO_LINENUMBER` tinyint(4) NOT NULL COMMENT '',
`LO_CUSTKEY` int(11) NOT NULL COMMENT '',
`LO_PARTKEY` int(11) NOT NULL COMMENT '',
`LO_SUPPKEY` int(11) NOT NULL COMMENT '',
`LO_ORDERPRIORITY` varchar(100) NOT NULL COMMENT '',
`LO_SHIPPRIORITY` tinyint(4) NOT NULL COMMENT '',
`LO_QUANTITY` tinyint(4) NOT NULL COMMENT '',
`LO_EXTENDEDPRICE` int(11) NOT NULL COMMENT '',
`LO_ORDTOTALPRICE` int(11) NOT NULL COMMENT '',
`LO_DISCOUNT` tinyint(4) NOT NULL COMMENT '',
`LO_REVENUE` int(11) NOT NULL COMMENT '',
`LO_SUPPLYCOST` int(11) NOT NULL COMMENT '',
`LO_TAX` tinyint(4) NOT NULL COMMENT '',
`LO_COMMITDATE` date NOT NULL COMMENT '',
`LO_SHIPMODE` varchar(100) NOT NULL COMMENT '',
`C_NAME` varchar(100) NOT NULL COMMENT '',
`C_ADDRESS` varchar(100) NOT NULL COMMENT '',
`C_CITY` varchar(100) NOT NULL COMMENT '',
`C_NATION` varchar(100) NOT NULL COMMENT '',
`C_REGION` varchar(100) NOT NULL COMMENT '',
`C_PHONE` varchar(100) NOT NULL COMMENT '',
`C_MKTSEGMENT` varchar(100) NOT NULL COMMENT '',
`S_NAME` varchar(100) NOT NULL COMMENT '',
`S_ADDRESS` varchar(100) NOT NULL COMMENT '',
`S_CITY` varchar(100) NOT NULL COMMENT '',
`S_NATION` varchar(100) NOT NULL COMMENT '',
`S_REGION` varchar(100) NOT NULL COMMENT '',
`S_PHONE` varchar(100) NOT NULL COMMENT '',
`P_NAME` varchar(100) NOT NULL COMMENT '',
`P_MFGR` varchar(100) NOT NULL COMMENT '',
`P_CATEGORY` varchar(100) NOT NULL COMMENT '',
`P_BRAND` varchar(100) NOT NULL COMMENT '',
`P_COLOR` varchar(100) NOT NULL COMMENT '',
`P_TYPE` varchar(100) NOT NULL COMMENT '',
`P_SIZE` tinyint(4) NOT NULL COMMENT '',
`P_CONTAINER` varchar(100) NOT NULL COMMENT ''
);
##load data
19980721,34,1,12202,88362,727,3-MEDIUM,0,13,1755468,5894967,0,1755468,81021,7,19980914,REG AIR,Customer#000012202,crWpqvyx4fOpC3IP,JAPAN 5,JAPAN,ASIA,22-437-209-5615,FURNITURE,Supplier#000000727,HO,lDAVvCDTthJs3oYHW,BRAZIL 4,BRAZIL,AMERICA,12-815-316-3525,dim thistle,MFGR#2,MFGR#23,MFGR#236,seashell,ECONOMY POLISHED STEEL,39,WRAP BAG
Environment
Ver 14.14 Distrib 5.7.36-StoneDB, for Linux (x86_64) using EditLine wrapper
Are you interested in submitting a PR to solve the problem?
- Yes, I will!
Metadata
Metadata
Assignees
Type
Projects
Status