[#MDEV-12520] ConnectSE truncating data on DECIMAL column

The Connect engine is doing some strange things for a DECIMAL column.

It starts off normal:

MariaDB [test]> CREATE TABLE connect14007 ( id INT PRIMARY KEY AUTO_INCREMENT, foo DECIMAL(18,3));

Query OK, 0 rows affected (0.02 sec)

MariaDB [test]> CREATE TABLE connect14007j ENGINE=CONNECT TABLE_TYPE=JDBC TABNAME=connect14007 CONNECTION='jdbc:mysql://localhost/test?user=root';

Query OK, 0 rows affected (0.02 sec)

MariaDB [test]> INSERT INTO connect14007 ( foo ) VALUES ( 1234567890.123 );

Query OK, 1 row affected (0.09 sec)

MariaDB [test]> SELECT 'MariaDB', foo FROM connect14007 UNION ALL SELECT 'Connect', foo FROM connect14007j;

+---------+----------------+

| MariaDB | foo            |

+---------+----------------+

| MariaDB | 1234567890.123 |

| Connect | 1234567890.123 |

+---------+----------------+

2 rows in set (0.01 sec)

MariaDB [test]>

Until we add one more number (10x):

MariaDB [test]> INSERT INTO connect14007 ( foo ) VALUES ( 12345678901.123 );

Query OK, 1 row affected (0.00 sec)

MariaDB [test]> SELECT 'MariaDB', foo FROM connect14007 UNION ALL SELECT 'Connect', foo FROM connect14007j;

+---------+-----------------+

| MariaDB | foo             |

+---------+-----------------+

| MariaDB |  1234567890.123 |

| MariaDB | 12345678901.123 |

| Connect |  1234567890.123 |

| Connect | 12345678901.123 |

+---------+-----------------+

4 rows in set, 1 warning (0.00 sec)

MariaDB [test]> SHOW WARNINGS;

+-------+------+------------------------------------------+

| Level | Code | Message                                  |

+-------+------+------------------------------------------+

| Note  | 1265 | Data truncated for column 'foo' at row 2 |

+-------+------+------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]>

We can do this three more times:

MariaDB [test]> SELECT 'MariaDB', foo FROM connect14007 UNION ALL SELECT 'Connect', foo FROM connect14007j;

+---------+--------------------+

| MariaDB | foo                |

+---------+--------------------+

| MariaDB |     1234567890.123 |

| MariaDB |    12345678901.123 |

| MariaDB |   123456789012.123 |

| MariaDB |  1234567890123.123 |

| MariaDB | 12345678901234.123 |

| Connect |     1234567890.123 |

| Connect |    12345678901.123 |

| Connect |   123456789012.123 |

| Connect |  1234567890123.123 |

| Connect | 12345678901234.123 |

+---------+--------------------+

10 rows in set, 4 warnings (0.01 sec)

MariaDB [test]> show warnings;

+-------+------+------------------------------------------+

| Level | Code | Message                                  |

+-------+------+------------------------------------------+

| Note  | 1265 | Data truncated for column 'foo' at row 2 |

| Note  | 1265 | Data truncated for column 'foo' at row 3 |

| Note  | 1265 | Data truncated for column 'foo' at row 4 |

| Note  | 1265 | Data truncated for column 'foo' at row 5 |

+-------+------+------------------------------------------+

4 rows in set (0.00 sec)

MariaDB [test]>

And the fifth one somehow changes the decimal value:

MariaDB [test]> INSERT INTO connect14007 ( foo ) VALUES ( 123456789012345.123 );

Query OK, 1 row affected (0.00 sec)

MariaDB [test]> SELECT 'MariaDB', foo FROM connect14007 UNION ALL SELECT 'Connect', foo FROM connect14007j;

+---------+---------------------+

| MariaDB | foo                 |

+---------+---------------------+

| MariaDB |      1234567890.123 |

| MariaDB |     12345678901.123 |

| MariaDB |    123456789012.123 |

| MariaDB |   1234567890123.123 |

| MariaDB |  12345678901234.123 |

| MariaDB | 123456789012345.123 |

| Connect |      1234567890.123 |

| Connect |     12345678901.123 |

| Connect |    123456789012.123 |

| Connect |   1234567890123.123 |

| Connect |  12345678901234.123 |

| Connect | 123456789012345.125 |

+---------+---------------------+

12 rows in set, 4 warnings (0.00 sec)

MariaDB [test]> SHOW WARNINGS;

+-------+------+------------------------------------------+

| Level | Code | Message                                  |

+-------+------+------------------------------------------+

| Note  | 1265 | Data truncated for column 'foo' at row 2 |

| Note  | 1265 | Data truncated for column 'foo' at row 3 |

| Note  | 1265 | Data truncated for column 'foo' at row 4 |

| Note  | 1265 | Data truncated for column 'foo' at row 5 |

+-------+------+------------------------------------------+

4 rows in set (0.00 sec)

MariaDB [test]>

[MDEV-12520] ConnectSE truncating data on DECIMAL column Created: 2017-04-18 Updated: 2020-08-25 Resolved: 2017-05-09
Status:	Closed
Project:	MariaDB Server
Component/s:	Storage Engine - Connect
Affects Version/s:	10.1.19
Fix Version/s:	10.1.25, 10.0.31, 10.2.7