[MCOL-327] time() comparison broken with quoted numbers Created: 2016-09-26  Updated: 2016-09-28  Resolved: 2016-09-28

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Andrew Hutchings (Inactive)
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
PartOf
is part of MCOL-25 001 Working Folder UM Join Test Fails Closed
is part of MCOL-280 Beta issues Closed
Sprint: 2016-19

 Description   

working_tpch1/qa_fe_cnxFunctions/bug3584.sql
time(0) does not compare with '0'. Also with values such as '074000' the minutes are truncated.

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2016-09-27 ]

This one is might be too complex for now. Basically PrimProc tries to do a string comparison of the time (ie. '06:40:22') to the input which is '074000'. I'll take a quick look at the function builder around ha_calpont_execplan.cpp:2828 tomorrow to see if I can get some better support for "cast_as_time" comparison.

Generated at Thu Feb 08 02:20:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.