[Bug] mongo cdc when type is boolean , use starrocks(paimon catalog) query with wrong value

[bulolo]

Search before asking

• I searched in the issues and found nothing similar.

Paimon version

paimon 0.9
starrocks 3.3.7
flink 1.20

Compute Engine

paimon mongo cdc
starrocks

Minimal reproduce step

• mongodb

db.getCollection("manufacturers").find({}, {
    _id: 0,
    slug: 1,
    isOverseas: 1
}).sort({
    slug: 1
}).limit(3)

slug	isOverseas
AA	true
AADY	
AAL	true

• paimon mongo cdc

./bin/flink run -d \
    ./lib/paimon-flink-action-0.9.0.jar \
    mongodb_sync_database \
    --warehouse s3://lakehouse-1253767413/paimon \
    --database biocitydb \
    --mongodb_conf hosts=172.16.0.11:27017 \
    --mongodb_conf username=mongouser \
    --mongodb_conf password=XXX \
    --mongodb_conf database=biocitydb \
    --catalog_conf s3.endpoint=cos.ap-guangzhou.myqcloud.com \
    --catalog_conf s3.access-key=XXX \
    --catalog_conf s3.secret-key=XXX \
    --table-conf bucket=1 \
    --including_tables 'manufacturers' \
    --table_prefix ods_

• starrocks

CREATE EXTERNAL CATALOG paimon
PROPERTIES
(
    "type" = "paimon",
    "paimon.catalog.type" = "filesystem",
    "paimon.catalog.warehouse" = "s3://lakehouse-1253767413/paimon",
    "aws.s3.endpoint" = "cos.ap-guangzhou.myqcloud.com",
    "aws.s3.access_key" = "XXX",
    "aws.s3.secret_key" = "XXX"
);

SELECT
	slug,isOverseas
FROM
	paimon.biocitydb.ods_manufacturers
	order by slug asc
	limit 3

slug	isOverseas
AA	
AADY	
AAL	

• query from paimon parquet file
  

What doesn't meet your expectations?

same value with string type

Anything else?

发现的规律（不太确定）：只要mongodb 字段（bool类型）存在(N/A)，当同步到paimon,并在starrocks 查询，所有查出来的该字段的值都是NULL

举例：mongo db 中 AADY 的 isOverseas为N/A，数据中有N/A情况

slug	isOverseas
AA	true
AADY	
AAL	true

starrocks paimon catalog 中查询出来就都是 NULL

slug	isOverseas
AA	
AADY	
AAL	

只有当 mongo 布尔字段全部有值， paimon catalog 中查询出来才正常 显示布尔字符串（过一段时间又不正常）

Are you willing to submit a PR?

• I'm willing to submit a PR!