starrocks-sink: insert decimal type data got error

[xuefengze]

Describe the bug

when column_type is decimal64(10, 0)

risingwave/src/connector/src/sink/starrocks.rs

Lines 316 to 341 in 0f0e3e7

	if column_type.contains("decimal") {
	let decimal_all = column_type
	.split("decimal(")
	.last()
	.ok_or_else(|| SinkError::Starrocks("must have last".to_string()))?
	.split(')')
	.next()
	.ok_or_else(|| SinkError::Starrocks("must have next".to_string()))?
	.split(',')
	.collect_vec();
	let length = decimal_all
	.first()
	.ok_or_else(|| SinkError::Starrocks("must have next".to_string()))?
	.parse::<u8>()
	.map_err(|e| {
	SinkError::Starrocks(format!("starrocks sink error: {}", e.as_report()))
	})?;
	let scale = decimal_all
	.last()
	.ok_or_else(|| SinkError::Starrocks("must have next".to_string()))?
	.parse::<u8>()
	.map_err(|e| {
	SinkError::Starrocks(format!("starrocks sink error: {}", e.as_report()))
	})?;
	decimal_map.insert(name.to_string(), (length, scale));

Error message/log

ERROR risingwave_stream::task::stream_manager: actor exit with error actor_id=11 error=Executor error: Sink error: Starrocks error: starrocks sink error: invalid digit found in string

To Reproduce

starrocks v3.1.7:

CREATE table starrocks_types(
    types_id int,
    c_decimal decimal
) ENGINE=OLAP
UNIQUE KEY(`types_id`)
DISTRIBUTED BY HASH(`types_id`) BUCKETS 1
PROPERTIES (
    "replication_num" = "1"
);

rw:

CREATE TABLE starrocks_types (
  types_id INT,
  c_decimal decimal,
  PRIMARY KEY (types_id)
);

INSERT INTO starrocks_types VALUES (1, 0);

CREATE SINK starrocks_types_sink
FROM
    starrocks_types WITH (
    connector = 'starrocks',
    type = 'append-only',
    starrocks.host = 'localhost',
    starrocks.mysqlport = '9030',
    starrocks.httpport = '8030',
    starrocks.user = 'users',
    starrocks.password = '123456',
    starrocks.database = 'demo',
    starrocks.table = 'starrocks_types',
    force_append_only='true'
);

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

No response

Additional context

No response

[xxhZs]

Could be a known issue #15664