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

Projected comparison between date and timestamp columns always returns true

    XMLWordPrintableJSON

    Details

      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_v6.patch
          103 kB
          James R. Taylor
        2. PHOENIX-2946_v5.patch
          102 kB
          James R. Taylor
        3. PHOENIX-2946_v4.patch
          60 kB
          James R. Taylor
        4. PHOENIX-2946_v3.patch
          32 kB
          James R. Taylor
        5. PHOENIX-2946_v2.patch
          9 kB
          James R. Taylor

          Issue Links

            Activity

              People

              • Assignee:
                jamestaylor James R. Taylor
                Reporter:
                kliew Kevin Liew
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: