ytrlmy521 commented on issue #25913:
URL: 
https://github.com/apache/shardingsphere/issues/25913#issuecomment-1565924967

   > Hi @ytrlmy521, can you try latest 5.3.2? 3.x is too old.
   
   ok,thank you for reply,But when I execute this simple SQL statement, an 
error is reported again. I did not use any keywords, and the execution on the 
mysql terminal is completely successful.
   
   
   version:5.1.1    ` implementation 
'org.apache.shardingsphere:shardingsphere-jdbc-core-spring-boot-starter:5.1.1'`
   
   SQL:`select admaterial0_.id as id1_2_, admaterial0_.created_by as 
created_2_2_, admaterial0_.created_time as created_3_2_, admaterial0_.deleted 
as deleted4_2_, admaterial0_.deleted_time as deleted_5_2_, 
admaterial0_.updated_by as updated_6_2_, admaterial0_.updated_time as 
updated_7_2_, admaterial0_.ad_type_id as ad_type_8_2_, 
admaterial0_.advertiser_id as advertis9_2_, admaterial0_.android_media_url as 
android10_2_, admaterial0_.bit_rate as bit_rat11_2_, admaterial0_.duration as 
duratio12_2_, admaterial0_.full_url as full_ur13_2_, 
admaterial0_.horizontal_resolution as horizon14_2_, admaterial0_.ios_media_url 
as ios_med15_2_, admaterial0_.link as link16_2_, admaterial0_.link_param as 
link_pa17_2_, admaterial0_.link_type as link_ty18_2_, admaterial0_.media_fail 
as media_f19_2_, admaterial0_.media_file_md5 as media_f20_2_, 
admaterial0_.media_id as media_i21_2_, admaterial0_.media_url as media_u22_2_, 
admaterial0_.name as name23_2_, admaterial0_.remarks as remarks24_2_, 
admaterial0_
 .skip as skip25_2_, admaterial0_.upload_type as upload_26_2_, 
admaterial0_.vertical_resolution as vertica27_2_ from ad_material admaterial0_ 
where admaterial0_.media_fail=0 and admaterial0_.deleted=0 and 
(admaterial0_.media_url is null) and (admaterial0_.media_id is not null)`
   
   @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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to