下面是DDL:
CREATE TABLE `list_search_test` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) DEFAULT NULL,
`info` json DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
当我插入数据时:
INSERT INTO list_search_test
(id, name, info)
VALUES(4, 'jsonTest',
'{"apis": [{"name": "BenefitService", "assetRef": false, "operations": [{"name": "createBenefit", "inputs": [{"name": "benefitid", "nameCn": "", "assetRef": false, "dataType": "Integer", "required": false}, {"name": "userid", "nameCn": "", "assetRef": false, "dataType": "Long", "required": true}], "outputs": [{"name": "result", "intro": "", "assetRef": false, "dataType": "Long", "required": false}], "assetRef": false, "displayName": "", "dependencies": {"assetRef": false, "applicationServiceOperations": [{"bizCode": "http://www.103573587971.com/bizgo-ep/MODULE_CENTER/CampaignDomain/application-service|BenefitMgt|createUserBenefit", "version": "1.0.0"}]}, "requestMethod": "POST", "requestProtocol": "HTTP"}], "displayName": "", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter/business-capability-api"}], "name": "BenefitCenter", "appInfo": {"code": "benefitcenter", "version": "v1.0.0", "assetRef": false}, "bizCode": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter|BenefitCenter", "assetRef": false, "diagrams": [{"assetRef": false, "activities": [{"name": "createTest", "binding": {"assetRef": false, "apiOperations": [{"name": "BenefitService", "assetRef": false, "operations": [{"name": "createBenefit", "inputs": [{"name": "benefitid", "nameCn": "", "assetRef": false, "dataType": "Integer"}, {"name": "userid", "nameCn": "用户ID", "assetRef": false, "dataType": "Long", "required": true}], "outputs": [{"name": "result", "intro": "", "assetRef": false, "dataType": "Long"}], "assetRef": false, "displayName": "", "dependencies": {"assetRef": false, "applicationServiceOperations": [{"bizCode": "http://www.103573587971.com/bizgo-ep/MODULE_CENTER/CampaignDomain/application-service|BenefitMgt|createUserBenefit", "version": "1.0.0"}]}, "requestMethod": "POST", "requestProtocol": "HTTP"}], "displayName": "b", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter/business-capability-api"}]}, "assetRef": false, "displayName": ""}], "designerData": "{\"id\":\"s\"}"}], "sdkInfos": [{"id": "BenefitCenter", "bizCode": "BenefitCenter", "assetRef": true, "endpoint": "bw.app.bizworks.cn", "bizVersion": "V1.0.0", "downloadLink": "http://bw-paas.qa.console.aliyun.test/cloudapi-gateway-lite?Version=2016-07-14&Action=SdkGenerateForBizworks&RegionId=bizworks-premeses&ProjectCode=bizgo-ep&BizCode=BenefitCenter"}], "assetType": "BusinessCapability", "bizVersion": "V1.0.0", "displayName": "AI+】", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter"}');
bug mysql告诉我:
Data truncation: Invalid JSON text: "Missing a comma or '}' after an object member." at position 2177 in value for column 'list_search_test.info'.
我该怎么解决它呢?
发布于 2021-07-23 12:22:04
问题出在内部json上。
designerData -为此,您提供的是json字符串,而不是实际的json。
工作中:
INSERT INTO list_search_test
( name, info)
VALUES( 'jsonTest',
'{"apis": [{"name": "BenefitService", "assetRef": false, "operations": [{"name": "createBenefit", "inputs": [{"name": "benefitid", "nameCn": "", "assetRef": false, "dataType": "Integer", "required": false}, {"name": "userid", "nameCn": "", "assetRef": false, "dataType": "Long", "required": true}], "outputs": [{"name": "result", "intro": "", "assetRef": false, "dataType": "Long", "required": false}], "assetRef": false, "displayName": "", "dependencies": {"assetRef": false, "applicationServiceOperations": [{"bizCode": "http://www.103573587971.com/bizgo-ep/MODULE_CENTER/CampaignDomain/application-service|BenefitMgt|createUserBenefit", "version": "1.0.0"}]}, "requestMethod": "POST", "requestProtocol": "HTTP"}], "displayName": "", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter/business-capability-api"}], "name": "BenefitCenter", "appInfo": {"code": "benefitcenter", "version": "v1.0.0", "assetRef": false}, "bizCode": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter|BenefitCenter", "assetRef": false, "diagrams": [{"assetRef": false, "activities": [{"name": "createTest", "binding": {"assetRef": false, "apiOperations": [{"name": "BenefitService", "assetRef": false, "operations": [{"name": "createBenefit", "inputs": [{"name": "benefitid", "nameCn": "", "assetRef": false, "dataType": "Integer"}, {"name": "userid", "nameCn": "用户ID", "assetRef": false, "dataType": "Long", "required": true}], "outputs": [{"name": "result", "intro": "", "assetRef": false, "dataType": "Long"}], "assetRef": false, "displayName": "", "dependencies": {"assetRef": false, "applicationServiceOperations": [{"bizCode": "http://www.103573587971.com/bizgo-ep/MODULE_CENTER/CampaignDomain/application-service|BenefitMgt|createUserBenefit", "version": "1.0.0"}]}, "requestMethod": "POST", "requestProtocol": "HTTP"}], "displayName": "b", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter/business-capability-api"}]}, "assetRef": false, "displayName": ""}], "designerData": {"id":"s"}}], "sdkInfos": [{"id": "BenefitCenter", "bizCode": "BenefitCenter", "assetRef": true, "endpoint": "bw.app.bizworks.cn", "bizVersion": "V1.0.0", "downloadLink": "http://bw-paas.qa.console.aliyun.test/cloudapi-gateway-lite?Version=2016-07-14&Action=SdkGenerateForBizworks&RegionId=bizworks-premeses&ProjectCode=bizgo-ep&BizCode=BenefitCenter"}], "assetType": "BusinessCapability", "bizVersion": "V1.0.0", "displayName": "AI+]", "targetNamespace": "http://www.103573587971.com/bizgo-ep/BUSINESS_CAPABILITY/BenefitCenter"}');
https://stackoverflow.com/questions/68493948
复制相似问题