You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "794086163 (via GitHub)" <gi...@apache.org> on 2023/04/06 08:38:16 UTC

[GitHub] [shardingsphere] 794086163 opened a new issue, #24917: pgsql aliases cannot be resolved

794086163 opened a new issue, #24917:
URL: https://github.com/apache/shardingsphere/issues/24917

   ## 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
   ![image](https://user-images.githubusercontent.com/37607959/228998448-a75b7004-0dd3-455c-bb37-67c9b6e1060b.png)
   
   
   ### 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"
   	
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] 794086163 commented on issue #24917: pgsql aliases cannot be resolved

Posted by "794086163 (via GitHub)" <gi...@apache.org>.
794086163 commented on issue #24917:
URL: https://github.com/apache/shardingsphere/issues/24917#issuecomment-1491176516

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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] 794086163 commented on issue #24917: pgsql aliases cannot be resolved

Posted by "794086163 (via GitHub)" <gi...@apache.org>.
794086163 commented on issue #24917:
URL: https://github.com/apache/shardingsphere/issues/24917#issuecomment-1498709542

   > You can try the latest 5.3.2 version, we have fix this exception.
   
   ![image](https://user-images.githubusercontent.com/37607959/230322628-cfe5cda1-9fd8-4d8b-b88b-aafd3d48f172.png)
   
   select cast( id as text) ,cast(id as text) from test


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] 794086163 commented on issue #24917: pgsql aliases cannot be resolved

Posted by "794086163 (via GitHub)" <gi...@apache.org>.
794086163 commented on issue #24917:
URL: https://github.com/apache/shardingsphere/issues/24917#issuecomment-1491177773

   > You can try the latest 5.3.2 version, we have fix this exception.
   
   ok，i try it


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu commented on issue #24917: pgsql aliases cannot be resolved

Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #24917:
URL: https://github.com/apache/shardingsphere/issues/24917#issuecomment-1491176923

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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] 794086163 closed issue #24917: pgsql aliases cannot be resolved

Posted by "794086163 (via GitHub)" <gi...@apache.org>.
794086163 closed issue #24917: pgsql aliases cannot be resolved
URL: https://github.com/apache/shardingsphere/issues/24917


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] strongduanmu commented on issue #24917: pgsql aliases cannot be resolved

Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #24917:
URL: https://github.com/apache/shardingsphere/issues/24917#issuecomment-1491175990

   Hi @794086163, does this sql contains sharding table?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] 794086163 closed issue #24917: pgsql aliases cannot be resolved

Posted by "794086163 (via GitHub)" <gi...@apache.org>.
794086163 closed issue #24917: pgsql aliases cannot be resolved
URL: https://github.com/apache/shardingsphere/issues/24917


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] 794086163 commented on issue #24917: pgsql aliases cannot be resolved

Posted by "794086163 (via GitHub)" <gi...@apache.org>.
794086163 commented on issue #24917:
URL: https://github.com/apache/shardingsphere/issues/24917#issuecomment-1491605955

   5.3.2 Can be fixed


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org