SQL: tracker for missing scalar functions

[elasticmachine]

Original comment by @costin:

This is a meta-issue for tracking the various missing functions missing according to SQL/ODBC/JDBC spec.

To keep things in sync across server and client, let's use the ODBC spec

• String

The vast majority are implemented - are missing methods with two arguments and truncation, namely:

• Numeric

• ATAN2
• COT
• MOD
• POWER
• ROUND( numeric_exp, integer_exp)
• SIGN
• TRUNCATE

• System
  Outside IfNull, the rest are straight-forward.

• DATABASE
• IFNULL
• USER

• Time/Date

EXTRACT & co are implemented; date math, interval, current and name are missing:

• CURRENT_DATE( )
• CURRENT_TIME[( time-precision )]
• CURRENT_TIMESTAMP
• CURDATE()
• CURTIME()
• DAYNAME( date_exp )
• MONTHNAME( date_exp )
• NOW( )
• QUARTER( )
• TIMESTAMPADD
• TIMESTAMPDIFF

The time math depends on LINK REDACTED .

• Conversion

• CAST
  Whic is supported but needs double-checking.

[matriv]

@costin do you thing we should close this?

[matriv]

Closing this as all functions listed are implemented.