chenkovsky commented on code in PR #1980:
URL:
https://github.com/apache/datafusion-sqlparser-rs/pull/1980#discussion_r2239969296
##########
tests/sqlparser_bigquery.rs:
##########
@@ -2806,3 +2806,23 @@ fn test_begin_transaction() {
fn test_begin_statement() {
bigquery().verified_stmt("BEGIN");
}
+
+#[test]
+fn test_alter_schema_default_collate() {
+ bigquery_and_generic().verified_stmt("ALTER SCHEMA mydataset SET DEFAULT
COLLATE 'und:ci'");
+}
+
+#[test]
+fn test_alter_schema_add_replica() {
+ bigquery_and_generic().verified_stmt("ALTER SCHEMA mydataset ADD REPLICA
'us'");
+}
+
+#[test]
+fn test_alter_schema_drop_replica() {
+ bigquery_and_generic().verified_stmt("ALTER SCHEMA mydataset DROP REPLICA
'us'");
+}
+
+#[test]
+fn test_alter_schema_set_options() {
+ bigquery_and_generic().verified_stmt("ALTER SCHEMA mydataset SET OPTIONS
(location = 'us')");
+}
Review Comment:
postgres also has `alter schema`, but it's quite different.
https://www.postgresql.org/docs/17/sql-alterschema.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: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
