linrrzqqq opened a new pull request, #63906:
URL: https://github.com/apache/doris/pull/63906

   ### What problem does this PR solve?
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   
   Before this change, even when inline code was present, the FE would still 
attempt to parse and validate the `FILE` in the `CREATE FUNCTION` statement. 
However, during subsequent execution, even if `FILE` is valid, it would not be 
used. Therefore, when inline code is present, we can omit checking the `FILE` 
field when creating the table.
   
   before
   ```sql
   DROP FUNCTION IF EXISTS py_inline_file_udf(INT);
   CREATE FUNCTION py_inline_file_udf(INT)
   RETURNS INT
   PROPERTIES (
     "type"="PYTHON_UDF",
     "file"="http://127.0.0.1:12345/non_existent.zip";,
     "symbol"="evaluate",
     "runtime_version"="3.12.11",
     "always_nullable"="true"
   )
   AS $$
   def evaluate(x):
       if x is None:
           return None
       return x + 100
   $$;
   
   SELECT py_inline_file_udf(val) FROM t_repro ORDER BY id;
   -- errCode = 2, detailMessage = cannot to compute object's checksum.
   ```
   
   now
   ```sql
   Doris> SELECT py_inline_file_udf(val) FROM t_repro ORDER BY id;
   +-------------------------+
   | py_inline_file_udf(val) |
   +-------------------------+
   |                     110 |
   |                     120 |
   |                     130 |
   +-------------------------+
   ```
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: 
https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should 
merge into -->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to