Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4704

Retest MCOL-4687 (Insert from view) regression in 6.1.1 when ready

Details

    • Task
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • None
    • 6.1.1
    • ExeMgr
    • None
    • 2021-8

    Attachments

      Issue Links

        Activity

          MariaDB [monty]> INSERT INTO bar SELECT * FROM view_foo;
          Query OK, 1 row affected (1.623 sec)
          Records: 1  Duplicates: 0  Warnings: 0
           
          MariaDB [monty]> select * from view_foo;
          +------+-------+
          | id   | fname |
          +------+-------+
          |    1 | Greg  |
          +------+-------+
          1 row in set (0.001 sec)
           
          MariaDB [monty]> select * from bar;
          +------+-------+
          | id   | fname |
          +------+-------+
          |    1 | Greg  |
          +------+-------+
          1 row in set (0.067 sec)
           
          MariaDB [monty]> INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t;
          Query OK, 1 row affected (1.284 sec)
          Records: 1  Duplicates: 0  Warnings: 0
           
          MariaDB [monty]> select * from bar;
          +------+-------+
          | id   | fname |
          +------+-------+
          |    1 | Greg  |
          |    1 | Greg  |
          +------+-------+
          2 rows in set (0.018 sec)
          
          

          dleeyh Daniel Lee (Inactive) added a comment - MariaDB [monty]> INSERT INTO bar SELECT * FROM view_foo; Query OK, 1 row affected (1.623 sec) Records: 1 Duplicates: 0 Warnings: 0   MariaDB [monty]> select * from view_foo; +------+-------+ | id | fname | +------+-------+ | 1 | Greg | +------+-------+ 1 row in set (0.001 sec)   MariaDB [monty]> select * from bar; +------+-------+ | id | fname | +------+-------+ | 1 | Greg | +------+-------+ 1 row in set (0.067 sec)   MariaDB [monty]> INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; Query OK, 1 row affected (1.284 sec) Records: 1 Duplicates: 0 Warnings: 0   MariaDB [monty]> select * from bar; +------+-------+ | id | fname | +------+-------+ | 1 | Greg | | 1 | Greg | +------+-------+ 2 rows in set (0.018 sec)

          People

            dleeyh Daniel Lee (Inactive)
            gdorman Gregory Dorman (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.