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

Date-time functions on null dates return no data

    XMLWordPrintableJSON

Details

    • Test
    • Status: Resolved
    • Minor
    • Resolution: Cannot Reproduce
    • 4.4.0
    • None
    • None

    • HDP 2.3.4

    Description

      select month(at1.DATE_col5) from at1 where date_col5 is null

      returns zero rows but should return one null row for each null row in at1.DATE_col5

      Attachments

        Issue Links

          links to

          Web Link GitHub Pull Request #201

          Activity

            People

              kliew Kevin Liew
              kliew Kevin Liew
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: