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

        split from

        Bug - A problem which impairs or prevents the functions of the product. MCOL-4687 Insert from view regression

        • Major - Major loss of function.
        • Closed

        Activity

          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)

          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.