[MDEV-27489] Create view on Connect TABLE with decimal type column return errors or 0,00... value Created: 2022-01-13  Updated: 2022-02-14

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.4.22
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Davide Bonsangue Assignee: Olivier Bertrand
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Centos 7 Linux



 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.


Generated at Thu Feb 08 09:53:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.