[MDEV-17204] Mariadb 10.3.9 Spider DB SQL Alias no execute Created: 2018-09-17  Updated: 2019-06-28  Resolved: 2019-06-28

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.3.9
Fix Version/s: 10.4.7

Type: Bug Priority: Major
Reporter: a1s2d3f4 Assignee: Kentoku Shiba (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Centos7


Attachments: PNG File ScreenClip [1].png     PNG File ScreenClip.png    

 Description   

MariaDB 10.3.9 Spider Engine DB does not run when execute ther following query

  • This is Problem Query
    SELECT `user_no`, LEFT(`push_id`, 256) FROM `test_db`.`tb_test` LIMIT 1000;
  • This is No Problem Query
    SELECT `user_no`, LEFT(`push_id`, 256) as A FROM `test_db`.`tb_test` LIMIT 1000;

The difference between the above two queries is alias

but

It works well on the data node.



 Comments   
Comment by Kentoku Shiba (Inactive) [ 2019-04-30 ]

Back quoted name in the Item_ident and column names of SELECT clause should be escaped at generating SQL for data nodes. Please review the following commit.
fbc5fbe

Comment by willhan [ 2019-06-28 ]

kentoku
We don't have this problem, and your solution seems like our's

Comment by Kentoku Shiba (Inactive) [ 2019-06-28 ]

willhan
Thank you for checking this.
I just merged.

Generated at Thu Feb 08 08:34:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.