pgsql aliases cannot be resolved

[794086163]

Bug Report

Which version of ShardingSphere did you use?

5.2.1

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

ShardingSphere-JDBC

Expected behavior

can get the function alias field

Actual behavior

Error attempting to get column 'statisticsDate' from result set. Cause: java.sql.SQLFeatureNotSupportedException: Can not get index from column label statisticsDate.\n; Can not get index from column label statisticsDate.; nested exception is java.sql.SQLFeatureNotSupportedException: Can not get index from column label statisticsDate."

Reason analyze (If you can)

SQL parsing exception

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

SELECT * FROM ( SELECT '2023-03' AS "statisticsDate" ) A LEFT JOIN ( SELECT id AS "data_net_type" , to_char( date_trunc( 'month', '2023-03-03' :: DATE ), 'YYYY-MM' ) AS "date"

FROM
    test

ORDER BY
"date" 
) b ON A."statisticsDate" = b."date"

[strongduanmu]

Hi @794086163, does this sql contains sharding table?

[794086163]

Hi @794086163, does this sql contains sharding table? Does not contain

[strongduanmu]

You can try the latest 5.3.2 version, we have fix this exception.

[794086163]

You can try the latest 5.3.2 version, we have fix this exception.

ok，i try it

[794086163]

5.3.2 Can be fixed

[794086163]

You can try the latest 5.3.2 version, we have fix this exception.

select cast( id as text) ,cast(id as text) from test