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

        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.