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

Error in counting in sequence engine

    XMLWordPrintable

Details

    Description

      When you count from high to low the Values starts not from "from" Value every time. see sample

      MariaDB [mysql]> select Version();
      +-----------------------+
      | Version()             |
      +-----------------------+
      | 10.1.12-MariaDB-debug |
      +-----------------------+
      1 row in set (0.00 sec)
      

      MariaDB [mysql]> SELECT * FROM seq_15_to_1_step_2;
      +-----+
      | seq |
      +-----+
      |  15 |
      |  13 |
      |  11 |
      |   9 |
      |   7 |
      |   5 |
      |   3 |
      |   1 |
      +-----+
      8 rows in set (0.00 sec)
      

      MariaDB [mysql]> SELECT * FROM seq_15_to_1_step_3;
      +-----+
      | seq |
      +-----+
      |  13 |
      |  10 |
      |   7 |
      |   4 |
      |   1 |
      +-----+
      5 rows in set (0.01 sec)
      

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            Bernd Buffen Bernd Buffen
            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.