[MCOL-4468] ALTER TABLE ADD COLUMN ... TIME fails with Internal error Created: 2020-12-23  Updated: 2021-02-02  Resolved: 2021-01-29

Status: Closed
Project: MariaDB ColumnStore
Component/s: writeengine
Affects Version/s: 6.1.1
Fix Version/s: 6.1.1

Type: Bug Priority: Minor
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-4236 ceiling() gives wrong answer for date... Closed
Sprint: 2021-2

 Description   

Consider the example.

MariaDB [test]> alter table dtypes add column tm time;
 
ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed:  AlterTableProcessor::addColumn CAL0001: we_readthread caught exception  boost::bad_any_cast: failed conversion using boost::any_cast

This happens b/c any::boost conversion in WriteEngineWrapper::convertValue() throws an exception trying to cast from int64_t (AKA long in x86_64) into long long.

 Comments   
Comment by Roman [ 2020-12-24 ]

The regression part for MCOL-4236 had been merged into develop and not develop-5. After that test000 started to fail.

Comment by Roman [ 2020-12-24 ]

4QA The query from the description should be enough to test but I will appreciate if you test it with other temporal data types.

Comment by Daniel Lee (Inactive) [ 2021-01-29 ]

Build verified: 6.1.1 (Drone b1583)

Tested on all supported data types.

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