Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
1.1.1
-
None
Description
Build tested: 1.1.1-1
Autopilot's datatypecasting test was designed to join columns of different datatypes. It compares query requires between columnstore and innodb to ensure columnstore is working correctly, or at least the same as innodb. Few examples of such joins are:
date=vchar()
tinyint=smallint
tinyint=decimal
integer=varchar()
The test suite use to work, and now return over 800 error because of incompatible data types in join clause.
The concern is that, good practice or not, people do use string columns to store numeric strings, dates, etc. These join requirement could be too restrictive for some existing data bases to be converted to ColumnStore. Such simple joins should be supported, especially they are supported in InnoDB.