Serge Rielau created SPARK-44680: ------------------------------------ Summary: parameter markers are not blocked from DEFAULT (and other places) Key: SPARK-44680 URL: https://issues.apache.org/jira/browse/SPARK-44680 Project: Spark Issue Type: Bug Components: Spark Core Affects Versions: 3.4.0 Reporter: Serge Rielau
scala> spark.sql("CREATE TABLE t11(c1 int default :parm)", args = Map("parm" -> 5)).show() -> success scala> spark.sql("describe t11"); [INVALID_DEFAULT_VALUE.UNRESOLVED_EXPRESSION] Failed to execute EXISTS_DEFAULT command because the destination table column `c1` has a DEFAULT value :parm, which fails to resolve as a valid expression. This likely extends to other DDL-y places. I can only find protection against placement in the body of a CREATE VIEW. I see two ways out of this: * Raise an error (as we do for CREATE VIEW v1(c1) AS SELECT ? ) * Improve the way we persist queries/expressions to substitute the at-DDL-time bound parameter value (it' not a bug it's a feature....) -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org