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/10 02:16:27 UTC

[GitHub] [flink] whitecloud6688 opened a new pull request, #19415: Illegal use of 'NULL'

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

   ###  Illegal use of 'NULL'
   
   需要将 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
   


-- 
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] MartijnVisser closed pull request #19415: Illegal use of 'NULL'

Posted by GitBox <gi...@apache.org>.
MartijnVisser closed pull request #19415: Illegal use of 'NULL'
URL: https://github.com/apache/flink/pull/19415


-- 
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] MartijnVisser commented on pull request #19415: Illegal use of 'NULL'

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

   @whitecloud6688 Thanks for this PR, but this seems incorrect. Therefore I'm closing it. Please follow the code contribution guide https://flink.apache.org/contributing/how-to-contribute.html


-- 
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 #19415: Illegal use of 'NULL'

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

   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "66d896081ae9c9572972ec13cef8169d57391444",
       "status" : "UNKNOWN",
       "url" : "TBD",
       "triggerID" : "66d896081ae9c9572972ec13cef8169d57391444",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * 66d896081ae9c9572972ec13cef8169d57391444 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