Error finding temporary result set in CTE SQL statement

[zihaoAK47]

Bug Report

Which version of ShardingSphere did you use?

master dd44eb00aba6f63efdba6f

Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?

ShardingSphere-Proxy

Expected behavior

Correct execution result and return 1

Actual behavior

ERROR 10007 (42S02): Table or view cte does not exist.

Reason analyze (If you can)

SimpleTableSegmentBinder.java

Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.

mysql version: 8.0.27

server.yaml

mode:
  type: Cluster
  repository:
    type: ZooKeeper
    props:
      namespace: poc_sharding
      server-lists: 127.0.0.1:2181
      retryIntervalMilliseconds: 500
      timeToLiveSeconds: 60
      maxRetries: 3
      operationTimeoutMilliseconds: 500

sqlFederation:
  sqlFederationEnabled: true
  executionPlanCache:
    initialCapacity: 2000
    maximumSize: 65535

create database test;

use test;

REGISTER STORAGE UNIT ds_0 (
    URL="jdbc:mysql://127.0.0.1:3304/test_db?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true",
    USER="root",
    PASSWORD="root",
    PROPERTIES("maximumPoolSize"="10","idleTimeout"="30000")
);

with cte as (select 1) select * from cte;

Example codes for reproduce this issue (such as a github link).

[Yash-cor]

I think this Issue can be closed now

[strongduanmu]

@Yash-cor Thank you for your feedback, I will close this issue.