Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.1.6
-
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; |
|
|
|