You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by GitBox <gi...@apache.org> on 2022/04/12 13:54:40 UTC

[GitHub] [flink] whitecloud6688 opened a new pull request, #19442: NULL语法支持

whitecloud6688 opened a new pull request, #19442:
URL: https://github.com/apache/flink/pull/19442

   ## What is the purpose of the change
   请支持类似以下语法：
   select if(1>2,1,NULL) as col1;
   select NULL as col1;
   
   ## Brief change log
   需要将 NULL 赋值给一个字段，然后写入表，但报语法错误。版本：FLINK-1.13.6。
   Flink SQL> select if(1>2,1,NULL) as col1;
   [ERROR] Could not execute SQL statement. Reason:
   org.apache.calcite.sql.validate.SqlValidatorException: Illegal use of 'NULL'
   
   Flink SQL> select NULL as col1;
   [ERROR] Could not execute SQL statement. Reason:
   org.apache.calcite.sql.validate.SqlValidatorException: Illegal use of 'NULL'
   
   以下语法能执行
   Flink SQL> select NULL is NULL as col1;
   +----+--------+
   | op | col1 |
   +----+--------+
   | +I | true |
   +----+--------+
   Received a total of 1 row
   
   ## Verifying this change
   select if(1>2,1,NULL) as col1;
   select NULL as col1;
   
   ## Does this pull request potentially affect one of the following parts:
     - Dependencies (does it add or upgrade a dependency): (yes / **no**)
     - The public API, i.e., is any changed class annotated with `@Public(Evolving)`: (yes / **no**)
     - The serializers: (yes / **no** / don't know)
     - The runtime per-record code paths (performance sensitive): (yes / **no** / don't know)
     - Anything that affects deployment or recovery: JobManager (and its components), Checkpointing, Kubernetes/Yarn, ZooKeeper: (yes / **no** / don't know)
     - The S3 file system connector: (yes / **no** / don't know)
   
   ## Documentation
     - Does this pull request introduce a new feature? (yes / **no**)
     - If yes, how is the feature documented? (not applicable / **docs** / JavaDocs / not documented)
   
   


-- 
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: issues-unsubscribe@flink.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] zentol closed pull request #19442: NULL语法支持

Posted by GitBox <gi...@apache.org>.
zentol closed pull request #19442: NULL语法支持
URL: https://github.com/apache/flink/pull/19442


-- 
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: issues-unsubscribe@flink.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot commented on pull request #19442: NULL语法支持

Posted by GitBox <gi...@apache.org>.
flinkbot commented on PR #19442:
URL: https://github.com/apache/flink/pull/19442#issuecomment-1096774398

   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "dbfe5da2a2bc4564a1cf715a918299d107758b6c",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "dbfe5da2a2bc4564a1cf715a918299d107758b6c",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * dbfe5da2a2bc4564a1cf715a918299d107758b6c UNKNOWN
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run azure` re-run the last Azure build
   </details>


-- 
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: issues-unsubscribe@flink.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org