Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2934

Checking a coerce expression at top level should not be necessary for Union All query

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.8.0
    • Labels:
      None

      Description

      When working on PHOENIX-2886, found that we need special handling of coerce expression. Otherwise the following query would fail.

      create table person ( id bigint not null primary key, firstname char(10), lastname varchar(10) );
      select id, cast( 'foo' as char(10)) firstname, lastname from person union all select * from person;
      

      Checking a coerce expression at top level should not be necessary. Need to find out root cause on coerceExpression.

        Attachments

        1. PHOENIX-2934.patch
          6 kB
          Alicia Ying Shu
        2. PHOENIX-2934-v1.patch
          8 kB
          Alicia Ying Shu

          Activity

            People

            • Assignee:
              aliciashu Alicia Ying Shu
              Reporter:
              aliciashu Alicia Ying Shu
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: