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

Mariadb 10.3.9 Spider DB SQL Alias no execute

    XMLWordPrintable

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

        1. ScreenClip.png
          11 kB
          a1s2d3f4
        2. ScreenClip [1].png
          7 kB
          a1s2d3f4

        Activity

          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.