You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by mb...@apache.org on 2026/07/13 17:58:36 UTC
(asterixdb) branch master updated: [ASTERIXDB-3784]: Add test to update a typed view with untyped view
This is an automated email from the ASF dual-hosted git repository.
asf-gitbox-commits pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/asterixdb.git
The following commit(s) were added to refs/heads/master by this push:
new 4b2a2d44c1 [ASTERIXDB-3784]: Add test to update a typed view with untyped view
4b2a2d44c1 is described below
commit 4b2a2d44c113508ccab85cbaf349e7206065c687
Author: Janhavi Tripurwar <ja...@couchbase.com>
AuthorDate: Thu Jul 9 20:39:42 2026 +0530
[ASTERIXDB-3784]: Add test to update a typed view with untyped view
Ext-ref: MB-72465
Change-Id: I00d6077c8cbdb34e32200d3190905c9347148f82
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/21414
Reviewed-by: Janhavi Tripurwar <ja...@apache.org>
Reviewed-by: Ali Alsuliman <al...@gmail.com>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
---
.../create-view-9-replace-untyped.1.ddl.sqlpp | 30 ++++++++++++++++++++++
.../create-view-9-replace-untyped.2.update.sqlpp | 25 ++++++++++++++++++
.../create-view-9-replace-untyped.3.query.sqlpp | 22 ++++++++++++++++
.../create-view-9-replace-untyped.3.adm | 2 ++
.../src/test/resources/runtimets/sqlpp_queries.xml | 5 ++++
5 files changed, 84 insertions(+)
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.1.ddl.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.1.ddl.sqlpp
new file mode 100644
index 0000000000..80cfd39b5c
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.1.ddl.sqlpp
@@ -0,0 +1,30 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+drop dataverse test1 if exists;
+create dataverse test1;
+
+use test1;
+
+create dataset t1(c_id int32 not unknown) open type primary key c_id;
+
+create view v1(c_id int32, c_val int64) default null as select c_id, c_val from t1;
+
+-- replace the typed view with an untyped one;
+create or replace view v1 as select c_id, c_val from t1;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.2.update.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.2.update.sqlpp
new file mode 100644
index 0000000000..8da731c9a8
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.2.update.sqlpp
@@ -0,0 +1,25 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test1;
+
+insert into t1 ([
+ { 'c_id': 1, 'c_val': 100 },
+ { 'c_id': 2 }
+]);
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.3.query.sqlpp b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.3.query.sqlpp
new file mode 100644
index 0000000000..e77504f99a
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/view/create-view-9-replace-untyped/create-view-9-replace-untyped.3.query.sqlpp
@@ -0,0 +1,22 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+use test1;
+
+select c_id, c_val from v1 order by c_id;
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/view/create-view-9-replace-untyped/create-view-9-replace-untyped.3.adm b/asterixdb/asterix-app/src/test/resources/runtimets/results/view/create-view-9-replace-untyped/create-view-9-replace-untyped.3.adm
new file mode 100644
index 0000000000..72ea2a4d20
--- /dev/null
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/view/create-view-9-replace-untyped/create-view-9-replace-untyped.3.adm
@@ -0,0 +1,2 @@
+{ "c_id": 1, "c_val": 100 }
+{ "c_id": 2 }
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml b/asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml
index 3f55393e41..cdafd20906 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml
@@ -14064,6 +14064,11 @@
<output-dir compare="Text">create-view-8-replace-typed</output-dir>
</compilation-unit>
</test-case>
+ <test-case FilePath="view">
+ <compilation-unit name="create-view-9-replace-untyped">
+ <output-dir compare="Text">create-view-9-replace-untyped</output-dir>
+ </compilation-unit>
+ </test-case>
<test-case FilePath="view">
<compilation-unit name="drop-dataverse-1">
<output-dir compare="Text">drop-dataverse-1</output-dir>