You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/01/24 03:26:14 UTC

[GitHub] [shardingsphere] asp1111 opened a new issue #15014: proxy 5.0 not support row_number function

asp1111 opened a new issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014


   i customize my shardingAlggorithm,it olny route to one datasource,but still not support row_number function  ,is that a bug ? or just not support?
   ![image](https://user-images.githubusercontent.com/13173179/150717142-aadb56bc-da84-4860-a03a-d12ac3f5f126.png)
   
   


-- 
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 edited a comment on issue #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
strongduanmu edited a comment on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019998790


   Fixed in master branch, and this pr will be included in 5.1.0 version.


-- 
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] asp1111 edited a comment on issue #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
asp1111 edited a comment on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019793070


   ### here is exception message
   ![image](https://user-images.githubusercontent.com/13173179/150731377-6f1b9626-4f3d-42d1-b388-1ed149acf198.png)
   ### reproduce this problem
   set up two database , create user table  
   ```sql
       CREATE TABLE `aiot_t_user` (
         `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
         `tenantId` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ,
         `departmentId` bigint DEFAULT NULL ,
         `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL ,
         `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ,
         PRIMARY KEY (`id`) USING BTREE,
       ) ENGINE=InnoDB AUTO_INCREMENT=399 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
   ```
   
   customize  shardingAlggorithm and run sql
   
   ```sql
       SELECT
   	    id,
   	    ROW_NUMBER() OVER ( PARTITION BY departmentId ORDER BY createTime DESC ) 
       FROM
   	    aiot_t_user 
       WHERE
   	    tenantId = "1004200"
   ```
   


-- 
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] asp1111 edited a comment on issue #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
asp1111 edited a comment on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019793070


   ### here is exception message
   ![image](https://user-images.githubusercontent.com/13173179/150731377-6f1b9626-4f3d-42d1-b388-1ed149acf198.png)
   ### reproduce this problem
   set up two database , create user table  
   ```sql
       CREATE TABLE `aiot_t_user` (
         `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
         `tenantId` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ,
         `departmentId` bigint DEFAULT NULL ,
         `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL ,
          `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ,
         PRIMARY KEY (`id`) USING BTREE,
       ) ENGINE=InnoDB AUTO_INCREMENT=399 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
   ```
   
   customize  shardingAlggorithm and run sql
   
   ```sql
       SELECT
   	    id,
   	    ROW_NUMBER() OVER ( PARTITION BY departmentId ORDER BY createTime DESC ) 
       FROM
   	    aiot_t_user 
       WHERE
   	    tenantId = "1004200"
   ```
   


-- 
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 #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019798072


   @asp1111 Where is the createTime column in create table statement?


-- 
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 #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019998790


   Fixed in master branch.


-- 
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 #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019689048


   @asp1111 What is the exception message? Also, what should I do to reproduce this problem.


-- 
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 #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019686123


   @asp1111 Can you provide your sharding configuration and exception info?


-- 
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] asp1111 commented on issue #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
asp1111 commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019836830


   that is great,thanks


-- 
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 #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019794909


   @asp1111 Thank you for your feedback, I will check this issue.


-- 
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 closed issue #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014


   


-- 
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] asp1111 commented on issue #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
asp1111 commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019686935


   ![image](https://user-images.githubusercontent.com/13173179/150718467-5c5c45dc-f126-46da-87c1-03b43f86dffc.png)
   ![image](https://user-images.githubusercontent.com/13173179/150718486-c2e3aea1-4f01-41b7-b3af-0fdf5d36937b.png)
   @strongduanmu 


-- 
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] asp1111 commented on issue #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
asp1111 commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019793070


   ### here is exception message
   ![image](https://user-images.githubusercontent.com/13173179/150731377-6f1b9626-4f3d-42d1-b388-1ed149acf198.png)
   ### reproduce this problem
   set up two database , create user table  
   
       CREATE TABLE `aiot_t_user` (
         `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID',
         `tenantId` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL ,
         `departmentId` bigint DEFAULT NULL ,
         `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL ,
         PRIMARY KEY (`id`) USING BTREE,
       ) ENGINE=InnoDB AUTO_INCREMENT=399 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
   
   customize  shardingAlggorithm and run sql
   
       SELECT
   	    id,
   	    ROW_NUMBER() OVER ( PARTITION BY departmentId ORDER BY createTime DESC ) 
       FROM
   	    aiot_t_user 
       WHERE
   	    tenantId = "1004200"
   


-- 
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] asp1111 commented on issue #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
asp1111 commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019804073


   i edit 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 #15014: proxy 5.0 not support row_number function

Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #15014:
URL: https://github.com/apache/shardingsphere/issues/15014#issuecomment-1019834503


   Hi @asp1111, I have tested master branch, this exception has been 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