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

[GitHub] [shardingsphere] fanchuanlin opened a new issue, #27912: navicat view can't be update real time

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

   hi all,i have a requestion。
   my shardingsphere-proxy version is 5.1.2, and i shardingsphere-proxy's mode is cluster ,it has two nodes.
   when i commit a alter sql eg:
   ```
   alter table  `U_SITE_WITHDRAWALS`
   add column `create_time` datetime NOT NULL COMMENT '提现时间';
   ```
   then the real db(mysql) was commited,but the navicat table view  can't be updated real time.
   
   but sql can use the new column.
   `
   SELECT create_time FROM `U_SITE_WITHDRAWALS` ORDER BY create_time desc limit 1;
   `
   what can i do or Config for navicat view  be update real time?
   


-- 
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] azexcy commented on issue #27912: navicat view can't be update real time

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

   @fanchuanlin What I know, support navicat is not yet perfect, so there are some strange problem with using 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


Re: [I] navicat view can't be update real time [shardingsphere]

Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #27912: navicat view can't be update real time
URL: https://github.com/apache/shardingsphere/issues/27912


-- 
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] fanchuanlin commented on issue #27912: navicat view can't be update real time

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

   The problem was disappeared when i restarted shardingsphere-proxy.i don't know the reason.but i think maybe the shardingsphere-proxy cache refreshed real time??


-- 
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] github-actions[bot] commented on issue #27912: navicat view can't be update real time

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #27912:
URL: https://github.com/apache/shardingsphere/issues/27912#issuecomment-1704390047

   There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.


-- 
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


Re: [I] navicat view can't be update real time [shardingsphere]

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

   The issue involves other third-party dependencies, but our focus is solely on ShardingSphere itself. Since ShardingSphere implements the JDBC interface, standard applications should be functional. We wish to allocate more effort towards enhancing the current version, and therefore will no longer handle such issues. Please read the documentation or provide more effective information when submitting an 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