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

TO_CHAR fails to handle indexed null value

Attach filesAttach ScreenshotVotersStop watchingWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.8.0
    • None
    • None

    Description

      Steps to reproduce

      create table t (id integer primary key, ts1 timestamp, ts2 timestamp);
      create index t_ts2_idx on t (ts2);
      upsert into t values (1, null, null);
      
      -- OK
      select to_char(ts1) from t;
      
      -- java.lang.IllegalArgumentException: Unknown class: <null>
      select to_char(ts2) from t;
      

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            junegunn Junegunn Choi
            junegunn Junegunn Choi
            Votes:
            0 Vote for this issue
            Watchers:
            5 Stop watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment