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

crossjoin without result , if datatype decimal is exact decimal(18,0)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 1.1.6
    • Icebox
    • DMLProc
    • None
    • Debian 9 , Columnstore 1.1.6

    Description

      Crossjoin gives no results back, if datatype in the innodbtable is exact decimal (18,0)

      Works with decimal (17,0) and decimal(19,0)
      Testcase:

      drop table if exists `d1`;
      drop table if exists `d2`;
       
       CREATE TABLE `d1` (
        `dec18` decimal(18,0) DEFAULT -1
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      ;
       
       CREATE TABLE `d2` (
        `dec18` decimal(18,0) DEFAULT -1
      ) ENGINE=Columnstore DEFAULT CHARSET=latin1 
      ;
       
      INSERT INTO `d1` (`dec18`) VALUES (5);
      INSERT INTO `d2` (`dec18`) VALUES (5);
       
      select d1.dec18,d2.dec18 from d1,d2 where d1.dec18 = d2.dec18;
       
      or 
       
      select d1.dec18,d2.dec18 
      from d1 
      inner join d2
      on d1.dec18 = d2.dec18;
       
       
      
      

      Attachments

        Activity

          People

            kirill.perov@mariadb.com Kirill Perov
            Richard Richard Stracke
            Votes:
            2 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.