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

Syntax error with federeted_pushdown=ON and using BETWEEN operator on Date Column

    XMLWordPrintable

Details

    • Unexpected results

    Description

      Issue:

      ---------
      With federated_pushdown=ON , query throws syntax error
      Note: With OFF , query executes fine.

      MariaDB [m8]> UPDATE D AS OUTR1, D AS OUTR2 SET OUTR1.a=NULL WHERE OUTR1.a BETWEEN NULL AND NULL;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<cache>(NULL) and <cache>(NULL)' at line 1

      Version used:

      ----------------
      Debug build
      Branch : 13.2-MDEV-41243-fedx-pushdown-assert-for-upd-del-prepared-stmts
      commit: e7d83013b31c4cc97a0003a0e58b707d94cba042
      Version : 13.1.0

      How to repeat:

      ----------------
      Slave:

      create table D( a date);
      

      Master: Start server with federated engine enabled

      create table D(a date)  ENGINE="FEDERATED" CONNECTION='mysql://u3@127.0.0.1:3306/m8/D';
       
      set global federated_pushdown=ON;
      UPDATE D AS OUTR1, D AS OUTR2 SET OUTR1.a=NULL WHERE OUTR1.a BETWEEN NULL AND NULL;
      

      Attachments

        Issue Links

          Activity

            People

              bsrikanth Srikanth Bondalapati
              mariadb-pavithrapandith Pavithra Pandith
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1d 1h 20m
                  1d 1h 20m

                  Git Integration

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