You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by im...@apache.org on 2015/05/20 03:25:51 UTC
[10/10] incubator-asterixdb git commit: fix multi-delete statement
issue
fix multi-delete statement issue
Change-Id: I32c55e225fb8cc3f164da7029b4c31c26c6e574d
Reviewed-on: https://asterix-gerrit.ics.uci.edu/271
Reviewed-by: Ian Maxon <im...@uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Project: http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/commit/7de6f4eb
Tree: http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/tree/7de6f4eb
Diff: http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/diff/7de6f4eb
Branch: refs/heads/master
Commit: 7de6f4eb80a8bc74a9491b319197c0ca14df8e90
Parents: ccd67fe
Author: Yingyi Bu <bu...@gmail.com>
Authored: Mon May 18 17:02:17 2015 -0700
Committer: Ian Maxon <im...@uci.edu>
Committed: Tue May 19 18:21:40 2015 -0700
----------------------------------------------------------------------
.../asterix/translator/TranslationContext.java | 3 +
.../delete-multi-statement.1.ddl.aql | 106 +++++++++++++
.../delete-multi-statement.2.update.aql | 41 +++++
.../delete-multi-statement.3.query.aql | 5 +
.../delete-multi-statement.1.adm | 151 +++++++++++++++++++
.../src/test/resources/runtimets/testsuite.xml | 5 +
6 files changed, 311 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/7de6f4eb/asterix-algebra/src/main/java/edu/uci/ics/asterix/translator/TranslationContext.java
----------------------------------------------------------------------
diff --git a/asterix-algebra/src/main/java/edu/uci/ics/asterix/translator/TranslationContext.java b/asterix-algebra/src/main/java/edu/uci/ics/asterix/translator/TranslationContext.java
index 538b78b..a9576eb 100644
--- a/asterix-algebra/src/main/java/edu/uci/ics/asterix/translator/TranslationContext.java
+++ b/asterix-algebra/src/main/java/edu/uci/ics/asterix/translator/TranslationContext.java
@@ -52,6 +52,9 @@ public final class TranslationContext {
public LogicalVariable newVar(VariableExpr v) {
Integer i = v.getVar().getId();
+ if (i > varCounter.get()) {
+ varCounter.set(i);
+ }
LogicalVariable var = new LogicalVariable(i);
varEnv.put(i, var);
return var;
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/7de6f4eb/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.1.ddl.aql
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.1.ddl.aql b/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.1.ddl.aql
new file mode 100644
index 0000000..5258bc2
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.1.ddl.aql
@@ -0,0 +1,106 @@
+drop dataverse tpch if exists;
+create dataverse tpch;
+
+use dataverse tpch;
+
+create type LineItemType as closed {
+ l_orderkey: int32,
+ l_partkey: int32,
+ l_suppkey: int32,
+ l_linenumber: int32,
+ l_quantity: int32,
+ l_extendedprice: double,
+ l_discount: double,
+ l_tax: double,
+ l_returnflag: string,
+ l_linestatus: string,
+ l_shipdate: string,
+ l_commitdate: string,
+ l_receiptdate: string,
+ l_shipinstruct: string,
+ l_shipmode: string,
+ l_comment: string
+}
+
+create type OrderType as closed {
+ o_orderkey: int32,
+ o_custkey: int32,
+ o_orderstatus: string,
+ o_totalprice: double,
+ o_orderdate: string,
+ o_orderpriority: string,
+ o_clerk: string,
+ o_shippriority: int32,
+ o_comment: string
+}
+
+create type CustomerType as closed {
+ c_custkey: int32,
+ c_name: string,
+ c_address: string,
+ c_nationkey: int32,
+ c_phone: string,
+ c_acctbal: double,
+ c_mktsegment: string,
+ c_comment: string
+}
+
+create type SupplierType as closed {
+ s_suppkey: int32,
+ s_name: string,
+ s_address: string,
+ s_nationkey: int32,
+ s_phone: string,
+ s_acctbal: double,
+ s_comment: string
+}
+
+create type NationType as closed {
+ n_nationkey: int32,
+ n_name: string,
+ n_regionkey: int32,
+ n_comment: string
+}
+
+create type RegionType as closed {
+ r_regionkey: int32,
+ r_name: string,
+ r_comment: string
+}
+
+create type PartType as closed {
+ p_partkey: int32,
+ p_name: string,
+ p_mfgr: string,
+ p_brand: string,
+ p_type: string,
+ p_size: int32,
+ p_container: string,
+ p_retailprice: double,
+ p_comment: string
+}
+
+create type PartSuppType as closed {
+ ps_partkey: int32,
+ ps_suppkey: int32,
+ ps_availqty: int32,
+ ps_supplycost: double,
+ ps_comment: string
+}
+
+create dataset LineItem(LineItemType)
+ primary key l_orderkey, l_linenumber;
+create dataset Orders(OrderType)
+ primary key o_orderkey;
+create dataset Supplier(SupplierType)
+ primary key s_suppkey;
+create dataset Region(RegionType)
+ primary key r_regionkey;
+create dataset Nation(NationType)
+ primary key n_nationkey;
+create dataset Part(PartType)
+ primary key p_partkey;
+create dataset Partsupp(PartSuppType)
+ primary key ps_partkey, ps_suppkey;
+create dataset Customer(CustomerType)
+ primary key c_custkey;
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/7de6f4eb/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.2.update.aql
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.2.update.aql b/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.2.update.aql
new file mode 100644
index 0000000..314a199
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.2.update.aql
@@ -0,0 +1,41 @@
+use dataverse tpch;
+
+load dataset LineItem
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/tpch0.001/lineitem.tbl"),("format"="delimited-text"),("delimiter"="|"));
+
+load dataset Orders
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/tpch0.001/orders.tbl"),("format"="delimited-text"),("delimiter"="|"));
+
+load dataset Supplier
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/tpch0.001/supplier.tbl"),("format"="delimited-text"),("delimiter"="|"));
+
+load dataset Region
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/tpch0.001/region.tbl"),("format"="delimited-text"),("delimiter"="|"));
+
+load dataset Nation
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/tpch0.001/nation.tbl"),("format"="delimited-text"),("delimiter"="|"));
+
+load dataset Part
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/tpch0.001/part.tbl"),("format"="delimited-text"),("delimiter"="|"));
+
+load dataset Partsupp
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/tpch0.001/partsupp.tbl"),("format"="delimited-text"),("delimiter"="|"));
+
+load dataset Customer
+using "edu.uci.ics.asterix.external.dataset.adapter.NCFileSystemAdapter"
+(("path"="nc1://data/tpch0.001/customer.tbl"),("format"="delimited-text"),("delimiter"="|"));
+
+delete $l from dataset LineItem;
+delete $o from dataset Orders;
+delete $s from dataset Supplier;
+delete $s from dataset Region;
+delete $s from dataset Nation;
+delete $s from dataset Part;
+delete $s from dataset Partsupp;
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/7de6f4eb/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.3.query.aql
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.3.query.aql b/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.3.query.aql
new file mode 100644
index 0000000..cde20fb
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/queries/dml/delete-multi-statement/delete-multi-statement.3.query.aql
@@ -0,0 +1,5 @@
+use dataverse tpch;
+
+for $c in dataset Customer
+return $c;
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/7de6f4eb/asterix-app/src/test/resources/runtimets/results/dml/delete-multi-statement/delete-multi-statement.1.adm
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results/dml/delete-multi-statement/delete-multi-statement.1.adm b/asterix-app/src/test/resources/runtimets/results/dml/delete-multi-statement/delete-multi-statement.1.adm
new file mode 100644
index 0000000..f0946aa
--- /dev/null
+++ b/asterix-app/src/test/resources/runtimets/results/dml/delete-multi-statement/delete-multi-statement.1.adm
@@ -0,0 +1,151 @@
+[ { "c_custkey": 6i32, "c_name": "Customer#000000006", "c_address": "sKZz0CsnMD7mp4Xd0YrBvx,LREYKUWAh yVn", "c_nationkey": 20i32, "c_phone": "30-114-968-4951", "c_acctbal": 7638.57d, "c_mktsegment": "AUTOMOBILE", "c_comment": "tions. even deposits boost according to the slyly bold packages. final accounts cajole requests. furious" }
+, { "c_custkey": 11i32, "c_name": "Customer#000000011", "c_address": "PkWS 3HlXqwTuzrKg633BEi", "c_nationkey": 23i32, "c_phone": "33-464-151-3439", "c_acctbal": -272.6d, "c_mktsegment": "BUILDING", "c_comment": "ckages. requests sleep slyly. quickly even pinto beans promise above the slyly regular pinto beans. " }
+, { "c_custkey": 12i32, "c_name": "Customer#000000012", "c_address": "9PWKuhzT4Zr1Q", "c_nationkey": 13i32, "c_phone": "23-791-276-1263", "c_acctbal": 3396.49d, "c_mktsegment": "HOUSEHOLD", "c_comment": " to the carefully final braids. blithely regular requests nag. ironic theodolites boost quickly along" }
+, { "c_custkey": 14i32, "c_name": "Customer#000000014", "c_address": "KXkletMlL2JQEA ", "c_nationkey": 1i32, "c_phone": "11-845-129-3851", "c_acctbal": 5266.3d, "c_mktsegment": "FURNITURE", "c_comment": ", ironic packages across the unus" }
+, { "c_custkey": 21i32, "c_name": "Customer#000000021", "c_address": "XYmVpr9yAHDEn", "c_nationkey": 8i32, "c_phone": "18-902-614-8344", "c_acctbal": 1428.25d, "c_mktsegment": "MACHINERY", "c_comment": " quickly final accounts integrate blithely furiously u" }
+, { "c_custkey": 23i32, "c_name": "Customer#000000023", "c_address": "OdY W13N7Be3OC5MpgfmcYss0Wn6TKT", "c_nationkey": 3i32, "c_phone": "13-312-472-8245", "c_acctbal": 3332.02d, "c_mktsegment": "HOUSEHOLD", "c_comment": "deposits. special deposits cajole slyly. fluffily special deposits about the furiously " }
+, { "c_custkey": 26i32, "c_name": "Customer#000000026", "c_address": "8ljrc5ZeMl7UciP", "c_nationkey": 22i32, "c_phone": "32-363-455-4837", "c_acctbal": 5182.05d, "c_mktsegment": "AUTOMOBILE", "c_comment": "c requests use furiously ironic requests. slyly ironic dependencies us" }
+, { "c_custkey": 30i32, "c_name": "Customer#000000030", "c_address": "nJDsELGAavU63Jl0c5NKsKfL8rIJQQkQnYL2QJY", "c_nationkey": 1i32, "c_phone": "11-764-165-5076", "c_acctbal": 9321.01d, "c_mktsegment": "BUILDING", "c_comment": "lithely final requests. furiously unusual account" }
+, { "c_custkey": 33i32, "c_name": "Customer#000000033", "c_address": "qFSlMuLucBmx9xnn5ib2csWUweg D", "c_nationkey": 17i32, "c_phone": "27-375-391-1280", "c_acctbal": -78.56d, "c_mktsegment": "AUTOMOBILE", "c_comment": "s. slyly regular accounts are furiously. carefully pending requests" }
+, { "c_custkey": 38i32, "c_name": "Customer#000000038", "c_address": "a5Ee5e9568R8RLP 2ap7", "c_nationkey": 12i32, "c_phone": "22-306-880-7212", "c_acctbal": 6345.11d, "c_mktsegment": "HOUSEHOLD", "c_comment": "lar excuses. closely even asymptotes cajole blithely excuses. carefully silent pinto beans sleep carefully fin" }
+, { "c_custkey": 45i32, "c_name": "Customer#000000045", "c_address": "4v3OcpFgoOmMG,CbnF,4mdC", "c_nationkey": 9i32, "c_phone": "19-715-298-9917", "c_acctbal": 9983.38d, "c_mktsegment": "AUTOMOBILE", "c_comment": "nto beans haggle slyly alongside of t" }
+, { "c_custkey": 47i32, "c_name": "Customer#000000047", "c_address": "b0UgocSqEW5 gdVbhNT", "c_nationkey": 2i32, "c_phone": "12-427-271-9466", "c_acctbal": 274.58d, "c_mktsegment": "BUILDING", "c_comment": "ions. express, ironic instructions sleep furiously ironic ideas. furi" }
+, { "c_custkey": 49i32, "c_name": "Customer#000000049", "c_address": "cNgAeX7Fqrdf7HQN9EwjUa4nxT,68L FKAxzl", "c_nationkey": 10i32, "c_phone": "20-908-631-4424", "c_acctbal": 4573.94d, "c_mktsegment": "FURNITURE", "c_comment": "nusual foxes! fluffily pending packages maintain to the regular " }
+, { "c_custkey": 51i32, "c_name": "Customer#000000051", "c_address": "uR,wEaiTvo4", "c_nationkey": 12i32, "c_phone": "22-344-885-4251", "c_acctbal": 855.87d, "c_mktsegment": "FURNITURE", "c_comment": "eposits. furiously regular requests integrate carefully packages. furious" }
+, { "c_custkey": 58i32, "c_name": "Customer#000000058", "c_address": "g9ap7Dk1Sv9fcXEWjpMYpBZIRUohi T", "c_nationkey": 13i32, "c_phone": "23-244-493-2508", "c_acctbal": 6478.46d, "c_mktsegment": "HOUSEHOLD", "c_comment": "ideas. ironic ideas affix furiously express, final instructions. regular excuses use quickly e" }
+, { "c_custkey": 60i32, "c_name": "Customer#000000060", "c_address": "FyodhjwMChsZmUz7Jz0H", "c_nationkey": 12i32, "c_phone": "22-480-575-5866", "c_acctbal": 2741.87d, "c_mktsegment": "MACHINERY", "c_comment": "latelets. blithely unusual courts boost furiously about the packages. blithely final instruct" }
+, { "c_custkey": 70i32, "c_name": "Customer#000000070", "c_address": "mFowIuhnHjp2GjCiYYavkW kUwOjIaTCQ", "c_nationkey": 22i32, "c_phone": "32-828-107-2832", "c_acctbal": 4867.52d, "c_mktsegment": "FURNITURE", "c_comment": "fter the special asymptotes. ideas after the unusual frets cajole quickly regular pinto be" }
+, { "c_custkey": 72i32, "c_name": "Customer#000000072", "c_address": "putjlmskxE,zs,HqeIA9Wqu7dhgH5BVCwDwHHcf", "c_nationkey": 2i32, "c_phone": "12-759-144-9689", "c_acctbal": -362.86d, "c_mktsegment": "FURNITURE", "c_comment": "ithely final foxes sleep always quickly bold accounts. final wat" }
+, { "c_custkey": 77i32, "c_name": "Customer#000000077", "c_address": "4tAE5KdMFGD4byHtXF92vx", "c_nationkey": 17i32, "c_phone": "27-269-357-4674", "c_acctbal": 1738.87d, "c_mktsegment": "BUILDING", "c_comment": "uffily silent requests. carefully ironic asymptotes among the ironic hockey players are carefully bli" }
+, { "c_custkey": 88i32, "c_name": "Customer#000000088", "c_address": "wtkjBN9eyrFuENSMmMFlJ3e7jE5KXcg", "c_nationkey": 16i32, "c_phone": "26-516-273-2566", "c_acctbal": 8031.44d, "c_mktsegment": "AUTOMOBILE", "c_comment": "s are quickly above the quickly ironic instructions; even requests about the carefully final deposi" }
+, { "c_custkey": 89i32, "c_name": "Customer#000000089", "c_address": "dtR, y9JQWUO6FoJExyp8whOU", "c_nationkey": 14i32, "c_phone": "24-394-451-5404", "c_acctbal": 1530.76d, "c_mktsegment": "FURNITURE", "c_comment": "counts are slyly beyond the slyly final accounts. quickly final ideas wake. r" }
+, { "c_custkey": 92i32, "c_name": "Customer#000000092", "c_address": "obP PULk2LH LqNF,K9hcbNqnLAkJVsl5xqSrY,", "c_nationkey": 2i32, "c_phone": "12-446-416-8471", "c_acctbal": 1182.91d, "c_mktsegment": "MACHINERY", "c_comment": ". pinto beans hang slyly final deposits. ac" }
+, { "c_custkey": 93i32, "c_name": "Customer#000000093", "c_address": "EHXBr2QGdh", "c_nationkey": 7i32, "c_phone": "17-359-388-5266", "c_acctbal": 2182.52d, "c_mktsegment": "MACHINERY", "c_comment": "press deposits. carefully regular platelets r" }
+, { "c_custkey": 103i32, "c_name": "Customer#000000103", "c_address": "8KIsQX4LJ7QMsj6DrtFtXu0nUEdV,8a", "c_nationkey": 9i32, "c_phone": "19-216-107-2107", "c_acctbal": 2757.45d, "c_mktsegment": "BUILDING", "c_comment": "furiously pending notornis boost slyly around the blithely ironic ideas? final, even instructions cajole fl" }
+, { "c_custkey": 105i32, "c_name": "Customer#000000105", "c_address": "4iSJe4L SPjg7kJj98Yz3z0B", "c_nationkey": 10i32, "c_phone": "20-793-553-6417", "c_acctbal": 9091.82d, "c_mktsegment": "MACHINERY", "c_comment": "l pains cajole even accounts. quietly final instructi" }
+, { "c_custkey": 109i32, "c_name": "Customer#000000109", "c_address": "OOOkYBgCMzgMQXUmkocoLb56rfrdWp2NE2c", "c_nationkey": 16i32, "c_phone": "26-992-422-8153", "c_acctbal": -716.1d, "c_mktsegment": "BUILDING", "c_comment": "es. fluffily final dependencies sleep along the blithely even pinto beans. final deposits haggle furiously furiou" }
+, { "c_custkey": 115i32, "c_name": "Customer#000000115", "c_address": "0WFt1IXENmUT2BgbsB0ShVKJZt0HCBCbFl0aHc", "c_nationkey": 8i32, "c_phone": "18-971-699-1843", "c_acctbal": 7508.92d, "c_mktsegment": "HOUSEHOLD", "c_comment": "sits haggle above the carefully ironic theodolite" }
+, { "c_custkey": 118i32, "c_name": "Customer#000000118", "c_address": "OVnFuHygK9wx3xpg8", "c_nationkey": 18i32, "c_phone": "28-639-943-7051", "c_acctbal": 3582.37d, "c_mktsegment": "AUTOMOBILE", "c_comment": "uick packages alongside of the furiously final deposits haggle above the fluffily even foxes. blithely dogged dep" }
+, { "c_custkey": 125i32, "c_name": "Customer#000000125", "c_address": ",wSZXdVR xxIIfm9s8ITyLl3kgjT6UC07GY0Y", "c_nationkey": 19i32, "c_phone": "29-261-996-3120", "c_acctbal": -234.12d, "c_mktsegment": "FURNITURE", "c_comment": "x-ray finally after the packages? regular requests c" }
+, { "c_custkey": 126i32, "c_name": "Customer#000000126", "c_address": "ha4EHmbx3kg DYCsP6DFeUOmavtQlHhcfaqr", "c_nationkey": 22i32, "c_phone": "32-755-914-7592", "c_acctbal": 1001.39d, "c_mktsegment": "HOUSEHOLD", "c_comment": "s about the even instructions boost carefully furiously ironic pearls. ruthless, " }
+, { "c_custkey": 135i32, "c_name": "Customer#000000135", "c_address": "oZK,oC0 fdEpqUML", "c_nationkey": 19i32, "c_phone": "29-399-293-6241", "c_acctbal": 8732.91d, "c_mktsegment": "FURNITURE", "c_comment": " the slyly final accounts. deposits cajole carefully. carefully sly packag" }
+, { "c_custkey": 138i32, "c_name": "Customer#000000138", "c_address": "5uyLAeY7HIGZqtu66Yn08f", "c_nationkey": 5i32, "c_phone": "15-394-860-4589", "c_acctbal": 430.59d, "c_mktsegment": "MACHINERY", "c_comment": "ts doze on the busy ideas. regular" }
+, { "c_custkey": 141i32, "c_name": "Customer#000000141", "c_address": "5IW,WROVnikc3l7DwiUDGQNGsLBGOL6Dc0", "c_nationkey": 1i32, "c_phone": "11-936-295-6204", "c_acctbal": 6706.14d, "c_mktsegment": "FURNITURE", "c_comment": "packages nag furiously. carefully unusual accounts snooze according to the fluffily regular pinto beans. slyly spec" }
+, { "c_custkey": 147i32, "c_name": "Customer#000000147", "c_address": "6VvIwbVdmcsMzuu,C84GtBWPaipGfi7DV", "c_nationkey": 18i32, "c_phone": "28-803-187-4335", "c_acctbal": 8071.4d, "c_mktsegment": "AUTOMOBILE", "c_comment": "ress packages above the blithely regular packages sleep fluffily blithely ironic accounts. " }
+, { "c_custkey": 1i32, "c_name": "Customer#000000001", "c_address": "IVhzIApeRb ot,c,E", "c_nationkey": 15i32, "c_phone": "25-989-741-2988", "c_acctbal": 711.56d, "c_mktsegment": "BUILDING", "c_comment": "to the even, regular platelets. regular, ironic epitaphs nag e" }
+, { "c_custkey": 2i32, "c_name": "Customer#000000002", "c_address": "XSTf4,NCwDVaWNe6tEgvwfmRchLXak", "c_nationkey": 13i32, "c_phone": "23-768-687-3665", "c_acctbal": 121.65d, "c_mktsegment": "AUTOMOBILE", "c_comment": "l accounts. blithely ironic theodolites integrate boldly: caref" }
+, { "c_custkey": 4i32, "c_name": "Customer#000000004", "c_address": "XxVSJsLAGtn", "c_nationkey": 4i32, "c_phone": "14-128-190-5944", "c_acctbal": 2866.83d, "c_mktsegment": "MACHINERY", "c_comment": " requests. final, regular ideas sleep final accou" }
+, { "c_custkey": 13i32, "c_name": "Customer#000000013", "c_address": "nsXQu0oVjD7PM659uC3SRSp", "c_nationkey": 3i32, "c_phone": "13-761-547-5974", "c_acctbal": 3857.34d, "c_mktsegment": "BUILDING", "c_comment": "ounts sleep carefully after the close frays. carefully bold notornis use ironic requests. blithely" }
+, { "c_custkey": 15i32, "c_name": "Customer#000000015", "c_address": "YtWggXoOLdwdo7b0y,BZaGUQMLJMX1Y,EC,6Dn", "c_nationkey": 23i32, "c_phone": "33-687-542-7601", "c_acctbal": 2788.52d, "c_mktsegment": "HOUSEHOLD", "c_comment": " platelets. regular deposits detect asymptotes. blithely unusual packages nag slyly at the fluf" }
+, { "c_custkey": 16i32, "c_name": "Customer#000000016", "c_address": "cYiaeMLZSMAOQ2 d0W,", "c_nationkey": 10i32, "c_phone": "20-781-609-3107", "c_acctbal": 4681.03d, "c_mktsegment": "FURNITURE", "c_comment": "kly silent courts. thinly regular theodolites sleep fluffily after " }
+, { "c_custkey": 19i32, "c_name": "Customer#000000019", "c_address": "uc,3bHIx84H,wdrmLOjVsiqXCq2tr", "c_nationkey": 18i32, "c_phone": "28-396-526-5053", "c_acctbal": 8914.71d, "c_mktsegment": "HOUSEHOLD", "c_comment": " nag. furiously careful packages are slyly at the accounts. furiously regular in" }
+, { "c_custkey": 20i32, "c_name": "Customer#000000020", "c_address": "JrPk8Pqplj4Ne", "c_nationkey": 22i32, "c_phone": "32-957-234-8742", "c_acctbal": 7603.4d, "c_mktsegment": "FURNITURE", "c_comment": "g alongside of the special excuses-- fluffily enticing packages wake " }
+, { "c_custkey": 22i32, "c_name": "Customer#000000022", "c_address": "QI6p41,FNs5k7RZoCCVPUTkUdYpB", "c_nationkey": 3i32, "c_phone": "13-806-545-9701", "c_acctbal": 591.98d, "c_mktsegment": "MACHINERY", "c_comment": "s nod furiously above the furiously ironic ideas. " }
+, { "c_custkey": 24i32, "c_name": "Customer#000000024", "c_address": "HXAFgIAyjxtdqwimt13Y3OZO 4xeLe7U8PqG", "c_nationkey": 13i32, "c_phone": "23-127-851-8031", "c_acctbal": 9255.67d, "c_mktsegment": "MACHINERY", "c_comment": "into beans. fluffily final ideas haggle fluffily" }
+, { "c_custkey": 29i32, "c_name": "Customer#000000029", "c_address": "sJ5adtfyAkCK63df2,vF25zyQMVYE34uh", "c_nationkey": 0i32, "c_phone": "10-773-203-7342", "c_acctbal": 7618.27d, "c_mktsegment": "FURNITURE", "c_comment": "its after the carefully final platelets x-ray against " }
+, { "c_custkey": 31i32, "c_name": "Customer#000000031", "c_address": "LUACbO0viaAv6eXOAebryDB xjVst", "c_nationkey": 23i32, "c_phone": "33-197-837-7094", "c_acctbal": 5236.89d, "c_mktsegment": "HOUSEHOLD", "c_comment": "s use among the blithely pending depo" }
+, { "c_custkey": 35i32, "c_name": "Customer#000000035", "c_address": "TEjWGE4nBzJL2", "c_nationkey": 17i32, "c_phone": "27-566-888-7431", "c_acctbal": 1228.24d, "c_mktsegment": "HOUSEHOLD", "c_comment": "requests. special, express requests nag slyly furiousl" }
+, { "c_custkey": 46i32, "c_name": "Customer#000000046", "c_address": "eaTXWWm10L9", "c_nationkey": 6i32, "c_phone": "16-357-681-2007", "c_acctbal": 5744.59d, "c_mktsegment": "AUTOMOBILE", "c_comment": "ctions. accounts sleep furiously even requests. regular, regular accounts cajole blithely around the final pa" }
+, { "c_custkey": 48i32, "c_name": "Customer#000000048", "c_address": "0UU iPhBupFvemNB", "c_nationkey": 0i32, "c_phone": "10-508-348-5882", "c_acctbal": 3792.5d, "c_mktsegment": "BUILDING", "c_comment": "re fluffily pending foxes. pending, bold platelets sleep slyly. even platelets cajo" }
+, { "c_custkey": 52i32, "c_name": "Customer#000000052", "c_address": "7 QOqGqqSy9jfV51BC71jcHJSD0", "c_nationkey": 11i32, "c_phone": "21-186-284-5998", "c_acctbal": 5630.28d, "c_mktsegment": "HOUSEHOLD", "c_comment": "ic platelets use evenly even accounts. stealthy theodolites cajole furiou" }
+, { "c_custkey": 55i32, "c_name": "Customer#000000055", "c_address": "zIRBR4KNEl HzaiV3a i9n6elrxzDEh8r8pDom", "c_nationkey": 10i32, "c_phone": "20-180-440-8525", "c_acctbal": 4572.11d, "c_mktsegment": "MACHINERY", "c_comment": "ully unusual packages wake bravely bold packages. unusual requests boost deposits! blithely ironic packages ab" }
+, { "c_custkey": 56i32, "c_name": "Customer#000000056", "c_address": "BJYZYJQk4yD5B", "c_nationkey": 10i32, "c_phone": "20-895-685-6920", "c_acctbal": 6530.86d, "c_mktsegment": "FURNITURE", "c_comment": ". notornis wake carefully. carefully fluffy requests are furiously even accounts. slyly expre" }
+, { "c_custkey": 57i32, "c_name": "Customer#000000057", "c_address": "97XYbsuOPRXPWU", "c_nationkey": 21i32, "c_phone": "31-835-306-1650", "c_acctbal": 4151.93d, "c_mktsegment": "AUTOMOBILE", "c_comment": "ove the carefully special packages. even, unusual deposits sleep slyly pend" }
+, { "c_custkey": 59i32, "c_name": "Customer#000000059", "c_address": "zLOCP0wh92OtBihgspOGl4", "c_nationkey": 1i32, "c_phone": "11-355-584-3112", "c_acctbal": 3458.6d, "c_mktsegment": "MACHINERY", "c_comment": "ously final packages haggle blithely after the express deposits. furiou" }
+, { "c_custkey": 62i32, "c_name": "Customer#000000062", "c_address": "upJK2Dnw13,", "c_nationkey": 7i32, "c_phone": "17-361-978-7059", "c_acctbal": 595.61d, "c_mktsegment": "MACHINERY", "c_comment": "kly special dolphins. pinto beans are slyly. quickly regular accounts are furiously a" }
+, { "c_custkey": 63i32, "c_name": "Customer#000000063", "c_address": "IXRSpVWWZraKII", "c_nationkey": 21i32, "c_phone": "31-952-552-9584", "c_acctbal": 9331.13d, "c_mktsegment": "AUTOMOBILE", "c_comment": "ithely even accounts detect slyly above the fluffily ir" }
+, { "c_custkey": 64i32, "c_name": "Customer#000000064", "c_address": "MbCeGY20kaKK3oalJD,OT", "c_nationkey": 3i32, "c_phone": "13-558-731-7204", "c_acctbal": -646.64d, "c_mktsegment": "BUILDING", "c_comment": "structions after the quietly ironic theodolites cajole be" }
+, { "c_custkey": 65i32, "c_name": "Customer#000000065", "c_address": "RGT yzQ0y4l0H90P783LG4U95bXQFDRXbWa1sl,X", "c_nationkey": 23i32, "c_phone": "33-733-623-5267", "c_acctbal": 8795.16d, "c_mktsegment": "AUTOMOBILE", "c_comment": "y final foxes serve carefully. theodolites are carefully. pending i" }
+, { "c_custkey": 68i32, "c_name": "Customer#000000068", "c_address": "o8AibcCRkXvQFh8hF,7o", "c_nationkey": 12i32, "c_phone": "22-918-832-2411", "c_acctbal": 6853.37d, "c_mktsegment": "HOUSEHOLD", "c_comment": " pending pinto beans impress realms. final dependencies " }
+, { "c_custkey": 71i32, "c_name": "Customer#000000071", "c_address": "TlGalgdXWBmMV,6agLyWYDyIz9MKzcY8gl,w6t1B", "c_nationkey": 7i32, "c_phone": "17-710-812-5403", "c_acctbal": -611.19d, "c_mktsegment": "HOUSEHOLD", "c_comment": "g courts across the regular, final pinto beans are blithely pending ac" }
+, { "c_custkey": 73i32, "c_name": "Customer#000000073", "c_address": "8IhIxreu4Ug6tt5mog4", "c_nationkey": 0i32, "c_phone": "10-473-439-3214", "c_acctbal": 4288.5d, "c_mktsegment": "BUILDING", "c_comment": "usual, unusual packages sleep busily along the furiou" }
+, { "c_custkey": 75i32, "c_name": "Customer#000000075", "c_address": "Dh 6jZ,cwxWLKQfRKkiGrzv6pm", "c_nationkey": 18i32, "c_phone": "28-247-803-9025", "c_acctbal": 6684.1d, "c_mktsegment": "AUTOMOBILE", "c_comment": " instructions cajole even, even deposits. finally bold deposits use above the even pains. slyl" }
+, { "c_custkey": 81i32, "c_name": "Customer#000000081", "c_address": "SH6lPA7JiiNC6dNTrR", "c_nationkey": 20i32, "c_phone": "30-165-277-3269", "c_acctbal": 2023.71d, "c_mktsegment": "BUILDING", "c_comment": "r packages. fluffily ironic requests cajole fluffily. ironically regular theodolit" }
+, { "c_custkey": 91i32, "c_name": "Customer#000000091", "c_address": "S8OMYFrpHwoNHaGBeuS6E 6zhHGZiprw1b7 q", "c_nationkey": 8i32, "c_phone": "18-239-400-3677", "c_acctbal": 4643.14d, "c_mktsegment": "AUTOMOBILE", "c_comment": "onic accounts. fluffily silent pinto beans boost blithely according to the fluffily exp" }
+, { "c_custkey": 97i32, "c_name": "Customer#000000097", "c_address": "OApyejbhJG,0Iw3j rd1M", "c_nationkey": 17i32, "c_phone": "27-588-919-5638", "c_acctbal": 2164.48d, "c_mktsegment": "AUTOMOBILE", "c_comment": "haggle slyly. bold, special ideas are blithely above the thinly bold theo" }
+, { "c_custkey": 98i32, "c_name": "Customer#000000098", "c_address": "7yiheXNSpuEAwbswDW", "c_nationkey": 12i32, "c_phone": "22-885-845-6889", "c_acctbal": -551.37d, "c_mktsegment": "BUILDING", "c_comment": "ages. furiously pending accounts are quickly carefully final foxes: busily pe" }
+, { "c_custkey": 100i32, "c_name": "Customer#000000100", "c_address": "fptUABXcmkC5Wx", "c_nationkey": 20i32, "c_phone": "30-749-445-4907", "c_acctbal": 9889.89d, "c_mktsegment": "FURNITURE", "c_comment": "was furiously fluffily quiet deposits. silent, pending requests boost against " }
+, { "c_custkey": 106i32, "c_name": "Customer#000000106", "c_address": "xGCOEAUjUNG", "c_nationkey": 1i32, "c_phone": "11-751-989-4627", "c_acctbal": 3288.42d, "c_mktsegment": "MACHINERY", "c_comment": "lose slyly. ironic accounts along the evenly regular theodolites wake about the special, final gifts. " }
+, { "c_custkey": 114i32, "c_name": "Customer#000000114", "c_address": "xAt 5f5AlFIU", "c_nationkey": 14i32, "c_phone": "24-805-212-7646", "c_acctbal": 1027.46d, "c_mktsegment": "FURNITURE", "c_comment": "der the carefully express theodolites are after the packages. packages are. bli" }
+, { "c_custkey": 119i32, "c_name": "Customer#000000119", "c_address": "M1ETOIecuvH8DtM0Y0nryXfW", "c_nationkey": 7i32, "c_phone": "17-697-919-8406", "c_acctbal": 3930.35d, "c_mktsegment": "FURNITURE", "c_comment": "express ideas. blithely ironic foxes thrash. special acco" }
+, { "c_custkey": 121i32, "c_name": "Customer#000000121", "c_address": "tv nCR2YKupGN73mQudO", "c_nationkey": 17i32, "c_phone": "27-411-990-2959", "c_acctbal": 6428.32d, "c_mktsegment": "BUILDING", "c_comment": "uriously stealthy ideas. carefully final courts use carefully" }
+, { "c_custkey": 122i32, "c_name": "Customer#000000122", "c_address": "yp5slqoNd26lAENZW3a67wSfXA6hTF", "c_nationkey": 3i32, "c_phone": "13-702-694-4520", "c_acctbal": 7865.46d, "c_mktsegment": "HOUSEHOLD", "c_comment": " the special packages hinder blithely around the permanent requests. bold depos" }
+, { "c_custkey": 127i32, "c_name": "Customer#000000127", "c_address": "Xyge4DX2rXKxXyye1Z47LeLVEYMLf4Bfcj", "c_nationkey": 21i32, "c_phone": "31-101-672-2951", "c_acctbal": 9280.71d, "c_mktsegment": "MACHINERY", "c_comment": "ic, unusual theodolites nod silently after the final, ironic instructions: pending r" }
+, { "c_custkey": 129i32, "c_name": "Customer#000000129", "c_address": "q7m7rbMM0BpaCdmxloCgBDRCleXsXkdD8kf", "c_nationkey": 7i32, "c_phone": "17-415-148-7416", "c_acctbal": 9127.27d, "c_mktsegment": "HOUSEHOLD", "c_comment": " unusual deposits boost carefully furiously silent ideas. pending accounts cajole slyly across" }
+, { "c_custkey": 130i32, "c_name": "Customer#000000130", "c_address": "RKPx2OfZy0Vn 8wGWZ7F2EAvmMORl1k8iH", "c_nationkey": 9i32, "c_phone": "19-190-993-9281", "c_acctbal": 5073.58d, "c_mktsegment": "HOUSEHOLD", "c_comment": "ix slowly. express packages along the furiously ironic requests integrate daringly deposits. fur" }
+, { "c_custkey": 131i32, "c_name": "Customer#000000131", "c_address": "jyN6lAjb1FtH10rMC,XzlWyCBrg75", "c_nationkey": 11i32, "c_phone": "21-840-210-3572", "c_acctbal": 8595.53d, "c_mktsegment": "HOUSEHOLD", "c_comment": "jole special packages. furiously final dependencies about the furiously speci" }
+, { "c_custkey": 140i32, "c_name": "Customer#000000140", "c_address": "XRqEPiKgcETII,iOLDZp5jA", "c_nationkey": 4i32, "c_phone": "14-273-885-6505", "c_acctbal": 9963.15d, "c_mktsegment": "MACHINERY", "c_comment": "ies detect slyly ironic accounts. slyly ironic theodolites hag" }
+, { "c_custkey": 143i32, "c_name": "Customer#000000143", "c_address": "681r22uL452zqk 8By7I9o9enQfx0", "c_nationkey": 16i32, "c_phone": "26-314-406-7725", "c_acctbal": 2186.5d, "c_mktsegment": "MACHINERY", "c_comment": "across the blithely unusual requests haggle theodo" }
+, { "c_custkey": 144i32, "c_name": "Customer#000000144", "c_address": "VxYZ3ebhgbltnetaGjNC8qCccjYU05 fePLOno8y", "c_nationkey": 1i32, "c_phone": "11-717-379-4478", "c_acctbal": 6417.31d, "c_mktsegment": "MACHINERY", "c_comment": "ges. slyly regular accounts are slyly. bold, idle reque" }
+, { "c_custkey": 149i32, "c_name": "Customer#000000149", "c_address": "3byTHCp2mNLPigUrrq", "c_nationkey": 19i32, "c_phone": "29-797-439-6760", "c_acctbal": 8959.65d, "c_mktsegment": "AUTOMOBILE", "c_comment": "al instructions haggle against the slyly bold w" }
+, { "c_custkey": 8i32, "c_name": "Customer#000000008", "c_address": "I0B10bB0AymmC, 0PrRYBCP1yGJ8xcBPmWhl5", "c_nationkey": 17i32, "c_phone": "27-147-574-9335", "c_acctbal": 6819.74d, "c_mktsegment": "BUILDING", "c_comment": "among the slyly regular theodolites kindle blithely courts. carefully even theodolites haggle slyly along the ide" }
+, { "c_custkey": 9i32, "c_name": "Customer#000000009", "c_address": "xKiAFTjUsCuxfeleNqefumTrjS", "c_nationkey": 8i32, "c_phone": "18-338-906-3675", "c_acctbal": 8324.07d, "c_mktsegment": "FURNITURE", "c_comment": "r theodolites according to the requests wake thinly excuses: pending requests haggle furiousl" }
+, { "c_custkey": 10i32, "c_name": "Customer#000000010", "c_address": "6LrEaV6KR6PLVcgl2ArL Q3rqzLzcT1 v2", "c_nationkey": 5i32, "c_phone": "15-741-346-9870", "c_acctbal": 2753.54d, "c_mktsegment": "HOUSEHOLD", "c_comment": "es regular deposits haggle. fur" }
+, { "c_custkey": 25i32, "c_name": "Customer#000000025", "c_address": "Hp8GyFQgGHFYSilH5tBfe", "c_nationkey": 12i32, "c_phone": "22-603-468-3533", "c_acctbal": 7133.7d, "c_mktsegment": "FURNITURE", "c_comment": "y. accounts sleep ruthlessly according to the regular theodolites. unusual instructions sleep. ironic, final" }
+, { "c_custkey": 28i32, "c_name": "Customer#000000028", "c_address": "iVyg0daQ,Tha8x2WPWA9m2529m", "c_nationkey": 8i32, "c_phone": "18-774-241-1462", "c_acctbal": 1007.18d, "c_mktsegment": "FURNITURE", "c_comment": " along the regular deposits. furiously final pac" }
+, { "c_custkey": 34i32, "c_name": "Customer#000000034", "c_address": "Q6G9wZ6dnczmtOx509xgE,M2KV", "c_nationkey": 15i32, "c_phone": "25-344-968-5422", "c_acctbal": 8589.7d, "c_mktsegment": "HOUSEHOLD", "c_comment": "nder against the even, pending accounts. even" }
+, { "c_custkey": 37i32, "c_name": "Customer#000000037", "c_address": "7EV4Pwh,3SboctTWt", "c_nationkey": 8i32, "c_phone": "18-385-235-7162", "c_acctbal": -917.75d, "c_mktsegment": "FURNITURE", "c_comment": "ilent packages are carefully among the deposits. furiousl" }
+, { "c_custkey": 40i32, "c_name": "Customer#000000040", "c_address": "gOnGWAyhSV1ofv", "c_nationkey": 3i32, "c_phone": "13-652-915-8939", "c_acctbal": 1335.3d, "c_mktsegment": "BUILDING", "c_comment": "rges impress after the slyly ironic courts. foxes are. blithely " }
+, { "c_custkey": 41i32, "c_name": "Customer#000000041", "c_address": "IM9mzmyoxeBmvNw8lA7G3Ydska2nkZF", "c_nationkey": 10i32, "c_phone": "20-917-711-4011", "c_acctbal": 270.95d, "c_mktsegment": "HOUSEHOLD", "c_comment": "ly regular accounts hang bold, silent packages. unusual foxes haggle slyly above the special, final depo" }
+, { "c_custkey": 43i32, "c_name": "Customer#000000043", "c_address": "ouSbjHk8lh5fKX3zGso3ZSIj9Aa3PoaFd", "c_nationkey": 19i32, "c_phone": "29-316-665-2897", "c_acctbal": 9904.28d, "c_mktsegment": "MACHINERY", "c_comment": "ial requests: carefully pending foxes detect quickly. carefully final courts cajole quickly. carefully" }
+, { "c_custkey": 66i32, "c_name": "Customer#000000066", "c_address": "XbsEqXH1ETbJYYtA1A", "c_nationkey": 22i32, "c_phone": "32-213-373-5094", "c_acctbal": 242.77d, "c_mktsegment": "HOUSEHOLD", "c_comment": "le slyly accounts. carefully silent packages benea" }
+, { "c_custkey": 67i32, "c_name": "Customer#000000067", "c_address": "rfG0cOgtr5W8 xILkwp9fpCS8", "c_nationkey": 9i32, "c_phone": "19-403-114-4356", "c_acctbal": 8166.59d, "c_mktsegment": "MACHINERY", "c_comment": "indle furiously final, even theodo" }
+, { "c_custkey": 69i32, "c_name": "Customer#000000069", "c_address": "Ltx17nO9Wwhtdbe9QZVxNgP98V7xW97uvSH1prEw", "c_nationkey": 9i32, "c_phone": "19-225-978-5670", "c_acctbal": 1709.28d, "c_mktsegment": "HOUSEHOLD", "c_comment": "thely final ideas around the quickly final dependencies affix carefully quickly final theodolites. final accounts c" }
+, { "c_custkey": 76i32, "c_name": "Customer#000000076", "c_address": "m3sbCvjMOHyaOofH,e UkGPtqc4", "c_nationkey": 0i32, "c_phone": "10-349-718-3044", "c_acctbal": 5745.33d, "c_mktsegment": "FURNITURE", "c_comment": "pecial deposits. ironic ideas boost blithely according to the closely ironic theodolites! furiously final deposits n" }
+, { "c_custkey": 79i32, "c_name": "Customer#000000079", "c_address": "n5hH2ftkVRwW8idtD,BmM2", "c_nationkey": 15i32, "c_phone": "25-147-850-4166", "c_acctbal": 5121.28d, "c_mktsegment": "MACHINERY", "c_comment": "es. packages haggle furiously. regular, special requests poach after the quickly express ideas. blithely pending re" }
+, { "c_custkey": 84i32, "c_name": "Customer#000000084", "c_address": "lpXz6Fwr9945rnbtMc8PlueilS1WmASr CB", "c_nationkey": 11i32, "c_phone": "21-546-818-3802", "c_acctbal": 5174.71d, "c_mktsegment": "FURNITURE", "c_comment": "ly blithe foxes. special asymptotes haggle blithely against the furiously regular depo" }
+, { "c_custkey": 85i32, "c_name": "Customer#000000085", "c_address": "siRerlDwiolhYR 8FgksoezycLj", "c_nationkey": 5i32, "c_phone": "15-745-585-8219", "c_acctbal": 3386.64d, "c_mktsegment": "FURNITURE", "c_comment": "ronic ideas use above the slowly pendin" }
+, { "c_custkey": 86i32, "c_name": "Customer#000000086", "c_address": "US6EGGHXbTTXPL9SBsxQJsuvy", "c_nationkey": 0i32, "c_phone": "10-677-951-2353", "c_acctbal": 3306.32d, "c_mktsegment": "HOUSEHOLD", "c_comment": "quests. pending dugouts are carefully aroun" }
+, { "c_custkey": 94i32, "c_name": "Customer#000000094", "c_address": "IfVNIN9KtkScJ9dUjK3Pg5gY1aFeaXewwf", "c_nationkey": 9i32, "c_phone": "19-953-499-8833", "c_acctbal": 5500.11d, "c_mktsegment": "HOUSEHOLD", "c_comment": "latelets across the bold, final requests sleep according to the fluffily bold accounts. unusual deposits amon" }
+, { "c_custkey": 95i32, "c_name": "Customer#000000095", "c_address": "EU0xvmWvOmUUn5J,2z85DQyG7QCJ9Xq7", "c_nationkey": 15i32, "c_phone": "25-923-255-2929", "c_acctbal": 5327.38d, "c_mktsegment": "MACHINERY", "c_comment": "ithely. ruthlessly final requests wake slyly alongside of the furiously silent pinto beans. even the" }
+, { "c_custkey": 96i32, "c_name": "Customer#000000096", "c_address": "vWLOrmXhRR", "c_nationkey": 8i32, "c_phone": "18-422-845-1202", "c_acctbal": 6323.92d, "c_mktsegment": "AUTOMOBILE", "c_comment": "press requests believe furiously. carefully final instructions snooze carefully. " }
+, { "c_custkey": 99i32, "c_name": "Customer#000000099", "c_address": "szsrOiPtCHVS97Lt", "c_nationkey": 15i32, "c_phone": "25-515-237-9232", "c_acctbal": 4088.65d, "c_mktsegment": "HOUSEHOLD", "c_comment": "cajole slyly about the regular theodolites! furiously bold requests nag along the pending, regular packages. somas" }
+, { "c_custkey": 102i32, "c_name": "Customer#000000102", "c_address": "UAtflJ06 fn9zBfKjInkQZlWtqaA", "c_nationkey": 19i32, "c_phone": "29-324-978-8538", "c_acctbal": 8462.17d, "c_mktsegment": "BUILDING", "c_comment": "ously regular dependencies nag among the furiously express dinos. blithely final" }
+, { "c_custkey": 108i32, "c_name": "Customer#000000108", "c_address": "GPoeEvpKo1", "c_nationkey": 5i32, "c_phone": "15-908-619-7526", "c_acctbal": 2259.38d, "c_mktsegment": "BUILDING", "c_comment": "refully ironic deposits sleep. regular, unusual requests wake slyly" }
+, { "c_custkey": 111i32, "c_name": "Customer#000000111", "c_address": "CBSbPyOWRorloj2TBvrK9qp9tHBs", "c_nationkey": 22i32, "c_phone": "32-582-283-7528", "c_acctbal": 6505.26d, "c_mktsegment": "MACHINERY", "c_comment": "ly unusual instructions detect fluffily special deposits-- theodolites nag carefully during the ironic dependencies" }
+, { "c_custkey": 113i32, "c_name": "Customer#000000113", "c_address": "eaOl5UBXIvdY57rglaIzqvfPD,MYfK", "c_nationkey": 12i32, "c_phone": "22-302-930-4756", "c_acctbal": 2912.0d, "c_mktsegment": "BUILDING", "c_comment": "usly regular theodolites boost furiously doggedly pending instructio" }
+, { "c_custkey": 116i32, "c_name": "Customer#000000116", "c_address": "yCuVxIgsZ3,qyK2rloThy3u", "c_nationkey": 16i32, "c_phone": "26-632-309-5792", "c_acctbal": 8403.99d, "c_mktsegment": "BUILDING", "c_comment": "as. quickly final sauternes haggle slyly carefully even packages. brave, ironic pinto beans are above the furious" }
+, { "c_custkey": 124i32, "c_name": "Customer#000000124", "c_address": "aTbyVAW5tCd,v09O", "c_nationkey": 18i32, "c_phone": "28-183-750-7809", "c_acctbal": 1842.49d, "c_mktsegment": "AUTOMOBILE", "c_comment": "le fluffily even dependencies. quietly s" }
+, { "c_custkey": 128i32, "c_name": "Customer#000000128", "c_address": "AmKUMlJf2NRHcKGmKjLS", "c_nationkey": 4i32, "c_phone": "14-280-874-8044", "c_acctbal": -986.96d, "c_mktsegment": "HOUSEHOLD", "c_comment": "ing packages integrate across the slyly unusual dugouts. blithely silent ideas sublate carefully. blithely expr" }
+, { "c_custkey": 132i32, "c_name": "Customer#000000132", "c_address": "QM5YabAsTLp9", "c_nationkey": 4i32, "c_phone": "14-692-150-9717", "c_acctbal": 162.57d, "c_mktsegment": "HOUSEHOLD", "c_comment": "uickly carefully special theodolites. carefully regular requests against the blithely unusual instructions " }
+, { "c_custkey": 133i32, "c_name": "Customer#000000133", "c_address": "IMCuXdpIvdkYO92kgDGuyHgojcUs88p", "c_nationkey": 17i32, "c_phone": "27-408-997-8430", "c_acctbal": 2314.67d, "c_mktsegment": "AUTOMOBILE", "c_comment": "t packages. express pinto beans are blithely along the unusual, even theodolites. silent packages use fu" }
+, { "c_custkey": 134i32, "c_name": "Customer#000000134", "c_address": "sUiZ78QCkTQPICKpA9OBzkUp2FM", "c_nationkey": 11i32, "c_phone": "21-200-159-5932", "c_acctbal": 4608.9d, "c_mktsegment": "BUILDING", "c_comment": "yly fluffy foxes boost final ideas. b" }
+, { "c_custkey": 136i32, "c_name": "Customer#000000136", "c_address": "QoLsJ0v5C1IQbh,DS1", "c_nationkey": 7i32, "c_phone": "17-501-210-4726", "c_acctbal": -842.39d, "c_mktsegment": "FURNITURE", "c_comment": "ackages sleep ironic, final courts. even requests above the blithely bold requests g" }
+, { "c_custkey": 139i32, "c_name": "Customer#000000139", "c_address": "3ElvBwudHKL02732YexGVFVt ", "c_nationkey": 9i32, "c_phone": "19-140-352-1403", "c_acctbal": 7897.78d, "c_mktsegment": "MACHINERY", "c_comment": "nstructions. quickly ironic ideas are carefully. bold, " }
+, { "c_custkey": 150i32, "c_name": "Customer#000000150", "c_address": "zeoGShTjCwGPplOWFkLURrh41O0AZ8dwNEEN4 ", "c_nationkey": 18i32, "c_phone": "28-328-564-7630", "c_acctbal": 3849.48d, "c_mktsegment": "MACHINERY", "c_comment": "ole blithely among the furiously pending packages. furiously bold ideas wake fluffily ironic idea" }
+, { "c_custkey": 3i32, "c_name": "Customer#000000003", "c_address": "MG9kdTD2WBHm", "c_nationkey": 1i32, "c_phone": "11-719-748-3364", "c_acctbal": 7498.12d, "c_mktsegment": "AUTOMOBILE", "c_comment": " deposits eat slyly ironic, even instructions. express foxes detect slyly. blithely even accounts abov" }
+, { "c_custkey": 5i32, "c_name": "Customer#000000005", "c_address": "KvpyuHCplrB84WgAiGV6sYpZq7Tj", "c_nationkey": 3i32, "c_phone": "13-750-942-6364", "c_acctbal": 794.47d, "c_mktsegment": "HOUSEHOLD", "c_comment": "n accounts will have to unwind. foxes cajole accor" }
+, { "c_custkey": 7i32, "c_name": "Customer#000000007", "c_address": "TcGe5gaZNgVePxU5kRrvXBfkasDTea", "c_nationkey": 18i32, "c_phone": "28-190-982-9759", "c_acctbal": 9561.95d, "c_mktsegment": "AUTOMOBILE", "c_comment": "ainst the ironic, express theodolites. express, even pinto beans among the exp" }
+, { "c_custkey": 17i32, "c_name": "Customer#000000017", "c_address": "izrh 6jdqtp2eqdtbkswDD8SG4SzXruMfIXyR7", "c_nationkey": 2i32, "c_phone": "12-970-682-3487", "c_acctbal": 6.34d, "c_mktsegment": "AUTOMOBILE", "c_comment": "packages wake! blithely even pint" }
+, { "c_custkey": 18i32, "c_name": "Customer#000000018", "c_address": "3txGO AiuFux3zT0Z9NYaFRnZt", "c_nationkey": 6i32, "c_phone": "16-155-215-1315", "c_acctbal": 5494.43d, "c_mktsegment": "BUILDING", "c_comment": "s sleep. carefully even instructions nag furiously alongside of t" }
+, { "c_custkey": 27i32, "c_name": "Customer#000000027", "c_address": "IS8GIyxpBrLpMT0u7", "c_nationkey": 3i32, "c_phone": "13-137-193-2709", "c_acctbal": 5679.84d, "c_mktsegment": "BUILDING", "c_comment": " about the carefully ironic pinto beans. accoun" }
+, { "c_custkey": 32i32, "c_name": "Customer#000000032", "c_address": "jD2xZzi UmId,DCtNBLXKj9q0Tlp2iQ6ZcO3J", "c_nationkey": 15i32, "c_phone": "25-430-914-2194", "c_acctbal": 3471.53d, "c_mktsegment": "BUILDING", "c_comment": "cial ideas. final, furious requests across the e" }
+, { "c_custkey": 36i32, "c_name": "Customer#000000036", "c_address": "3TvCzjuPzpJ0,DdJ8kW5U", "c_nationkey": 21i32, "c_phone": "31-704-669-5769", "c_acctbal": 4987.27d, "c_mktsegment": "BUILDING", "c_comment": "haggle. enticing, quiet platelets grow quickly bold sheaves. carefully regular acc" }
+, { "c_custkey": 39i32, "c_name": "Customer#000000039", "c_address": "nnbRg,Pvy33dfkorYE FdeZ60", "c_nationkey": 2i32, "c_phone": "12-387-467-6509", "c_acctbal": 6264.31d, "c_mktsegment": "AUTOMOBILE", "c_comment": "tions. slyly silent excuses slee" }
+, { "c_custkey": 42i32, "c_name": "Customer#000000042", "c_address": "ziSrvyyBke", "c_nationkey": 5i32, "c_phone": "15-416-330-4175", "c_acctbal": 8727.01d, "c_mktsegment": "BUILDING", "c_comment": "ssly according to the pinto beans: carefully special requests across the even, pending accounts wake special" }
+, { "c_custkey": 44i32, "c_name": "Customer#000000044", "c_address": "Oi,dOSPwDu4jo4x,,P85E0dmhZGvNtBwi", "c_nationkey": 16i32, "c_phone": "26-190-260-5375", "c_acctbal": 7315.94d, "c_mktsegment": "AUTOMOBILE", "c_comment": "r requests around the unusual, bold a" }
+, { "c_custkey": 50i32, "c_name": "Customer#000000050", "c_address": "9SzDYlkzxByyJ1QeTI o", "c_nationkey": 6i32, "c_phone": "16-658-112-3221", "c_acctbal": 4266.13d, "c_mktsegment": "MACHINERY", "c_comment": "ts. furiously ironic accounts cajole furiously slyly ironic dinos." }
+, { "c_custkey": 53i32, "c_name": "Customer#000000053", "c_address": "HnaxHzTfFTZs8MuCpJyTbZ47Cm4wFOOgib", "c_nationkey": 15i32, "c_phone": "25-168-852-5363", "c_acctbal": 4113.64d, "c_mktsegment": "HOUSEHOLD", "c_comment": "ar accounts are. even foxes are blithely. fluffily pending deposits boost" }
+, { "c_custkey": 54i32, "c_name": "Customer#000000054", "c_address": ",k4vf 5vECGWFy,hosTE,", "c_nationkey": 4i32, "c_phone": "14-776-370-4745", "c_acctbal": 868.9d, "c_mktsegment": "AUTOMOBILE", "c_comment": "sual, silent accounts. furiously express accounts cajole special deposits. final, final accounts use furi" }
+, { "c_custkey": 61i32, "c_name": "Customer#000000061", "c_address": "9kndve4EAJxhg3veF BfXr7AqOsT39o gtqjaYE", "c_nationkey": 17i32, "c_phone": "27-626-559-8599", "c_acctbal": 1536.24d, "c_mktsegment": "FURNITURE", "c_comment": "egular packages shall have to impress along the " }
+, { "c_custkey": 74i32, "c_name": "Customer#000000074", "c_address": "IkJHCA3ZThF7qL7VKcrU nRLl,kylf ", "c_nationkey": 4i32, "c_phone": "14-199-862-7209", "c_acctbal": 2764.43d, "c_mktsegment": "MACHINERY", "c_comment": "onic accounts. blithely slow packages would haggle carefully. qui" }
+, { "c_custkey": 78i32, "c_name": "Customer#000000078", "c_address": "HBOta,ZNqpg3U2cSL0kbrftkPwzX", "c_nationkey": 9i32, "c_phone": "19-960-700-9191", "c_acctbal": 7136.97d, "c_mktsegment": "FURNITURE", "c_comment": "ests. blithely bold pinto beans h" }
+, { "c_custkey": 80i32, "c_name": "Customer#000000080", "c_address": "K,vtXp8qYB ", "c_nationkey": 0i32, "c_phone": "10-267-172-7101", "c_acctbal": 7383.53d, "c_mktsegment": "FURNITURE", "c_comment": "tect among the dependencies. bold accounts engage closely even pinto beans. ca" }
+, { "c_custkey": 82i32, "c_name": "Customer#000000082", "c_address": "zhG3EZbap4c992Gj3bK,3Ne,Xn", "c_nationkey": 18i32, "c_phone": "28-159-442-5305", "c_acctbal": 9468.34d, "c_mktsegment": "AUTOMOBILE", "c_comment": "s wake. bravely regular accounts are furiously. regula" }
+, { "c_custkey": 83i32, "c_name": "Customer#000000083", "c_address": "HnhTNB5xpnSF20JBH4Ycs6psVnkC3RDf", "c_nationkey": 22i32, "c_phone": "32-817-154-4122", "c_acctbal": 6463.51d, "c_mktsegment": "BUILDING", "c_comment": "ccording to the quickly bold warhorses. final, regular foxes integrate carefully. bold packages nag blithely ev" }
+, { "c_custkey": 87i32, "c_name": "Customer#000000087", "c_address": "hgGhHVSWQl 6jZ6Ev", "c_nationkey": 23i32, "c_phone": "33-869-884-7053", "c_acctbal": 6327.54d, "c_mktsegment": "FURNITURE", "c_comment": "hely ironic requests integrate according to the ironic accounts. slyly regular pla" }
+, { "c_custkey": 90i32, "c_name": "Customer#000000090", "c_address": "QxCzH7VxxYUWwfL7", "c_nationkey": 16i32, "c_phone": "26-603-491-1238", "c_acctbal": 7354.23d, "c_mktsegment": "BUILDING", "c_comment": "sly across the furiously even " }
+, { "c_custkey": 101i32, "c_name": "Customer#000000101", "c_address": "sMmL2rNeHDltovSm Y", "c_nationkey": 2i32, "c_phone": "12-514-298-3699", "c_acctbal": 7470.96d, "c_mktsegment": "MACHINERY", "c_comment": " sleep. pending packages detect slyly ironic pack" }
+, { "c_custkey": 104i32, "c_name": "Customer#000000104", "c_address": "9mcCK L7rt0SwiYtrbO88DiZS7U d7M", "c_nationkey": 10i32, "c_phone": "20-966-284-8065", "c_acctbal": -588.38d, "c_mktsegment": "FURNITURE", "c_comment": "rate carefully slyly special pla" }
+, { "c_custkey": 107i32, "c_name": "Customer#000000107", "c_address": "Zwg64UZ,q7GRqo3zm7P1tZIRshBDz", "c_nationkey": 15i32, "c_phone": "25-336-529-9919", "c_acctbal": 2514.15d, "c_mktsegment": "AUTOMOBILE", "c_comment": "counts cajole slyly. regular requests wake. furiously regular deposits about the blithely final fo" }
+, { "c_custkey": 110i32, "c_name": "Customer#000000110", "c_address": "mymPfgphaYXNYtk", "c_nationkey": 10i32, "c_phone": "20-893-536-2069", "c_acctbal": 7462.99d, "c_mktsegment": "AUTOMOBILE", "c_comment": "nto beans cajole around the even, final deposits. quickly bold packages according to the furiously regular dept" }
+, { "c_custkey": 112i32, "c_name": "Customer#000000112", "c_address": "RcfgG3bO7QeCnfjqJT1", "c_nationkey": 19i32, "c_phone": "29-233-262-8382", "c_acctbal": 2953.35d, "c_mktsegment": "FURNITURE", "c_comment": "rmanently unusual multipliers. blithely ruthless deposits are furiously along the" }
+, { "c_custkey": 117i32, "c_name": "Customer#000000117", "c_address": "uNhM,PzsRA3S,5Y Ge5Npuhi", "c_nationkey": 24i32, "c_phone": "34-403-631-3505", "c_acctbal": 3950.83d, "c_mktsegment": "FURNITURE", "c_comment": "affix. instructions are furiously sl" }
+, { "c_custkey": 120i32, "c_name": "Customer#000000120", "c_address": "zBNna00AEInqyO1", "c_nationkey": 12i32, "c_phone": "22-291-534-1571", "c_acctbal": 363.75d, "c_mktsegment": "MACHINERY", "c_comment": " quickly. slyly ironic requests cajole blithely furiously final dependen" }
+, { "c_custkey": 123i32, "c_name": "Customer#000000123", "c_address": "YsOnaaER8MkvK5cpf4VSlq", "c_nationkey": 5i32, "c_phone": "15-817-151-1168", "c_acctbal": 5897.83d, "c_mktsegment": "BUILDING", "c_comment": "ependencies. regular, ironic requests are fluffily regu" }
+, { "c_custkey": 137i32, "c_name": "Customer#000000137", "c_address": "cdW91p92rlAEHgJafqYyxf1Q", "c_nationkey": 16i32, "c_phone": "26-777-409-5654", "c_acctbal": 7838.3d, "c_mktsegment": "HOUSEHOLD", "c_comment": "carefully regular theodolites use. silent dolphins cajo" }
+, { "c_custkey": 142i32, "c_name": "Customer#000000142", "c_address": "AnJ5lxtLjioClr2khl9pb8NLxG2,", "c_nationkey": 9i32, "c_phone": "19-407-425-2584", "c_acctbal": 2209.81d, "c_mktsegment": "AUTOMOBILE", "c_comment": ". even, express theodolites upo" }
+, { "c_custkey": 145i32, "c_name": "Customer#000000145", "c_address": "kQjHmt2kcec cy3hfMh969u", "c_nationkey": 13i32, "c_phone": "23-562-444-8454", "c_acctbal": 9748.93d, "c_mktsegment": "HOUSEHOLD", "c_comment": "ests? express, express instructions use. blithely fina" }
+, { "c_custkey": 146i32, "c_name": "Customer#000000146", "c_address": "GdxkdXG9u7iyI1,,y5tq4ZyrcEy", "c_nationkey": 3i32, "c_phone": "13-835-723-3223", "c_acctbal": 3328.68d, "c_mktsegment": "FURNITURE", "c_comment": "ffily regular dinos are slyly unusual requests. slyly specia" }
+, { "c_custkey": 148i32, "c_name": "Customer#000000148", "c_address": "BhSPlEWGvIJyT9swk vCWE", "c_nationkey": 11i32, "c_phone": "21-562-498-6636", "c_acctbal": 2135.6d, "c_mktsegment": "HOUSEHOLD", "c_comment": "ing to the carefully ironic requests. carefully regular dependencies about the theodolites wake furious" }
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/7de6f4eb/asterix-app/src/test/resources/runtimets/testsuite.xml
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/testsuite.xml b/asterix-app/src/test/resources/runtimets/testsuite.xml
index a954f7e..694077c 100644
--- a/asterix-app/src/test/resources/runtimets/testsuite.xml
+++ b/asterix-app/src/test/resources/runtimets/testsuite.xml
@@ -1729,6 +1729,11 @@
<output-dir compare="Text">scan-insert-rtree-secondary-index-open</output-dir>
</compilation-unit>
</test-case>
+ <test-case FilePath="dml">
+ <compilation-unit name="delete-multi-statement">
+ <output-dir compare="Text">delete-multi-statement</output-dir>
+ </compilation-unit>
+ </test-case>
</test-group>
<test-group name="employee">
<test-case FilePath="employee">