asterixdb-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From buyin...@apache.org
Subject [20/29] incubator-asterixdb git commit: Supports Left Outer Join and Left Outer Unnest in SQL++.
Date Sat, 04 Jun 2016 02:44:24 GMT
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/b0fe0ac0/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-delete-btree-secondary-index-open/scan-delete-btree-secondary-index-open.1.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-delete-btree-secondary-index-open/scan-delete-btree-secondary-index-open.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-delete-btree-secondary-index-open/scan-delete-btree-secondary-index-open.1.adm
index c46aa1f..4ed64c9 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-delete-btree-secondary-index-open/scan-delete-btree-secondary-index-open.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-delete-btree-secondary-index-open/scan-delete-btree-secondary-index-open.1.adm
@@ -1,14 +1,14 @@
-{ "cid": 3, "name": "Phung Wheetley", "address": { "number": 5549, "street": "Hill St.",
"city": "Mountain View" }, "interests": {{ "Wine" }}, "children": [ { "name": "Raelene Wheetley",
"age": null }, { "name": "Dudley Wheetley", "age": null } ], "age": 12 }
-{ "cid": 11, "name": "Meta Simek", "address": { "number": 4384, "street": "7th St.", "city":
"San Jose" }, "interests": {{ "Wine", "Walking" }}, "children": [ { "name": "Oretha Simek",
"age": null }, { "name": "Terence Simek", "age": null } ], "age": 13 }
-{ "cid": 52, "name": "Janna Tish", "address": { "number": 2598, "street": "Washington St.",
"city": "San Jose" }, "interests": {{  }}, "children": [ { "name": "Mackenzie Tish", "age":
null }, { "name": "Ettie Tish", "age": null }, { "name": "Hortencia Tish", "age": null },
{ "name": "Paul Tish", "age": null } ], "age": 12 }
-{ "cid": 55, "name": "Terrence Bryant", "address": { "number": 3188, "street": "Park St.",
"city": "Seattle" }, "interests": {{ "Wine", "Cooking" }}, "children": [ { "name": "Dayna
Bryant", "age": null } ], "age": 12 }
-{ "cid": 61, "name": "Linsey Mose", "address": { "number": 9198, "street": "Lake St.", "city":
"Portland" }, "interests": {{ "Puzzles" }}, "children": [ { "name": "Tilda Mose", "age": null
}, { "name": "Lillie Mose", "age": null }, { "name": "Robyn Mose", "age": null } ], "age":
17 }
+{ "cid": 3, "name": "Phung Wheetley", "address": { "number": 5549, "street": "Hill St.",
"city": "Mountain View" }, "interests": {{ "Wine" }}, "children": [ { "name": "Raelene Wheetley"
}, { "name": "Dudley Wheetley" } ], "age": 12 }
+{ "cid": 11, "name": "Meta Simek", "address": { "number": 4384, "street": "7th St.", "city":
"San Jose" }, "interests": {{ "Wine", "Walking" }}, "children": [ { "name": "Oretha Simek"
}, { "name": "Terence Simek" } ], "age": 13 }
+{ "cid": 52, "name": "Janna Tish", "address": { "number": 2598, "street": "Washington St.",
"city": "San Jose" }, "interests": {{  }}, "children": [ { "name": "Mackenzie Tish" }, { "name":
"Ettie Tish" }, { "name": "Hortencia Tish" }, { "name": "Paul Tish" } ], "age": 12 }
+{ "cid": 55, "name": "Terrence Bryant", "address": { "number": 3188, "street": "Park St.",
"city": "Seattle" }, "interests": {{ "Wine", "Cooking" }}, "children": [ { "name": "Dayna
Bryant" } ], "age": 12 }
+{ "cid": 61, "name": "Linsey Mose", "address": { "number": 9198, "street": "Lake St.", "city":
"Portland" }, "interests": {{ "Puzzles" }}, "children": [ { "name": "Tilda Mose" }, { "name":
"Lillie Mose" }, { "name": "Robyn Mose" } ], "age": 17 }
 { "cid": 92, "name": "Kenny Laychock", "address": { "number": 4790, "street": "Washington
St.", "city": "Portland" }, "interests": {{ "Video Games", "Basketball" }}, "children": [
 ], "age": 15 }
-{ "cid": 111, "name": "Eddy Ortea", "address": { "number": 6874, "street": "Main St.", "city":
"Los Angeles" }, "interests": {{  }}, "children": [ { "name": "Shera Ortea", "age": null }
], "age": 16 }
-{ "cid": 112, "name": "Dorie Lave", "address": { "number": 2286, "street": "Lake St.", "city":
"Los Angeles" }, "interests": {{ "Coffee" }}, "children": [ { "name": "Grady Lave", "age":
null }, { "name": "Daysi Lave", "age": null } ], "age": 10 }
-{ "cid": 144, "name": "Celesta Sosebee", "address": { "number": 2683, "street": "7th St.",
"city": "Portland" }, "interests": {{ "Databases", "Databases" }}, "children": [ { "name":
"Jesse Sosebee", "age": null }, { "name": "Oralee Sosebee", "age": null }, { "name": "Sunday
Sosebee", "age": null } ], "age": 19 }
-{ "cid": 146, "name": "Glennis Vanruiten", "address": { "number": 8272, "street": "Park St.",
"city": "Los Angeles" }, "interests": {{ "Squash", "Databases" }}, "children": [ { "name":
"Joanie Vanruiten", "age": null }, { "name": "Long Vanruiten", "age": null }, { "name": "Abdul
Vanruiten", "age": null } ], "age": 14 }
+{ "cid": 111, "name": "Eddy Ortea", "address": { "number": 6874, "street": "Main St.", "city":
"Los Angeles" }, "interests": {{  }}, "children": [ { "name": "Shera Ortea" } ], "age": 16
}
+{ "cid": 112, "name": "Dorie Lave", "address": { "number": 2286, "street": "Lake St.", "city":
"Los Angeles" }, "interests": {{ "Coffee" }}, "children": [ { "name": "Grady Lave" }, { "name":
"Daysi Lave" } ], "age": 10 }
+{ "cid": 144, "name": "Celesta Sosebee", "address": { "number": 2683, "street": "7th St.",
"city": "Portland" }, "interests": {{ "Databases", "Databases" }}, "children": [ { "name":
"Jesse Sosebee" }, { "name": "Oralee Sosebee" }, { "name": "Sunday Sosebee" } ], "age": 19
}
+{ "cid": 146, "name": "Glennis Vanruiten", "address": { "number": 8272, "street": "Park St.",
"city": "Los Angeles" }, "interests": {{ "Squash", "Databases" }}, "children": [ { "name":
"Joanie Vanruiten" }, { "name": "Long Vanruiten" }, { "name": "Abdul Vanruiten" } ], "age":
14 }
 { "cid": 153, "name": "Randy Hueso", "address": { "number": 1957, "street": "Oak St.", "city":
"San Jose" }, "interests": {{ "Computers", "Wine", "Databases", "Walking" }}, "children":
[  ], "age": 11 }
 { "cid": 186, "name": "Krystle Spangler", "address": { "number": 4697, "street": "Cedar St.",
"city": "Seattle" }, "interests": {{ "Cigars", "Squash", "Coffee", "Video Games" }}, "children":
[  ], "age": 15 }
-{ "cid": 192, "name": "Shakira Delmonte", "address": { "number": 8838, "street": "Park St.",
"city": "Sunnyvale" }, "interests": {{ "Books", "Cigars", "Bass", "Base Jumping" }}, "children":
[ { "name": "Sergio Delmonte", "age": null }, { "name": "Aida Delmonte", "age": null }, {
"name": "Juliane Delmonte", "age": null } ], "age": 10 }
-{ "cid": 195, "name": "Annetta Demille", "address": { "number": 5722, "street": "Park St.",
"city": "Portland" }, "interests": {{ "Bass" }}, "children": [ { "name": "Natacha Demille",
"age": null }, { "name": "Giuseppe Demille", "age": null }, { "name": "Kami Demille", "age":
null }, { "name": "Jewell Demille", "age": null } ], "age": 17 }
+{ "cid": 192, "name": "Shakira Delmonte", "address": { "number": 8838, "street": "Park St.",
"city": "Sunnyvale" }, "interests": {{ "Books", "Cigars", "Bass", "Base Jumping" }}, "children":
[ { "name": "Sergio Delmonte" }, { "name": "Aida Delmonte" }, { "name": "Juliane Delmonte"
} ], "age": 10 }
+{ "cid": 195, "name": "Annetta Demille", "address": { "number": 5722, "street": "Park St.",
"city": "Portland" }, "interests": {{ "Bass" }}, "children": [ { "name": "Natacha Demille"
}, { "name": "Giuseppe Demille" }, { "name": "Kami Demille" }, { "name": "Jewell Demille"
} ], "age": 17 }

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/b0fe0ac0/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.1.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.1.adm
index a12b9b9..39520d3 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-nullable/scan-insert-btree-secondary-index-nullable.1.adm
@@ -1,14 +1,14 @@
-{ "cid": 3, "name": "Phung Wheetley", "age": 12, "address": { "number": 5549, "street": "Hill
St.", "city": "Mountain View" }, "interests": {{ "Wine" }}, "children": [ { "name": "Raelene
Wheetley", "age": null }, { "name": "Dudley Wheetley", "age": null } ] }
-{ "cid": 11, "name": "Meta Simek", "age": 13, "address": { "number": 4384, "street": "7th
St.", "city": "San Jose" }, "interests": {{ "Wine", "Walking" }}, "children": [ { "name":
"Oretha Simek", "age": null }, { "name": "Terence Simek", "age": null } ] }
-{ "cid": 52, "name": "Janna Tish", "age": 12, "address": { "number": 2598, "street": "Washington
St.", "city": "San Jose" }, "interests": {{  }}, "children": [ { "name": "Mackenzie Tish",
"age": null }, { "name": "Ettie Tish", "age": null }, { "name": "Hortencia Tish", "age": null
}, { "name": "Paul Tish", "age": null } ] }
-{ "cid": 55, "name": "Terrence Bryant", "age": 12, "address": { "number": 3188, "street":
"Park St.", "city": "Seattle" }, "interests": {{ "Wine", "Cooking" }}, "children": [ { "name":
"Dayna Bryant", "age": null } ] }
-{ "cid": 61, "name": "Linsey Mose", "age": 17, "address": { "number": 9198, "street": "Lake
St.", "city": "Portland" }, "interests": {{ "Puzzles" }}, "children": [ { "name": "Tilda Mose",
"age": null }, { "name": "Lillie Mose", "age": null }, { "name": "Robyn Mose", "age": null
} ] }
+{ "cid": 3, "name": "Phung Wheetley", "age": 12, "address": { "number": 5549, "street": "Hill
St.", "city": "Mountain View" }, "interests": {{ "Wine" }}, "children": [ { "name": "Raelene
Wheetley" }, { "name": "Dudley Wheetley" } ] }
+{ "cid": 11, "name": "Meta Simek", "age": 13, "address": { "number": 4384, "street": "7th
St.", "city": "San Jose" }, "interests": {{ "Wine", "Walking" }}, "children": [ { "name":
"Oretha Simek" }, { "name": "Terence Simek" } ] }
+{ "cid": 52, "name": "Janna Tish", "age": 12, "address": { "number": 2598, "street": "Washington
St.", "city": "San Jose" }, "interests": {{  }}, "children": [ { "name": "Mackenzie Tish"
}, { "name": "Ettie Tish" }, { "name": "Hortencia Tish" }, { "name": "Paul Tish" } ] }
+{ "cid": 55, "name": "Terrence Bryant", "age": 12, "address": { "number": 3188, "street":
"Park St.", "city": "Seattle" }, "interests": {{ "Wine", "Cooking" }}, "children": [ { "name":
"Dayna Bryant" } ] }
+{ "cid": 61, "name": "Linsey Mose", "age": 17, "address": { "number": 9198, "street": "Lake
St.", "city": "Portland" }, "interests": {{ "Puzzles" }}, "children": [ { "name": "Tilda Mose"
}, { "name": "Lillie Mose" }, { "name": "Robyn Mose" } ] }
 { "cid": 92, "name": "Kenny Laychock", "age": 15, "address": { "number": 4790, "street":
"Washington St.", "city": "Portland" }, "interests": {{ "Video Games", "Basketball" }}, "children":
[  ] }
-{ "cid": 111, "name": "Eddy Ortea", "age": 16, "address": { "number": 6874, "street": "Main
St.", "city": "Los Angeles" }, "interests": {{  }}, "children": [ { "name": "Shera Ortea",
"age": null } ] }
-{ "cid": 112, "name": "Dorie Lave", "age": 10, "address": { "number": 2286, "street": "Lake
St.", "city": "Los Angeles" }, "interests": {{ "Coffee" }}, "children": [ { "name": "Grady
Lave", "age": null }, { "name": "Daysi Lave", "age": null } ] }
-{ "cid": 144, "name": "Celesta Sosebee", "age": 19, "address": { "number": 2683, "street":
"7th St.", "city": "Portland" }, "interests": {{ "Databases", "Databases" }}, "children":
[ { "name": "Jesse Sosebee", "age": null }, { "name": "Oralee Sosebee", "age": null }, { "name":
"Sunday Sosebee", "age": null } ] }
-{ "cid": 146, "name": "Glennis Vanruiten", "age": 14, "address": { "number": 8272, "street":
"Park St.", "city": "Los Angeles" }, "interests": {{ "Squash", "Databases" }}, "children":
[ { "name": "Joanie Vanruiten", "age": null }, { "name": "Long Vanruiten", "age": null },
{ "name": "Abdul Vanruiten", "age": null } ] }
+{ "cid": 111, "name": "Eddy Ortea", "age": 16, "address": { "number": 6874, "street": "Main
St.", "city": "Los Angeles" }, "interests": {{  }}, "children": [ { "name": "Shera Ortea"
} ] }
+{ "cid": 112, "name": "Dorie Lave", "age": 10, "address": { "number": 2286, "street": "Lake
St.", "city": "Los Angeles" }, "interests": {{ "Coffee" }}, "children": [ { "name": "Grady
Lave" }, { "name": "Daysi Lave" } ] }
+{ "cid": 144, "name": "Celesta Sosebee", "age": 19, "address": { "number": 2683, "street":
"7th St.", "city": "Portland" }, "interests": {{ "Databases", "Databases" }}, "children":
[ { "name": "Jesse Sosebee" }, { "name": "Oralee Sosebee" }, { "name": "Sunday Sosebee" }
] }
+{ "cid": 146, "name": "Glennis Vanruiten", "age": 14, "address": { "number": 8272, "street":
"Park St.", "city": "Los Angeles" }, "interests": {{ "Squash", "Databases" }}, "children":
[ { "name": "Joanie Vanruiten" }, { "name": "Long Vanruiten" }, { "name": "Abdul Vanruiten"
} ] }
 { "cid": 153, "name": "Randy Hueso", "age": 11, "address": { "number": 1957, "street": "Oak
St.", "city": "San Jose" }, "interests": {{ "Computers", "Wine", "Databases", "Walking" }},
"children": [  ] }
 { "cid": 186, "name": "Krystle Spangler", "age": 15, "address": { "number": 4697, "street":
"Cedar St.", "city": "Seattle" }, "interests": {{ "Cigars", "Squash", "Coffee", "Video Games"
}}, "children": [  ] }
-{ "cid": 192, "name": "Shakira Delmonte", "age": 10, "address": { "number": 8838, "street":
"Park St.", "city": "Sunnyvale" }, "interests": {{ "Books", "Cigars", "Bass", "Base Jumping"
}}, "children": [ { "name": "Sergio Delmonte", "age": null }, { "name": "Aida Delmonte", "age":
null }, { "name": "Juliane Delmonte", "age": null } ] }
-{ "cid": 195, "name": "Annetta Demille", "age": 17, "address": { "number": 5722, "street":
"Park St.", "city": "Portland" }, "interests": {{ "Bass" }}, "children": [ { "name": "Natacha
Demille", "age": null }, { "name": "Giuseppe Demille", "age": null }, { "name": "Kami Demille",
"age": null }, { "name": "Jewell Demille", "age": null } ] }
+{ "cid": 192, "name": "Shakira Delmonte", "age": 10, "address": { "number": 8838, "street":
"Park St.", "city": "Sunnyvale" }, "interests": {{ "Books", "Cigars", "Bass", "Base Jumping"
}}, "children": [ { "name": "Sergio Delmonte" }, { "name": "Aida Delmonte" }, { "name": "Juliane
Delmonte" } ] }
+{ "cid": 195, "name": "Annetta Demille", "age": 17, "address": { "number": 5722, "street":
"Park St.", "city": "Portland" }, "interests": {{ "Bass" }}, "children": [ { "name": "Natacha
Demille" }, { "name": "Giuseppe Demille" }, { "name": "Kami Demille" }, { "name": "Jewell
Demille" } ] }

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/b0fe0ac0/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-open/scan-insert-btree-secondary-index-open.1.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-open/scan-insert-btree-secondary-index-open.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-open/scan-insert-btree-secondary-index-open.1.adm
index c46aa1f..4ed64c9 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-open/scan-insert-btree-secondary-index-open.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/dml/scan-insert-btree-secondary-index-open/scan-insert-btree-secondary-index-open.1.adm
@@ -1,14 +1,14 @@
-{ "cid": 3, "name": "Phung Wheetley", "address": { "number": 5549, "street": "Hill St.",
"city": "Mountain View" }, "interests": {{ "Wine" }}, "children": [ { "name": "Raelene Wheetley",
"age": null }, { "name": "Dudley Wheetley", "age": null } ], "age": 12 }
-{ "cid": 11, "name": "Meta Simek", "address": { "number": 4384, "street": "7th St.", "city":
"San Jose" }, "interests": {{ "Wine", "Walking" }}, "children": [ { "name": "Oretha Simek",
"age": null }, { "name": "Terence Simek", "age": null } ], "age": 13 }
-{ "cid": 52, "name": "Janna Tish", "address": { "number": 2598, "street": "Washington St.",
"city": "San Jose" }, "interests": {{  }}, "children": [ { "name": "Mackenzie Tish", "age":
null }, { "name": "Ettie Tish", "age": null }, { "name": "Hortencia Tish", "age": null },
{ "name": "Paul Tish", "age": null } ], "age": 12 }
-{ "cid": 55, "name": "Terrence Bryant", "address": { "number": 3188, "street": "Park St.",
"city": "Seattle" }, "interests": {{ "Wine", "Cooking" }}, "children": [ { "name": "Dayna
Bryant", "age": null } ], "age": 12 }
-{ "cid": 61, "name": "Linsey Mose", "address": { "number": 9198, "street": "Lake St.", "city":
"Portland" }, "interests": {{ "Puzzles" }}, "children": [ { "name": "Tilda Mose", "age": null
}, { "name": "Lillie Mose", "age": null }, { "name": "Robyn Mose", "age": null } ], "age":
17 }
+{ "cid": 3, "name": "Phung Wheetley", "address": { "number": 5549, "street": "Hill St.",
"city": "Mountain View" }, "interests": {{ "Wine" }}, "children": [ { "name": "Raelene Wheetley"
}, { "name": "Dudley Wheetley" } ], "age": 12 }
+{ "cid": 11, "name": "Meta Simek", "address": { "number": 4384, "street": "7th St.", "city":
"San Jose" }, "interests": {{ "Wine", "Walking" }}, "children": [ { "name": "Oretha Simek"
}, { "name": "Terence Simek" } ], "age": 13 }
+{ "cid": 52, "name": "Janna Tish", "address": { "number": 2598, "street": "Washington St.",
"city": "San Jose" }, "interests": {{  }}, "children": [ { "name": "Mackenzie Tish" }, { "name":
"Ettie Tish" }, { "name": "Hortencia Tish" }, { "name": "Paul Tish" } ], "age": 12 }
+{ "cid": 55, "name": "Terrence Bryant", "address": { "number": 3188, "street": "Park St.",
"city": "Seattle" }, "interests": {{ "Wine", "Cooking" }}, "children": [ { "name": "Dayna
Bryant" } ], "age": 12 }
+{ "cid": 61, "name": "Linsey Mose", "address": { "number": 9198, "street": "Lake St.", "city":
"Portland" }, "interests": {{ "Puzzles" }}, "children": [ { "name": "Tilda Mose" }, { "name":
"Lillie Mose" }, { "name": "Robyn Mose" } ], "age": 17 }
 { "cid": 92, "name": "Kenny Laychock", "address": { "number": 4790, "street": "Washington
St.", "city": "Portland" }, "interests": {{ "Video Games", "Basketball" }}, "children": [
 ], "age": 15 }
-{ "cid": 111, "name": "Eddy Ortea", "address": { "number": 6874, "street": "Main St.", "city":
"Los Angeles" }, "interests": {{  }}, "children": [ { "name": "Shera Ortea", "age": null }
], "age": 16 }
-{ "cid": 112, "name": "Dorie Lave", "address": { "number": 2286, "street": "Lake St.", "city":
"Los Angeles" }, "interests": {{ "Coffee" }}, "children": [ { "name": "Grady Lave", "age":
null }, { "name": "Daysi Lave", "age": null } ], "age": 10 }
-{ "cid": 144, "name": "Celesta Sosebee", "address": { "number": 2683, "street": "7th St.",
"city": "Portland" }, "interests": {{ "Databases", "Databases" }}, "children": [ { "name":
"Jesse Sosebee", "age": null }, { "name": "Oralee Sosebee", "age": null }, { "name": "Sunday
Sosebee", "age": null } ], "age": 19 }
-{ "cid": 146, "name": "Glennis Vanruiten", "address": { "number": 8272, "street": "Park St.",
"city": "Los Angeles" }, "interests": {{ "Squash", "Databases" }}, "children": [ { "name":
"Joanie Vanruiten", "age": null }, { "name": "Long Vanruiten", "age": null }, { "name": "Abdul
Vanruiten", "age": null } ], "age": 14 }
+{ "cid": 111, "name": "Eddy Ortea", "address": { "number": 6874, "street": "Main St.", "city":
"Los Angeles" }, "interests": {{  }}, "children": [ { "name": "Shera Ortea" } ], "age": 16
}
+{ "cid": 112, "name": "Dorie Lave", "address": { "number": 2286, "street": "Lake St.", "city":
"Los Angeles" }, "interests": {{ "Coffee" }}, "children": [ { "name": "Grady Lave" }, { "name":
"Daysi Lave" } ], "age": 10 }
+{ "cid": 144, "name": "Celesta Sosebee", "address": { "number": 2683, "street": "7th St.",
"city": "Portland" }, "interests": {{ "Databases", "Databases" }}, "children": [ { "name":
"Jesse Sosebee" }, { "name": "Oralee Sosebee" }, { "name": "Sunday Sosebee" } ], "age": 19
}
+{ "cid": 146, "name": "Glennis Vanruiten", "address": { "number": 8272, "street": "Park St.",
"city": "Los Angeles" }, "interests": {{ "Squash", "Databases" }}, "children": [ { "name":
"Joanie Vanruiten" }, { "name": "Long Vanruiten" }, { "name": "Abdul Vanruiten" } ], "age":
14 }
 { "cid": 153, "name": "Randy Hueso", "address": { "number": 1957, "street": "Oak St.", "city":
"San Jose" }, "interests": {{ "Computers", "Wine", "Databases", "Walking" }}, "children":
[  ], "age": 11 }
 { "cid": 186, "name": "Krystle Spangler", "address": { "number": 4697, "street": "Cedar St.",
"city": "Seattle" }, "interests": {{ "Cigars", "Squash", "Coffee", "Video Games" }}, "children":
[  ], "age": 15 }
-{ "cid": 192, "name": "Shakira Delmonte", "address": { "number": 8838, "street": "Park St.",
"city": "Sunnyvale" }, "interests": {{ "Books", "Cigars", "Bass", "Base Jumping" }}, "children":
[ { "name": "Sergio Delmonte", "age": null }, { "name": "Aida Delmonte", "age": null }, {
"name": "Juliane Delmonte", "age": null } ], "age": 10 }
-{ "cid": 195, "name": "Annetta Demille", "address": { "number": 5722, "street": "Park St.",
"city": "Portland" }, "interests": {{ "Bass" }}, "children": [ { "name": "Natacha Demille",
"age": null }, { "name": "Giuseppe Demille", "age": null }, { "name": "Kami Demille", "age":
null }, { "name": "Jewell Demille", "age": null } ], "age": 17 }
+{ "cid": 192, "name": "Shakira Delmonte", "address": { "number": 8838, "street": "Park St.",
"city": "Sunnyvale" }, "interests": {{ "Books", "Cigars", "Bass", "Base Jumping" }}, "children":
[ { "name": "Sergio Delmonte" }, { "name": "Aida Delmonte" }, { "name": "Juliane Delmonte"
} ], "age": 10 }
+{ "cid": 195, "name": "Annetta Demille", "address": { "number": 5722, "street": "Park St.",
"city": "Portland" }, "interests": {{ "Bass" }}, "children": [ { "name": "Natacha Demille"
}, { "name": "Giuseppe Demille" }, { "name": "Kami Demille" }, { "name": "Jewell Demille"
} ], "age": 17 }

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/b0fe0ac0/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_01/q_01.1.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_01/q_01.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_01/q_01.1.adm
index 2d4e3ac..43a851c 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_01/q_01.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_01/q_01.1.adm
@@ -1,4 +1,4 @@
-{ "id": 775, "name": "Jodi Rotruck", "address": { "number": 8389, "street": "Hill St.", "city":
"Mountain View" }, "age": null, "interests": null, "children": [ "Ross", "Martin" ], "lastorder":
{ "oid": 75, "total": 8377.618f }, "openlist": [ 10, 2.0f, 3.0d, 40 ], "total": 97.20656f
}
-{ "id": 5, "name": "Jodi Alex", "address": { "number": 158, "street": "Palo verde", "city":
"Irvine" }, "age": 19, "interests": null, "children": null, "openlist": [ 10, 2.0f, 3.0d,
40 ], "total": 55.56f }
-{ "id": 5, "name": "Mike Mark", "address": { "number": 8, "street": "Main St.", "city": "LA"
}, "age": null, "interests": {{ "eating", "cooking" }}, "children": null, "openlist": [ 10,
2.0f, 3.0d, 40 ], "lastorder": { "oid": 5, "total": 83.6d } }
-{ "id": 5, "name": "Mike ley", "address": { "number": 9, "street": "Campus St.", "city":
"Long beach" }, "age": null, "interests": {{ "writing", "surfing" }}, "children": [ "Mike",
"Eric" ], "openlist": [ 10, 2.0f, 3.0d, 40 ], "total": 97, "lastorder": { "oid": 767675, "total":
7.618f } }
+{ "id": 775, "name": "Jodi Rotruck", "address": { "number": 8389, "street": "Hill St.", "city":
"Mountain View" }, "children": [ "Ross", "Martin" ], "lastorder": { "oid": 75, "total": 8377.618f
}, "openlist": [ 10, 2.0f, 3.0d, 40 ], "total": 97.20656f }
+{ "id": 5, "name": "Jodi Alex", "address": { "number": 158, "street": "Palo verde", "city":
"Irvine" }, "age": 19, "openlist": [ 10, 2.0f, 3.0d, 40 ], "total": 55.56f }
+{ "id": 5, "name": "Mike Mark", "address": { "number": 8, "street": "Main St.", "city": "LA"
}, "interests": {{ "eating", "cooking" }}, "openlist": [ 10, 2.0f, 3.0d, 40 ], "lastorder":
{ "oid": 5, "total": 83.6d } }
+{ "id": 5, "name": "Mike ley", "address": { "number": 9, "street": "Campus St.", "city":
"Long beach" }, "interests": {{ "writing", "surfing" }}, "children": [ "Mike", "Eric" ], "openlist":
[ 10, 2.0f, 3.0d, 40 ], "total": 97, "lastorder": { "oid": 767675, "total": 7.618f } }

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/b0fe0ac0/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_02/q_02.1.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_02/q_02.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_02/q_02.1.adm
index 922def6..bd0bfe9 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_02/q_02.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/employee/q_02/q_02.1.adm
@@ -1,4 +1,4 @@
-[ { "EmpName": "Jodi Rotruck", "parent_interest_1": null, "child1Name": "Ross", "child2Name":
"Martin" } ]
-[ { "EmpName": "Jodi Alex", "parent_interest_1": null, "child1Name": null, "child2Name":
null } ]
-[ { "EmpName": "Mike Mark", "parent_interest_1": "eating", "child1Name": null, "child2Name":
null } ]
+[ { "EmpName": "Jodi Rotruck", "child1Name": "Ross", "child2Name": "Martin" } ]
+[ { "EmpName": "Jodi Alex" } ]
+[ { "EmpName": "Mike Mark", "parent_interest_1": "eating" } ]
 [ { "EmpName": "Mike ley", "parent_interest_1": "writing", "child1Name": "Mike", "child2Name":
"Eric" } ]

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/b0fe0ac0/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_01/feeds_01.1.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_01/feeds_01.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_01/feeds_01.1.adm
index f3e4605..280974e 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_01/feeds_01.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_01/feeds_01.1.adm
@@ -1 +1 @@
-{ "DataverseName": "feeds", "FeedName": "TweetFeed", "Function": null, "FeedType": "PRIMARY",
"PrimaryTypeDetails": { "AdapterName": "file_feed", "AdapterConfiguration": {{ { "Name": "output-type-name",
"Value": "TweetType" }, { "Name": "fs", "Value": "localfs" }, { "Name": "path", "Value": "asterix_nc1://data/twitter/obamatweets.adm"
}, { "Name": "format", "Value": "adm" }, { "Name": "tuple-interval", "Value": "10" } }} },
"SecondaryTypeDetails": null, "Timestamp": "Sat Jun 20 13:55:58 PDT 2015" }
+{ "DataverseName": "feeds", "FeedName": "TweetFeed", "FeedType": "PRIMARY", "PrimaryTypeDetails":
{ "AdapterName": "file_feed", "AdapterConfiguration": {{ { "Name": "output-type-name", "Value":
"TweetType" }, { "Name": "fs", "Value": "localfs" }, { "Name": "path", "Value": "asterix_nc1://data/twitter/obamatweets.adm"
}, { "Name": "format", "Value": "adm" }, { "Name": "tuple-interval", "Value": "10" } }} },
"Timestamp": "Wed Jun 01 19:07:55 PDT 2016" }

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/b0fe0ac0/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_03/feeds_03.1.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_03/feeds_03.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_03/feeds_03.1.adm
index 37eb1d4..2581941 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_03/feeds_03.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/feeds/feeds_03/feeds_03.1.adm
@@ -1 +1 @@
-{ "DataverseName": "feeds", "FeedName": "TweetFeed", "Function": "feed_processor", "FeedType":
"PRIMARY", "PrimaryTypeDetails": { "AdapterName": "file_feed", "AdapterConfiguration": {{
{ "Name": "output-type-name", "Value": "TweetType" }, { "Name": "fs", "Value": "localfs" },
{ "Name": "path", "Value": "asterix_nc1://data/twitter/obamatweets.adm" }, { "Name": "format",
"Value": "adm" }, { "Name": "tuple-interval", "Value": "10" } }} }, "SecondaryTypeDetails":
null, "Timestamp": "Sat Jun 20 13:55:59 PDT 2015" }
+{ "DataverseName": "feeds", "FeedName": "TweetFeed", "Function": "feed_processor", "FeedType":
"PRIMARY", "PrimaryTypeDetails": { "AdapterName": "file_feed", "AdapterConfiguration": {{
{ "Name": "output-type-name", "Value": "TweetType" }, { "Name": "fs", "Value": "localfs" },
{ "Name": "path", "Value": "asterix_nc1://data/twitter/obamatweets.adm" }, { "Name": "format",
"Value": "adm" }, { "Name": "tuple-interval", "Value": "10" } }} }, "Timestamp": "Wed Jun
01 19:07:55 PDT 2016" }

http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/b0fe0ac0/asterixdb/asterix-app/src/test/resources/runtimets/results/index-selection/cust-index-age-nullable/cust-index-age-nullable.1.adm
----------------------------------------------------------------------
diff --git a/asterixdb/asterix-app/src/test/resources/runtimets/results/index-selection/cust-index-age-nullable/cust-index-age-nullable.1.adm
b/asterixdb/asterix-app/src/test/resources/runtimets/results/index-selection/cust-index-age-nullable/cust-index-age-nullable.1.adm
index f5b5521..3756d06 100644
--- a/asterixdb/asterix-app/src/test/resources/runtimets/results/index-selection/cust-index-age-nullable/cust-index-age-nullable.1.adm
+++ b/asterixdb/asterix-app/src/test/resources/runtimets/results/index-selection/cust-index-age-nullable/cust-index-age-nullable.1.adm
@@ -1,2 +1,2 @@
 { "cid": 92, "name": "Kenny Laychock", "age": 15, "address": { "number": 4790, "street":
"Washington St.", "city": "Portland" }, "interests": {{ "Video Games", "Basketball" }}, "children":
[  ] }
-{ "cid": 112, "name": "Dorie Lave", "age": 10, "address": { "number": 2286, "street": "Lake
St.", "city": "Los Angeles" }, "interests": {{ "Coffee" }}, "children": [ { "name": "Grady
Lave", "age": null }, { "name": "Daysi Lave", "age": null } ] }
+{ "cid": 112, "name": "Dorie Lave", "age": 10, "address": { "number": 2286, "street": "Lake
St.", "city": "Los Angeles" }, "interests": {{ "Coffee" }}, "children": [ { "name": "Grady
Lave" }, { "name": "Daysi Lave" } ] }


Mime
View raw message