oceanbase / odc

OceanBase Developer Center(ODC), An open-source, enterprise-grade database tool for collaborative development
https://github.com/oceanbase/odc
Apache License 2.0
539 stars 55 forks source link

[Bug]: Oracle float type does not support archiving #2631

Closed Huangxiao-mas closed 5 months ago

Huangxiao-mas commented 5 months ago

ODC version

ODC430

OB version

Oceanbase430

What happened?

Oracle float type does not support archiving image

What did you expect to happen?

How can we reproduce it (as minimally and precisely as possible)?

CREATE TABLE "LLC11" (
  "A" NUMBER(*,0),
  "B" NUMBER(*,0) NOT NULL ENABLE,
  "C" FLOAT(20),
  "D" FLOAT(20),
  "E" FLOAT(20),
  "G" VARCHAR2(1000),
  "L" VARCHAR2(1000),
  "M" VARCHAR2(1000),
  "N" VARCHAR2(1000),
  "X" VARCHAR2(1000),
  "Y" VARCHAR2(1000),
  "Z" VARCHAR2(1000),
  "C1" VARCHAR2(1000),
  "C11" NVARCHAR2(1000),
  "C12" BINARY_DOUBLE,
  "C13" FLOAT(126),
  "C14" DATE,
  CONSTRAINT "啊啊啊啊啊啊啊啊啊啊啊啊" UNIQUE ("B")
) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by hash("D")
(partition "P0",
partition "P1",
partition "P2",
partition "P3",
partition "P4",
partition "P5",
partition "P6",
partition "P7",
partition "P8",
partition "P9",
partition "P10",
partition "P11",
partition "P12",
partition "P13",
partition "P14",
partition "P15",
partition "P16",
partition "P17",
partition "P18",
partition "P19",
partition "P20",
partition "P21",
partition "P22",
partition "P23",
partition "P24",
partition "P25",
partition "P26",
partition "P27",
partition "P28",
partition "P29",
partition "P30",
partition "P31",
partition "P32",
partition "P33",
partition "P34",
partition "P35",
partition "P36",
partition "P37",
partition "P38",
partition "P39",
partition "P40",
partition "P41",
partition "P42",
partition "P43",
partition "P44",
partition "P45",
partition "P46",
partition "P47",
partition "P48",
partition "P49",
partition "P50",
partition "P51",
partition "P52",
partition "P53",
partition "P54",
partition "P55",
partition "P56",
partition "P57",
partition "P58",
partition "P59",
partition "P60",
partition "P61",
partition "P62",
partition "P63",
partition "P64",
partition "P65",
partition "P66",
partition "P67",
partition "P68",
partition "P69",
partition "P70",
partition "P71",
partition "P72",
partition "P73",
partition "P74",
partition "P75",
partition "P76",
partition "P77",
partition "P78",
partition "P79",
partition "P80",
partition "P81",
partition "P82",
partition "P83",
partition "P84",
partition "P85",
partition "P86",
partition "P87",
partition "P88",
partition "P89",
partition "P90",
partition "P91",
partition "P92",
partition "P93",
partition "P94",
partition "P95",
partition "P96",
partition "P97",
partition "P98",
partition "P99",
partition "P100",
partition "P101",
partition "P102",
partition "P103",
partition "P104",
partition "P105",
partition "P106",
partition "P107",
partition "P108",
partition "P109",
partition "P110",
partition "P111",
partition "P112",
partition "P113",
partition "P114",
partition "P115",
partition "P116",
partition "P117",
partition "P118",
partition "P119",
partition "P120",
partition "P121",
partition "P122",
partition "P123",
partition "P124",
partition "P125",
partition "P126",
partition "P127",
partition "P128",
partition "P129",
partition "P130",
partition "P131",
partition "P132",
partition "P133",
partition "P134",
partition "P135",
partition "P136",
partition "P137",
partition "P138",
partition "P139",
partition "P140",
partition "P141",
partition "P142",
partition "P143",
partition "P144",
partition "P145",
partition "P146",
partition "P147",
partition "P148",
partition "P149",
partition "P150",
partition "P151",
partition "P152",
partition "P153",
partition "P154",
partition "P155",
partition "P156",
partition "P157",
partition "P158",
partition "P159",
partition "P160",
partition "P161",
partition "P162",
partition "P163",
partition "P164",
partition "P165",
partition "P166",
partition "P167",
partition "P168",
partition "P169",
partition "P170",
partition "P171",
partition "P172",
partition "P173",
partition "P174",
partition "P175",
partition "P176",
partition "P177",
partition "P178",
partition "P179",
partition "P180",
partition "P181",
partition "P182",
partition "P183",
partition "P184",
partition "P185",
partition "P186",
partition "P187",
partition "P188",
partition "P189",
partition "P190",
partition "P191",
partition "P192",
partition "P193",
partition "P194",
partition "P195",
partition "P196",
partition "P197",
partition "P198",
partition "P199",
partition "P200",
partition "P201",
partition "P202",
partition "P203",
partition "P204",
partition "P205",
partition "P206",
partition "P207",
partition "P208",
partition "P209",
partition "P210",
partition "P211",
partition "P212",
partition "P213",
partition "P214",
partition "P215",
partition "P216",
partition "P217",
partition "P218",
partition "P219",
partition "P220",
partition "P221",
partition "P222",
partition "P223",
partition "P224",
partition "P225",
partition "P226",
partition "P227",
partition "P228",
partition "P229",
partition "P230",
partition "P231",
partition "P232",
partition "P233",
partition "P234",
partition "P235",
partition "P236",
partition "P237",
partition "P238",
partition "P239",
partition "P240",
partition "P241",
partition "P242",
partition "P243",
partition "P244",
partition "P245",
partition "P246",
partition "P247",
partition "P248",
partition "P249",
partition "P250",
partition "P251",
partition "P252",
partition "P253",
partition "P254",
partition "P255",
partition "P256",
partition "P257",
partition "P258",
partition "P259",
partition "P260",
partition "P261",
partition "P262",
partition "P263",
partition "P264",
partition "P265",
partition "P266",
partition "P267",
partition "P268",
partition "P269",
partition "P270",
partition "P271",
partition "P272",
partition "P273",
partition "P274",
partition "P275",
partition "P276",
partition "P277",
partition "P278",
partition "P279",
partition "P280",
partition "P281",
partition "P282",
partition "P283",
partition "P284",
partition "P285",
partition "P286",
partition "P287",
partition "P288",
partition "P289",
partition "P290",
partition "P291",
partition "P292",
partition "P293",
partition "P294",
partition "P295",
partition "P296",
partition "P297",
partition "P298",
partition "P299",
partition "P300",
partition "P301",
partition "P302",
partition "P303",
partition "P304",
partition "P305",
partition "P306",
partition "P307",
partition "P308",
partition "P309",
partition "P310",
partition "P311",
partition "P312",
partition "P313",
partition "P314",
partition "P315",
partition "P316",
partition "P317",
partition "P318",
partition "P319",
partition "P320",
partition "P321",
partition "P322",
partition "P323",
partition "P324",
partition "P325",
partition "P326",
partition "P327",
partition "P328",
partition "P329",
partition "P330",
partition "P331",
partition "P332",
partition "P333",
partition "P334",
partition "P335",
partition "P336",
partition "P337",
partition "P338",
partition "P339",
partition "P340",
partition "P341",
partition "P342",
partition "P343",
partition "P344",
partition "P345",
partition "P346",
partition "P347",
partition "P348",
partition "P349",
partition "P350",
partition "P351",
partition "P352",
partition "P353",
partition "P354",
partition "P355",
partition "P356",
partition "P357",
partition "P358",
partition "P359",
partition "P360",
partition "P361",
partition "P362",
partition "P363",
partition "P364",
partition "P365",
partition "P366",
partition "P367",
partition "P368",
partition "P369",
partition "P370",
partition "P371",
partition "P372",
partition "P373",
partition "P374",
partition "P375",
partition "P376",
partition "P377",
partition "P378",
partition "P379",
partition "P380",
partition "P381",
partition "P382",
partition "P383",
partition "P384",
partition "P385",
partition "P386",
partition "P387",
partition "P388",
partition "P389",
partition "P390",
partition "P391",
partition "P392",
partition "P393",
partition "P394",
partition "P395",
partition "P396",
partition "P397",
partition "P398",
partition "P399",
partition "P400",
partition "P401",
partition "P402",
partition "P403",
partition "P404",
partition "P405",
partition "P406",
partition "P407",
partition "P408",
partition "P409",
partition "P410",
partition "P411",
partition "P412",
partition "P413",
partition "P414",
partition "P415",
partition "P416",
partition "P417",
partition "P418",
partition "P419",
partition "P420",
partition "P421",
partition "P422",
partition "P423",
partition "P424",
partition "P425",
partition "P426",
partition "P427",
partition "P428",
partition "P429",
partition "P430",
partition "P431",
partition "P432",
partition "P433",
partition "P434",
partition "P435",
partition "P436",
partition "P437",
partition "P438",
partition "P439",
partition "P440",
partition "P441",
partition "P442",
partition "P443",
partition "P444",
partition "P445",
partition "P446",
partition "P447",
partition "P448",
partition "P449",
partition "P450",
partition "P451",
partition "P452",
partition "P453",
partition "P454",
partition "P455",
partition "P456",
partition "P457",
partition "P458",
partition "P459",
partition "P460",
partition "P461",
partition "P462",
partition "P463",
partition "P464",
partition "P465",
partition "P466",
partition "P467",
partition "P468",
partition "P469",
partition "P470",
partition "P471",
partition "P472",
partition "P473",
partition "P474",
partition "P475",
partition "P476",
partition "P477",
partition "P478",
partition "P479",
partition "P480",
partition "P481",
partition "P482",
partition "P483",
partition "P484",
partition "P485",
partition "P486",
partition "P487",
partition "P488",
partition "P489",
partition "P490",
partition "P491",
partition "P492",
partition "P493",
partition "P494",
partition "P495",
partition "P496",
partition "P497",
partition "P498",
partition "P499");

LLC11.22.0.csv

Anything else we need to know?

No response

Huangxiao-mas commented 5 months ago

dev test pass