001package gudusoft.gsqlparser; 002 003/* 004* Date: 12-8-22 005*/ 006public enum EFunctionType { 007 unknown_t, 008 builtin_t, 009 udf_t, 010 trim_t, 011 cast_t, 012 convert_t, 013 extract_t, 014 extract_xml_t, 015 treat_t, 016 contains_t, 017 freetext_t, // 018 casen_t, //teradata 019 rangen_t, //teradata 020 position_t, //teradata 021 translate_t, //teradata ,oracle 022 translate_chk_t, //teradata 023 csum_t, //teradata 024 rank_t, //teradata 025 substring_t,//mysql , informix 026 adddate_t,//mysql 027 date_add_t,//mysql 028 subdate_t,//mysql 029 date_sub_t,//mysql 030 timestampadd_t,//mysql 031 timestampdiff_t,//mysql 032 group_concat_t,//mysql 033 match_against_t,//mysql 034 extractxml_t, 035 ogc_t, 036 interval_t, //mysql 037 overlay_t, 038 case_n_t, 039 range_n_t, 040 extend_t,//informix 041 collect_t,//oracle 042 chr_t,//oracle 043 get_format,//mysql 044 percentile_cont_t,//sql server 045 percentile_disc_t,//sql server 046 parse_t,//sql server 047 try_parse_t,//sql parser 048 049 // DAX 050 minx_t, 051 maxx_t, 052 sumx_t, 053 all_t, 054 allexcept_t, 055 allnoblankrow_t, 056 allselected_t, 057 calculatetable_t, 058 crossfilter_t, 059 relatedtable_t, 060 substitutewithindex_t, 061 addmissingitems_t, 062 values_t, 063 isonorafter_t, 064 filter_t, 065 datatable_t, 066 groupby_t, 067 summarize_t, 068 summarizecolumns_t, 069 rollupaddissubtotal_t, 070 rollupgroup_t, 071 addcolumns_t, 072 beta_dist_t, 073 beta_inv_t, 074 chisq_inv_t, 075 chisq_inv_rt_t, 076 confidence_norm_t, 077 confidence_t_t, 078 expon_dist_t, 079 percentile_exc_t, 080 percentile_inc_t, 081 percentilex_exc_t, 082 percentilex_inc_t, 083 poisson_dist_t, 084 rank_eq_t, 085 row_t, 086 sample_t, 087 selectcolumns_t, 088 stdev_s_t, 089 stdev_p_t, 090 stdevx_s_t, 091 stdevx_p_t, 092 topn_t, 093 var_s_t, 094 var_p_t, 095 varx_s_t, 096 varx_p_t, 097 concatenatex_t, 098 calculate_t, 099 return_t, 100 distinct_t, 101 crossjoin_t, 102 dateadd_t, 103 datesinperiod_t, 104 iso_ceiling_t, 105 overlaps_t, 106 quantile_t, 107 listagg_t, 108 array_t,//bigquery 109 generate_date_array_t,//bigquery 110 flatten_t,//snowflake 111 match_t,//sql server 112 current_timestamp_t,//teradata 113 current_date_t,//teradata 114 current_time_t,//teradata 115 xmlquery_t, //oracle 116 xml_sqlserver_query_t, 117 xmlvalue_t,//sql server 118 xmlexist_t,//sql server 119 xmlmodify_t,//sql server 120 xmlnodes_t,//sql server 121 xmlcast_t,//oracle 122 xmlserialize_t,//oracle 123 xmlelement_t,//oracle 124 xmlroot_t,//oracle 125 xmlforest_t,//oracle 126 xmlagg_t,//oracle 127 xmlexists_t,//oracle 128 xmlparse_t,//oracle 129 xmlpi_t,//oracle 130 xmlmethod_t, 131 json_query_t,//oracle 132 floor_t,//hive 133 array_agg_t,//bigquery 134 string_agg_t, //bigquery 135 timestamp_sub_t, 136 timestamp_add_t, 137 date_t, 138 fields_t,//soql 139 map_t,//presto 140 time_t,//teradata 141 struct_t,//bigquery,databricks 142 if_t,//mysql 143 json_object_t,//oracle 144 year_t,//teradata 145 oracle_dbms_package_t,//oracle 146 json_agg_t, 147 ml_predict_t,//bigquery 148 array_concat_agg_t,//bigquery 149 json_table_t,//mysql 150}