lazyboyl commented on issue #9291: URL: https://github.com/apache/shardingsphere/issues/9291#issuecomment-773091647
> Hi~ @lazyboyl ！ > First of all, it is clear that the windows environment is not case sensitive.Secondly, the design of shardingsphere 5.0.0-apha is not case sensitive. Even if you are using a Linux system, it is recommended to temporarily turn off case sensitivity. > > About the SQL statement, your question is similar to #9270. > In our 5.0.0-apha, if join and ‘_’ are involved at the same time, it may cause some data loss problems in the result merging.We also found this problem and fixed it in the latest version (master branch). My suggestion is to avoid using ‘_’ as much as possible, or try to install the master branch, or wait for our upcoming release version! > Hi~ @lazyboyl ！ > First of all, it is clear that the windows environment is not case sensitive.Secondly, the design of shardingsphere 5.0.0-apha is not case sensitive. Even if you are using a Linux system, it is recommended to temporarily turn off case sensitivity. > > About the SQL statement, your question is similar to #9270. > In our 5.0.0-apha, if join and ‘_’ are involved at the same time, it may cause some data loss problems in the result merging.We also found this problem and fixed it in the latest version (master branch). My suggestion is to avoid using ‘_’ as much as possible, or try to install the master branch, or wait for our upcoming release version! It is mainly in the investigation stage that various scenarios need to be considered. Therefore, the MySQL database sensitivity is specially turned on, and this problem is found during the verification, so it is fed back to the official. Although this problem can be solved by setting the MySQL database to be case insensitive. ---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected]
