[BUG] Test project_source_change_type_env should throw a SemanticCheckException

[GumpacG]

What is the bug?
The test project_source_change_type_env does not throw a SemanticCheckException.

How can one reproduce the bug?
Steps to reproduce the behavior:

1. Run the test project_source_change_type_env in https://github.com/opensearch-project/sql/blob/2.x/core/src/test/java/org/opensearch/sql/analysis/AnalyzerTest.java
2. See that a SemanticCheckException was expected to be thrown however, nothing was thrown.

What is the expected behavior?
The query source=schema | fields integer_value, double_value | fields float_value should throw a SemanticCheckException because the first fields already shrink the typeenv to {interger_value, double_value}

What is your host/environment?

• OS: macOS
• Version: OpenSearch 2.4
• Plugins: OpenSearch SQL 2.x

Do you have any additional context?
Test should be enabled once this issue is resolved.

[DevPJ9]

Hello, @GumpacG I would like to contribute.

[Yury-Fridlyand]

Hello, @GumpacG I would like to contribute.

@DevPJ9, you are welcome!

[DevPJ9]

@Yury-Fridlyand can you please assign this to me.

[DevPJ9]

Hello, @Yury-Fridlyand Sorry for the late reply. Can you please guide me through the steps to reproduce the error. I have not worked with "Test". Again, I am sorry for the late reply.

[Yury-Fridlyand]

@DevPJ9,
You can activate the test

sql/core/src/test/java/org/opensearch/sql/analysis/AnalyzerTest.java

Lines 391 to 393 in 863f751

	@Disabled("the project/remove command should shrink the type env")
	@Test
	public void project_source_change_type_env() {

(delete @Disabled line)
and run it

./gradlew :core:test --tests org.opensearch.sql.analysis.AnalyzerTest.project_source_change_type_env

[dai-chen]

@DevPJ9 you need any help on this?