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

Spider: IF(COUNT( trigger SQL Error (1054)_ Unknown column '' in field list

    XMLWordPrintable

Details

    Description

      Hio,

      works with 10.4.13, somewhere between 10.4.14 and 10.4.17 broken.

      Testcase to reproduce

       
      USE spider;
       
      DROP TABLE if EXISTS `t1`;
      DROP TABLE if EXISTS `t1remote`;
       
      CREATE TABLE `t1` (
      	id INT)
      	;
      CREATE TABLE `t1remote` (
      	id INT)
       ENGINE=SPIDER DEFAULT CHARSET=utf8 COMMENT='host "127.0.0.1",  database "spider" ,table "t1" ,user "spider", password "xxxxxxx", port "3307"';
      	
      SELECT IF(COUNT(a.`id` )>=0,'Y','N') FROM t1remote a;
      

      Attachments

        Issue Links

          Activity

            People

              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              Richard Richard Stracke
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.