show create starrocks external table fail

[blanklin030]

Steps to reproduce the behavior (Required)

• 1. remote cluster target table

     CREATE TABLE `target_dup_sr` (
     `id` bigint(20) NOT NULL DEFAULT "0" COMMENT "",
     `price` decimal128(38, 6) NOT NULL DEFAULT "0.0" COMMENT "",
     `dt` date NOT NULL DEFAULT "2022-01-01" COMMENT ""
     ) ENGINE=OLAP
     DUPLICATE KEY(`id`)
     COMMENT "aa"
     PARTITION BY RANGE(`dt`)
     (PARTITION p20240331 VALUES [("2024-03-31"), ("2024-04-01")),
     PARTITION p20240401 VALUES [("2024-04-01"), ("2024-04-02")),
     PARTITION p20240402 VALUES [("2024-04-02"), ("2024-04-03")),
     PARTITION p20240403 VALUES [("2024-04-03"), ("2024-04-04")))
     DISTRIBUTED BY HASH(`id`) BUCKETS 10
     PROPERTIES (
     "replication_num" = "1",
     "dynamic_partition.enable" = "true",
     "dynamic_partition.time_unit" = "DAY",
     "dynamic_partition.time_zone" = "Asia/Shanghai",
     "dynamic_partition.start" = "-2",
     "dynamic_partition.end" = "1",
     "dynamic_partition.prefix" = "p",
     "dynamic_partition.buckets" = "10",
     "dynamic_partition.history_partition_num" = "0",
     "in_memory" = "false",
     "storage_format" = "DEFAULT",
     "enable_persistent_index" = "false",
     "compression" = "LZ4"
     );

• 2. current cluster external table

     CREATE EXTERNAL TABLE `target_dup_sr_external` (
     `id` bigint(20) NOT NULL DEFAULT "0" COMMENT "",
     `price` decimal128(38, 6) NOT NULL DEFAULT "0.0" COMMENT "",
     `dt` date NOT NULL DEFAULT "2022-01-01" COMMENT ""
     ) ENGINE=OLAP
     DUPLICATE KEY(`id`)
     PARTITION BY RANGE(`dt`)
     (PARTITION p20240331 VALUES [("2024-03-31"), ("2024-04-01")),
     PARTITION p20240401 VALUES [("2024-04-01"), ("2024-04-02")),
     PARTITION p20240402 VALUES [("2024-04-02"), ("2024-04-03")),
     PARTITION p20240403 VALUES [("2024-04-03"), ("2024-04-04")))
     DISTRIBUTED BY HASH(`id`) BUCKETS 10
     PROPERTIES (
     "replication_num" = "1",
     "host" = "10.xx.xx.xx",
     "port" = "9020",
     "user" = "prod_xx",
     "password" = "xx",
     "database" = "xx_stream",
     "table" = "target_dup_sr"
     );

• 3. operation of show create table in current cluster fail

     show create table target_dup_sr_external

Expected behavior (Required)

get show create table resource

Real behavior (Required)

2024-03-26 16:42:07,858 WARN (starrocks-mysql-nio-pool-1|174) [StmtExecutor.execute():549] execute Exception, sql show create table target_dup_sr_external
java.lang.NullPointerException: null
        at com.starrocks.catalog.RangePartitionInfo.toSql(RangePartitionInfo.java:503) ~[starrocks-fe.jar:?]
        at com.starrocks.server.GlobalStateMgr.getDdlStmt(GlobalStateMgr.java:2246) ~[starrocks-fe.jar:?]
        at com.starrocks.server.GlobalStateMgr.getDdlStmt(GlobalStateMgr.java:2139) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ShowExecutor.showCreateInternalCatalogTable(ShowExecutor.java:852) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ShowExecutor.handleShowCreateTable(ShowExecutor.java:742) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ShowExecutor.execute(ShowExecutor.java:223) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.handleShow(StmtExecutor.java:1118) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:507) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:327) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:444) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:702) ~[starrocks-fe.jar:?]
        at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_144]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_144]
        at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_144]

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version() 2.5.12

[github-actions[bot]]

We have marked this issue as stale because it has been inactive for 6 months. If this issue is still relevant, removing the stale label or adding a comment will keep it active. Otherwise, we'll close it in 10 days to keep the issue queue tidy. Thank you for your contribution to StarRocks!