fix: non-breaking detection for redundant cast projections (#5851) #3891

Job	Run time
test-dbt-versions (1.5)	1m 38s
changes	8s
test-dbt-versions (1.6)	1m 43s
test-dbt-versions (1.7)	1m 40s
test-dbt-versions (1.3)	1m 39s
test-dbt-versions (1.9)	1m 41s
test-dbt-versions (1.10)	1m 41s
test-dbt-versions (1.8)	1m 36s
test-dbt-versions (1.4)	1m 23s
test-vscode-e2e	0s
test-vscode	-10s
migration-test	1m 23s
cicd-tests-windows	10m 41s
doc-tests	30s
ui-test	1m 22s
style-and-cicd-tests (3.9)	23m 50s
style-and-cicd-tests (3.10)	23m 28s
style-and-cicd-tests (3.12)	25m 36s
style-and-cicd-tests (3.13)	23m 39s
engine-tests-docker (spark)	5m 42s
style-and-cicd-tests (3.11)	23m 11s
engine-tests-docker (trino)	8m 52s
engine-tests-docker (postgres)	2m 8s
engine-tests-docker (starrocks)	2m 46s
engine-tests-docker (mysql)	1m 34s
engine-tests-docker (clickhouse)	2m 44s
engine-tests-docker (risingwave)	4m 8s
engine-tests-docker (mssql)	1m 58s
engine-tests-docker (duckdb)	1m 27s
ui-style	0s
engine-tests-cloud (databricks)	11m 48s
engine-tests-cloud (snowflake)	8m 14s
engine-tests-cloud (redshift)	5m 57s
engine-tests-cloud (gcp-postgres)	3m 1s
engine-tests-cloud (clickhouse-cloud)	11m 23s
engine-tests-cloud (athena)	25m 17s
engine-tests-cloud (bigquery)	17m 14s
engine-tests-cloud (fabric)	4m 57s
	4h 25m 49s

Provide feedback