Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27489

Create view on Connect TABLE with decimal type column return errors or 0,00... value

Details

    Description

      When select values on a view with decimal column/s from a Connect table, MariaDB returns error or value filled with 0,00...
      How to reproduce:

      CREATE TABLE test_table (
      		 
      `dec_column` decimal(22,8) DEFAULT NULL
      		 
      ) ENGINE=CONNECT DEFAULT CHARSET=latin1 CONNECTION='Driver=ODBC Driver 17 for SQL Server;Server=192.168.*.*,1434;Database=DBNAME;UID=sa;PWD=password;connect timeout=3600' `TABLE_TYPE`='ODBC' `TABNAME`='original_table';
      		 
       
      		 
      CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `test_view` AS select sql_cache `test_table`.`dec_column` AS `dec_column` from `test_table` ;
      		 
       
      		 
      SELECT * FROM test_view;
      		 
      Result:
      		 
      0.00000000
      		 
      0.00000000
      		 
      0.00000000
      		 
      0.00000000
      		 
      .......

      MariaDB 10.4.21 works without problems.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          brainstorm Davide Bonsangue created issue -
          anel Anel Husakovic made changes -
          Field Original Value New Value
          Description When select values on a view with decimal column/s from a Connect table, mariadb returns error or value filled with 0,00...
          How to reproduce:

          CREATE TABLE test_table (
          `dec_column` decimal(22,8) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=latin1 CONNECTION='Driver=ODBC Driver 17 for SQL Server;Server=192.168.*.*,1434;Database=DBNAME;UID=sa;PWD=password;connect timeout=3600' `TABLE_TYPE`='ODBC' `TABNAME`='original_table';

          CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `test_view` AS select sql_cache `test_table`.`dec_column` AS `dec_column` from `test_table` ;

          SELECT * FROM test_view;
          Result:
          0.00000000
          0.00000000
          0.00000000
          0.00000000
          .......           		When select values on a view with decimal column/s from a {{Connect}} table, {{MariaDB}} returns error or value filled with 0,00...
          How to reproduce:
          {code}
          CREATE TABLE test_table (
          `dec_column` decimal(22,8) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=latin1 CONNECTION='Driver=ODBC Driver 17 for SQL Server;Server=192.168.*.*,1434;Database=DBNAME;UID=sa;PWD=password;connect timeout=3600' `TABLE_TYPE`='ODBC' `TABNAME`='original_table';

          CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `test_view` AS select sql_cache `test_table`.`dec_column` AS `dec_column` from `test_table` ;

          SELECT * FROM test_view;
          Result:
          0.00000000
          0.00000000
          0.00000000
          0.00000000
          .......
          {code}
          anel Anel Husakovic made changes -
          Assignee Olivier Bertrand [ bertrandop ]
          anel Anel Husakovic made changes -
          Description When select values on a view with decimal column/s from a {{Connect}} table, {{MariaDB}} returns error or value filled with 0,00...
          How to reproduce:
          {code}
          CREATE TABLE test_table (
          `dec_column` decimal(22,8) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=latin1 CONNECTION='Driver=ODBC Driver 17 for SQL Server;Server=192.168.*.*,1434;Database=DBNAME;UID=sa;PWD=password;connect timeout=3600' `TABLE_TYPE`='ODBC' `TABNAME`='original_table';

          CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `test_view` AS select sql_cache `test_table`.`dec_column` AS `dec_column` from `test_table` ;

          SELECT * FROM test_view;
          Result:
          0.00000000
          0.00000000
          0.00000000
          0.00000000
          .......
          {code}           		When select values on a view with decimal column/s from a {{Connect}} table, {{MariaDB}} returns error or value filled with 0,00...
          How to reproduce:
          {code}
          CREATE TABLE test_table (
          `dec_column` decimal(22,8) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=latin1 CONNECTION='Driver=ODBC Driver 17 for SQL Server;Server=192.168.*.*,1434;Database=DBNAME;UID=sa;PWD=password;connect timeout=3600' `TABLE_TYPE`='ODBC' `TABNAME`='original_table';

          CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `test_view` AS select sql_cache `test_table`.`dec_column` AS `dec_column` from `test_table` ;

          SELECT * FROM test_view;
          Result:
          0.00000000
          0.00000000
          0.00000000
          0.00000000
          .......
          {code}

          MariaDB 10.4.21 works without problems.
          elenst Elena Stepanova made changes -
          Fix Version/s 10.4 [ 22408 ]

          People

            bertrandop Olivier Bertrand
            brainstorm Davide Bonsangue
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.