Open lukaseder opened 3 years ago
Continuing with #11704, here are some remaining dialects whose NaN or Infinity floating point values are not yet supported:
NaN
Infinity
INF
NAN
Inf
These dialects would require formal support for vendor specific float types, first:
SNAN
INFINITY
DECFLOAT
CAST('NaN' AS DECFLOAT)
CAST('Infinity' AS DECFLOAT)
Nan
-Infinity
0f/0
1f/0
-1f/0
BINARY_DOUBLE
BINARY_FLOAT
I'll use the momentum from the jOOQ 3.20 DECFLOAT support to fix these as well:
Continuing with #11704, here are some remaining dialects whose
NaN
orInfinity
floating point values are not yet supported:INF
orNAN
in the string version of the value: https://stackoverflow.com/q/33192022/521799NaN
orInf
: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36271.1550/html/blocks/blocks27.htmNaN
orInf
: http://infocenter.sybase.com/help/topic/com.sybase.dbrfen10/pdf/dbrfen10.pdfNaN
orInf
(only unauthoritative docs found, to be verified)These dialects would require formal support for vendor specific float types, first:
SNAN
orINFINITY
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000731.html (only forDECFLOAT
)CAST('NaN' AS DECFLOAT)
andCAST('Infinity' AS DECFLOAT)
also seems to work, so let's leave it at that.Nan
,Infinity
,-Infinity
: https://www.ibm.com/support/knowledgecenter/SSGU8G_11.70.0/com.ibm.jccids.doc/src/tpc/imjcc_cjv00003.htm (only forDECFLOAT
)0f/0
,1f/0
,-1f/0
(only forBINARY_DOUBLE
andBINARY_FLOAT
)