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

error 1815 invalid column type with complex window function query

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.1.5
    • Icebox
    • ExeMgr
    • None

    Description

      To reproduce:

      CREATE TABLE `q1` (
        `bin1` int(11) DEFAULT NULL,
        `bin2` int(11) DEFAULT NULL,
        `bin3` int(11) DEFAULT NULL,
        `non_zero` int(11) DEFAULT NULL
      ) ENGINE=Columnstore;
       
      insert into q1 values (0 ,0 ,1 , 10);
      insert into q1 values (0 ,0, 23 , 2);
      insert into q1 values (0 ,1, 14 , 3);
      insert into q1 values (1 ,1 ,7 , 9); 
      insert into q1 values (1 ,1 ,7 , 10);
       
      select
          t.bin1,
          if( count(t.bin1) over (  )
              % ( dense_rank() over (order by bin1 asc ) + dense_rank() over (order by bin1 desc ) - 1 ) = 0
              and VARIANCE(t.non_zero) over (  ) = 0
              , 1, 0) as coll1
      from q1 t;
       
       
      ERROR 1815 (HY000): Internal error: Error while fetching from ExeMgr: Row::isNullValue(): got bad column type (32544).  Width=32544
      

      removing the variance window function or adding a partition clause to it removes the error.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dthompson David Thompson (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.