Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17204

Mariadb 10.3.9 Spider DB SQL Alias no execute

Details

    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.

      Attachments

        Activity

          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

          Kentoku Kentoku Shiba (Inactive) added a comment - 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
          willhan willhan added a comment -

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

          willhan willhan added a comment - kentoku We don't have this problem, and your solution seems like our's

          willhan
          Thank you for checking this.
          I just merged.

          Kentoku Kentoku Shiba (Inactive) added a comment - willhan Thank you for checking this. I just merged.

          People

            Kentoku Kentoku Shiba (Inactive)
            q1w2e3r4 a1s2d3f4
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.