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

Projected comparison between date and timestamp columns always returns true

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.6.0, 4.8.0
    • Fix Version/s: 4.9.0, 4.8.1
    • Component/s: None

      Description

      0: jdbc:phoenix:thin:url=http://localhost:876> create table test (dateCol DATE primary key, timestampCol TIMESTAMP);
      No rows affected (2.559 seconds)
      
      0: jdbc:phoenix:thin:url=http://localhost:876> upsert into test values (TO_DATE('1990-01-01'), NOW());
      1 row affected (0.255 seconds)
      
      0: jdbc:phoenix:thin:url=http://localhost:876> select dateCol = timestampCol from test;
      +------------------------------------------+
      |          DATECOL = TIMESTAMPCOL          |
      +------------------------------------------+
      | true                                     |
      +------------------------------------------+
      1 row selected (0.019 seconds)
      
      

        Attachments

        1. PHOENIX-2946_v2.patch
          9 kB
          James R. Taylor
        2. PHOENIX-2946_v3.patch
          32 kB
          James R. Taylor
        3. PHOENIX-2946_v4.patch
          60 kB
          James R. Taylor
        4. PHOENIX-2946_v5.patch
          102 kB
          James R. Taylor
        5. PHOENIX-2946_v6.patch
          103 kB
          James R. Taylor

          Activity

            People

            • Assignee:
              jamestaylor James R. Taylor
              Reporter:
              kliew Kevin Liew

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment