[ 
https://issues.apache.org/jira/browse/CALCITE-6977?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wei.Zhou updated CALCITE-6977:
------------------------------
    Description: 
When i use  SqlDelete.Operator to created  a SqlDelete  , then try to  call 
toString method unparse to string, it will throw a exception like below:
java.lang.UnsupportedOperationException: class 
org.apache.calcite.sql.SqlSyntax$7: 
SPECIALjava.lang.UnsupportedOperationException: class 
org.apache.calcite.sql.SqlSyntax$7: SPECIAL
at org.apache.calcite.util.Util.needToImplement(Util.java:1080) at 
org.apache.calcite.sql.SqlSyntax$7.unparse(SqlSyntax.java:128) at 
org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:377) at 
org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:453) at 
org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:103) at 
org.apache.calcite.sql.SqlNode.toSqlString(SqlNode.java:155)
This exception can be reproduced as below:

 

{{@Test void testSqlDeleteSqlBasicCallToString() throws Exception {}}
{{    final String sql = "delete from employees where id = 1 ";}}
{{    final SqlNode sqlNode = parseSql(sql);}}
{{    final SqlDelete sqlDelete = (SqlDelete) sqlNode;}}
{{    final SqlCall call = 
SqlDelete.OPERATOR.createCall((sqlDelete).getFunctionQuantifier(),}}
{{             sqlDelete.getParserPosition(), }}{{sqlDelete.getOperandList());}}
{{    System.out.println(call.toString());}}
{{}}}

 

 

  was:
When i use  SqlDelete.Operator to created  a SqlDelete  , then try to  call 
toString method unparse to string, it will throw a exception like below:
java.lang.UnsupportedOperationException: class 
org.apache.calcite.sql.SqlSyntax$7: 
SPECIALjava.lang.UnsupportedOperationException: class 
org.apache.calcite.sql.SqlSyntax$7: SPECIAL
 at org.apache.calcite.util.Util.needToImplement(Util.java:1080) at 
org.apache.calcite.sql.SqlSyntax$7.unparse(SqlSyntax.java:128) at 
org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:377) at 
org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:453) at 
org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:103) at 
org.apache.calcite.sql.SqlNode.toSqlString(SqlNode.java:155)
This exception can be reproduced as below:
// code placeholder
@Test void testSqlDeleteSqlBasicCallToString() throws Exception { 
  final String sql = "delete from employees where id = 1 ";
  final SqlNode sqlNode = parseSql(sql); 
  final SqlDelete sqlDelete = (SqlDelete) sqlNode;
  final SqlCall call = 
SqlDelete.OPERATOR.createCall((sqlDelete).getFunctionQuantifier(),  
sqlDelete.getParserPosition(), sqlDelete.getOperandList());   
System.out.println(call.toString()); 
}


> A SqlDelete that  it is created by SqlDelete.Operator need to support unparse 
> ------------------------------------------------------------------------------
>
>                 Key: CALCITE-6977
>                 URL: https://issues.apache.org/jira/browse/CALCITE-6977
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.39.0
>            Reporter: Wei.Zhou
>            Priority: Major
>
> When i use  SqlDelete.Operator to created  a SqlDelete  , then try to  call 
> toString method unparse to string, it will throw a exception like below:
> java.lang.UnsupportedOperationException: class 
> org.apache.calcite.sql.SqlSyntax$7: 
> SPECIALjava.lang.UnsupportedOperationException: class 
> org.apache.calcite.sql.SqlSyntax$7: SPECIAL
> at org.apache.calcite.util.Util.needToImplement(Util.java:1080) at 
> org.apache.calcite.sql.SqlSyntax$7.unparse(SqlSyntax.java:128) at 
> org.apache.calcite.sql.SqlOperator.unparse(SqlOperator.java:377) at 
> org.apache.calcite.sql.SqlDialect.unparseCall(SqlDialect.java:453) at 
> org.apache.calcite.sql.SqlCall.unparse(SqlCall.java:103) at 
> org.apache.calcite.sql.SqlNode.toSqlString(SqlNode.java:155)
> This exception can be reproduced as below:
>  
> {{@Test void testSqlDeleteSqlBasicCallToString() throws Exception {}}
> {{    final String sql = "delete from employees where id = 1 ";}}
> {{    final SqlNode sqlNode = parseSql(sql);}}
> {{    final SqlDelete sqlDelete = (SqlDelete) sqlNode;}}
> {{    final SqlCall call = 
> SqlDelete.OPERATOR.createCall((sqlDelete).getFunctionQuantifier(),}}
> {{             sqlDelete.getParserPosition(), 
> }}{{sqlDelete.getOperandList());}}
> {{    System.out.println(call.toString());}}
> {{}}}
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to