triage failing integration tests

[JLDLaughlin]

status	mz can support?	test name	query	materialized error
❌	❌	test_current_timestamp	CREATE VIEW materialize.public.test_recency__dbt_tmp AS SELECT date_trunc(\'day\', current_timestamp::timestamp)::datetime AS today	current_timestamp cannot be used in static queries
❌	❌	test_current_timestamp_in_utc	CREATE VIEW materialize.public.test_current_timestamp_in_utc__dbt_tmp AS SELECT current_timestamp::timestamp AS actual, current_timestamp::timestamp AS expected	current_timestamp cannot be used in static queries
❌	??	test_date_spine	select (()::date - ()::date)	Expected an expression, found right parenthesis - LINE 7: (()::date - ()::date)
✅	✅	test_date_trunc	CREATE VIEW materialize.public.test_date_trunc__dbt_tmp AS WITH data AS (SELECT * FROM materialize.public.data_date_trunc) SELECT date_trunc(\'day\', updated_at)::date AS actual, \"day\" AS expected FROM data UNION ALL SELECT date_trunc(\'month\', updated_at)::date AS actual, \"month\" AS expected FROM data	Cannot call function date_trunc(unknown, text): arguments cannot be implicitly cast to any implementation's parameters; try providing explicit casts
✅	✅	test_dateadd	CREATE VIEW materialize.public.test_dateadd__dbt_tmp AS WITH data AS (SELECT * FROM materialize.public.data_dateadd) SELECT CASE WHEN datepart = \'hour\' THEN dateadd(\"hour\", interval_length, from_time)::timestamp WHEN datepart = \'day\' THEN dateadd(\"day\", interval_length, from_time)::timestamp WHEN datepart = \'month\' THEN dateadd(\"month\", interval_length, from_time)::timestamp WHEN datepart = \'year\' THEN dateadd(\"year\", interval_length, from_time)::timestamp ELSE NULL END AS actual, result AS expected FROM data	function "dateadd" does not exist
❌	??	test_datediff	found here	no overload for interval + float8: arguments cannot be implicitly cast to any implementation's parameters; try providing explicit casts
✅	✅	test_get_relations_by_pattern	??	Required ILIKE support.
✅	✅	test_get_relations_by_prefix_and_union	??	Required ILIKE support.
❌	✅	test_generate_series	??	function "pow" does not exist
❌	blocked	test_hash	CREATE VIEW materialize.public.test_hash__dbt_tmp AS WITH data AS (SELECT * FROM materialize.public.data_hash) SELECT md5(input_1::text) AS actual, output AS expected FROM data	function "md5" does not exist
❌	??	test_last_day	CREATE VIEW materialize.public.test_last_day__dbt_tmp AS WITH data AS (SELECT * FROM materialize.public.data_last_day) SELECT CASE WHEN date_part = \'month\' THEN dateadd(\"day\", - 1, dateadd(\"month\", 1, date_trunc(\'month\', date_day)))::date WHEN date_part = \'year\' THEN dateadd(\"day\", - 1, dateadd(\"year\", 1, date_trunc(\'year\', date_day)))::date ELSE NULL END AS actual, result AS expected FROM data	column "month" does not exist
❌	??	test_position	here	didn't parse! Expected left parenthesis, found identifier - LINE 15: substring_text in string_text
❌	❌	test_recency	CREATE VIEW materialize.public.test_recency__dbt_tmp AS SELECT date_trunc(\'day\', current_timestamp::timestamp)::datetime AS today	unknown catalog item 'datetime'
❌	✅	test_right	CREATE VIEW materialize.public.test_right__dbt_tmp AS WITH data AS (SELECT * FROM materialize.public.data_right) SELECT \"right\"(string_text, length_expression) AS actual, COALESCE(output, \'\') AS expected FROM data	function "right" does not exist
❌	blocked	test_surrogate_key	CREATE VIEW materialize.public.test_surrogate_key__dbt_tmp AS WITH data AS (SELECT * FROM materialize.public.data_surrogate_key) SELECT md5(concat(COALESCE(column_1::text, \'\'))::text) AS actual_column_1_only, expected_column_1_only, md5(concat(COALESCE(column_1::text, \'\'), \'-\', COALESCE(column_2::text, \'\'), \'-\', COALESCE(column_3::text, \'\'))::text) AS actual_all_columns_arguments, md5(concat(COALESCE(column_1::text, \'\'), \'-\', COALESCE(column_2::text, \'\'), \'-\', COALESCE(column_3::text, \'\'))::text) AS actual_all_columns_list, expected_all_columns FROM data"	function "md5" does not exist
❌	??	test_url_path	here	didn't parse! Expected left parenthesis, found REPLACE - LINE 67: replace(
❌	??	test_width_bucket	CREATE VIEW materialize.public.test_width_bucket__dbt_tmp AS WITH data AS (SELECT * FROM materialize.public.data_width_bucket) SELECT (CASE WHEN mod(amount::numeric(28, 6), ((max_value - min_value) / num_buckets)::numeric(28, 6)) = 0 THEN 1 ELSE 0 END) + least(ceil((amount - min_value) / ((max_value - min_value) / num_buckets)), num_buckets + 1) AS actual, bucket AS expected FROM data	no overload for text - text: arguments cannot be implicitly cast to any implementation's parameters; try providing explicit casts

[JLDLaughlin]

The above test failures have been (mostly) triaged and documented in this repo's README. Moving forward, I think we should only fix macros as we receive user requests. Closing this!