GitHub user DaveBirdsall opened a pull request:
https://github.com/apache/trafodion/pull/1541
[TRAFODION-3043] Add missing binder check for DATE_PART function
This change adds a check to Extract::synthesizeType
(optimizer/SynthType.cpp) to raise a 4037 error if one attempts to perform
DATE_PART on an Interval data type with an extract qualifier of YEARMONTH or
YEARQUARTER.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/DaveBirdsall/trafodion DatePartBug
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1541.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1541
----
commit 5c6bf2a14a9e748fa08ac5e905cb62c451257b16
Author: Dave Birdsall <dbirdsall@...>
Date: 2018-04-26T00:19:59Z
[TRAFODION-3043] Add missing binder check for DATE_PART function
----
---