Details
-
Bug
-
Resolution: Done
-
Major
-
8.12.5
-
None
Description
Teiid's QUARTER function returns integer.
SAP HANA's QUARTER function returns string in form:
Unable to find source-code formatter for language: plain. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
2000-Q1
So the function either shouldn't be pushed down, or it has to be pushed down together with some substring method wrapping it:
SUBSTR_REGEXPR('[[:digit:]]{4}\-Q([[:digit:]]{1})' IN quarter(datevalue) GROUP 1)
