search

apache / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
19.66k stars 6.67k forks source link

java.sql.SQLFeatureNotSupportedException: can't get index from columnLabel[field_2] #31824

Closed zxk1111 closed 2 weeks ago

zxk1111 commented 1 month ago 
          i has the same error,like select t.*  from (select s.field_1,if(s.field_2 is null,1,2) as field_2 from sub s)t  will display this error because of t.*,

if like select t.field_1,t.field_2 will success,

error msg: java.sql.SQLFeatureNotSupportedException: can't get index from columnLabel[field_2]

related version:

org.apache.shardingsphere shardingsphere-jdbc-core-spring-boot-starter 5.1.1 com.alibaba druid-spring-boot-starter 1.2.20

Originally posted by @zxk1111 in https://github.com/apache/shardingsphere/issues/24207#issuecomment-2185428616

terrymanu commented 3 weeks ago

The markdown format in your issue is incorrect. To facilitate reading, could you please revise it?

zxk1111 commented 2 weeks ago

1