feature: The tianmu storage engine does not support union query for fields whose data types are datetime and timestamp

[haitaoguan]

mysql> create table t1(a datetime);
Query OK, 0 rows affected (0.02 sec)

mysql> create table t2(b timestamp);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t1 values('2020-12-23 00:00:00');
Query OK, 1 row affected (0.00 sec)

mysql> insert into t2 values('2022-04-18 00:00:00');
Query OK, 1 row affected (0.00 sec)

mysql> select * from t1 union select * from t2;
ERROR 1105 (HY000): The query includes syntax that is not supported by the storage engine. Tianmu: UNION of non-matching columns (column no 0) .

[isredstar]

ACK

[isredstar]

bool is_timestamp1 = (this->vc_type.GetTypeName() == common::ColumnType::TIMESTAMP);
bool is_timestamp2 = (vc->Type().GetTypeName() == common::ColumnType::TIMESTAMP);
if (is_timestamp1 ^ is_timestamp2)
return false;  // cannot compare timestamp with anything different than
                  // timestamp