This is an automated email from the ASF dual-hosted git repository.
mblow 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 6a3ad0b940 [ASTERIXDB-3516][COMP] Adding UPDATE statement testcases
new c6c6cf60e0 Merge "Merge branch 'phoenix'"
6a3ad0b940 is described below
commit 6a3ad0b940bd4ebbdf4cef42068f89a868c7b86c
Author: Shahrzad Shirazi <[email protected]>
AuthorDate: Mon Sep 8 13:39:58 2025 -0700
[ASTERIXDB-3516][COMP] Adding UPDATE statement testcases
Ext-ref: MB-61969
Change-Id: I0d908fbf6ea084855157e6271fd0e58d61870d3c
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/20368
Reviewed-by: Ali Alsuliman <[email protected]>
Tested-by: Ali Alsuliman <[email protected]>
---
.../complex-case/complex-case.1.ddl.sqlpp | 39 +++++++
.../complex-case/complex-case.10.update.sqlpp | 29 ++++++
.../complex-case/complex-case.11.query.sqlpp | 25 +++++
.../complex-case/complex-case.2.ddl.sqlpp | 24 +++++
.../complex-case/complex-case.3.update.sqlpp | 53 ++++++++++
.../complex-case/complex-case.4.update.sqlpp | 27 +++++
.../complex-case/complex-case.5.query.sqlpp | 25 +++++
.../complex-case/complex-case.6.update.sqlpp | 30 ++++++
.../complex-case/complex-case.7.query.sqlpp | 25 +++++
.../complex-case/complex-case.8.update.sqlpp | 25 +++++
.../complex-case/complex-case.9.query.sqlpp | 25 +++++
.../simple-case/simple-case.1.ddl.sqlpp | 35 +++++++
.../simple-case/simple-case.10.update.sqlpp | 26 +++++
.../simple-case/simple-case.11.query.sqlpp | 27 +++++
.../simple-case/simple-case.12.update.sqlpp | 26 +++++
.../simple-case/simple-case.13.query.sqlpp | 25 +++++
.../simple-case/simple-case.14.update.sqlpp | 32 ++++++
.../simple-case/simple-case.15.query.sqlpp | 25 +++++
.../simple-case/simple-case.16.query.sqlpp | 32 ++++++
.../simple-case/simple-case.2.ddl.sqlpp | 24 +++++
.../simple-case/simple-case.3.update.sqlpp | 116 +++++++++++++++++++++
.../simple-case/simple-case.4.update.sqlpp | 25 +++++
.../simple-case/simple-case.5.query.sqlpp | 25 +++++
.../simple-case/simple-case.6.update.sqlpp | 27 +++++
.../simple-case/simple-case.7.query.sqlpp | 27 +++++
.../simple-case/simple-case.8.update.sqlpp | 27 +++++
.../simple-case/simple-case.9.query.sqlpp | 27 +++++
.../complex-case/complex-case.11.adm | 1 +
.../complex-case/complex-case.5.adm | 1 +
.../complex-case/complex-case.7.adm | 1 +
.../complex-case/complex-case.9.adm | 1 +
.../simple-case/simple-case.11.adm | 1 +
.../simple-case/simple-case.13.adm | 11 ++
.../simple-case/simple-case.15.adm | 11 ++
.../simple-case/simple-case.16.adm | 1 +
.../simple-case/simple-case.5.adm | 1 +
.../simple-case/simple-case.7.adm | 11 ++
.../simple-case/simple-case.9.adm | 1 +
.../src/test/resources/runtimets/sqlpp_queries.xml | 14 ++-
39 files changed, 907 insertions(+), 1 deletion(-)
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.1.ddl.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.1.ddl.sqlpp
new file mode 100644
index 0000000000..2a21874f04
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.1.ddl.sqlpp
@@ -0,0 +1,39 @@
+/*
+ * 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 test IF EXISTS;
+CREATE DATAVERSE test;
+USE test;
+
+CREATE TYPE UserType AS {
+ userId: int,
+ email: string,
+ username: string,
+ isActive: boolean,
+ roles: [
+ {
+ roleId: string,
+ roleName: string
+ }
+ ]
+};
+
+CREATE DATASET UserTypes(UserType)
+PRIMARY KEY userId;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.10.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.10.update.sqlpp
new file mode 100644
index 0000000000..da35760c74
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.10.update.sqlpp
@@ -0,0 +1,29 @@
+
+/*
+ * 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 test;
+
+UPDATE UserTypes
+(UPDATE roles AS r
+SET r.roleName = "manager")
+Set email="[email protected]"
+WHERE userId = 2;
+
+
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.11.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.11.query.sqlpp
new file mode 100644
index 0000000000..51ad5ccf3e
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.11.query.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 test;
+
+select *
+from UserTypes
+where userId=2;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.2.ddl.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.2.ddl.sqlpp
new file mode 100644
index 0000000000..c62b828717
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.2.ddl.sqlpp
@@ -0,0 +1,24 @@
+/*
+ * 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 test;
+
+create index idx_age on UserTypes(age);
+--This is created to test if the updated data is also reachable from the
secondary index.
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.3.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.3.update.sqlpp
new file mode 100644
index 0000000000..c222f6e8ac
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.3.update.sqlpp
@@ -0,0 +1,53 @@
+/*
+ * 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 test;
+
+INSERT INTO UserTypes([
+ {
+ "userId": 1,
+ "email": "[email protected]",
+ "username": "alice",
+ "isActive": true,
+ "roles": [
+ { "roleId": "role1", "roleName": "admin" },
+ { "roleId": "role2", "roleName": "developer" }
+ ]
+ },
+ {
+ "userId": 2,
+ "email": "[email protected]",
+ "username": "bob",
+ "isActive": false,
+ "roles": [
+ { "roleId": "role1", "roleName": "user" },
+ { "roleId": "role2", "roleName": "contributor" }
+ ]
+ },
+ {
+ "userId": 3,
+ "email": "[email protected]",
+ "username": "carol",
+ "isActive": true,
+ "roles": [
+ { "roleId": "role1", "roleName": "moderator" },
+ { "roleId": "role2", "roleName": "reviewer" }
+ ]
+ }
+]);
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.4.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.4.update.sqlpp
new file mode 100644
index 0000000000..d95bbfae6b
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.4.update.sqlpp
@@ -0,0 +1,27 @@
+/*
+ * 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 test;
+
+UPDATE UserTypes
+(UPDATE roles AS r
+SET r.roleName = "Sr. developer"
+WHERE roleId="role2")
+WHERE userId = 1;
+
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.5.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.5.query.sqlpp
new file mode 100644
index 0000000000..3d3b2cac8a
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.5.query.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 test;
+
+select *
+from UserTypes
+where userId=1;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.6.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.6.update.sqlpp
new file mode 100644
index 0000000000..f52b896a47
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.6.update.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.
+ */
+
+Use test;
+
+UPDATE UserTypes
+(UPDATE roles AS r
+SET r.roleName = "manager2"
+where roleId="role2")
+(INSERT INTO roles AT 3([
+{"roleId": "role3", "roleName": "reviewer"}]))
+ SET age=33
+WHERE userId = 1;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.7.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.7.query.sqlpp
new file mode 100644
index 0000000000..3d3b2cac8a
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.7.query.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 test;
+
+select *
+from UserTypes
+where userId=1;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.8.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.8.update.sqlpp
new file mode 100644
index 0000000000..dcfdb8999a
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.8.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 test;
+
+UPDATE UserTypes
+SET age=Missing
+WHERE userId = 1;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.9.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.9.query.sqlpp
new file mode 100644
index 0000000000..ee6f78619d
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/complex-case/complex-case.9.query.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 test;
+
+select *
+from UserTypes
+where userId=1;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.1.ddl.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.1.ddl.sqlpp
new file mode 100644
index 0000000000..c68a532d73
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.1.ddl.sqlpp
@@ -0,0 +1,35 @@
+/*
+ * 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 test if exists;
+create dataverse test;
+use test;
+
+
+CREATE TYPE UserType AS {
+ userId : int,
+ email : string,
+ username : string,
+ isActive : boolean
+};
+
+create dataset UserTypes(UserType) primary key userId;
+
+
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.10.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.10.update.sqlpp
new file mode 100644
index 0000000000..a846fc0a09
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.10.update.sqlpp
@@ -0,0 +1,26 @@
+
+/*
+ * 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 test;
+
+
+UPDATE UserTypes AS u
+(INSERT INTO u.addresses AT 2([
+{"city": "Irvine, United States", "street" : "Second st","zipcode" : 98128}]))
where u.userId= 11;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.11.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.11.query.sqlpp
new file mode 100644
index 0000000000..6801b96964
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.11.query.sqlpp
@@ -0,0 +1,27 @@
+
+/*
+ * 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 test;
+
+Use test;
+
+select *
+from UserTypes
+where age =23;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.12.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.12.update.sqlpp
new file mode 100644
index 0000000000..99a95ce3fd
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.12.update.sqlpp
@@ -0,0 +1,26 @@
+
+/*
+ * 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 test;
+
+
+UPDATE UserTypes AS u
+(DELETE FROM u.addresses AT number WHERE number IN [0,1])
+WHERE u.userId =11;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.13.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.13.query.sqlpp
new file mode 100644
index 0000000000..f7661a7232
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.13.query.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 test;
+
+select *
+from UserTypes
+order by userId;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.14.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.14.update.sqlpp
new file mode 100644
index 0000000000..261253d71a
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.14.update.sqlpp
@@ -0,0 +1,32 @@
+
+/*
+ * 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 test;
+
+
+UPDATE UserTypes as u
+ SET u.age=30
+ SET u.age=u.age+1
+(INSERT INTO u.addresses AT 2([
+{"city": "iii, United States", "street" : "Second st","zipcode" : 98128}]))
+ SET u. occupation =Missing
+ SET u. job ="pilot"
+ where userId=11;
+
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.15.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.15.query.sqlpp
new file mode 100644
index 0000000000..00ccd9e072
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.15.query.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 test;
+
+select *
+from UserTypes
+order by userId;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.16.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.16.query.sqlpp
new file mode 100644
index 0000000000..fb0772058a
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.16.query.sqlpp
@@ -0,0 +1,32 @@
+/*
+ * 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 test;
+
+
+UPDATE UserTypes as u
+ SET u.age=30
+ SET u.age=u.age+1
+(INSERT INTO u.addresses AT 2([
+{"city": "iii, United States", "street" : "Second st","zipcode" : 98128}]))
+ SET u.occupation =Missing
+ SET u.job ="pilot2"
+ Where u.userId=11
+ Returning u;
+
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.2.ddl.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.2.ddl.sqlpp
new file mode 100644
index 0000000000..d32491400f
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.2.ddl.sqlpp
@@ -0,0 +1,24 @@
+/*
+ * 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 test;
+
+create index idx_user_age on UserTypes(age);
+--This is created to test if the updated data is also reachable from the
secondary index.
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.3.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.3.update.sqlpp
new file mode 100644
index 0000000000..ea6fa8b069
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.3.update.sqlpp
@@ -0,0 +1,116 @@
+/*
+ * 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 test;
+
+INSERT INTO UserTypes (
+ [
+ {
+ "userId": 1,
+ "email": "[email protected]",
+ "username": "johndoe",
+ "isActive": true,
+ "occupation": "teacher",
+ "age": 23
+ },
+ {
+ "userId": 2,
+ "email": "[email protected]",
+ "username": "janesmith",
+ "isActive": false,
+ "occupation": "firefighter"
+
+
+ },
+ {
+ "userId": 3,
+ "email": "[email protected]",
+ "username": "michaelb",
+ "isActive": true,
+ "age": "five",
+ "occupation":4
+
+ },
+ {
+ "userId": 4,
+ "email": "[email protected]",
+ "username": "emilyd",
+ "isActive": true,
+ "age": 23.1
+
+ },
+ {
+ "userId": 5,
+ "email": "[email protected]",
+ "username": "chrisj",
+ "isActive": false,
+ "age": "old"
+
+ },
+ {
+ "userId": 6,
+ "email": "[email protected]",
+ "username": "patriciag",
+ "isActive": true,
+ "age": "45"
+
+ },
+ {
+ "userId": 7,
+ "email": "[email protected]",
+ "username": "lindam",
+ "isActive": false
+ },
+ {
+ "userId": 8,
+ "email": "[email protected]",
+ "username": "robertl",
+ "isActive": true,
+ "age": 31
+
+ },
+ {
+ "userId": 9,
+ "email": "[email protected]",
+ "username": "jamesw",
+ "isActive": true,
+ "age": "65"
+
+ },
+ {
+ "userId": 10,
+ "email": "[email protected]",
+ "username": "marym",
+ "isActive": false,
+ "age": "",
+ "addresses":[ {"city": "Riverside","zipcode" : 92510}]
+
+ },
+ {
+ "userId": 11,
+ "email": "[email protected]",
+ "username": "jk",
+ "isActive": true,
+ "age": "20",
+ "occupation": "firefighter",
+ "addresses":[ {"city": "San Jose, United States", "street" :
"Santana Row","zipcode" : 95128},{"city": "Riverside","zipcode" : 92507}]
+ }
+ ]
+
+);
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.4.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.4.update.sqlpp
new file mode 100644
index 0000000000..56aa8394e0
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.4.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 test;
+
+UPDATE UserTypes as u
+ SET u.age=32
+ where userId=10;
+
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.5.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.5.query.sqlpp
new file mode 100644
index 0000000000..ecf528a163
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.5.query.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 test;
+
+select *
+from UserTypes
+where userId=10;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.6.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.6.update.sqlpp
new file mode 100644
index 0000000000..1759740fcb
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.6.update.sqlpp
@@ -0,0 +1,27 @@
+
+/*
+ * 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 test;
+
+Use test;
+
+UPDATE UserTypes as u
+ SET u.timeZone="PT"
+ where userId=10;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.7.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.7.query.sqlpp
new file mode 100644
index 0000000000..60f5b6fd71
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.7.query.sqlpp
@@ -0,0 +1,27 @@
+
+/*
+ * 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 test;
+
+Use test;
+
+select *
+from UserTypes
+order by userId;
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.8.update.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.8.update.sqlpp
new file mode 100644
index 0000000000..9a2f994d37
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.8.update.sqlpp
@@ -0,0 +1,27 @@
+
+/*
+ * 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 test;
+
+
+UPDATE UserTypes as u
+ SET u.totalcost=25
+ SET u.totaltax= u.totalcost*1/100
+ where u.age =23;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.9.query.sqlpp
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.9.query.sqlpp
new file mode 100644
index 0000000000..6801b96964
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/queries_sqlpp/update-statements/simple-case/simple-case.9.query.sqlpp
@@ -0,0 +1,27 @@
+
+/*
+ * 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 test;
+
+Use test;
+
+select *
+from UserTypes
+where age =23;
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.11.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.11.adm
new file mode 100644
index 0000000000..523736ee16
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.11.adm
@@ -0,0 +1 @@
+{ "UserTypes": { "userId": 2, "email": "[email protected]",
"username": "bob", "isActive": false, "roles": [ { "roleId": "role1",
"roleName": "manager" }, { "roleId": "role2", "roleName": "manager" } ] } }
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.5.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.5.adm
new file mode 100644
index 0000000000..7ce8162b03
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.5.adm
@@ -0,0 +1 @@
+{ "UserTypes": { "userId": 1, "email": "[email protected]", "username":
"alice", "isActive": true, "roles": [ { "roleId": "role1", "roleName": "admin"
}, { "roleId": "role2", "roleName": "Sr. developer" } ] } }
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.7.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.7.adm
new file mode 100644
index 0000000000..11666ee492
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.7.adm
@@ -0,0 +1 @@
+{ "UserTypes": { "userId": 1, "email": "[email protected]", "username":
"alice", "isActive": true, "roles": [ { "roleId": "role1", "roleName": "admin"
}, { "roleId": "role2", "roleName": "manager2" }, { "roleId": "role3",
"roleName": "reviewer" } ], "age": 33 } }
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.9.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.9.adm
new file mode 100644
index 0000000000..3679ce049a
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/complex-case/complex-case.9.adm
@@ -0,0 +1 @@
+{ "UserTypes": { "userId": 1, "email": "[email protected]", "username":
"alice", "isActive": true, "roles": [ { "roleId": "role1", "roleName": "admin"
}, { "roleId": "role2", "roleName": "manager2" }, { "roleId": "role3",
"roleName": "reviewer" } ] } }
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.11.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.11.adm
new file mode 100644
index 0000000000..128089c858
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.11.adm
@@ -0,0 +1 @@
+{ "UserTypes": { "userId": 1, "email": "[email protected]", "username":
"johndoe", "isActive": true, "totaltax": 0.25, "totalcost": 25, "occupation":
"teacher", "age": 23 } }
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.13.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.13.adm
new file mode 100644
index 0000000000..54096d7612
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.13.adm
@@ -0,0 +1,11 @@
+{ "UserTypes": { "userId": 1, "email": "[email protected]", "username":
"johndoe", "isActive": true, "totaltax": 0.25, "totalcost": 25, "occupation":
"teacher", "age": 23 } }
+{ "UserTypes": { "userId": 2, "email": "[email protected]", "username":
"janesmith", "isActive": false, "occupation": "firefighter" } }
+{ "UserTypes": { "userId": 3, "email": "[email protected]",
"username": "michaelb", "isActive": true, "age": "five", "occupation": 4 } }
+{ "UserTypes": { "userId": 4, "email": "[email protected]", "username":
"emilyd", "isActive": true, "age": 23.1 } }
+{ "UserTypes": { "userId": 5, "email": "[email protected]", "username":
"chrisj", "isActive": false, "age": "old" } }
+{ "UserTypes": { "userId": 6, "email": "[email protected]",
"username": "patriciag", "isActive": true, "age": "45" } }
+{ "UserTypes": { "userId": 7, "email": "[email protected]",
"username": "lindam", "isActive": false } }
+{ "UserTypes": { "userId": 8, "email": "[email protected]", "username":
"robertl", "isActive": true, "age": 31 } }
+{ "UserTypes": { "userId": 9, "email": "[email protected]", "username":
"jamesw", "isActive": true, "age": "65" } }
+{ "UserTypes": { "userId": 10, "email": "[email protected]", "username":
"marym", "isActive": false, "timeZone": "PT", "age": 32, "addresses": [ {
"city": "Riverside", "zipcode": 92510 } ] } }
+{ "UserTypes": { "userId": 11, "email": "[email protected]", "username":
"jk", "isActive": true, "addresses": [ { "city": "Irvine, United States",
"street": "Second st", "zipcode": 98128 }, { "city": "Riverside", "zipcode":
92507 } ], "age": "20", "occupation": "firefighter" } }
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.15.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.15.adm
new file mode 100644
index 0000000000..17ef6291f6
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.15.adm
@@ -0,0 +1,11 @@
+{ "UserTypes": { "userId": 1, "email": "[email protected]", "username":
"johndoe", "isActive": true, "totaltax": 0.25, "totalcost": 25, "occupation":
"teacher", "age": 23 } }
+{ "UserTypes": { "userId": 2, "email": "[email protected]", "username":
"janesmith", "isActive": false, "occupation": "firefighter" } }
+{ "UserTypes": { "userId": 3, "email": "[email protected]",
"username": "michaelb", "isActive": true, "age": "five", "occupation": 4 } }
+{ "UserTypes": { "userId": 4, "email": "[email protected]", "username":
"emilyd", "isActive": true, "age": 23.1 } }
+{ "UserTypes": { "userId": 5, "email": "[email protected]", "username":
"chrisj", "isActive": false, "age": "old" } }
+{ "UserTypes": { "userId": 6, "email": "[email protected]",
"username": "patriciag", "isActive": true, "age": "45" } }
+{ "UserTypes": { "userId": 7, "email": "[email protected]",
"username": "lindam", "isActive": false } }
+{ "UserTypes": { "userId": 8, "email": "[email protected]", "username":
"robertl", "isActive": true, "age": 31 } }
+{ "UserTypes": { "userId": 9, "email": "[email protected]", "username":
"jamesw", "isActive": true, "age": "65" } }
+{ "UserTypes": { "userId": 10, "email": "[email protected]", "username":
"marym", "isActive": false, "timeZone": "PT", "age": 32, "addresses": [ {
"city": "Riverside", "zipcode": 92510 } ] } }
+{ "UserTypes": { "userId": 11, "email": "[email protected]", "username":
"jk", "isActive": true, "job": "pilot", "addresses": [ { "city": "Irvine,
United States", "street": "Second st", "zipcode": 98128 }, { "city": "iii,
United States", "street": "Second st", "zipcode": 98128 }, { "city":
"Riverside", "zipcode": 92507 } ], "age": 31 } }
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.16.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.16.adm
new file mode 100644
index 0000000000..18936e6eb4
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.16.adm
@@ -0,0 +1 @@
+{ "userId": 11, "email": "[email protected]", "username": "jk",
"isActive": true, "job": "pilot2", "addresses": [ { "city": "Irvine, United
States", "street": "Second st", "zipcode": 98128 }, { "city": "iii, United
States", "street": "Second st", "zipcode": 98128 }, { "city": "iii, United
States", "street": "Second st", "zipcode": 98128 }, { "city": "Riverside",
"zipcode": 92507 } ], "age": 31 }
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.5.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.5.adm
new file mode 100644
index 0000000000..129ca9ed20
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.5.adm
@@ -0,0 +1 @@
+{ "UserTypes": { "userId": 10, "email": "[email protected]", "username":
"marym", "isActive": false, "age": 32, "addresses": [ { "city": "Riverside",
"zipcode": 92510 } ] } }
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.7.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.7.adm
new file mode 100644
index 0000000000..39ccc68760
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.7.adm
@@ -0,0 +1,11 @@
+{ "UserTypes": { "userId": 1, "email": "[email protected]", "username":
"johndoe", "isActive": true, "occupation": "teacher", "age": 23 } }
+{ "UserTypes": { "userId": 2, "email": "[email protected]", "username":
"janesmith", "isActive": false, "occupation": "firefighter" } }
+{ "UserTypes": { "userId": 3, "email": "[email protected]",
"username": "michaelb", "isActive": true, "age": "five", "occupation": 4 } }
+{ "UserTypes": { "userId": 4, "email": "[email protected]", "username":
"emilyd", "isActive": true, "age": 23.1 } }
+{ "UserTypes": { "userId": 5, "email": "[email protected]", "username":
"chrisj", "isActive": false, "age": "old" } }
+{ "UserTypes": { "userId": 6, "email": "[email protected]",
"username": "patriciag", "isActive": true, "age": "45" } }
+{ "UserTypes": { "userId": 7, "email": "[email protected]",
"username": "lindam", "isActive": false } }
+{ "UserTypes": { "userId": 8, "email": "[email protected]", "username":
"robertl", "isActive": true, "age": 31 } }
+{ "UserTypes": { "userId": 9, "email": "[email protected]", "username":
"jamesw", "isActive": true, "age": "65" } }
+{ "UserTypes": { "userId": 10, "email": "[email protected]", "username":
"marym", "isActive": false, "timeZone": "PT", "age": 32, "addresses": [ {
"city": "Riverside", "zipcode": 92510 } ] } }
+{ "UserTypes": { "userId": 11, "email": "[email protected]", "username":
"jk", "isActive": true, "age": "20", "occupation": "firefighter", "addresses":
[ { "city": "San Jose, United States", "street": "Santana Row", "zipcode":
95128 }, { "city": "Riverside", "zipcode": 92507 } ] } }
\ No newline at end of file
diff --git
a/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.9.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.9.adm
new file mode 100644
index 0000000000..128089c858
--- /dev/null
+++
b/asterixdb/asterix-app/src/test/resources/runtimets/results/update-statements/simple-case/simple-case.9.adm
@@ -0,0 +1 @@
+{ "UserTypes": { "userId": 1, "email": "[email protected]", "username":
"johndoe", "isActive": true, "totaltax": 0.25, "totalcost": 25, "occupation":
"teacher", "age": 23 } }
\ No newline at end of file
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 c75cabb232..5e6c65411d 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/sqlpp_queries.xml
@@ -15383,7 +15383,19 @@
</compilation-unit>
</test-case>
</test-group>
- <test-group name="json">
+ <test-group name="update-statements">
+ <test-case FilePath="update-statements">
+ <compilation-unit name="simple-case">
+ <output-dir compare="Text">simple-case</output-dir>
+ </compilation-unit>
+ </test-case>
+ <test-case FilePath="update-statements">
+ <compilation-unit name="complex-case">
+ <output-dir compare="Text">complex-case</output-dir>
+ </compilation-unit>
+ </test-case>
+ </test-group>
+<test-group name="json">
<test-case FilePath="json">
<compilation-unit name="int01">
<output-dir compare="Lossless-JSON">int01-losslessjson</output-dir>
