[#MCOL-2059] Strings or empty strings are inserted as zero values in numeric data types

Strings or empty strings are inserted as zero values in numeric data types

expected: receive Error and operation is rejected

note:builtin innodb_version 10.3.11 and server version 10.3.11-MariaDB

1. Create tables with engine Columnstore and InnoDB columns of integer data type
2. Insert into string values --Operation is accepted and it's inserted zero values

MariaDB [a]> show create table acol;

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

| Table | Create Table                                                                                                             |

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

| acol  | CREATE TABLE `acol` (

  `a` int(11) DEFAULT NULL,

  `b` int(11) DEFAULT NULL

) ENGINE=Columnstore DEFAULT CHARSET=latin1 |

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

1 row in set (0.001 sec)

MariaDB [a]> show create table ainn;

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

| Table | Create Table                                                                                                        |

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

| ainn  | CREATE TABLE `ainn` (

  `a` int(11) DEFAULT NULL,

  `b` int(11) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

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

1 row in set (0.000 sec)

MariaDB [a]>

2.1 Insert a string

MariaDB [a]> insert into acol values ("RR",1);

Query OK, 1 row affected, 1 warning (0.364 sec)

MariaDB [a]> select * from acol;

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

| a    | b    |

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

|    0 |    1 |

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

1 row in set (0.100 sec)

MariaDB [a]> insert into ainn values ("RR",1);

Query OK, 1 row affected, 1 warning (0.014 sec)

MariaDB [a]> select * from ainn;

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

| a    | b    |

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

|    0 |    1 |

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

1 row in set (0.001 sec)

2.2 Insert an empty string

MariaDB [a]> insert into acol values ("",1);

Query OK, 1 row affected, 1 warning (0.105 sec)

MariaDB [a]> select * from acol;

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

| a    | b    |

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

|    0 |    1 |

|    0 |    1 |

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

2 rows in set (0.039 sec)

MariaDB [a]> insert into ainn values ("",1);

Query OK, 1 row affected, 1 warning (0.009 sec)

MariaDB [a]> select * from ainn;

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

| a    | b    |

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

|    0 |    1 |

|    0 |    1 |

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

2 rows in set (0.002 sec)

expected behavior as in pure MariDB server installation:

MariaDB [a]>  insert into a values ("RR",1) ;

ERROR 1366 (22007): Incorrect integer value: 'RR' for column 'a' at row 1

MariaDB [a]>  insert into a values ("",1) ;

ERROR 1366 (22007): Incorrect integer value: '' for column 'a' at row 1

MariaDB [a]>

[MCOL-2059] Strings or empty strings are inserted as zero values in numeric data types Created: 2019-01-04 Updated: 2019-09-29 Resolved: 2019-09-29
Status:	Closed
Project:	MariaDB ColumnStore
Component/s:	MariaDB Server
Affects Version/s:	1.2.2
Fix Version/s:	Icebox

[MCOL-2059] Strings or empty strings are inserted as zero values in numeric data types Created: 2019-01-04 Updated: 2019-09-29 Resolved: 2019-09-29