[Bug]: The data returned by querying json is 0

[Huangxiao-mas]

ODC version

ODC430

OB version

independent

What happened?

The data returned by querying json is 0

What did you expect to happen?

。

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

CREATE TABLE P_order_detail_test (
  "APPL_SEQ" NUMBER(20) NOT NULL ENABLE,
  "CHANNEL_NO" VARCHAR2(50),
  "APP_ID" VARCHAR2(50),
  "ORDER_TYPE" VARCHAR2(10),
  "ORDER_STATUS" VARCHAR2(1),
  "ORDER_INFO" JSON,
  "CHANNEL_TOPIC" VARCHAR2(50),
  "MESSAGE_ID" VARCHAR2(100),
  "CREATE_TIME" DATE DEFAULT sysdate NOT NULL ENABLE,
  "UPDATE_TIME" DATE DEFAULT sysdate NOT NULL ENABLE,
  CONSTRAINT "P_ORDER_DETAIL_TEST" PRIMARY KEY ("APPL_SEQ", "CREATE_TIME")
) COMPRESS FOR ARCHIVE REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by range(CREATE_TIME)
(partition "P1" values less than (TO_DATE(' 2025-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P2" values less than (TO_DATE(' 2025-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P3" values less than (TO_DATE(' 2026-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P4" values less than (TO_DATE(' 2026-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P5" values less than (TO_DATE(' 2027-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P6" values less than (TO_DATE(' 2027-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P7" values less than (TO_DATE(' 2028-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P8" values less than (TO_DATE(' 2028-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P9" values less than (TO_DATE(' 2029-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P10" values less than (TO_DATE(' 2029-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')),
partition "P11" values less than (TO_DATE(' 2030-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))) ;

INSERT INTO "P_ORDER_DETAIL_TEST" ("APPL_SEQ","CHANNEL_NO","APP_ID","ORDER_TYPE","ORDER_STATUS","ORDER_INFO","CHANNEL_TOPIC","MESSAGE_ID","CREATE_TIME","UPDATE_TIME") VALUES (1202406196,'jd','aa','credit','3',{"body":{"data":{"name":"zhangsan","applSeq":1202406196},"action":"order.submit","orderType":"credit","actionType":"new"},"head":{"appId":"aa","reqId":"1234","userId":"","reqTime":1717640528367,"extraInfo":{}}},null,null,to_date('2024-06-19 05:31:44','YYYY-MM-DD HH24:MI:SS'),to_date('2024-06-19 05:31:44','YYYY-MM-DD HH24:MI:SS'));

Anything else we need to know?

No response

[Huangxiao-mas]

Driver upgrade required

[abigsaltyfish]

This is a kernel bug that can be resolved by upgrading the database to the latest version

[tonghan-gsh]

The problem with OB 4.3.1.0 still exists and requires rd patch to fix it