Update the binder_context, when there is function expression in the projection's target_list

[xzdandy]

Search before asking

• I have searched the EvaDB issues and found no similar feature requests.

Description

Right now, the binder_context is not getting updated for the function expression in the projection's target_list. So the following query will not work:

SELECT HomeSaleForecast(3) ORDER BY price;

CREATE TABLE AS SELECT HomeSaleForecast(3) FROM postgres.home_sale;

Use case

No response

Are you willing to submit a PR?

• Yes I'd like to help by submitting a PR!

[xzdandy]

This will resolves the #1119

[xzdandy]

5 long integration test failed. circle ci

FAILED test/integration_tests/long/test_select_executor.py::SelectExecutorTest::test_sort_on_nonprojected_column - evadb.executor.executor_utils.ExecutorError: ['myvideo.id']
FAILED test/integration_tests/long/test_similarity.py::SimilarityTests::test_end_to_end_index_scan_should_work_correctly_on_image_dataset - evadb.executor.executor_utils.ExecutorError: ['testsimilarityimagedataset.data']
FAILED test/integration_tests/long/test_similarity.py::SimilarityTests::test_should_do_vector_index_scan - AssertionError: False is not true
FAILED test/integration_tests/long/test_single_document_similarity.py::SingleDocumentSimilarityTests::test_single_pdf_should_work - AssertionError: False is not true
FAILED test/integration_tests/long/interfaces/relational/test_relational_api.py::RelationalAPI::test_create_index - evadb.executor.executor_utils.ExecutorError: ['meme_images.data']

[xzdandy]

@gaurav274 A gentle ping.

[xzdandy]

Investigating in #1147