extended tests failures on main

[alamb]

Describe the bug

https://github.com/apache/datafusion/commits/main/

To Reproduce

Here is an example failure:
https://github.com/apache/datafusion/actions/runs/18526040467/job/52796987355

1. query is expected to fail, but actually succeed:
[SQL] SELECT ALL ( + 73 ) + - + 92 * - 97 + COALESCE ( + ( + NULLIF ( + 75, - MIN ( ALL + + 53 ) ) ), + ( - CASE - - 73 WHEN COALESCE ( - + 51, - 26 ) / + 0 THEN COUNT ( * ) * 14 END ), + COUNT ( * ) / + 3, + COUNT ( ALL 73 ) ) + - 86 * ( 8 ) * + 37 AS col1
at /__w/datafusion/datafusion/datafusion-testing/data/sqlite/random/expr/slt_good_77.slt:40803



External error: 1 errors in file /__w/datafusion/datafusion/datafusion-testing/data/sqlite/random/expr/slt_good_109.slt

1. query is expected to fail, but actually succeed:
[SQL] SELECT DISTINCT - 11 * - + ( CASE CASE + 13 WHEN + 27 * 78 THEN - 91 + - 29 WHEN 60 THEN + 1 * 72 END WHEN 3 * - COUNT ( * ) THEN NULL WHEN 58 THEN NULL WHEN - 83 / - 0 THEN NULL ELSE 88 END ) * COUNT ( * ) - 60
at /__w/datafusion/datafusion/datafusion-testing/data/sqlite/random/expr/slt_good_109.slt:16148



External error: 1 errors in file /__w/datafusion/datafusion/datafusion-testing/data/sqlite/random/expr/slt_good_103.slt

1. query is expected to fail, but actually succeed:
[SQL] SELECT ALL CASE + MIN ( DISTINCT + - 81 ) WHEN - 81 THEN NULL WHEN SUM ( ALL + 93 ) + 23 THEN COUNT ( * ) WHEN COUNT ( * ) / ( 84 / - ( + 88 / 97 ) ) THEN 6 - 55 ELSE NULL END
at /__w/datafusion/datafusion/datafusion-testing/data/sqlite/random/expr/slt_good_103.slt:50564



External error: 1 errors in file /__w/datafusion/datafusion/datafusion-testing/data/sqlite/random/expr/slt_good_53.slt

1. query is expected to fail, but actually succeed:
[SQL] SELECT + CASE CAST ( NULL AS INTEGER ) WHEN + + 75 + - + SUM ( ALL - + 6 ) THEN NULL WHEN + 62 / + + 0 + + CASE - MAX ( + - 51 ) WHEN + - COUNT ( * ) + 7 + - 60 THEN NULL WHEN - CASE - 99 WHEN + + COUNT ( * ) THEN CASE - + NULLIF ( + NULLIF ( + 91, + 80 ), + - 81 * + 86 ) WHEN + 14 * + - COUNT ( * ) THEN - 87 + + 88 END - - 41 - - 51 - 95 + + 46 * 34 - - - 83 * COUNT ( * ) / - 93 WHEN 30 THEN 77 END / 35 THEN CAST ( NULL AS INTEGER ) END * - 26 THEN NULL ELSE 45 + COUNT ( * ) END * - 47 AS col2
at /__w/datafusion/datafusion/datafusion-testing/data/sqlite/random/expr/slt_good_53.slt:46724

Expected behavior

No response

Additional context

First started with

• #17972 Restore case expr/expr optimisation while ensuring lazy evaluation #17973

I think it is because now some tests are (correctly) passing that used to fail

[comphead]

@alamb I created #18088 to protect some critical core areas with extended suite.

[alamb]

Here is a PR to update the expected test results

• Update extended tests with new results datafusion-testing#14

[alamb]

Here is a PR to fix them

• Fix extended tests on main to get CI green #18096