Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 创建表分区的时候创建了默认分区,为什么插入数据时还会报错
[TiDB Usage Environment] Production Environment
[TiDB Version] 7.5
CREATE TABLE `core`.`company_f3` (
`id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Company ID',
`name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Company Name',
`establish_date` DATE NULL DEFAULT NULL COMMENT 'Registration Date',
`reg_capital_std` DOUBLE NULL DEFAULT NULL COMMENT 'Registered Capital, standardized unit. Unit: ten thousand yuan',
`english_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'English Name',
`registration_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Business Registration Number',
`organization_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Organization Code',
`credit_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Unified Social Credit Code',
`first_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Business Entity',
`second_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Standardized Company Type',
`detail_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Company Type',
`industry` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'National Economic Industry Code',
`registered_capital` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Registered Capital',
`registered_add` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Registered Address',
`scope` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'Business Scope',
`business_start_date` DATE NULL DEFAULT NULL COMMENT 'Business Start Date',
`business_end_date` DATE NULL DEFAULT NULL COMMENT 'Business End Date',
`reg_organization` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Registration Authority',
`legal_representative` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Legal Representative',
`legal_rep_type` INT(11) NULL DEFAULT NULL COMMENT 'Legal Representative Type',
`approval_date` DATE NULL DEFAULT NULL COMMENT 'Approval Date',
`cancel_date` DATE NULL DEFAULT NULL COMMENT 'Cancellation Date',
`status_std` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Company Status',
`registered_capital_unit` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Registered Capital Unit',
`currency` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Registered Capital Currency',
`tel` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Company Contact Number',
`email` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'Email Address',
`cancel_reason` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'Cancellation Reason',
`ssfCount` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Number of Employees Insured',
`wechat` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT 'WeChat Public Account',
`logo` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Company Logo',
`alias` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Company Alias',
`create_time` DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
`update_time` DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update Time',
`source_id` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Source ID',
`reg_province` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Province',
`reg_city` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'City',
`reg_district` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'District',
`reg_geo_wgs84` JSON NULL COMMENT 'Geographical Coordinates of Registered Address',
`display` INT(255) NOT NULL COMMENT 'Company Status\n1: Active Business Entity\n2: Cancelled Company\n3: Non-Business Entity (Associations, Unions, Committees, Government Agencies, Universities, etc. registered with the Ministry of Civil Affairs or Ministry of Education)\n4: Hong Kong Company\n5: Taiwan Company\n0: Duplicate Company\n6: Individual Business\n7: Relocated Company\n8: Suspended Business\n9: Liquidation Company\n10: Other Status',
`off_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Office Address',
`off_province` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Office Province',
`off_city` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Office City',
`off_district` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Office District',
`off_geo_wgs84` JSON NULL COMMENT 'Office Geographical Coordinates',
`region_code` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Region Code',
`capital_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Capital Type Label',
`business_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Business Type',
`company_scale` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'Company Scale',
`score_financing_ability` FLOAT NULL DEFAULT NULL COMMENT 'Investment Value/Financing Ability',
`score_innovative_ability` FLOAT NULL DEFAULT NULL COMMENT 'Innovation Value/Innovation Ability',
`score_operating_ability` FLOAT NULL DEFAULT NULL COMMENT 'Growth Potential/Operating Ability',
`score_credit_risk` FLOAT NULL DEFAULT NULL COMMENT 'Credit Risk',
`score_growth_potential` FLOAT NULL DEFAULT NULL COMMENT 'Growth Ability',
`score_social_contribution` FLOAT NULL DEFAULT NULL COMMENT 'Social Contribution',
`score_total_point` FLOAT NULL DEFAULT NULL COMMENT 'Final Score',
`scale_tag` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL,
`score_competitive_strength` FLOAT NULL DEFAULT NULL COMMENT 'Competitive Strength Index',
PRIMARY KEY (`id`, `reg_province`, `display`) USING BTREE,
INDEX `establish_date` (`establish_date`) USING BTREE,
INDEX `reg_city` (`reg_city`) USING BTREE,
INDEX `establish_date_2` (`establish_date`, `reg_city`) USING BTREE,
INDEX `score_total_point` (`score_total_point`) USING BTREE,
INDEX `establish_date_3` (`establish_date`, `reg_province`, `reg_city`, `score_total_point`) USING BTREE,
INDEX `reg_province` (`reg_province`) USING BTREE,
INDEX `reg_district` (`reg_district`) USING BTREE,
INDEX `name` (`name`) USING BTREE,
INDEX `reg_capital_std_2` (`reg_capital_std`) USING BTREE,
INDEX `status_std` (`status_std`) USING BTREE,
INDEX `company_scale` (`company_scale`) USING BTREE,
INDEX `mul` (`establish_date`, `reg_capital_std`, `status_std`, `company_scale`, `score_total_point`) USING BTREE,
INDEX `establish_date_4` (`establish_date`, `reg_province`, `reg_city`, `reg_district`, `score_total_point`) USING BTREE
) ENGINE=INNODB CHARACTER SET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=Compact PARTITION BY LIST COLUMNS (`reg_province`) (
PARTITION `bjs` VALUES IN ("北京市"),
PARTITION `other` DEFAULT
);