Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
For example:
CREATE TABLE timecmp (a TIME, b TIME) ENGINE=ColumnStore; |
INSERT INTO timecmp VALUES ('00:00:30', '00:00:31'), ('-00:00:30', '-00:00:29'); |
SELECT a, b, IF(a < b, 'T', 'F') FROM timecmp; |
-- Result:
|
-- +-----------+-----------+---------------------+
|
-- | a | b | IF(a < b, 'T', 'F') |
|
-- +-----------+-----------+---------------------+
|
-- | 00:00:30 | 00:00:31 | T |
|
-- | -00:00:30 | -00:00:29 | F |
|
-- +-----------+-----------+---------------------+
|
--
|
-- Expected:
|
-- +-----------+-----------+---------------------+
|
-- | a | b | IF(a < b, 'T', 'F') |
|
-- +-----------+-----------+---------------------+
|
-- | 00:00:30 | 00:00:31 | T |
|
-- | -00:00:30 | -00:00:29 | T |
|
-- +-----------+-----------+---------------------+ |