[GitHub] [shardingsphere] somnuscq commented on issue #8038: left join+order by cause NullPointerException

GitBox Mon, 23 Nov 2020 17:17:24 -0800


somnuscq commented on issue #8038:
URL: https://github.com/apache/shardingsphere/issues/8038#issuecomment-732519812



   `SET NAMES utf8mb4;
   SET FOREIGN_KEY_CHECKS = 0;
   
   -- ----------------------------
   -- Table structure for basic_bominfo_2018
   -- ----------------------------
   DROP TABLE IF EXISTS `basic_bominfo_2018`;
   CREATE TABLE `basic_bominfo_2018`  (
     `BOM_ID` decimal(12, 0) NOT NULL COMMENT '主键ID',
     `HEADER_ID` decimal(12, 0) NULL DEFAULT NULL,
     `BOM_HEADER_ID` decimal(12, 0) NULL DEFAULT NULL,
     `ROW_ID` decimal(65, 30) NULL DEFAULT NULL,
     `ITEM_ID` decimal(12, 0) NULL DEFAULT NULL COMMENT '零件ID',
     `ITEM_CODE` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '零件编号',
     `QUANTITY` decimal(65, 30) NULL DEFAULT NULL COMMENT '数量',
     `ERP_OP_CODE` decimal(12, 0) NULL DEFAULT NULL COMMENT '工位编号',
     `CREATED_DATE` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
     `UPDATED_DATE` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
     `DATA_STATUS` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '状态',
     `ATTRIBUTE1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE5` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `PLID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 
NULL COMMENT '生产线ID',
     `ISTASK` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '是否生成任务',
     `ISKEY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 
NULL COMMENT '是否关重件',
     `INTEGRATE_TIME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 
NULL DEFAULT NULL COMMENT '同步时间',
     PRIMARY KEY (`BOM_ID`) USING BTREE,
     UNIQUE INDEX `UNIQUE_KEY_01`(`BOM_ID`) USING BTREE,
     INDEX `SHARDING_KEY_01`(`UPDATED_DATE`) USING BTREE
   ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT 
= Compact;
   
   -- ----------------------------
   -- Table structure for basic_bominfo_2019
   -- ----------------------------
   DROP TABLE IF EXISTS `basic_bominfo_2019`;
   CREATE TABLE `basic_bominfo_2019`  (
     `BOM_ID` decimal(12, 0) NOT NULL COMMENT '主键ID',
     `HEADER_ID` decimal(12, 0) NULL DEFAULT NULL,
     `BOM_HEADER_ID` decimal(12, 0) NULL DEFAULT NULL,
     `ROW_ID` decimal(65, 30) NULL DEFAULT NULL,
     `ITEM_ID` decimal(12, 0) NULL DEFAULT NULL COMMENT '零件ID',
     `ITEM_CODE` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '零件编号',
     `QUANTITY` decimal(65, 30) NULL DEFAULT NULL COMMENT '数量',
     `ERP_OP_CODE` decimal(12, 0) NULL DEFAULT NULL COMMENT '工位编号',
     `CREATED_DATE` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
     `UPDATED_DATE` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
     `DATA_STATUS` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '状态',
     `ATTRIBUTE1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE5` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `PLID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 
NULL COMMENT '生产线ID',
     `ISTASK` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '是否生成任务',
     `ISKEY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 
NULL COMMENT '是否关重件',
     `INTEGRATE_TIME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 
NULL DEFAULT NULL COMMENT '同步时间',
     PRIMARY KEY (`BOM_ID`) USING BTREE
   ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT 
= Compact;
   
   -- ----------------------------
   -- Table structure for basic_bominfo_2020
   -- ----------------------------
   DROP TABLE IF EXISTS `basic_bominfo_2020`;
   CREATE TABLE `basic_bominfo_2020`  (
     `BOM_ID` decimal(12, 0) NOT NULL COMMENT '主键ID',
     `HEADER_ID` decimal(12, 0) NULL DEFAULT NULL,
     `BOM_HEADER_ID` decimal(12, 0) NULL DEFAULT NULL,
     `ROW_ID` decimal(65, 30) NULL DEFAULT NULL,
     `ITEM_ID` decimal(12, 0) NULL DEFAULT NULL COMMENT '零件ID',
     `ITEM_CODE` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '零件编号',
     `QUANTITY` decimal(65, 30) NULL DEFAULT NULL COMMENT '数量',
     `ERP_OP_CODE` decimal(12, 0) NULL DEFAULT NULL COMMENT '工位编号',
     `CREATED_DATE` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
     `UPDATED_DATE` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
     `DATA_STATUS` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '状态',
     `ATTRIBUTE1` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE2` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE3` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE4` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `ATTRIBUTE5` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL,
     `PLID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 
NULL COMMENT '生产线ID',
     `ISTASK` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '是否生成任务',
     `ISKEY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 
NULL COMMENT '是否关重件',
     `INTEGRATE_TIME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci 
NULL DEFAULT NULL COMMENT '同步时间',
     PRIMARY KEY (`BOM_ID`) USING BTREE
   ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT 
= Compact;
   
   -- ----------------------------
   -- Table structure for basic_iteminfo
   -- ----------------------------
   DROP TABLE IF EXISTS `basic_iteminfo`;
   CREATE TABLE `basic_iteminfo`  (
     `ITEM_ID` varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 
COMMENT '主键ID',
     `ITEM_CODE` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '物料编号',
     `DRAWING_CODE` varchar(240) CHARACTER SET utf8 COLLATE utf8_general_ci 
NULL DEFAULT NULL COMMENT '物料图号',
     `ITEM_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '物料名称',
     `ISGZJ` decimal(1, 0) NULL DEFAULT NULL COMMENT '是否关重件（0：否；1：是）',
     `LAST_UPDATE_DATE` datetime(0) NULL DEFAULT NULL COMMENT '最后修改时间',
     `LAST_UPDATE_BY` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci 
NULL DEFAULT NULL COMMENT '最后修改人CODE',
     `STATUS` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '状态',
     `IS_CHANGED` decimal(1, 0) NULL DEFAULT NULL COMMENT '预留字段',
     `CREATED_BY` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 
DEFAULT NULL COMMENT '创建人ID',
     `CREATED_DATE` datetime(0) NULL DEFAULT NULL COMMENT '创建日期',
     PRIMARY KEY (`ITEM_ID`) USING BTREE
   ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT 
= Compact;
   
   SET FOREIGN_KEY_CHECKS = 1;`


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]

[GitHub] [shardingsphere] somnuscq commented on issue #8038: left join+order by cause NullPointerException

Reply via email to