search

aliyun / alibaba-cloud-sdk-go

Alibaba Cloud SDK for Go
Apache License 2.0
1.16k stars 273 forks source link

[ADB MySql] Unsupported column type: 245 #563

Closed eric-chao closed 2 years ago

eric-chao commented 2 years ago

[ADB MySql]

adb mysql version: 3.1.3.8

mysql column type: json array, e.g. ["basketball", "football"]

sdk: golang gorm

ERROR:

Error 1815: [9001, 2022042418393617201618417503453302922] Unsupported column type: 245

eric-chao commented 2 years ago

image

image

eric-chao commented 2 years ago

Create Table t_user ( id bigint NOT NULL AUTO_INCREMENT COMMENT '', name varchar COMMENT '', doc_id varchar NOT NULL COMMENT 'document id', doc_type varchar NOT NULL COMMENT 'document type', receipt_info json NOT NULL COMMENT '', beneficiary_type tinyint DEFAULT '1' COMMENT 'beneficiary type', country varchar COMMENT '', created_at datetime COMMENT '', updated_at datetime COMMENT '', primary key (id) ) DISTRIBUTE BY HASH(id) INDEX_ALL='Y' STORAGE_POLICY='HOT' BLOCK_SIZE=8192;

JacksonTian commented 2 years ago

Please submit a work order at https://selfservice.console.aliyun.com/ticket/createIndex?spm=5176.12818093.top-nav.ditem-sub.3b4d16d0EhWbQw