Accept type_options when testing type casts, making it possible to test every type cast

[silentninja]

Problem

Currently, test case fixture(db/tests/types/operations/test_cast.py:MASTER_DB_TYPE_MAP_SPEC) used to test casting of a column type do not seem to accept type options, so this makes it not possible to test certain type casts like URI to CHAR(CHAR without type_options defaults to 1 character), making the test cases incomplete.

Proposed solution

TARGET_DICT dictionary should accept type_options for each type.

[jjram20]

Hi, I would like to help in this problem.

[silentninja]

@jjram20 Thanks! I have assigned it to you.

[mathemancer]

@jjram20 Hey, are you still making progress on this issue?

[mathemancer]

Unassigning due to lack of progress / feedback.

[Jayitha]

Hi, I'd like to work on this issue.

[kgodey]

Sure, go ahead @Jayitha

[Jayitha]

Hi,

Sorry for the delay, I spent some time playing around with the codebase. I think the whole types system is pretty neat! especially how it renders in Postgres. I created a PR for this issue to get things going. I currently only included support to provide type options for the target type. I'd actually like to work on this issue in tandem with #1138 if possible?

[silentninja]

Sure @Jayitha, that shouldn't be a problem

[github-actions]

This issue has not been updated in 90 days and is being marked as stale.

[mathemancer]

We should avoid doing this until we've moved the type casting functions to the DB, and then also the type casting test suite.