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 2020/03/13 05:00:47 UTC
[GitHub] [incubator-shardingsphere] phoema opened a new issue #4746: When
Use Select * from with Mysql, Select One Record But return null invalid
phoema opened a new issue #4746: When Use Select * from with Mysql, Select One Record But return null invalid
URL: https://github.com/apache/incubator-shardingsphere/issues/4746
See Ref #4728
mybatis xml mapper
select * from ${prefix}ACT_GE_PROPERTY where NAME_ = #{name, jdbcType=VARCHAR}
is return null
select NAME_, VALUE_, REV_ from ${prefix}ACT_GE_PROPERTY where NAME_ = #{name, jdbcType=VARCHAR}
is return one record
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598992884
Version 4.0.1 is OK
my local code wiht master branch of 2020-03-05( 0ce016e13fd5ba42b5f6beba595d68e955f8dc1e [0ce016e]) is OK
when I got the new source code . 713ae319f45b4a97d3fe465c38071b2a29e3ebd2 [713ae31] \
not work well.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598815728
Did you mean version 4.0.1 and master is fine?
What's your version to meet the 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-599070772
The bug is caused by #4637. I just link to that issue.
It is not a bug because it is not cross the release, the fix progress is inside 5.0.0-SNAPSHOT.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null invalid
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null invalid
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598557101
char *
is not supported in new code after 2020-03-05?
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-599014743
not encrypt
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-599011680
Thank you for the report. The problem is caused by #4651 and #4653 probably.
Maybe load metadata error in some cases. Do you use sharding and encrypt together?
It is better to show your rule configuration may help us analyze 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null invalid
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null invalid
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598558497
![image](https://user-images.githubusercontent.com/8730272/76592922-be5f3400-652f-11ea-891a-eb0f64df4e2d.png)
* is return null, when change columns then return one record
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null invalid
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null invalid
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598556709
See Ref #4728
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-599000621
I changed My sql with 6 examples:
1) select NAME_, VALUE_, REV_ from ACT_GE_PROPERTY where NAME_ = #{name, jdbcType=VARCHAR}
2) select * from act_ge_property where NAME_ = #{name, jdbcType=VARCHAR}
3) select act_ge_property.* from act_ge_property where NAME_ = #{name, jdbcType=VARCHAR}
4) select t.* from act_ge_property as t where NAME_ = #{name, jdbcType=VARCHAR}
5) select * from ACT_GE_PROPERTY where NAME_ = #{name, jdbcType=VARCHAR}
6) select ACT_GE_PROPERTY.* from ACT_GE_PROPERTY where NAME_ = #{name, jdbcType=VARCHAR}
when I build with master branch of new source code . 713ae31 [713ae31]
1/2/3/4 is works well
5/6 not well
may be when char * ,then find columns from metadata with tableName with not uppercase/lowercase ?
【MySql Database config I set
lower_case_table_names=1 means ingore upper/lower】
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking edited a comment on issue
#4746: When Use Select * from with Mysql,
Select One Record But return null invalid
Posted by GitBox <gi...@apache.org>.
kimmking edited a comment on issue #4746: When Use Select * from with Mysql, Select One Record But return null invalid
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598553372
Show the actual SQL in console log, plz.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tristaZero closed issue #4746: When Use
Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598634681
I tried to changed many sql from * to columns such as:
<sql id="FiledNames">
ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_
</sql>
then it works well.
but it is too many.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-599014699
Only Using Hint
yaml.xml:
dataSources:
master: !!com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/wise-master?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true
test: !!com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/wise-test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true
test2: !!com.alibaba.druid.pool.DruidDataSource
driverClassName: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/wise-test2?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true
shardingRule:
tables:
v_info_case:
databaseStrategy:
hint: #Hint
algorithmClassName: com.smarttree.manage.config.mybatis.HintShardingStrategy
.........
act_ge_property:
databaseStrategy:
hint: #Hint
algorithmClassName: com.smarttree.manage.config.mybatis.HintShardingStrategy
sys_tenant_info:
actualDataNodes: master.sys_tenant_info
databaseStrategy:
none: #Hint
sys_column_define:
actualDataNodes: master.sys_column_define
databaseStrategy:
none: #Hint
defaultDatabaseStrategy:
hint: #Hint
algorithmClassName: com.smarttree.manage.config.mybatis.HintShardingStrategy
defaultTableStrategy:
hint: #Hint
algorithmClassName: com.smarttree.manage.config.mybatis.HintShardingStrategy
props:
sql.show: true
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema edited a comment on issue #4746:
When Use Select * from with Mysql, Select One Record But return null invalid
Posted by GitBox <gi...@apache.org>.
phoema edited a comment on issue #4746: When Use Select * from with Mysql, Select One Record But return null invalid
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598556680
2020-03-12 16:41:14,173 INFO (ShardingSQLLogger.java:75)- Actual SQL: master ::: select * from ACT_GE_PROPERTY where NAME_ = ? ::: [cfg.execution-related-entities-count]
Actual SQL is write。
Version 4.0.1 is OK
master branch of 2020-03-05 is OK
but I do not know new code where is changed。
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null invalid
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null invalid
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598556680
2020-03-12 16:41:14,173 INFO (ShardingSQLLogger.java:75)- Actual SQL: master ::: select * from ACT_GE_PROPERTY where NAME_ = ? ::: [cfg.execution-related-entities-count]
Actual SQL is write。
Version 4.0.1 is write
master branch of 2020-03-05 is write
but I do not know new code where is changed。
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-599001337
when I reset master branch with 0ce016e13fd5ba42b5f6beba595d68e955f8dc1e [0ce016e]
1/2/3/4/5/6 is works well
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4746: When
Use Select * from with Mysql, Select One Record But return null invalid
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4746: When Use Select * from with Mysql, Select One Record But return null invalid
URL: https://github.com/apache/incubator-shardingsphere/issues/4746#issuecomment-598553372
Show the actual SQL show in console log, plz.
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services