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

sum of col=value fails with Internal error: std::bad_typeid

    XMLWordPrintable

Details

    Description

      I have a probleme with this patch https://jira.mariadb.org/browse/MCOL-301

      The test is ok :
      ----------------------------------------------------

      1. mysql 14:23:48 > create table t1 (a int) engine=columnstore;
        Query OK, 0 rows affected (0.08 sec)
      1. mysql 14:24:18 > insert into t1 values (1),(1),(2),(2),(3),(3);
        Query OK, 6 rows affected (0.08 sec)
        Records: 6 Duplicates: 0 Warnings: 0
      1. mysql 14:24:24 > select sum(1) from t1;
        --------
        sum(1)

        --------

        1

        --------
        1 row in set (0.03 sec)

      1. mysql 14:24:37 > select sum((a=1)*(1=1)) from t1;
        ------------------
        sum((a=1)*(1=1))

        ------------------

        2

        ------------------
        1 row in set (0.01 sec)
        -----------------------------------------------------------------

      But I am obliged to add *(1*1) . Too bad

      1. mysql 14:25:02 > select sum(a=1) from t1;
        ERROR 1815 (HY000): Internal error: std::bad_typeid

      Attachments

        Issue Links

          Activity

            People

              David.Hall David Hall (Inactive)
              dthompson David Thompson (Inactive)
              Andrey Piskunov Andrey Piskunov (Inactive)
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.