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

delete throw error in Stored Procedures

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 1.0.0, 1.2
    • Icebox
    • MariaDB Server
    • None

    Description

      delete in stored procedures throw error

      ERROR 1178 (42000): The storage engine for the table doesn't support This stored procedure syntax is not supported by Columnstore in this version

      to reproduce:

      CREATE DATABASE `testsp`;
      use testsp;
      CREATE TABLE `ts1` (
      	`id` int
      )
      ENGINE=columnstore
      ;
      

      CREATE DEFINER=`root`@`%` PROCEDURE `simpledelete`()
      BEGIN
      delete from ts1;
      END
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              Richard Richard Stracke
              Votes:
              1 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.