registerFunction( "ascii", new StandardSQLFunction( "ascii", StandardBasicTypes.INTEGER ) ); registerFunction( "char", new StandardSQLFunction( "char", StandardBasicTypes.CHARACTER ) ); registerFunction( "len", new StandardSQLFunction( "len", StandardBasicTypes.LONG ) ); registerFunction( "lower", new StandardSQLFunction( "lower" ) ); registerFunction( "upper", new StandardSQLFunction( "upper" ) ); registerFunction( "str", new StandardSQLFunction( "str", StandardBasicTypes.STRING ) ); registerFunction( "ltrim", new StandardSQLFunction( "ltrim" ) ); registerFunction( "rtrim", new StandardSQLFunction( "rtrim" ) ); registerFunction( "reverse", new StandardSQLFunction( "reverse" ) ); registerFunction( "space", new StandardSQLFunction( "space", StandardBasicTypes.STRING ) ); registerFunction( "user", new NoArgSQLFunction( "user", StandardBasicTypes.STRING ) ); registerFunction( "current_timestamp", new NoArgSQLFunction( "getdate", StandardBasicTypes.TIMESTAMP ) ); registerFunction( "current_time", new NoArgSQLFunction( "getdate", StandardBasicTypes.TIME ) ); registerFunction( "current_date", new NoArgSQLFunction( "getdate", StandardBasicTypes.DATE ) ); registerFunction( "getdate", new NoArgSQLFunction( "getdate", StandardBasicTypes.TIMESTAMP ) ); registerFunction( "getutcdate", new NoArgSQLFunction( "getutcdate", StandardBasicTypes.TIMESTAMP ) ); registerFunction( "day", new StandardSQLFunction( "day", StandardBasicTypes.INTEGER ) ); registerFunction( "month", new StandardSQLFunction( "month", StandardBasicTypes.INTEGER ) ); registerFunction( "year", new StandardSQLFunction( "year", StandardBasicTypes.INTEGER ) ); registerFunction( "datename", new StandardSQLFunction( "datename", StandardBasicTypes.STRING ) ); registerFunction( "abs", new StandardSQLFunction( "abs" ) ); registerFunction( "sign", new StandardSQLFunction( "sign", StandardBasicTypes.INTEGER ) ); registerFunction( "acos", new StandardSQLFunction( "acos", StandardBasicTypes.DOUBLE ) ); registerFunction( "asin", new StandardSQLFunction( "asin", StandardBasicTypes.DOUBLE ) );
registerFunction( "ascii", new StandardSQLFunction("ascii", StandardBasicTypes.INTEGER) ); registerFunction( "char", new StandardSQLFunction("char", StandardBasicTypes.CHARACTER) ); registerFunction( "len", new StandardSQLFunction("len", StandardBasicTypes.LONG) ); registerFunction( "lower", new StandardSQLFunction("lower") ); registerFunction( "upper", new StandardSQLFunction("upper") ); registerFunction( "str", new StandardSQLFunction("str", StandardBasicTypes.STRING) ); registerFunction( "ltrim", new StandardSQLFunction("ltrim") ); registerFunction( "rtrim", new StandardSQLFunction("rtrim") ); registerFunction( "reverse", new StandardSQLFunction("reverse") ); registerFunction( "space", new StandardSQLFunction("space", StandardBasicTypes.STRING) ); registerFunction( "user", new NoArgSQLFunction("user", StandardBasicTypes.STRING) ); registerFunction( "current_timestamp", new NoArgSQLFunction("getdate", StandardBasicTypes.TIMESTAMP) ); registerFunction( "current_time", new NoArgSQLFunction("getdate", StandardBasicTypes.TIME) ); registerFunction( "current_date", new NoArgSQLFunction("getdate", StandardBasicTypes.DATE) ); registerFunction( "getdate", new NoArgSQLFunction("getdate", StandardBasicTypes.TIMESTAMP) ); registerFunction( "getutcdate", new NoArgSQLFunction("getutcdate", StandardBasicTypes.TIMESTAMP) ); registerFunction( "day", new StandardSQLFunction("day", StandardBasicTypes.INTEGER) ); registerFunction( "month", new StandardSQLFunction("month", StandardBasicTypes.INTEGER) ); registerFunction( "year", new StandardSQLFunction("year", StandardBasicTypes.INTEGER) ); registerFunction( "datename", new StandardSQLFunction("datename", StandardBasicTypes.STRING) ); registerFunction( "abs", new StandardSQLFunction("abs") ); registerFunction( "sign", new StandardSQLFunction("sign", StandardBasicTypes.INTEGER) ); registerFunction( "acos", new StandardSQLFunction("acos", StandardBasicTypes.DOUBLE) ); registerFunction( "asin", new StandardSQLFunction("asin", StandardBasicTypes.DOUBLE) );
registerFunction( "ascii", new StandardSQLFunction("ascii", StandardBasicTypes.INTEGER) ); registerFunction( "char", new StandardSQLFunction("char", StandardBasicTypes.CHARACTER) ); registerFunction( "len", new StandardSQLFunction("len", StandardBasicTypes.LONG) ); registerFunction( "lower", new StandardSQLFunction("lower") ); registerFunction( "upper", new StandardSQLFunction("upper") ); registerFunction( "str", new StandardSQLFunction("str", StandardBasicTypes.STRING) ); registerFunction( "ltrim", new StandardSQLFunction("ltrim") ); registerFunction( "rtrim", new StandardSQLFunction("rtrim") ); registerFunction( "reverse", new StandardSQLFunction("reverse") ); registerFunction( "space", new StandardSQLFunction("space", StandardBasicTypes.STRING) ); registerFunction( "user", new NoArgSQLFunction("user", StandardBasicTypes.STRING) ); registerFunction( "current_timestamp", new NoArgSQLFunction("getdate", StandardBasicTypes.TIMESTAMP) ); registerFunction( "current_time", new NoArgSQLFunction("getdate", StandardBasicTypes.TIME) ); registerFunction( "current_date", new NoArgSQLFunction("getdate", StandardBasicTypes.DATE) ); registerFunction( "getdate", new NoArgSQLFunction("getdate", StandardBasicTypes.TIMESTAMP) ); registerFunction( "getutcdate", new NoArgSQLFunction("getutcdate", StandardBasicTypes.TIMESTAMP) ); registerFunction( "day", new StandardSQLFunction("day", StandardBasicTypes.INTEGER) ); registerFunction( "month", new StandardSQLFunction("month", StandardBasicTypes.INTEGER) ); registerFunction( "year", new StandardSQLFunction("year", StandardBasicTypes.INTEGER) ); registerFunction( "datename", new StandardSQLFunction("datename", StandardBasicTypes.STRING) ); registerFunction( "abs", new StandardSQLFunction("abs") ); registerFunction( "sign", new StandardSQLFunction("sign", StandardBasicTypes.INTEGER) ); registerFunction( "acos", new StandardSQLFunction("acos", StandardBasicTypes.DOUBLE) ); registerFunction( "asin", new StandardSQLFunction("asin", StandardBasicTypes.DOUBLE) );