[2/5] MRQL-4: Create a testbed for MRQL queries

[fe...@apache.org]

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/data/orders.tbl
----------------------------------------------------------------------
diff --git a/tests/data/orders.tbl b/tests/data/orders.tbl
new file mode 100644
index 0000000..b42d87a
--- /dev/null
+++ b/tests/data/orders.tbl
@@ -0,0 +1,500 @@
+1|37|O|131251.81|1996-01-02|5-LOW|Clerk#000000951|0|nstructions sleep furiously among |
+2|79|O|40183.29|1996-12-01|1-URGENT|Clerk#000000880|0| foxes. pending accounts at the pending, silent asymptot|
+3|124|F|160882.76|1993-10-14|5-LOW|Clerk#000000955|0|sly final accounts boost. carefully regular ideas cajole carefully. depos|
+4|137|O|31084.79|1995-10-11|5-LOW|Clerk#000000124|0|sits. slyly regular warthogs cajole. regular, regular theodolites acro|
+5|46|F|86615.25|1994-07-30|5-LOW|Clerk#000000925|0|quickly. bold deposits sleep slyly. packages use slyly|
+6|56|F|36468.55|1992-02-21|4-NOT SPECIFIED|Clerk#000000058|0|ggle. special, final requests are against the furiously specia|
+7|40|O|171488.73|1996-01-10|2-HIGH|Clerk#000000470|0|ly special requests |
+32|131|O|116923.00|1995-07-16|2-HIGH|Clerk#000000616|0|ise blithely bold, regular requests. quickly unusual dep|
+33|67|F|99798.76|1993-10-27|3-MEDIUM|Clerk#000000409|0|uriously. furiously final request|
+34|62|O|41670.02|1998-07-21|3-MEDIUM|Clerk#000000223|0|ly final packages. fluffily final deposits wake blithely ideas. spe|
+35|128|O|148789.52|1995-10-23|4-NOT SPECIFIED|Clerk#000000259|0|zzle. carefully enticing deposits nag furio|
+36|116|O|38988.98|1995-11-03|1-URGENT|Clerk#000000358|0| quick packages are blithely. slyly silent accounts wake qu|
+37|88|F|113701.89|1992-06-03|3-MEDIUM|Clerk#000000456|0|kly regular pinto beans. carefully unusual waters cajole never|
+38|125|O|46366.56|1996-08-21|4-NOT SPECIFIED|Clerk#000000604|0|haggle blithely. furiously express ideas haggle blithely furiously regular re|
+39|82|O|219707.84|1996-09-20|3-MEDIUM|Clerk#000000659|0|ole express, ironic requests: ir|
+64|34|F|20065.73|1994-07-16|3-MEDIUM|Clerk#000000661|0|wake fluffily. sometimes ironic pinto beans about the dolphin|
+65|17|P|65883.92|1995-03-18|1-URGENT|Clerk#000000632|0|ular requests are blithely pending orbits-- even requests against the deposit|
+66|130|F|79258.24|1994-01-20|5-LOW|Clerk#000000743|0|y pending requests integrate|
+67|58|O|116227.05|1996-12-19|4-NOT SPECIFIED|Clerk#000000547|0|symptotes haggle slyly around the furiously iron|
+68|29|O|215135.72|1998-04-18|3-MEDIUM|Clerk#000000440|0| pinto beans sleep carefully. blithely ironic deposits haggle furiously acro|
+69|85|F|162176.23|1994-06-04|4-NOT SPECIFIED|Clerk#000000330|0| depths atop the slyly thin deposits detect among the furiously silent accou|
+70|65|F|84651.80|1993-12-18|5-LOW|Clerk#000000322|0| carefully ironic request|
+71|4|O|178821.73|1998-01-24|4-NOT SPECIFIED|Clerk#000000271|0| express deposits along the blithely regul|
+96|109|F|55090.67|1994-04-17|2-HIGH|Clerk#000000395|0|oost furiously. pinto|
+97|22|F|68908.31|1993-01-29|3-MEDIUM|Clerk#000000547|0|hang blithely along the regular accounts. furiously even ideas after the|
+98|106|F|51004.44|1994-09-25|1-URGENT|Clerk#000000448|0|c asymptotes. quickly regular packages should have to nag re|
+99|89|F|92326.79|1994-03-13|4-NOT SPECIFIED|Clerk#000000973|0|e carefully ironic packages. pending|
+100|148|O|141311.01|1998-02-28|4-NOT SPECIFIED|Clerk#000000577|0|heodolites detect slyly alongside of the ent|
+101|28|O|95591.40|1996-03-17|3-MEDIUM|Clerk#000000419|0|ding accounts above the slyly final asymptote|
+102|1|O|113954.89|1997-05-09|2-HIGH|Clerk#000000596|0| slyly according to the asymptotes. carefully final packages integrate furious|
+103|31|O|95563.95|1996-06-20|4-NOT SPECIFIED|Clerk#000000090|0|ges. carefully unusual instructions haggle quickly regular f|
+128|74|F|36333.34|1992-06-15|1-URGENT|Clerk#000000385|0|ns integrate fluffily. ironic asymptotes after the regular excuses nag around |
+129|73|F|188124.55|1992-11-19|5-LOW|Clerk#000000859|0|ing tithes. carefully pending deposits boost about the silently express |
+130|37|F|115717.37|1992-05-08|2-HIGH|Clerk#000000036|0|le slyly unusual, regular packages? express deposits det|
+131|94|F|96596.81|1994-06-08|3-MEDIUM|Clerk#000000625|0|after the fluffily special foxes integrate s|
+132|28|F|118802.62|1993-06-11|3-MEDIUM|Clerk#000000488|0|sits are daringly accounts. carefully regular foxes sleep slyly about the|
+133|44|O|80437.72|1997-11-29|1-URGENT|Clerk#000000738|0|usly final asymptotes |
+134|7|F|154260.84|1992-05-01|4-NOT SPECIFIED|Clerk#000000711|0|lar theodolites boos|
+135|61|O|174569.88|1995-10-21|4-NOT SPECIFIED|Clerk#000000804|0|l platelets use according t|
+160|83|O|86076.86|1996-12-19|4-NOT SPECIFIED|Clerk#000000342|0|thely special sauternes wake slyly of t|
+161|17|F|19056.99|1994-08-31|2-HIGH|Clerk#000000322|0|carefully! special instructions sin|
+162|16|O|2158.13|1995-05-08|3-MEDIUM|Clerk#000000378|0|nts hinder fluffily ironic instructions. express, express excuses |
+163|88|O|125170.86|1997-09-05|3-MEDIUM|Clerk#000000379|0|y final packages. final foxes since the quickly even|
+164|1|F|202660.52|1992-10-21|5-LOW|Clerk#000000209|0|cajole ironic courts. slyly final ideas are slyly. blithely final Tiresias sub|
+165|28|F|141824.23|1993-01-30|4-NOT SPECIFIED|Clerk#000000292|0|across the blithely regular accounts. bold|
+166|109|O|93335.60|1995-09-12|2-HIGH|Clerk#000000440|0|lets. ironic, bold asymptotes kindle|
+167|121|F|52982.23|1993-01-04|4-NOT SPECIFIED|Clerk#000000731|0|s nag furiously bold excuses. fluffily iron|
+192|83|O|133002.55|1997-11-25|5-LOW|Clerk#000000483|0|y unusual platelets among the final instructions integrate rut|
+193|80|F|48053.18|1993-08-08|1-URGENT|Clerk#000000025|0|the furiously final pin|
+194|62|F|114097.63|1992-04-05|3-MEDIUM|Clerk#000000352|0|egular requests haggle slyly regular, regular pinto beans. asymptote|
+195|136|F|120053.52|1993-12-28|3-MEDIUM|Clerk#000000216|0|old forges are furiously sheaves. slyly fi|
+196|65|F|33248.04|1993-03-17|2-HIGH|Clerk#000000988|0|beans boost at the foxes. silent foxes|
+197|34|P|100290.07|1995-04-07|2-HIGH|Clerk#000000969|0|solve quickly about the even braids. carefully express deposits affix care|
+198|112|O|125792.83|1998-01-02|4-NOT SPECIFIED|Clerk#000000331|0|its. carefully ironic requests sleep. furiously express fox|
+199|53|O|80592.44|1996-03-07|2-HIGH|Clerk#000000489|0|g theodolites. special packag|
+224|4|F|155680.60|1994-06-18|4-NOT SPECIFIED|Clerk#000000642|0|r the quickly thin courts. carefully|
+225|34|P|165890.47|1995-05-25|1-URGENT|Clerk#000000177|0|s. blithely ironic accounts wake quickly fluffily special acc|
+226|128|F|180119.22|1993-03-10|2-HIGH|Clerk#000000756|0|s are carefully at the blithely ironic acc|
+227|10|O|46076.46|1995-11-10|5-LOW|Clerk#000000919|0| express instructions. slyly regul|
+228|46|F|2638.98|1993-02-25|1-URGENT|Clerk#000000562|0|es was slyly among the regular foxes. blithely regular dependenci|
+229|112|F|142290.77|1993-12-29|1-URGENT|Clerk#000000628|0|he fluffily even instructions. furiously i|
+230|103|F|107231.60|1993-10-27|1-URGENT|Clerk#000000520|0|odolites. carefully quick requ|
+231|91|F|141554.06|1994-09-29|2-HIGH|Clerk#000000446|0| packages haggle slyly after the carefully ironic instruct|
+256|125|F|106315.25|1993-10-19|4-NOT SPECIFIED|Clerk#000000834|0|he fluffily final ideas might are final accounts. carefully f|
+257|124|O|7102.74|1998-03-28|3-MEDIUM|Clerk#000000680|0|ts against the sly warhorses cajole slyly accounts|
+258|43|F|186669.10|1993-12-29|1-URGENT|Clerk#000000167|0|dencies. blithely quick packages cajole. ruthlessly final accounts|
+259|44|F|75661.70|1993-09-29|4-NOT SPECIFIED|Clerk#000000601|0|ages doubt blithely against the final foxes. carefully express deposits dazzle|
+260|106|O|179292.14|1996-12-10|3-MEDIUM|Clerk#000000960|0|lently regular pinto beans sleep after the slyly e|
+261|47|F|201003.12|1993-06-29|3-MEDIUM|Clerk#000000310|0|ully fluffily brave instructions. furiousl|
+262|31|O|108443.84|1995-11-25|4-NOT SPECIFIED|Clerk#000000551|0|l packages. blithely final pinto beans use carefu|
+263|118|F|79782.56|1994-05-17|2-HIGH|Clerk#000000088|0| pending instructions. blithely un|
+288|8|O|163794.53|1997-02-21|1-URGENT|Clerk#000000109|0|uriously final requests. even, final ideas det|
+289|104|O|131092.67|1997-02-10|3-MEDIUM|Clerk#000000103|0|sily. slyly special excuse|
+290|118|F|62814.89|1994-01-01|4-NOT SPECIFIED|Clerk#000000735|0|efully dogged deposits. furiou|
+291|142|F|66817.05|1994-03-13|1-URGENT|Clerk#000000923|0|dolites. carefully regular pinto beans cajol|
+292|23|F|30783.05|1992-01-13|2-HIGH|Clerk#000000193|0|g pinto beans will have to sleep f|
+293|31|F|37248.78|1992-10-02|2-HIGH|Clerk#000000629|0|re bold, ironic deposits. platelets c|
+294|52|F|30059.47|1993-07-16|3-MEDIUM|Clerk#000000499|0|kly according to the frays. final dolphins affix quickly |
+295|19|F|89345.99|1994-09-29|2-HIGH|Clerk#000000155|0| unusual pinto beans play. regular ideas haggle|
+320|1|O|39835.54|1997-11-21|2-HIGH|Clerk#000000573|0|ar foxes nag blithely|
+321|124|F|62251.15|1993-03-21|3-MEDIUM|Clerk#000000289|0|equests run. blithely final dependencies after the deposits wake caref|
+322|134|F|127068.89|1992-03-19|1-URGENT|Clerk#000000158|0|fully across the slyly bold packages. packages against the quickly regular i|
+323|40|F|79683.42|1994-03-26|1-URGENT|Clerk#000000959|0|arefully pending foxes sleep blithely. slyly express accoun|
+324|106|F|26868.85|1992-03-20|1-URGENT|Clerk#000000352|0| about the ironic, regular deposits run blithely against the excuses|
+325|41|F|71543.41|1993-10-17|5-LOW|Clerk#000000844|0|ly sometimes pending pa|
+326|76|O|229165.17|1995-06-04|2-HIGH|Clerk#000000466|0| requests. furiously ironic asymptotes mold carefully alongside of the blit|
+327|145|P|24468.16|1995-04-17|5-LOW|Clerk#000000992|0|ng the slyly final courts. slyly even escapades eat |
+352|107|F|16003.86|1994-03-08|2-HIGH|Clerk#000000932|0|ke slyly bold pinto beans. blithely regular accounts against the spe|
+353|2|F|179984.42|1993-12-31|5-LOW|Clerk#000000449|0| quiet ideas sleep. even instructions cajole slyly. silently spe|
+354|139|O|157062.70|1996-03-14|2-HIGH|Clerk#000000511|0|ly regular ideas wake across the slyly silent ideas. final deposits eat b|
+355|71|F|69447.25|1994-06-14|5-LOW|Clerk#000000532|0|s. sometimes regular requests cajole. regular, pending accounts a|
+356|148|F|162786.67|1994-06-30|4-NOT SPECIFIED|Clerk#000000944|0|as wake along the bold accounts. even, |
+357|61|O|98723.11|1996-10-09|2-HIGH|Clerk#000000301|0|e blithely about the express, final accounts. quickl|
+358|4|F|226806.66|1993-09-20|2-HIGH|Clerk#000000392|0|l, silent instructions are slyly. silently even de|
+359|79|F|142891.22|1994-12-19|3-MEDIUM|Clerk#000000934|0|n dolphins. special courts above the carefully ironic requests use|
+384|115|F|122785.82|1992-03-03|5-LOW|Clerk#000000206|0|, even accounts use furiously packages. slyly ironic pla|
+385|34|O|50724.06|1996-03-22|5-LOW|Clerk#000000600|0|hless accounts unwind bold pain|
+386|61|F|90380.40|1995-01-25|2-HIGH|Clerk#000000648|0| haggle quickly. stealthily bold asymptotes haggle among the furiously even re|
+387|4|O|130647.18|1997-01-26|4-NOT SPECIFIED|Clerk#000000768|0| are carefully among the quickly even deposits. furiously silent req|
+388|46|F|120533.46|1992-12-16|4-NOT SPECIFIED|Clerk#000000356|0|ar foxes above the furiously ironic deposits nag slyly final reque|
+389|127|F|1984.14|1994-02-17|2-HIGH|Clerk#000000062|0|ing to the regular asymptotes. final, pending foxes about the blithely sil|
+390|103|O|168562.27|1998-04-07|5-LOW|Clerk#000000404|0|xpress asymptotes use among the regular, final pinto b|
+391|112|F|13282.23|1994-11-17|2-HIGH|Clerk#000000256|0|orges thrash fluffil|
+416|41|F|71362.50|1993-09-27|5-LOW|Clerk#000000294|0| the accounts. fluffily bold depo|
+417|55|F|91982.29|1994-02-06|3-MEDIUM|Clerk#000000468|0|ironic, even packages. thinly unusual accounts sleep along the slyly unusual |
+418|95|P|33124.96|1995-04-13|4-NOT SPECIFIED|Clerk#000000643|0|. furiously ironic instruc|
+419|118|O|111597.96|1996-10-01|3-MEDIUM|Clerk#000000376|0|osits. blithely pending theodolites boost carefully|
+420|91|O|198039.23|1995-10-31|4-NOT SPECIFIED|Clerk#000000756|0|leep carefully final excuses. fluffily pending requests unwind carefully above|
+421|40|F|1084.38|1992-02-22|5-LOW|Clerk#000000405|0|egular, even packages according to the final, un|
+422|74|O|106045.89|1997-05-31|4-NOT SPECIFIED|Clerk#000000049|0|aggle carefully across the accounts. regular accounts eat fluffi|
+423|104|O|26981.31|1996-06-01|1-URGENT|Clerk#000000674|0|quests. deposits cajole quickly. furiously bold accounts haggle q|
+448|149|O|114978.03|1995-08-21|3-MEDIUM|Clerk#000000597|0| regular, express foxes use blithely. quic|
+449|97|O|41605.63|1995-07-20|2-HIGH|Clerk#000000841|0|. furiously regular theodolites affix blithely |
+450|49|P|153386.61|1995-03-05|4-NOT SPECIFIED|Clerk#000000293|0|d theodolites. boldly bold foxes since the pack|
+451|100|O|104664.40|1998-05-25|5-LOW|Clerk#000000048|0|nic pinto beans. theodolites poach carefully; |
+452|61|O|2007.48|1997-10-14|1-URGENT|Clerk#000000498|0|t, unusual instructions above the blithely bold pint|
+453|46|O|216826.73|1997-05-26|5-LOW|Clerk#000000504|0|ss foxes. furiously regular ideas sleep according to t|
+454|49|O|23198.24|1995-12-27|5-LOW|Clerk#000000890|0|dolites sleep carefully blithely regular deposits. quickly regul|
+455|13|O|138010.76|1996-12-04|1-URGENT|Clerk#000000796|0| about the final platelets. dependen|
+480|73|F|20530.97|1993-05-08|5-LOW|Clerk#000000004|0|ealthy pinto beans. fluffily regular requests along the special sheaves wake |
+481|31|F|117827.18|1992-10-08|2-HIGH|Clerk#000000230|0|ly final ideas. packages haggle fluffily|
+482|127|O|136634.34|1996-03-26|1-URGENT|Clerk#000000295|0|ts. deposits wake: final acco|
+483|35|O|39793.05|1995-07-11|2-HIGH|Clerk#000000025|0|cross the carefully final e|
+484|55|O|219920.62|1997-01-03|3-MEDIUM|Clerk#000000545|0|grouches use. furiously bold accounts maintain. bold, regular deposits|
+485|101|O|110432.76|1997-03-26|2-HIGH|Clerk#000000105|0| regular ideas nag thinly furiously s|
+486|52|O|185968.15|1996-03-11|4-NOT SPECIFIED|Clerk#000000803|0|riously dolphins. fluffily ironic requ|
+487|109|F|48502.79|1992-08-18|1-URGENT|Clerk#000000086|0|ithely unusual courts eat accordi|
+512|64|P|124661.48|1995-05-20|5-LOW|Clerk#000000814|0|ding requests. carefully express theodolites was quickly. furious|
+513|61|O|63703.92|1995-05-01|2-HIGH|Clerk#000000522|0|regular packages. pinto beans cajole carefully against the even|
+514|76|O|104585.77|1996-04-04|2-HIGH|Clerk#000000094|0| cajole furiously. slyly final excuses cajole. slyly special instructions |
+515|142|F|153720.22|1993-08-29|4-NOT SPECIFIED|Clerk#000000700|0|eposits are furiously furiously silent pinto beans. pending pack|
+516|44|O|10677.86|1998-04-21|2-HIGH|Clerk#000000305|0|lar, unusual platelets are carefully. even courts sleep bold, final pinto bea|
+517|10|O|82197.79|1997-04-07|5-LOW|Clerk#000000359|0|slyly pending deposits cajole quickly packages. furiou|
+518|145|O|223537.09|1998-02-08|2-HIGH|Clerk#000000768|0| the carefully bold accounts. quickly regular excuses are|
+519|64|O|95731.50|1997-10-31|1-URGENT|Clerk#000000985|0|ains doze furiously against the f|
+544|94|F|47627.89|1993-02-17|2-HIGH|Clerk#000000145|0|the special, final accounts. dogged dolphins|
+545|64|O|23476.12|1995-11-07|2-HIGH|Clerk#000000537|0|as. blithely final hockey players about th|
+546|145|O|14790.37|1996-11-01|2-HIGH|Clerk#000000041|0|osits sleep. slyly special dolphins about the q|
+547|100|O|96855.29|1996-06-22|3-MEDIUM|Clerk#000000976|0|ing accounts eat. carefully regular packa|
+548|124|F|99088.75|1994-09-21|1-URGENT|Clerk#000000435|0|arefully express instru|
+549|110|F|141679.41|1992-07-13|1-URGENT|Clerk#000000196|0|ideas alongside of |
+550|25|O|33123.28|1995-08-02|1-URGENT|Clerk#000000204|0|t requests. blithely |
+551|91|O|46355.83|1995-05-30|1-URGENT|Clerk#000000179|0|xpress accounts boost quic|
+576|31|O|18307.45|1997-05-13|3-MEDIUM|Clerk#000000955|0|l requests affix regular requests. final account|
+577|56|F|34768.68|1994-12-19|5-LOW|Clerk#000000154|0| deposits engage stealthil|
+578|94|O|70392.02|1997-01-10|5-LOW|Clerk#000000281|0|e blithely even packages. slyly pending platelets bes|
+579|68|O|120828.12|1998-03-11|2-HIGH|Clerk#000000862|0| regular instructions. blithely even p|
+580|61|O|88219.12|1997-07-05|2-HIGH|Clerk#000000314|0|tegrate fluffily regular accou|
+581|70|O|126066.00|1997-02-23|4-NOT SPECIFIED|Clerk#000000239|0| requests. even requests use slyly. blithely ironic |
+582|50|O|129004.81|1997-10-21|1-URGENT|Clerk#000000378|0|n pinto beans print a|
+583|49|O|127817.38|1997-03-19|3-MEDIUM|Clerk#000000792|0|efully express requests. a|
+608|26|O|62567.99|1996-02-28|3-MEDIUM|Clerk#000000995|0|nic waters wake slyly slyly expre|
+609|127|F|21088.59|1994-06-01|3-MEDIUM|Clerk#000000348|0|- ironic gifts believe furiously ca|
+610|52|O|175142.28|1995-08-02|1-URGENT|Clerk#000000610|0|totes. ironic, unusual packag|
+611|106|F|73907.63|1993-01-27|1-URGENT|Clerk#000000401|0|ounts detect furiously ac|
+612|82|F|145695.42|1992-10-21|3-MEDIUM|Clerk#000000759|0|boost quickly quickly final excuses. final foxes use bravely afte|
+613|139|O|33396.35|1995-06-18|2-HIGH|Clerk#000000172|0|ts hinder among the deposits. fluffily ironic depos|
+614|134|F|218116.21|1992-12-01|2-HIGH|Clerk#000000388|0| deposits! even, daring theodol|
+615|67|F|32890.89|1992-05-09|5-LOW|Clerk#000000388|0|t to promise asymptotes. packages haggle alongside of the fluffil|
+640|97|F|145495.62|1993-01-23|2-HIGH|Clerk#000000433|0|r, unusual accounts boost carefully final ideas. slyly silent theod|
+641|133|F|120626.49|1993-08-30|5-LOW|Clerk#000000175|0|ents cajole furiously about the quickly silent pac|
+642|40|F|22994.51|1993-12-16|3-MEDIUM|Clerk#000000357|0| among the requests wake slyly alongside of th|
+643|58|P|180396.95|1995-03-25|2-HIGH|Clerk#000000354|0|g dependencies. regular accounts |
+644|8|F|201268.06|1992-05-01|1-URGENT|Clerk#000000550|0| blithely unusual platelets haggle ironic, special excuses. excuses unwi|
+645|115|F|234763.73|1994-12-03|2-HIGH|Clerk#000000090|0|quickly daring theodolites across the regu|
+646|52|F|142070.65|1994-11-22|2-HIGH|Clerk#000000203|0|carefully even foxes. fina|
+647|143|O|56449.23|1997-08-07|1-URGENT|Clerk#000000270|0|egular pearls. carefully express asymptotes are. even account|
+672|109|F|89877.09|1994-04-14|5-LOW|Clerk#000000106|0|egular requests are furiously according to |
+673|80|F|21137.08|1994-03-10|1-URGENT|Clerk#000000448|0| special pinto beans use quickly furiously even depende|
+674|34|F|27204.60|1992-08-29|5-LOW|Clerk#000000448|0|ully special deposits. furiously final warhorses affix carefully. fluffily f|
+675|13|O|125188.72|1997-07-31|2-HIGH|Clerk#000000168|0|ffily between the careful|
+676|38|O|163966.67|1996-12-13|2-HIGH|Clerk#000000248|0|the final deposits. special, pending|
+677|124|F|147915.68|1993-11-24|3-MEDIUM|Clerk#000000824|0|uriously special pinto beans cajole carefully. fi|
+678|131|F|135761.05|1993-02-27|5-LOW|Clerk#000000530|0|. blithely final somas about the|
+679|49|O|8945.03|1995-12-15|2-HIGH|Clerk#000000853|0|tealthy, final pinto beans haggle slyly. pending platelets about the special, |
+704|85|O|56210.26|1996-11-21|3-MEDIUM|Clerk#000000682|0|blithely pending platelets wake alongside of the final, iron|
+705|43|O|83773.49|1997-02-13|4-NOT SPECIFIED|Clerk#000000294|0|ithely regular dependencies. express, even packages sleep slyly pending t|
+706|148|O|23973.60|1995-09-09|1-URGENT|Clerk#000000448|0|g the packages. deposits caj|
+707|118|F|58218.35|1994-11-20|3-MEDIUM|Clerk#000000199|0| ideas about the silent, bold deposits nag dolphins|
+708|32|O|100445.59|1998-07-03|3-MEDIUM|Clerk#000000101|0|lphins cajole about t|
+709|37|O|72055.87|1998-04-21|1-URGENT|Clerk#000000461|0|ons alongside of the carefully bold pinto bea|
+710|133|F|208974.42|1993-01-02|5-LOW|Clerk#000000026|0| regular, regular requests boost. fluffily re|
+711|64|F|92484.70|1993-09-23|4-NOT SPECIFIED|Clerk#000000856|0|its. fluffily regular gifts are furi|
+736|47|O|130204.17|1998-06-21|5-LOW|Clerk#000000881|0|refully of the final pi|
+737|121|F|12984.85|1992-04-26|5-LOW|Clerk#000000233|0|ake blithely express, ironic theodolites. blithely special accounts wa|
+738|22|F|114145.18|1993-03-02|4-NOT SPECIFIED|Clerk#000000669|0|ly even foxes. furiously regular accounts cajole ca|
+739|1|O|159171.69|1998-05-31|5-LOW|Clerk#000000900|0| against the slyly ironic packages nag slyly ironic|
+740|44|O|83490.99|1995-07-16|3-MEDIUM|Clerk#000000583|0|courts haggle furiously across the final, regul|
+741|106|O|47985.98|1998-07-07|2-HIGH|Clerk#000000295|0|ic instructions. slyly express instructions solv|
+742|103|F|207632.55|1994-12-23|5-LOW|Clerk#000000543|0|equests? slyly ironic dolphins boost carefully above the blithely|
+743|79|O|23614.89|1996-10-04|4-NOT SPECIFIED|Clerk#000000933|0|eans. furiously ironic deposits sleep carefully carefully qui|
+768|98|O|220636.82|1996-08-20|3-MEDIUM|Clerk#000000411|0|jole slyly ironic packages. slyly even idea|
+769|80|F|43092.76|1993-06-02|3-MEDIUM|Clerk#000000172|0|ggle furiously. ironic packages haggle slyly. bold platelets affix s|
+770|32|O|64271.75|1998-05-23|5-LOW|Clerk#000000572|0|heodolites. furiously special pinto beans cajole pac|
+771|46|O|105302.05|1995-06-17|1-URGENT|Clerk#000000105|0|s. furiously final instructions across the deposit|
+772|97|F|128234.96|1993-04-17|2-HIGH|Clerk#000000430|0|s boost blithely fluffily idle ideas? fluffily even pin|
+773|133|F|146862.27|1993-09-26|3-MEDIUM|Clerk#000000307|0|tions are quickly accounts. accounts use bold, even pinto beans. gifts ag|
+774|80|O|145857.60|1995-12-04|1-URGENT|Clerk#000000883|0|tealthily even depths|
+775|134|F|59455.61|1995-03-18|1-URGENT|Clerk#000000191|0|kly express requests. fluffily silent accounts poach furiously|
+800|56|O|87892.38|1998-07-14|2-HIGH|Clerk#000000213|0|y alongside of the pending packages? final platelets nag fluffily carefu|
+801|118|F|127717.72|1992-02-18|1-URGENT|Clerk#000000186|0|iously from the furiously enticing reques|
+802|137|F|156381.95|1995-01-05|1-URGENT|Clerk#000000516|0|posits. ironic, pending requests cajole. even theodol|
+803|16|O|27629.66|1997-04-29|5-LOW|Clerk#000000260|0|ic instructions. even deposits haggle furiously at the deposits-- regular de|
+804|50|F|94400.43|1993-03-12|3-MEDIUM|Clerk#000000931|0|s. blithely final foxes are about the packag|
+805|127|O|90042.41|1995-07-05|4-NOT SPECIFIED|Clerk#000000856|0|y according to the fluffily |
+806|131|O|26839.16|1996-06-20|2-HIGH|Clerk#000000240|0| the ironic packages wake carefully fina|
+807|145|F|222392.53|1993-11-24|3-MEDIUM|Clerk#000000012|0|refully special tithes. blithely regular accoun|
+832|29|F|68494.08|1992-04-19|5-LOW|Clerk#000000495|0|xes. bravely regular packages sleep up the furiously bold accou|
+833|56|F|49033.69|1994-02-13|3-MEDIUM|Clerk#000000437|0|ts haggle quickly across the slyl|
+834|43|F|46459.92|1994-05-23|3-MEDIUM|Clerk#000000805|0| sleep. quickly even foxes are boldly. slyly express requests use slyly|
+835|65|O|62430.67|1995-10-08|4-NOT SPECIFIED|Clerk#000000416|0|s about the carefully special foxes haggle quickly about the|
+836|70|O|72843.48|1996-11-25|4-NOT SPECIFIED|Clerk#000000729|0|ely bold excuses sleep regular ideas. furiously unusual ideas wake furiou|
+837|116|F|60918.41|1994-06-15|4-NOT SPECIFIED|Clerk#000000563|0|kages sleep slyly above the ironic, final orbits|
+838|17|O|82918.36|1998-01-29|5-LOW|Clerk#000000213|0| slyly around the slyly even|
+839|28|O|70182.63|1995-08-08|1-URGENT|Clerk#000000951|0|the carefully even platelets. furiously unusual fo|
+864|139|O|74710.74|1997-08-17|1-URGENT|Clerk#000000036|0|ly after the slyly regular deposits. express, regular asymptotes nag ca|
+865|4|F|70430.54|1993-05-04|3-MEDIUM|Clerk#000000337|0|. special packages wake after the carefully final accounts. express pinto be|
+866|40|F|4766.19|1992-11-28|3-MEDIUM|Clerk#000000718|0|ins after the even, even accounts nod blithel|
+867|26|F|7471.75|1993-11-16|3-MEDIUM|Clerk#000000877|0|pades nag quickly final, |
+868|104|F|127345.45|1992-06-09|4-NOT SPECIFIED|Clerk#000000782|0|onic theodolites print carefully. blithely dogge|
+869|136|O|58932.19|1997-01-12|2-HIGH|Clerk#000000245|0|ar sheaves are slowly. slyly even attainments boost theodolites. furiously|
+870|34|F|40492.37|1993-06-20|4-NOT SPECIFIED|Clerk#000000123|0|blithely ironic ideas nod. sly, r|
+871|16|O|172861.58|1995-11-15|5-LOW|Clerk#000000882|0|oss the ironic theodolites.|
+896|2|F|169847.63|1993-03-09|1-URGENT|Clerk#000000187|0|inal packages eat blithely according to the warhorses. furiously quiet de|
+897|49|P|57697.44|1995-03-20|1-URGENT|Clerk#000000316|0| wake quickly against |
+898|55|F|101020.75|1993-06-03|2-HIGH|Clerk#000000611|0|. unusual pinto beans haggle quickly across |
+899|109|O|125562.09|1998-04-08|5-LOW|Clerk#000000575|0|rts engage carefully final theodolites.|
+900|46|F|120073.51|1994-10-01|4-NOT SPECIFIED|Clerk#000000060|0| fluffily express deposits nag furiousl|
+901|13|O|81826.12|1998-07-21|4-NOT SPECIFIED|Clerk#000000929|0|lyly even foxes are furious, silent requests. requests about the quickly |
+902|10|F|37348.62|1994-07-27|4-NOT SPECIFIED|Clerk#000000811|0|yly final requests over the furiously regula|
+903|11|O|109351.87|1995-07-07|4-NOT SPECIFIED|Clerk#000000793|0|e slyly about the final pl|
+928|67|F|228136.49|1995-03-02|5-LOW|Clerk#000000450|0|ithely express pinto beans. |
+929|83|F|109301.02|1992-10-02|2-HIGH|Clerk#000000160|0|its. furiously even foxes affix carefully finally silent accounts. express req|
+930|131|F|199102.23|1994-12-17|1-URGENT|Clerk#000000004|0| accounts nag slyly. ironic, ironic accounts wake blithel|
+931|103|F|117909.23|1992-12-07|1-URGENT|Clerk#000000881|0|ss packages haggle furiously express, regular deposits. even, e|
+932|41|O|40234.50|1997-05-16|2-HIGH|Clerk#000000218|0|ly express instructions boost furiously reg|
+933|97|F|71349.30|1992-08-05|4-NOT SPECIFIED|Clerk#000000752|0|ial courts wake permanently against the furiously regular ideas. unusual |
+934|52|O|17213.59|1996-07-03|1-URGENT|Clerk#000000229|0|ts integrate carefully. sly, regular deposits af|
+935|50|O|97733.87|1997-09-24|5-LOW|Clerk#000000180|0|iously final deposits cajole. blithely even packages |
+960|35|F|63537.13|1994-09-21|3-MEDIUM|Clerk#000000120|0|regular accounts. requests|
+961|56|P|158893.16|1995-06-04|4-NOT SPECIFIED|Clerk#000000720|0|ons nag furiously among the quickl|
+962|37|F|98258.73|1994-05-06|5-LOW|Clerk#000000463|0|ments nag deposits. fluffily ironic a|
+963|26|F|53287.25|1994-05-26|3-MEDIUM|Clerk#000000497|0|uses haggle carefully. slyly even dependencies after the packages ha|
+964|76|O|131146.47|1995-05-20|3-MEDIUM|Clerk#000000657|0|print blithely ironic, careful theodolit|
+965|70|P|41758.44|1995-05-15|5-LOW|Clerk#000000218|0|iously special packages. slyly pending requests are carefully |
+966|14|O|120516.93|1998-04-30|2-HIGH|Clerk#000000239|0|special deposits. furious|
+967|110|F|179287.95|1992-06-21|3-MEDIUM|Clerk#000000167|0|excuses engage quickly bold dep|
+992|55|O|133665.12|1997-11-11|3-MEDIUM|Clerk#000000875|0|ts. regular pinto beans thrash carefully sl|
+993|80|O|198238.65|1995-09-10|3-MEDIUM|Clerk#000000894|0|quickly express accounts among the furiously bol|
+994|2|F|41433.48|1994-04-20|5-LOW|Clerk#000000497|0|ole. slyly bold excuses nag caref|
+995|116|P|135157.92|1995-05-31|3-MEDIUM|Clerk#000000439|0|deas. blithely final deposits play. express accounts wake blithely caref|
+996|71|O|47447.63|1997-12-29|1-URGENT|Clerk#000000497|0|arefully final packages into the slyly final requests affix blit|
+997|109|O|27561.82|1997-05-19|2-HIGH|Clerk#000000651|0|ly express depths. furiously final requests haggle furiously. carefu|
+998|32|F|65269.38|1994-11-26|4-NOT SPECIFIED|Clerk#000000956|0|ronic dolphins. ironic, bold ideas haggle furiously furious|
+999|61|F|145249.13|1993-09-05|5-LOW|Clerk#000000464|0|pitaphs sleep. regular accounts use. f|
+1024|4|O|176084.63|1997-12-23|5-LOW|Clerk#000000903|0| blithely. even, express theodolites cajole slyly across|
+1025|103|F|82034.03|1995-05-05|2-HIGH|Clerk#000000376|0|ross the slyly final pa|
+1026|73|O|36464.76|1997-06-04|5-LOW|Clerk#000000223|0|s wake blithely. special acco|
+1027|128|F|112770.89|1992-06-03|3-MEDIUM|Clerk#000000241|0|equests cajole. slyly final pinto bean|
+1028|70|F|153864.67|1994-01-01|2-HIGH|Clerk#000000131|0|ts are. final, silent deposits are among the fl|
+1029|130|F|47440.91|1994-06-21|2-HIGH|Clerk#000000700|0|quests sleep. slyly even foxes wake quickly final theodolites. clo|
+1030|134|F|16346.94|1994-06-15|5-LOW|Clerk#000000422|0|ully ironic accounts sleep carefully. requests are carefully alongside of the |
+1031|4|F|128024.71|1994-09-01|3-MEDIUM|Clerk#000000448|0|s; ironic theodolites along the carefully ex|
+1056|28|F|38446.39|1995-02-11|1-URGENT|Clerk#000000125|0|t, even deposits hang about the slyly special i|
+1057|76|F|108107.42|1992-02-20|1-URGENT|Clerk#000000124|0|cuses dazzle carefully careful, ironic pinto beans. carefully even theod|
+1058|53|F|89359.11|1993-04-26|3-MEDIUM|Clerk#000000373|0|kly pending courts haggle. blithely regular sheaves integrate carefully fi|
+1059|127|F|198360.22|1994-02-27|1-URGENT|Clerk#000000104|0|en accounts. carefully bold packages cajole daringly special depende|
+1060|140|F|121994.04|1993-02-21|3-MEDIUM|Clerk#000000989|0|l platelets sleep quickly slyly special requests. furiously |
+1061|103|O|166947.75|1998-05-15|5-LOW|Clerk#000000576|0|uests sleep at the packages. fur|
+1062|106|O|39805.04|1997-01-15|1-URGENT|Clerk#000000152|0|eposits use blithely |
+1063|37|F|41392.31|1994-04-02|2-HIGH|Clerk#000000024|0|deposits nag quickly regular deposits. quickl|
+1088|148|F|47120.41|1992-05-21|5-LOW|Clerk#000000347|0|counts are blithely. platelets print. carefully |
+1089|49|O|103192.74|1996-05-04|4-NOT SPECIFIED|Clerk#000000226|0|ns haggle ruthlessly. even requests are quickly abov|
+1090|19|O|32929.30|1997-11-15|2-HIGH|Clerk#000000300|0| furiously regular platelets haggle along the slyly unusual foxes! |
+1091|83|O|35795.22|1996-08-27|1-URGENT|Clerk#000000549|0| even pinto beans haggle quickly alongside of the eve|
+1092|124|P|85552.21|1995-03-04|3-MEDIUM|Clerk#000000006|0|re quickly along the blithe|
+1093|101|O|79189.58|1997-07-31|4-NOT SPECIFIED|Clerk#000000159|0| after the carefully ironic requests. carefully ironic packages wake fluffil|
+1094|145|O|9006.25|1997-12-24|3-MEDIUM|Clerk#000000570|0|beans affix furiously about the pending, even deposits. finally pendi|
+1095|145|O|178491.24|1995-08-22|3-MEDIUM|Clerk#000000709|0|sly bold requests cajole carefully according to|
+1120|140|O|107958.62|1997-11-07|3-MEDIUM|Clerk#000000319|0|lly special requests. slyly pending platelets are quickly pending requ|
+1121|29|O|241837.88|1997-01-13|3-MEDIUM|Clerk#000000541|0|r escapades. deposits above the fluffily bold requests hag|
+1122|121|O|179747.47|1997-01-10|1-URGENT|Clerk#000000083|0|uffily carefully final theodolites. furiously express packages affix|
+1123|73|O|93259.93|1996-08-03|3-MEDIUM|Clerk#000000929|0|uriously pending requests. slyly regular instruction|
+1124|80|O|141858.97|1998-07-30|5-LOW|Clerk#000000326|0|regular pinto beans along the fluffily silent packages|
+1125|25|F|80438.38|1994-10-27|2-HIGH|Clerk#000000510|0|ithely final requests. i|
+1126|145|O|59982.31|1998-01-28|4-NOT SPECIFIED|Clerk#000000928|0|d slyly regular ideas: special ideas believe slyly. slyly ironic sheaves w|
+1127|58|O|103320.91|1995-09-19|4-NOT SPECIFIED|Clerk#000000397|0|usly silent, regular pinto beans. blithely express requests boos|
+1152|49|F|51775.54|1994-08-14|4-NOT SPECIFIED|Clerk#000000496|0|equests. deposits ab|
+1153|121|O|220727.97|1996-04-18|5-LOW|Clerk#000000059|0| across the pending deposi|
+1154|37|F|192417.85|1992-02-15|1-URGENT|Clerk#000000268|0|old asymptotes are special requests. blithely even deposits sleep furiously|
+1155|149|O|126902.81|1997-10-06|2-HIGH|Clerk#000000164|0|c deposits haggle among the ironic, even requests. carefully ironic sheaves n|
+1156|133|O|217682.81|1996-10-19|1-URGENT|Clerk#000000200|0| blithely ironic dolphins. furiously pendi|
+1157|97|O|85394.06|1998-01-14|4-NOT SPECIFIED|Clerk#000000207|0|out the regular excuses boost carefully against the furio|
+1158|142|O|31075.51|1996-06-30|2-HIGH|Clerk#000000549|0|integrate slyly furiously ironic deposit|
+1159|70|F|55553.68|1992-09-18|3-MEDIUM|Clerk#000000992|0|ts may sleep. requests according to the|
+1184|89|O|39700.29|1997-10-26|5-LOW|Clerk#000000777|0|iously even packages haggle fluffily care|
+1185|74|F|47033.21|1992-08-24|5-LOW|Clerk#000000344|0| even escapades are. package|
+1186|59|O|82026.18|1996-08-15|4-NOT SPECIFIED|Clerk#000000798|0|ingly regular pinto beans: instructi|
+1187|134|F|85948.02|1992-11-20|3-MEDIUM|Clerk#000000047|0|s after the furiously final deposits boost slyly under the|
+1188|20|O|54655.07|1996-04-11|2-HIGH|Clerk#000000256|0|ully ironic deposits. slyl|
+1189|46|F|71017.99|1994-04-09|1-URGENT|Clerk#000000243|0|f the even accounts. courts print blithely ironic accounts. sile|
+1190|13|O|31043.39|1997-03-16|5-LOW|Clerk#000000575|0|ccounts above the foxes integrate carefully after the |
+1191|112|O|28623.04|1995-11-07|3-MEDIUM|Clerk#000000011|0|uests nag furiously. carefully even requests|
+1216|122|F|68056.57|1992-12-07|5-LOW|Clerk#000000918|0|nal foxes around the e|
+1217|7|F|40982.08|1992-04-26|4-NOT SPECIFIED|Clerk#000000538|0| foxes nag quickly. ironic excuses nod. blithely pending|
+1218|10|F|99834.47|1994-06-20|4-NOT SPECIFIED|Clerk#000000994|0|s cajole. special, silent deposits about the theo|
+1219|28|O|10163.56|1995-10-05|3-MEDIUM|Clerk#000000800|0|od carefully. slyly final dependencies across the even fray|
+1220|49|O|122157.14|1996-08-29|1-URGENT|Clerk#000000712|0|inal theodolites wake. fluffily ironic asymptotes cajol|
+1221|14|F|117397.16|1992-04-19|4-NOT SPECIFIED|Clerk#000000852|0| detect against the silent, even deposits. carefully ironic|
+1222|10|F|47623.94|1993-02-05|3-MEDIUM|Clerk#000000811|0|theodolites use quickly even accounts. carefully final asympto|
+1223|10|O|26714.67|1996-05-25|4-NOT SPECIFIED|Clerk#000000238|0|posits was blithely fr|
+1248|49|F|210713.88|1992-01-02|1-URGENT|Clerk#000000890|0|t the carefully regular dugouts. s|
+1249|149|F|45889.09|1994-01-05|1-URGENT|Clerk#000000095|0|al ideas sleep above the pending pin|
+1250|37|F|12907.62|1992-09-29|4-NOT SPECIFIED|Clerk#000000652|0|ts after the fluffily pending instructions use slyly about the s|
+1251|38|O|109536.55|1997-10-30|1-URGENT|Clerk#000000276|0|, brave sauternes. deposits boost fluffily.|
+1252|149|O|93403.05|1997-08-04|5-LOW|Clerk#000000348|0|ng the slyly regular excuses. special courts nag furiously blithely e|
+1253|115|F|92730.74|1993-01-26|1-URGENT|Clerk#000000775|0| requests sleep furiously even foxes. ruthless packag|
+1254|70|O|94649.25|1995-12-22|1-URGENT|Clerk#000000607|0| pinto beans. carefully regular request|
+1255|122|F|62518.31|1994-05-30|4-NOT SPECIFIED|Clerk#000000798|0|ct slyly regular accounts. quick|
+1280|97|F|91664.85|1993-01-11|5-LOW|Clerk#000000160|0|posits thrash quickly after the theodolites. furiously iro|
+1281|62|F|165454.51|1994-12-11|1-URGENT|Clerk#000000430|0|counts. carefully pending accounts eat |
+1282|116|F|61297.42|1992-02-29|4-NOT SPECIFIED|Clerk#000000168|0|he quickly special packages. furiously final re|
+1283|118|O|202623.92|1996-08-30|4-NOT SPECIFIED|Clerk#000000260|0| pinto beans boost slyly ac|
+1284|134|O|106122.38|1996-01-07|2-HIGH|Clerk#000000492|0|s. blithely silent deposits s|
+1285|11|F|139124.72|1992-06-01|1-URGENT|Clerk#000000423|0|cial deposits cajole after the ironic requests. p|
+1286|109|F|207291.83|1993-05-14|4-NOT SPECIFIED|Clerk#000000939|0| deposits use carefully from the excuses. slyly bold p|
+1287|19|F|131432.42|1994-07-05|2-HIGH|Clerk#000000288|0|ly ironic dolphins integrate furiously among the final packages. st|
+1312|112|F|58111.00|1994-05-19|3-MEDIUM|Clerk#000000538|0|n, express accounts across the ironic|
+1313|148|F|46598.65|1994-09-13|1-URGENT|Clerk#000000774|0|ld accounts. regular deposits cajole. ironically pending theodolites use car|
+1314|143|F|56207.66|1994-05-13|3-MEDIUM|Clerk#000000485|0|ickly blithe packages nod ideas. furiously bold braids boost around the car|
+1315|22|O|121935.23|1998-03-22|5-LOW|Clerk#000000840|0|final theodolites alongside of the carefu|
+1316|16|F|163746.47|1993-12-03|1-URGENT|Clerk#000000857|0|ully bold theodolites? pending, bold pin|
+1317|100|P|139714.71|1995-05-19|2-HIGH|Clerk#000000373|0|sts. furiously special deposits lose fur|
+1318|128|O|81663.65|1998-06-27|3-MEDIUM|Clerk#000000581|0|s hang bold requests. pending, re|
+1319|32|O|31103.83|1996-09-27|2-HIGH|Clerk#000000257|0|y across the ruthlessly ironic accounts. unusu|
+1344|17|F|43809.37|1992-04-16|5-LOW|Clerk#000000178|0|omise close, silent requests. pending theodolites boost pending |
+1345|95|F|111207.93|1992-10-28|5-LOW|Clerk#000000447|0| regular tithes. quickly fluffy de|
+1346|76|F|171975.62|1992-06-18|2-HIGH|Clerk#000000374|0|ges sleep quickly-- even pint|
+1347|41|O|173444.60|1997-06-20|5-LOW|Clerk#000000977|0|he furiously even foxes use carefully express req|
+1348|19|O|94135.77|1998-04-18|5-LOW|Clerk#000000206|0|tly. quickly even deposi|
+1349|64|O|46376.09|1997-10-26|1-URGENT|Clerk#000000543|0|yly! blithely special theodolites cajole. unusual, reg|
+1350|52|F|49305.98|1993-08-24|1-URGENT|Clerk#000000635|0|iously about the blithely special a|
+1351|106|O|24637.96|1998-04-20|1-URGENT|Clerk#000000012|0| cajole. regular, special re|
+1376|47|O|23984.88|1997-05-04|4-NOT SPECIFIED|Clerk#000000730|0|der furiously final, final frets. carefull|
+1377|20|O|108334.30|1998-04-24|4-NOT SPECIFIED|Clerk#000000625|0|lly across the blithely express accounts. ironic excuses promise carefully de|
+1378|20|O|118495.12|1996-03-09|4-NOT SPECIFIED|Clerk#000000705|0| furiously even tithes cajole slyly among the quick|
+1379|65|O|84627.76|1998-05-25|5-LOW|Clerk#000000861|0|y deposits are caref|
+1380|137|O|94969.41|1996-07-07|3-MEDIUM|Clerk#000000969|0|inal deposits wake slyly daringly even requests. bold, even foxe|
+1381|127|O|58212.22|1998-05-25|3-MEDIUM|Clerk#000000107|0|even requests breach after the bold, ironic instructions. slyly even|
+1382|133|F|173522.71|1993-08-17|5-LOW|Clerk#000000241|0|fully final packages sl|
+1383|121|F|34797.72|1993-04-27|2-HIGH|Clerk#000000785|0|ts. express requests sleep blithel|
+1408|55|O|183965.61|1997-12-26|4-NOT SPECIFIED|Clerk#000000942|0|t the quickly final asymptotes. unusual|
+1409|143|F|72440.52|1992-12-31|4-NOT SPECIFIED|Clerk#000000065|0|ructions. furiously unusual excuses are regular, unusual theodolites. fin|
+1410|113|O|114879.19|1997-04-12|5-LOW|Clerk#000000123|0|iously along the bravely regular dolphins. pinto beans cajole furiously sp|
+1411|95|F|164462.61|1994-12-21|2-HIGH|Clerk#000000566|0|s. furiously special excuses across the pending pinto beans haggle sp|
+1412|53|F|78676.54|1993-03-13|4-NOT SPECIFIED|Clerk#000000083|0|uffily daring theodolit|
+1413|91|O|75733.58|1997-06-14|3-MEDIUM|Clerk#000000342|0|, ironic instructions. carefully even packages dazzle|
+1414|77|O|38057.81|1995-08-16|1-URGENT|Clerk#000000883|0|ccounts. ironic foxes haggle car|
+1415|79|F|24654.79|1994-05-29|4-NOT SPECIFIED|Clerk#000000601|0|rays. blithely final ideas affix quickl|
+1440|98|O|50201.16|1995-08-10|5-LOW|Clerk#000000956|0| pending requests. closely s|
+1441|122|O|156477.94|1997-03-06|4-NOT SPECIFIED|Clerk#000000156|0|ter the excuses. ironic dependencies m|
+1442|112|F|7108.12|1994-07-05|4-NOT SPECIFIED|Clerk#000000935|0|nal pinto beans. slyly ironic ideas cajol|
+1443|44|O|44672.03|1996-12-16|5-LOW|Clerk#000000185|0|x blithely against the carefully final somas. even asymptotes are. quickly spe|
+1444|134|F|207907.60|1994-12-06|3-MEDIUM|Clerk#000000783|0|ove the bold accounts cajole fluffily about|
+1445|115|F|154653.32|1995-01-10|3-MEDIUM|Clerk#000000211|0|even packages wake fluffily |
+1446|41|O|27663.16|1998-02-16|5-LOW|Clerk#000000274|0|lly regular notornis above the requests sleep final accounts! |
+1447|91|F|108171.38|1992-10-15|2-HIGH|Clerk#000000880|0|inly against the blithely pending excuses. regular, pe|
+1472|149|O|65331.05|1996-10-06|5-LOW|Clerk#000000303|0|y special dolphins around the final dependencies wake quick|
+1473|94|O|80624.38|1997-03-17|3-MEDIUM|Clerk#000000960|0|furiously close accoun|
+1474|70|F|51697.18|1995-01-09|1-URGENT|Clerk#000000438|0|detect quickly above the carefully even |
+1475|5|O|185496.66|1997-11-12|2-HIGH|Clerk#000000972|0|cally final packages boost. blithely ironic packa|
+1476|145|O|18795.62|1996-06-27|2-HIGH|Clerk#000000673|0|ding accounts hinder alongside of the quickly pending requests. fluf|
+1477|76|O|231831.35|1997-08-24|5-LOW|Clerk#000000612|0|ly bold foxes. final ideas would cajo|
+1478|50|O|20791.50|1997-08-03|2-HIGH|Clerk#000000827|0|lessly. carefully express|
+1479|16|O|31471.04|1995-12-16|4-NOT SPECIFIED|Clerk#000000697|0|he furiously even foxes. thinly bold deposits|
+1504|2|F|89399.40|1992-08-28|3-MEDIUM|Clerk#000000381|0|, brave deposits. bold de|
+1505|37|F|55892.35|1992-08-21|2-HIGH|Clerk#000000544|0|s. slyly ironic packages cajole. carefully regular packages haggle |
+1506|148|F|195844.84|1992-09-21|3-MEDIUM|Clerk#000000620|0| dependencies. accounts affix blithely slowly unusual deposits. slyly regular |
+1507|121|F|96166.92|1993-10-14|3-MEDIUM|Clerk#000000305|0|stealthy, ironic de|
+1508|103|O|151282.65|1998-04-10|5-LOW|Clerk#000000117|0| after the furiously regular pinto beans hang slyly quickly ironi|
+1509|64|F|180455.98|1993-07-08|5-LOW|Clerk#000000770|0|the regular ideas. regul|
+1510|53|O|154590.05|1996-09-17|5-LOW|Clerk#000000128|0|ld carefully. furiously final asymptotes haggle furiously|
+1511|79|O|59651.38|1996-12-22|4-NOT SPECIFIED|Clerk#000000386|0|ts above the depend|
+1536|94|O|5184.26|1997-01-26|3-MEDIUM|Clerk#000000117|0|ges are! furiously final deposits cajole iron|
+1537|109|F|108317.51|1992-02-15|4-NOT SPECIFIED|Clerk#000000862|0|g to the even deposits. ironic, final packages |
+1538|29|O|179554.41|1995-06-18|4-NOT SPECIFIED|Clerk#000000258|0| instructions. regular theod|
+1539|112|F|39612.63|1995-03-10|5-LOW|Clerk#000000840|0|nstructions boost pa|
+1540|16|F|128014.15|1992-08-05|2-HIGH|Clerk#000000927|0|r ideas hinder blithe|
+1541|94|P|47286.32|1995-05-18|1-URGENT|Clerk#000000906|0|y. slyly ironic warhorses around the furiously regul|
+1542|143|F|132972.24|1993-09-15|3-MEDIUM|Clerk#000000435|0|t the furiously close deposits do was f|
+1543|52|O|139047.22|1997-02-20|1-URGENT|Clerk#000000398|0|unts. furiously pend|
+1568|17|O|76119.72|1997-01-30|4-NOT SPECIFIED|Clerk#000000554|0|d notornis. carefully |
+1569|104|O|87803.55|1998-04-02|5-LOW|Clerk#000000786|0|orbits. fluffily even decoys serve blithely. furiously furious realms nag acro|
+1570|124|O|35589.57|1998-03-16|1-URGENT|Clerk#000000745|0|pinto beans haggle furiousl|
+1571|103|F|151404.78|1992-12-05|2-HIGH|Clerk#000000565|0|ously furiously bold warthogs. slyly ironic instructions are quickly a|
+1572|11|O|47232.79|1996-02-24|2-HIGH|Clerk#000000994|0|fluffily ironic accounts haggle blithely final platelets! slyly regular foxes|
+1573|148|F|86918.57|1992-12-28|2-HIGH|Clerk#000000940|0|ess, ironic deposits use along the carefu|
+1574|134|O|179923.54|1996-12-12|3-MEDIUM|Clerk#000000809|0| ideas hinder after the carefully unusual |
+1575|145|O|197031.52|1995-09-13|3-MEDIUM|Clerk#000000497|0|. furiously regular dep|
+1600|94|F|130515.61|1993-03-03|3-MEDIUM|Clerk#000000627|0|tions cajole quietly above the regular, silent requests. slyly fin|
+1601|53|F|73962.95|1994-08-27|5-LOW|Clerk#000000469|0|ent deposits are ca|
+1602|1|F|4225.26|1993-08-05|5-LOW|Clerk#000000660|0|deposits. busily silent instructions haggle furiously. fin|
+1603|2|F|29305.47|1993-07-31|4-NOT SPECIFIED|Clerk#000000869|0|s. slyly silent deposits boo|
+1604|113|F|107139.29|1993-07-17|5-LOW|Clerk#000000512|0|lithely silent waters. blithely unusual packages alongside |
+1605|58|O|130687.64|1998-04-24|4-NOT SPECIFIED|Clerk#000000616|0|sleep furiously? ruthless, even pinto beans |
+1606|53|O|115877.40|1997-04-17|4-NOT SPECIFIED|Clerk#000000550|0|r requests. quickly even platelets breach before the ironically|
+1607|149|O|166335.03|1995-12-16|2-HIGH|Clerk#000000498|0| bold, pending foxes haggle. slyly silent |
+1632|67|O|183286.33|1997-01-08|3-MEDIUM|Clerk#000000351|0|onic requests are accounts. bold a|
+1633|16|O|52359.51|1995-10-14|2-HIGH|Clerk#000000666|0|y silent accounts sl|
+1634|70|O|145898.47|1996-09-10|1-URGENT|Clerk#000000360|0|arefully blithely ironic requests. slyly unusual instructions alongside|
+1635|4|O|70232.26|1997-02-13|3-MEDIUM|Clerk#000000958|0|s. slyly ironic requests affix slyly |
+1636|79|O|172021.87|1997-06-17|3-MEDIUM|Clerk#000000457|0|ding requests. slyly ironic courts wake quickl|
+1637|73|F|180912.15|1995-02-08|4-NOT SPECIFIED|Clerk#000000189|0| final accounts. blithely silent ideas cajole bravely. carefully express |
+1638|139|O|172436.30|1997-08-13|2-HIGH|Clerk#000000643|0|he fluffily regular asymp|
+1639|5|O|104166.56|1995-08-20|4-NOT SPECIFIED|Clerk#000000939|0|haggle furiously. final requests detect furious|
+1664|64|O|178060.22|1996-03-03|1-URGENT|Clerk#000000090|0|y quickly even asymptotes. furiously regular packages haggle quickly fin|
+1665|76|F|4819.91|1994-05-08|2-HIGH|Clerk#000000920|0|ly regular packages are fluffily even ideas. fluffily final|
+1666|95|O|128367.97|1995-10-18|1-URGENT|Clerk#000000849|0|ffily pending dependencies wake fluffily. pending, final accounts |
+1667|5|O|125030.37|1997-10-10|2-HIGH|Clerk#000000103|0|e accounts. slyly express accounts must are a|
+1668|142|O|137576.19|1997-07-12|4-NOT SPECIFIED|Clerk#000000148|0|eodolites. carefully dogged dolphins haggle q|
+1669|2|O|24362.39|1997-06-09|3-MEDIUM|Clerk#000000663|0|er ironic requests detect furiously blithely sp|
+1670|25|O|89999.72|1997-05-24|2-HIGH|Clerk#000000320|0|unusual dependencies. furiously special platelets main|
+1671|35|O|104391.11|1996-07-27|4-NOT SPECIFIED|Clerk#000000275|0|ly. slyly pending requests was above the |
+1696|4|O|102665.03|1998-01-08|4-NOT SPECIFIED|Clerk#000000041|0|bravely bold accounts above the quickly bold|
+1697|76|O|122621.31|1996-10-07|1-URGENT|Clerk#000000815|0|o x-ray blithely. pl|
+1698|40|O|141118.87|1997-04-23|2-HIGH|Clerk#000000432|0|slyly. carefully express deposit|
+1699|85|F|66408.29|1993-12-30|1-URGENT|Clerk#000000125|0|jole blithely. furiously un|
+1700|65|O|89143.36|1996-06-15|3-MEDIUM|Clerk#000000328|0|ely final dolphins wake sometimes above the quietly regular deposits. fur|
+1701|130|F|72835.95|1992-05-19|2-HIGH|Clerk#000000395|0|furiously. regular, close theodoli|
+1702|67|P|194119.31|1995-05-07|2-HIGH|Clerk#000000300|0|around the carefully final deposits cajole carefully according to the b|
+1703|134|F|121220.59|1993-01-28|3-MEDIUM|Clerk#000000463|0| pinto beans poach. bold courts boost. regular, express deposits at|
+1728|64|O|131604.34|1996-05-22|2-HIGH|Clerk#000000711|0|beans. slyly regular instructions sleep! slyly final packages|
+1729|133|F|12137.76|1992-05-19|2-HIGH|Clerk#000000158|0|pending foxes wake. accounts|
+1730|124|O|150886.49|1998-07-24|5-LOW|Clerk#000000794|0| fluffily pending deposits serve. furiously even requests wake furiou|
+1731|128|O|190490.78|1996-01-06|1-URGENT|Clerk#000000268|0|lithely regular, final instructions. ironic, express packages are above|
+1732|146|F|179854.51|1993-11-29|5-LOW|Clerk#000000903|0|inal requests integrate dolph|
+1733|148|O|165489.52|1996-05-12|2-HIGH|Clerk#000000789|0|e carefully according to the accounts. furiously pending instructions sleep|
+1734|7|F|44002.53|1994-06-11|2-HIGH|Clerk#000000722|0| final ideas haggle. blithely quick foxes sleep busily bold ideas. i|
+1735|22|F|98541.95|1992-12-27|1-URGENT|Clerk#000000458|0|ully idle requests wake qu|
+1760|115|O|82151.12|1996-05-17|5-LOW|Clerk#000000917|0| deposits. busily regular deposits wake blithely along the furiously even re|
+1761|106|F|211925.95|1993-12-24|2-HIGH|Clerk#000000817|0|efully slyly bold frets. packages boost b|
+1762|77|F|202227.17|1994-08-20|4-NOT SPECIFIED|Clerk#000000653|0|ly ironic packages. furi|
+1763|121|O|140685.01|1996-10-29|2-HIGH|Clerk#000000321|0|es. bold dependencies haggle furiously along |
+1764|29|F|47384.71|1992-03-25|1-URGENT|Clerk#000000182|0|. slyly final packages integrate carefully acro|
+1765|73|O|36551.43|1995-12-03|4-NOT SPECIFIED|Clerk#000000490|0| regular excuses wake slyly|
+1766|139|O|41032.81|1996-10-12|2-HIGH|Clerk#000000983|0|unusual deposits affix quickly beyond the carefully s|
+1767|25|P|136582.60|1995-03-14|2-HIGH|Clerk#000000327|0|eposits use carefully carefully regular platelets. quickly regular packages al|
+1792|49|F|107919.86|1993-11-09|5-LOW|Clerk#000000102|0|ructions haggle along the pending packages. carefully speci|
+1793|19|F|82504.56|1992-07-12|4-NOT SPECIFIED|Clerk#000000291|0|regular packages cajole. blithely special packages according to the final d|
+1794|140|O|179462.21|1997-09-28|1-URGENT|Clerk#000000686|0|ally silent pinto beans. regular package|
+1795|94|F|146849.33|1994-03-19|2-HIGH|Clerk#000000815|0| quickly final packages! blithely dogged accounts c|
+1796|47|F|33755.47|1992-11-21|2-HIGH|Clerk#000000245|0|eans use furiously around th|
+1797|125|O|51494.47|1996-05-07|3-MEDIUM|Clerk#000000508|0|quiet platelets haggle since the quickly ironic instructi|
+1798|52|O|46393.97|1997-07-28|1-URGENT|Clerk#000000741|0|al foxes are blithe|
+1799|61|F|46815.93|1994-03-07|4-NOT SPECIFIED|Clerk#000000339|0|ns sleep furiously final waters. blithely regular instructions h|
+1824|49|F|81351.53|1994-05-05|1-URGENT|Clerk#000000972|0|e blithely fluffily|
+1825|148|F|150582.77|1993-12-05|3-MEDIUM|Clerk#000000345|0|ironic, final accou|
+1826|82|F|124719.97|1992-04-16|4-NOT SPECIFIED|Clerk#000000718|0|the even asymptotes dazzle fluffily slyly regular asymptotes. final, unu|
+1827|106|O|210113.88|1996-06-22|4-NOT SPECIFIED|Clerk#000000369|0|luffily even requests haggle sly|
+1828|32|F|137369.50|1994-04-18|3-MEDIUM|Clerk#000000840|0|y quickly bold packag|
+1829|112|F|127532.20|1994-05-08|2-HIGH|Clerk#000000537|0| accounts wake above the furiously unusual requests. pending package|
+1830|133|F|85122.24|1995-02-23|1-URGENT|Clerk#000000045|0|according to the even,|
+1831|71|F|58032.77|1993-12-02|1-URGENT|Clerk#000000854|0| accounts. carefully even accounts boost furiously. regular ideas engage. |
+1856|106|F|189361.42|1992-03-20|4-NOT SPECIFIED|Clerk#000000952|0|. special pinto beans run acr|
+1857|133|F|102793.59|1993-01-13|2-HIGH|Clerk#000000083|0|hely final ideas slee|
+1858|143|O|30457.91|1997-12-13|1-URGENT|Clerk#000000389|0|thely. slyly final deposits sleep|
+1859|61|O|105094.09|1997-04-11|4-NOT SPECIFIED|Clerk#000000949|0| the foxes. bravely special excuses nag carefully special r|
+1860|10|O|9103.40|1996-04-04|3-MEDIUM|Clerk#000000556|0|osits. quickly bold deposits according to |
+1861|70|F|95063.41|1994-01-03|3-MEDIUM|Clerk#000000847|0|r the fluffily close sauternes. furio|
+1862|34|O|97981.06|1998-02-24|5-LOW|Clerk#000000348|0|ts snooze ironically abou|
+1863|74|F|96359.65|1993-09-23|4-NOT SPECIFIED|Clerk#000000658|0|old sentiments. careful, |
+1888|121|F|224724.11|1993-10-31|4-NOT SPECIFIED|Clerk#000000659|0|olites. pinto beans cajole. regular deposits affix. slyly regular|
+1889|25|O|96431.77|1997-03-16|1-URGENT|Clerk#000000854|0|p around the regular notornis. unusual deposits|
+1890|10|O|202364.58|1996-12-18|4-NOT SPECIFIED|Clerk#000000627|0|romise final, regular deposits. regular fox|
+1891|61|F|76848.96|1994-12-15|5-LOW|Clerk#000000495|0|unusual foxes sleep regular deposits. requests wake special pac|
+1892|25|F|133273.64|1994-03-26|5-LOW|Clerk#000000733|0|sts. slyly regular dependencies use slyly. ironic, spec|
+1893|125|O|116792.13|1997-10-30|2-HIGH|Clerk#000000111|0|olites. silent, special deposits eat slyly quickly express packages; hockey p|
+1894|76|F|44387.23|1992-03-30|1-URGENT|Clerk#000000626|0|e furiously. furiously even accounts are slyly final accounts. closely speci|
+1895|7|F|44429.81|1994-05-30|3-MEDIUM|Clerk#000000878|0|ress accounts. bold accounts cajole. slyly final pinto beans poach regul|
+1920|110|O|119605.91|1998-06-24|5-LOW|Clerk#000000018|0|hely; furiously regular excuses|
+1921|88|F|57584.12|1994-01-18|3-MEDIUM|Clerk#000000293|0|counts. slyly quiet requests along the ruthlessly regular accounts are |
+1922|56|O|11575.77|1996-07-13|3-MEDIUM|Clerk#000000984|0|side of the blithely final re|
+1923|136|O|171128.10|1997-07-07|1-URGENT|Clerk#000000471|0| express dolphins. |
+1924|76|O|169756.19|1996-09-07|4-NOT SPECIFIED|Clerk#000000823|0| of the ironic accounts. instructions near the final instr|
+1925|17|F|146382.71|1992-03-05|1-URGENT|Clerk#000000986|0|e slyly regular deposits. furiously |
+1926|94|O|100035.03|1996-01-31|2-HIGH|Clerk#000000568|0|cajole. even warhorses sleep carefully. |
+1927|140|O|23327.88|1995-09-30|3-MEDIUM|Clerk#000000616|0|riously special packages. permanent pearls wake furiously. even packages alo|
+1952|67|F|12896.25|1994-03-16|2-HIGH|Clerk#000000254|0| silent accounts boost |
+1953|149|F|57213.18|1993-11-30|3-MEDIUM|Clerk#000000891|0| fluffily along the quickly even packages. |
+1954|56|O|158853.63|1997-05-31|4-NOT SPECIFIED|Clerk#000000104|0| unusual excuses cajole according to the blithely regular theodolites.|
+1955|13|F|103085.13|1992-04-20|1-URGENT|Clerk#000000792|0|ly special ideas. sometimes final |
+1956|127|F|88704.26|1992-09-20|4-NOT SPECIFIED|Clerk#000000600|0|ironic ideas are silent ideas. furiously final deposits sleep slyly carefu|
+1957|31|O|77482.87|1998-07-21|2-HIGH|Clerk#000000639|0|nding excuses about the |
+1958|53|O|176294.34|1995-09-22|5-LOW|Clerk#000000343|0| haggle blithely. flu|
+1959|43|O|62277.18|1997-01-13|4-NOT SPECIFIED|Clerk#000000631|0| cajole about the blithely express requests. even excuses mold bl|
+1984|52|O|79230.47|1998-04-01|1-URGENT|Clerk#000000416|0| slyly special instructions. unusual foxes use packages. carefully regular req|
+1985|7|F|171522.54|1994-09-02|4-NOT SPECIFIED|Clerk#000000741|0|slyly slyly even pains. slyly reg|
+1986|149|F|34269.96|1994-05-05|2-HIGH|Clerk#000000609|0|across the theodolites. quick|
+1987|100|F|6406.29|1994-04-30|2-HIGH|Clerk#000000652|0|gular platelets alongside |
+1988|109|O|117132.72|1995-10-06|4-NOT SPECIFIED|Clerk#000000011|0|ly ironic dolphins serve quickly busy accounts. bu|

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/data/points.txt
----------------------------------------------------------------------
diff --git a/tests/data/points.txt b/tests/data/points.txt
new file mode 100644
index 0000000..27127c4
--- /dev/null
+++ b/tests/data/points.txt
@@ -0,0 +1,500 @@
+6.921800136566162,6.954400062561035
+6.131800174713135,7.235499858856201
+3.900899887084961,6.2332000732421875
+3.921799898147583,3.2929999828338623
+6.3491997718811035,6.253900051116943
+2.4993999004364014,2.0225000381469727
+3.502700090408325,3.9000000953674316
+3.738100051879883,6.3267998695373535
+6.94950008392334,6.150700092315674
+6.35129976272583,6.667900085449219
+7.178899765014648,6.699900150299072
+3.9077999591827393,2.266200065612793
+2.983299970626831,6.317299842834473
+3.077899932861328,2.3768999576568604
+6.150599956512451,3.5055999755859375
+3.289599895477295,7.668700218200684
+3.728100061416626,7.604400157928467
+3.142199993133545,6.031599998474121
+7.528900146484375,2.4365999698638916
+2.8935999870300293,2.538800001144409
+3.68530011177063,2.5383999347686768
+7.368299961090088,6.472599983215332
+6.4268999099731445,3.189300060272217
+2.493499994277954,3.48009991645813
+3.822499990463257,3.3726999759674072
+7.537799835205078,2.49780011177063
+7.92549991607666,2.5899999141693115
+7.309999942779541,3.390700101852417
+2.922499895095825,2.505199909210205
+6.170199871063232,6.818900108337402
+6.580100059509277,6.479000091552734
+2.903899908065796,3.6621999740600586
+7.677199840545654,7.9670000076293945
+7.660099983215332,7.690499782562256
+2.3986001014709473,2.015700101852417
+3.6884000301361084,3.8282999992370605
+7.021200180053711,2.569200038909912
+2.246000051498413,2.516900062561035
+2.7613000869750977,2.2119998931884766
+6.311299800872803,3.557300090789795
+7.244900226593018,3.587599992752075
+7.651500225067139,7.397600173950195
+3.299999952316284,6.100299835205078
+2.3821001052856445,6.825099945068359
+3.725399971008301,2.5648000240325928
+2.0576999187469482,2.905600070953369
+6.289299964904785,3.348099946975708
+6.616600036621094,3.0078999996185303
+2.142400026321411,6.320000171661377
+3.3341000080108643,3.8861000537872314
+3.5374999046325684,3.5202999114990234
+6.624599933624268,2.6078999042510986
+6.464600086212158,6.085400104522705
+3.0425000190734863,7.662600040435791
+7.705699920654297,6.479899883270264
+7.363699913024902,2.5452001094818115
+2.1714000701904297,6.541999816894531
+7.850900173187256,3.646699905395508
+6.378699779510498,3.80649995803833
+2.7272000312805176,3.9781999588012695
+6.768400192260742,3.7948999404907227
+6.7393999099731445,6.712200164794922
+6.744800090789795,7.012400150299072
+6.523399829864502,7.8155999183654785
+2.190000057220459,6.07450008392334
+2.055999994277954,2.526900053024292
+7.172500133514404,7.018700122833252
+3.484800100326538,7.375400066375732
+6.329899787902832,3.1998000144958496
+7.992599964141846,7.713500022888184
+7.006199836730957,7.303699970245361
+3.472899913787842,7.819799900054932
+3.493299961090088,7.225100040435791
+6.735599994659424,7.082799911499023
+7.815499782562256,3.0378000736236572
+6.57450008392334,7.539000034332275
+3.40310001373291,6.245699882507324
+2.0090999603271484,2.5994999408721924
+6.988999843597412,3.2437000274658203
+7.522299766540527,7.429100036621094
+3.8046000003814697,7.24399995803833
+7.309700012207031,3.8366000652313232
+7.022900104522705,6.48859977722168
+2.51200008392334,3.9346001148223877
+7.65369987487793,6.635799884796143
+7.527699947357178,7.307400226593018
+7.249300003051758,2.057300090789795
+6.946800231933594,2.014699935913086
+6.645999908447266,7.848100185394287
+7.76639986038208,2.3155999183654785
+3.3743999004364014,6.633299827575684
+7.31790018081665,6.18179988861084
+6.199399948120117,3.9195001125335693
+2.67330002784729,3.5785000324249268
+6.949699878692627,3.9535999298095703
+2.6575000286102295,6.631100177764893
+3.024199962615967,7.639599800109863
+3.2160000801086426,6.066100120544434
+3.4969000816345215,3.5882999897003174
+7.34660005569458,7.804800033569336
+6.626399993896484,6.095799922943115
+3.652400016784668,3.7070999145507812
+6.416500091552734,3.092400074005127
+3.8994998931884766,2.5820999145507812
+2.5432000160217285,3.0197999477386475
+6.055500030517578,3.8004000186920166
+7.971399784088135,6.815299987792969
+3.3080999851226807,2.784899950027466
+7.5391998291015625,6.1956000328063965
+7.657199859619141,2.092600107192993
+2.4821999073028564,3.7964999675750732
+6.2947998046875,3.3835999965667725
+6.485099792480469,2.3071000576019287
+7.10860013961792,3.4391000270843506
+7.75,7.751299858093262
+7.371600151062012,7.951300144195557
+2.5346999168395996,6.521100044250488
+2.4096999168395996,3.0875000953674316
+2.7014000415802,6.6296000480651855
+6.255799770355225,7.450399875640869
+6.408999919891357,7.4506001472473145
+6.225399971008301,7.252099990844727
+6.158100128173828,3.4988999366760254
+7.041500091552734,2.530900001525879
+2.115799903869629,3.702699899673462
+7.837399959564209,7.920000076293945
+2.134399890899658,6.327700138092041
+2.6205999851226807,6.962699890136719
+6.412099838256836,6.9496002197265625
+2.4688000679016113,7.957099914550781
+2.6501998901367188,7.637599945068359
+3.888000011444092,2.4911000728607178
+3.9446001052856445,3.68969988822937
+2.6679000854492188,6.1940999031066895
+6.962399959564209,6.685299873352051
+6.9899001121521,6.793600082397461
+7.564499855041504,2.965100049972534
+2.0127999782562256,3.5176000595092773
+6.49399995803833,3.2639000415802
+7.330699920654297,7.61329984664917
+2.4379000663757324,2.280600070953369
+3.5696001052856445,2.069000005722046
+6.361400127410889,7.811600208282471
+7.305799961090088,3.124799966812134
+3.895400047302246,3.0109000205993652
+2.311199903488159,2.1410999298095703
+7.062099933624268,3.8060998916625977
+2.76990008354187,3.9946999549865723
+2.2741000652313232,3.0947000980377197
+7.338099956512451,2.7785000801086426
+6.309999942779541,3.011199951171875
+2.7232000827789307,3.6393001079559326
+2.893699884414673,7.241700172424316
+3.9500999450683594,3.8545000553131104
+2.375499963760376,6.386099815368652
+7.528900146484375,7.9847002029418945
+6.517899990081787,6.9471001625061035
+6.730100154876709,6.771699905395508
+3.2109999656677246,2.211199998855591
+3.4442999362945557,7.752799987792969
+6.950900077819824,7.447199821472168
+3.2637999057769775,2.2936999797821045
+6.354000091552734,3.3777999877929688
+2.607599973678589,2.039299964904785
+2.826900005340576,2.2344000339508057
+3.346100091934204,2.4226999282836914
+7.082499980926514,6.128900051116943
+6.73829984664917,7.183000087738037
+7.082900047302246,3.2086000442504883
+6.569900035858154,7.894800186157227
+6.118000030517578,6.448800086975098
+3.732300043106079,7.831699848175049
+6.376299858093262,2.183500051498413
+2.676100015640259,2.3494999408721924
+2.5123000144958496,6.920100212097168
+3.9307000637054443,7.425099849700928
+2.291599988937378,3.9927000999450684
+2.787600040435791,3.0785999298095703
+3.661400079727173,6.846799850463867
+3.6249001026153564,2.327199935913086
+2.281899929046631,2.2035999298095703
+2.3310999870300293,3.3859000205993652
+3.3529999256134033,3.3694000244140625
+6.7565999031066895,2.111299991607666
+2.321199893951416,6.125899791717529
+3.228600025177002,6.239999771118164
+7.517899990081787,6.13730001449585
+7.9766998291015625,2.504699945449829
+6.127399921417236,7.602099895477295
+3.799499988555908,6.989699840545654
+3.148699998855591,2.166300058364868
+6.047599792480469,2.237600088119507
+3.1891000270843506,6.691100120544434
+7.514900207519531,2.142400026321411
+7.020400047302246,2.558799982070923
+3.256999969482422,7.69789981842041
+7.07889986038208,7.684899806976318
+6.915299892425537,3.9291000366210938
+2.729300022125244,6.754700183868408
+6.190100193023682,6.945899963378906
+2.138000011444092,6.096099853515625
+6.718500137329102,7.073599815368652
+2.7667999267578125,6.999100208282471
+6.504899978637695,2.3001999855041504
+3.890000104904175,3.4119999408721924
+6.803400039672852,3.319700002670288
+3.652600049972534,2.648400068283081
+2.052500009536743,6.384699821472168
+7.038700103759766,2.9837000370025635
+6.0370001792907715,6.3105998039245605
+2.6131999492645264,7.368199825286865
+2.101900100708008,3.0227999687194824
+3.3541998863220215,7.217899799346924
+3.6145999431610107,6.589200019836426
+3.8541998863220215,2.5806000232696533
+2.803299903869629,7.7484002113342285
+6.4593000411987305,6.8831000328063965
+3.1250998973846436,2.650099992752075
+7.408699989318848,7.83459997177124
+6.266600131988525,6.865099906921387
+2.946899890899658,3.997299909591675
+3.5589001178741455,3.34689998626709
+3.88919997215271,3.647700071334839
+3.024199962615967,2.688999891281128
+2.0464000701904297,6.532400131225586
+3.9644999504089355,7.585899829864502
+6.644000053405762,6.124000072479248
+3.575000047683716,6.205599784851074
+7.868100166320801,7.030600070953369
+3.494499921798706,6.580999851226807
+2.363100051879883,3.761199951171875
+2.262500047683716,7.011300086975098
+2.0764999389648438,3.747499942779541
+3.414400100708008,7.368500232696533
+7.321700096130371,3.0181000232696533
+2.2358999252319336,2.769700050354004
+2.2130000591278076,2.8701999187469482
+7.24459981918335,3.954900026321411
+2.7200000286102295,6.013199806213379
+7.608099937438965,6.47730016708374
+2.8805999755859375,7.3471999168396
+6.823599815368652,3.09089994430542
+2.4570000171661377,3.9398999214172363
+7.138199806213379,7.345399856567383
+3.5241000652313232,2.8201000690460205
+3.368299961090088,3.818700075149536
+2.7402000427246094,7.48829984664917
+2.748800039291382,7.874300003051758
+3.3046000003814697,3.816699981689453
+6.023799896240234,6.960899829864502
+2.1923000812530518,3.738600015640259
+7.816299915313721,6.060500144958496
+7.651500225067139,2.3533999919891357
+2.6514999866485596,2.5483999252319336
+3.8304998874664307,7.5854997634887695
+7.2170000076293945,2.561199903488159
+3.0725998878479004,7.605599880218506
+6.690000057220459,6.574100017547607
+6.388500213623047,3.1524999141693115
+3.336699962615967,7.572400093078613
+3.546099901199341,2.897200107574463
+7.617700099945068,3.0355000495910645
+7.8993000984191895,3.384200096130371
+2.2709999084472656,2.289900064468384
+2.3125,2.823499917984009
+2.2781999111175537,7.196000099182129
+2.8922998905181885,7.639200210571289
+6.656700134277344,3.1435000896453857
+6.767000198364258,2.8536999225616455
+2.654400110244751,7.05649995803833
+6.396500110626221,3.655900001525879
+7.025100231170654,2.1208999156951904
+7.246600151062012,7.158899784088135
+2.677000045776367,2.612299919128418
+6.439899921417236,6.598999977111816
+7.158400058746338,7.845099925994873
+3.731600046157837,3.2042999267578125
+2.00600004196167,2.440700054168701
+6.624499797821045,6.501800060272217
+2.350800037384033,6.048600196838379
+3.307300090789795,3.5341999530792236
+7.782800197601318,2.8921000957489014
+2.4219000339508057,3.2500998973846436
+6.193299770355225,2.824899911880493
+3.065000057220459,2.075500011444092
+7.660900115966797,7.142199993133545
+7.95550012588501,7.130199909210205
+2.8970999717712402,2.2955000400543213
+7.84660005569458,2.1054999828338623
+2.86899995803833,6.74429988861084
+2.5439999103546143,3.8840999603271484
+7.807499885559082,3.507200002670288
+3.2590999603271484,6.9492998123168945
+3.973599910736084,6.573200225830078
+6.086999893188477,7.670499801635742
+6.406400203704834,2.4962000846862793
+7.639900207519531,7.828800201416016
+2.706199884414673,2.4725000858306885
+2.0859999656677246,2.222399950027466
+6.657299995422363,7.556399822235107
+6.025199890136719,3.4611001014709473
+6.036099910736084,3.2685999870300293
+2.2737998962402344,6.98859977722168
+7.912099838256836,3.9690001010894775
+3.566200017929077,7.4654998779296875
+2.308000087738037,6.670599937438965
+7.56220006942749,2.5703001022338867
+6.868800163269043,7.8719000816345215
+7.157199859619141,7.916999816894531
+3.9746999740600586,3.6157000064849854
+6.570000171661377,7.128600120544434
+7.809700012207031,2.8066000938415527
+7.9822998046875,6.943399906158447
+7.909599781036377,3.406599998474121
+6.336599826812744,6.531499862670898
+3.0443999767303467,2.305500030517578
+7.465799808502197,7.4217000007629395
+6.31220006942749,3.5764000415802
+2.6094000339508057,6.097400188446045
+7.015699863433838,6.960299968719482
+6.505799770355225,7.734499931335449
+3.1910998821258545,7.167300224304199
+6.976600170135498,7.292699813842773
+2.704900026321411,3.495800018310547
+6.029300212860107,6.078100204467773
+3.683799982070923,6.928500175476074
+6.7118000984191895,2.845900058746338
+3.8473000526428223,3.890000104904175
+6.94290018081665,7.445700168609619
+3.2620999813079834,6.315800189971924
+6.366700172424316,6.46560001373291
+3.6136999130249023,2.7599000930786133
+7.76200008392334,3.2701001167297363
+2.312999963760376,6.918000221252441
+6.500100135803223,3.675600051879883
+3.4368999004364014,2.3596999645233154
+7.853700160980225,7.183199882507324
+2.477400064468384,3.332900047302246
+2.4293999671936035,2.779599905014038
+3.9558000564575195,7.857600212097168
+3.786099910736084,3.865499973297119
+7.294600009918213,2.3431999683380127
+3.658900022506714,7.590700149536133
+2.114300012588501,2.609299898147583
+3.299099922180176,6.727799892425537
+2.2978999614715576,7.222099781036377
+6.009099960327148,3.8750998973846436
+2.433799982070923,2.7827999591827393
+2.092900037765503,6.9558000564575195
+7.3445000648498535,6.697500228881836
+6.736999988555908,2.824399948120117
+7.385000228881836,2.0313000679016113
+2.3245999813079834,2.6898000240325928
+7.465700149536133,3.433300018310547
+6.839700222015381,7.5152997970581055
+7.844299793243408,6.095900058746338
+2.404099941253662,7.042699813842773
+2.311500072479248,6.677199840545654
+2.0025999546051025,7.606100082397461
+6.330100059509277,7.257599830627441
+3.8756000995635986,6.626800060272217
+7.943900108337402,7.495800018310547
+6.806000232696533,7.029099941253662
+7.966300010681152,2.195499897003174
+7.24370002746582,7.573200225830078
+3.9442999362945557,6.847099781036377
+6.421899795532227,7.970399856567383
+2.0548999309539795,2.6538000106811523
+7.617800235748291,7.068600177764893
+6.893899917602539,2.588900089263916
+3.953900098800659,6.547100067138672
+3.2860000133514404,6.091000080108643
+6.447299957275391,2.6561999320983887
+3.895900011062622,6.848999977111816
+6.641600131988525,2.5624001026153564
+7.246099948883057,3.3494999408721924
+7.531099796295166,2.2258999347686768
+7.804500102996826,3.9358999729156494
+3.0936999320983887,6.97790002822876
+3.8548998832702637,3.8805999755859375
+7.6178998947143555,7.3618998527526855
+6.054200172424316,7.333499908447266
+2.9723000526428223,7.613399982452393
+3.738100051879883,2.9797000885009766
+7.290999889373779,2.4381000995635986
+2.166599988937378,3.697999954223633
+2.7709999084472656,3.6180999279022217
+3.678800106048584,2.0861001014709473
+7.483699798583984,6.344099998474121
+2.5620999336242676,7.974899768829346
+7.684999942779541,3.401900053024292
+7.936299800872803,7.753300189971924
+7.2758002281188965,7.101900100708008
+3.5334999561309814,6.274099826812744
+6.846799850463867,3.3877999782562256
+6.455699920654297,3.8445000648498535
+2.9647998809814453,7.840000152587891
+2.083199977874756,2.455199956893921
+6.35830020904541,3.4814999103546143
+6.941400051116943,2.62280011177063
+3.555299997329712,7.61269998550415
+3.5352001190185547,2.8441998958587646
+6.719299793243408,3.8926000595092773
+2.0429000854492188,2.5560998916625977
+6.846199989318848,6.692299842834473
+2.248300075531006,3.9449000358581543
+3.5787999629974365,3.100399971008301
+2.583199977874756,3.1394999027252197
+2.250499963760376,6.773600101470947
+3.8845999240875244,6.115499973297119
+7.4293999671936035,6.60699987411499
+6.3003997802734375,3.9921000003814697
+7.903500080108643,6.307300090789795
+3.208199977874756,6.548900127410889
+2.078700065612793,7.018899917602539
+7.5802998542785645,7.344299793243408
+6.981400012969971,7.213200092315674
+6.9593000411987305,6.086699962615967
+7.682600021362305,3.8201000690460205
+2.4165000915527344,6.874000072479248
+3.452199935913086,2.009500026702881
+7.562600135803223,2.858799934387207
+7.6996002197265625,3.7107999324798584
+3.7692999839782715,7.841800212860107
+7.906899929046631,3.7227001190185547
+7.05019998550415,2.2012999057769775
+6.180600166320801,2.8980000019073486
+3.580699920654297,7.499899864196777
+6.945700168609619,6.698699951171875
+7.280300140380859,6.3557000160217285
+2.6435999870300293,7.64870023727417
+6.340199947357178,7.26200008392334
+2.9312000274658203,6.268899917602539
+6.121699810028076,2.4433999061584473
+7.1269001960754395,7.306099891662598
+3.6814000606536865,6.787399768829346
+7.846099853515625,7.692399978637695
+7.968599796295166,3.5773000717163086
+7.042300224304199,3.5905001163482666
+3.9765000343322754,3.668600082397461
+3.0571000576019287,2.0439999103546143
+3.676300048828125,3.452500104904175
+2.2941999435424805,6.773600101470947
+2.0750999450683594,3.4758999347686768
+2.859800100326538,6.5432000160217285
+6.443600177764893,2.906899929046631
+7.389500141143799,2.7600998878479004
+2.5309998989105225,7.122399806976318
+7.405200004577637,3.388200044631958
+3.905400037765503,7.2677001953125
+6.52810001373291,2.163599967956543
+2.507699966430664,6.320199966430664
+2.7211999893188477,2.495800018310547
+6.644899845123291,6.898200035095215
+7.939199924468994,2.200900077819824
+6.826700210571289,3.96370005607605
+6.429699897766113,2.3241000175476074
+7.933000087738037,2.7105000019073486
+2.5796000957489014,6.081699848175049
+3.5578999519348145,7.047599792480469
+7.427000045776367,7.025100231170654
+6.194799900054932,3.8922998905181885
+2.8080999851226807,2.068700075149536
+7.7530999183654785,3.3668999671936035
+3.4412999153137207,7.258999824523926
+7.479700088500977,7.3196001052856445
+2.5922999382019043,3.058000087738037
+3.3357999324798584,3.5966999530792236
+7.2631001472473145,2.21589994430542
+2.806299924850464,3.121500015258789
+2.9435999393463135,7.49370002746582
+3.2492001056671143,7.291399955749512
+7.133900165557861,6.145899772644043
+6.143899917602539,3.521699905395508
+7.594600200653076,6.719600200653076
+7.16540002822876,6.940999984741211
+6.43310022354126,6.559599876403809
+2.8296000957489014,2.3584001064300537
+6.496500015258789,2.7995998859405518
+7.9268999099731445,3.9137001037597656
+2.810800075531006,3.022200107574463
+3.178100109100342,6.029099941253662
+7.866300106048584,3.9344000816345215
+6.610899925231934,2.597100019454956
+2.7797999382019043,7.019599914550781
+6.9430999755859375,6.469699859619141
+3.372299909591675,6.127699851989746
+6.222499847412109,6.622300148010254
+7.834799766540527,7.471499919891357
+3.9270999431610107,7.186999797821045
+3.8364999294281006,2.955399990081787
+2.2627999782562256,3.8503000736236572
+3.0081000328063965,2.770400047302246
+7.556700229644775,2.575500011444092
+3.6549999713897705,2.4228999614715576
+2.677500009536743,6.166800022125244
+7.718299865722656,2.933199882507324
+3.6826000213623047,6.3653998374938965
+7.3531999588012695,7.073599815368652
+7.1296000480651855,3.8197999000549316

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/core_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/core_1.mrql b/tests/queries/core_1.mrql
new file mode 100644
index 0000000..50794d7
--- /dev/null
+++ b/tests/queries/core_1.mrql
@@ -0,0 +1,39 @@
+[1,2,3,4][2];
+
+[1..1000][10:20];
+
+[1,2]+[1,2,3];
+
+{("a",1),("b",2)}["a"];
+
+store xx := Node("a",{("x","1")},[Node("b",{},[CData("text")])]);
+
+xx.b;
+
+toInt(xx.@x)+1;
+
+1 as long;
+
+1 as double;
+
+store x := [xml| <a A="2"><b>1</b><b>2</b></a> |];
+
+x.b;
+
+[xml| <a><b>10</b>{{(x.b)[0]}}</a> |];
+
+min({1,2,3});
+
+max({1.2,3.4});
+
+min({1.3 as double,4.8 as double});
+
+count({1,2,3});
+
+sum({1.2,3.4});
+
+avg({1,2,3});
+
+avg({1.2,3.4});
+
+avg({1.3 as double,4.8 as double});

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/distinct_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/distinct_1.mrql b/tests/queries/distinct_1.mrql
new file mode 100644
index 0000000..4118729
--- /dev/null
+++ b/tests/queries/distinct_1.mrql
@@ -0,0 +1,4 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select distinct o.CUSTKEY from o in O;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/group_by_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/group_by_1.mrql b/tests/queries/group_by_1.mrql
new file mode 100644
index 0000000..8210e02
--- /dev/null
+++ b/tests/queries/group_by_1.mrql
@@ -0,0 +1,6 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (k,sum(o.TOTALPRICE))
+ from o in O
+ group by k: o.CUSTKEY;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/group_by_having_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/group_by_having_1.mrql b/tests/queries/group_by_having_1.mrql
new file mode 100644
index 0000000..07ba883
--- /dev/null
+++ b/tests/queries/group_by_having_1.mrql
@@ -0,0 +1,7 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (k,sum(o.TOTALPRICE))
+ from o in O
+ group by k: o.CUSTKEY
+ having sum(o.TOTALPRICE) > 10000;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/group_by_order_by_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/group_by_order_by_1.mrql b/tests/queries/group_by_order_by_1.mrql
new file mode 100644
index 0000000..0652c84
--- /dev/null
+++ b/tests/queries/group_by_order_by_1.mrql
@@ -0,0 +1,8 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+
+select (key,count(p),avg(p))
+from <CUSTKEY:k,TOTALPRICE:p> in O
+group by key: k
+order by inv(count(p));

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/group_by_order_by_2.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/group_by_order_by_2.mrql b/tests/queries/group_by_order_by_2.mrql
new file mode 100644
index 0000000..6ac726d
--- /dev/null
+++ b/tests/queries/group_by_order_by_2.mrql
@@ -0,0 +1,7 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (key,avg(p))
+ from <CUSTKEY:k,TOTALPRICE:p> in O
+ group by key: k
+ order by inv(count(p));

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/join_group_by_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/join_group_by_1.mrql b/tests/queries/join_group_by_1.mrql
new file mode 100644
index 0000000..28e02d4
--- /dev/null
+++ b/tests/queries/join_group_by_1.mrql
@@ -0,0 +1,8 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (k,sum(o.TOTALPRICE))
+ from o in O,
+      c in C
+ where o.CUSTKEY=c.CUSTKEY
+ group by k: c.NAME;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/join_group_by_2.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/join_group_by_2.mrql b/tests/queries/join_group_by_2.mrql
new file mode 100644
index 0000000..a975bc0
--- /dev/null
+++ b/tests/queries/join_group_by_2.mrql
@@ -0,0 +1,8 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (k,sum(o.TOTALPRICE))
+ from o in O,
+      c in C
+ where o.CUSTKEY=c.CUSTKEY
+ group by k: c.CUSTKEY;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/join_group_by_3.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/join_group_by_3.mrql b/tests/queries/join_group_by_3.mrql
new file mode 100644
index 0000000..9634f41
--- /dev/null
+++ b/tests/queries/join_group_by_3.mrql
@@ -0,0 +1,8 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (k#1,avg(o.TOTALPRICE))
+ from o in O,
+      c in C
+ where o.CUSTKEY=c.CUSTKEY
+ group by k: (c.CUSTKEY,c.NAME);

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/join_order_by_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/join_order_by_1.mrql b/tests/queries/join_order_by_1.mrql
new file mode 100644
index 0000000..7d50a4d
--- /dev/null
+++ b/tests/queries/join_order_by_1.mrql
@@ -0,0 +1,6 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string,ADDRESS:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select <N: c.NAME, A: avg(select o.TOTALPRICE from o in O where o.CUSTKEY=c.CUSTKEY)>
+ from c in C
+ order by c.ADDRESS;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/joins_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/joins_1.mrql b/tests/queries/joins_1.mrql
new file mode 100644
index 0000000..369436c
--- /dev/null
+++ b/tests/queries/joins_1.mrql
@@ -0,0 +1,40 @@
+E = source(line,"tests/data/employee.txt",",",type(<name:string,dno:int,address:string>));
+D = source(line,"tests/data/department.txt",",",type(<name:string,dno:int>));
+
+select e.name from e in E where e.dno=10;
+
+sum(select e.dno from e in E);
+
+select n from <dno:10,name:n> in E;
+
+select e.dno+11 from e in E;
+
+select (e.name,d.name) from e in E, d in D where e.dno=d.dno;
+
+select (e.name,d.name) from e in E, d in D where e.dno=d.dno and e.name="John Smith";
+
+select (e.name,d.name) from e in E, d in D where e.dno=d.dno and e.name="John Smith" and d.name="CSE";
+
+select d.name from d in D where all e in (select e from e in E where e.dno=d.dno): e.address="a";
+
+select d.name from d in D where all(select e.address="a" from e in E where e.dno=d.dno);
+
+select e from e in E order by inv(e.dno);
+
+select e from e in E order by e.address;
+
+select (e.name,d.name) from e in E, d in D where e.dno=d.dno order by e.address;
+
+select (k,e) from e in E group by k: e.dno;
+
+(select (k,e) from e in E group by k: e.dno order by k)[1];
+
+(select (k,e) from e in E group by k: e.dno)[10];
+
+(select e from e in E order by e.dno)[1:2];
+
+select (k,e) from e in E group by k: e.dno order by inv(k);
+
+select (k,count(e)) from e in E group by k: e.dno order by count(e);
+
+all e in E: e.dno > 1;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/kmeans_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/kmeans_1.mrql b/tests/queries/kmeans_1.mrql
new file mode 100644
index 0000000..42c255b
--- /dev/null
+++ b/tests/queries/kmeans_1.mrql
@@ -0,0 +1,27 @@
+type point = < X: double, Y: double >;
+
+function distance ( x: point, y: point ): double {
+   sqrt(pow(x.X-y.X,2)+pow(x.Y-y.Y,2))
+};
+
+aggregation new_centroid (
+      \(p:(point,long),q:(point,long)):(point,long)
+                .( < X: p#0.X+q#0.X, Y: p#0.Y+q#0.Y >,
+                   p#1+q#1),
+      ( < X: 0.0 as double, Y :0.0 as double >, 0 as long )
+    ) : (point,long);
+
+function centroid ( p: (point,long), default: point ): point {
+   if p#1 = 0
+      then default
+      else < X: p#0.X/p#1, Y: p#0.Y/p#1 >
+};
+
+repeat centroids = { < X: 0.0 as double, Y: 0.0 as double >,
+                     < X: 10.0, Y: 0.0 >,
+                     < X: 0.0, Y: 10.0 >,
+                     < X: 10.0, Y: 10.0 > }
+  step select ( centroid(new_centroid(select (p,1 as long) from p in s),k), true )
+         from s in source(line,"tests/data/points.txt",",",type( < X: double, Y: double > ))
+        group by k: (select c from c in centroids order by distance(c,s))[0]
+  limit 2;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/matrix_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/matrix_1.mrql b/tests/queries/matrix_1.mrql
new file mode 100644
index 0000000..e7a619a
--- /dev/null
+++ b/tests/queries/matrix_1.mrql
@@ -0,0 +1,59 @@
+Xvector = source(line,"tests/data/Xvector.txt",",",type( (double,long) ));
+Yvector = source(line,"tests/data/Yvector.txt",",",type( (double,long) ));
+Xmatrix = source(line,"tests/data/Xmatrix.txt",",",type( (double,long,long) ));
+Ymatrix = source(line,"tests/data/Ymatrix.txt",",",type( (double,long,long) ));
+
+
+// inner product:
+
+sum(select v*w
+      from (v,i) in Xvector,
+           (w,i) in Yvector);
+
+// matrix addition:
+
+select ( x+y, i, j )
+  from (x,i,j) in Xmatrix,
+       (y,i,j) in Ymatrix;
+
+// matrix transpose:
+
+macro transpose ( X ) {
+  select (x,j,i)
+    from (x,i,j) in X
+};
+
+transpose(Xmatrix);
+
+// map to a vector:
+
+select (sum(x),i)
+  from (x,i,j) in Xmatrix
+ group by i;
+
+// matrix multiplication #1:
+
+macro multiply ( X, Y ) {
+  select (sum(z),i,j)
+    from (x,i,k) in X, (y,k,j) in Y, z = x*y
+   group by (i,j)
+};
+
+multiply(Xmatrix,transpose(Ymatrix));
+
+// matrix multiplication #2:
+
+select (sum(select p.x*p.y from p in partition),i,j)
+  from (x,i,k) in Xmatrix,
+       (y,k,j) in Ymatrix
+ group by (i,j);
+
+// matrix-vector product:
+
+macro MVprod ( M, V ) {
+  select ( sum(z), i )
+    from (m,i,j) in M, (v,j) in V, z = m*v
+   group by i
+};
+
+MVprod(Xmatrix,Xvector);

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/nested_select_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/nested_select_1.mrql b/tests/queries/nested_select_1.mrql
new file mode 100644
index 0000000..396f956
--- /dev/null
+++ b/tests/queries/nested_select_1.mrql
@@ -0,0 +1,7 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (c.NAME,avg(select o.TOTALPRICE
+                     from o in O
+                    where o.CUSTKEY=c.CUSTKEY))
+  from c in C;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/order_by_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/order_by_1.mrql b/tests/queries/order_by_1.mrql
new file mode 100644
index 0000000..e652d24
--- /dev/null
+++ b/tests/queries/order_by_1.mrql
@@ -0,0 +1,6 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (o.CUSTKEY,o.TOTALPRICE)
+ from o in O
+ order by o.TOTALPRICE;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/pagerank_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/pagerank_1.mrql b/tests/queries/pagerank_1.mrql
new file mode 100644
index 0000000..9fb5d14
--- /dev/null
+++ b/tests/queries/pagerank_1.mrql
@@ -0,0 +1,24 @@
+// preprocessing: for each node, group its outgoing links into a bag
+graph = select (key,n#1)
+          from n in source(line,"tests/data/graph.txt",",",type( (int,int) ))
+         group by key: n#0;
+
+store graph_size := 1000;
+
+// damping factor
+factor = 0.85;
+
+select < node: x.id, rank: x.rank >
+from x in (repeat nodes = select < id: key, rank: 1.0/graph_size as double, adjacent: al >
+                            from (key,al) in graph
+             step select (< id: m.id, rank: n.rank, adjacent: m.adjacent >,
+                          abs((n.rank-m.rank)/m.rank) > 0.1)
+                    from n in (select < id: key,
+                                        rank: (1-factor)/graph_size+factor*sum(select x.rank from x in c) >
+                                 from c in ( select < id: a, rank: n.rank/count(n.adjacent) >
+                                               from n in nodes, a in n.adjacent )
+                                group by key: c.id),
+                         m in nodes
+                   where n.id = m.id
+            limit 2)
+order by x.rank desc;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/relational_join_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/relational_join_1.mrql b/tests/queries/relational_join_1.mrql
new file mode 100644
index 0000000..13d8872
--- /dev/null
+++ b/tests/queries/relational_join_1.mrql
@@ -0,0 +1,7 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+select (c.NAME,o.TOTALPRICE)
+ from o in O,
+      c in C
+where o.CUSTKEY=c.CUSTKEY;

http://git-wip-us.apache.org/repos/asf/incubator-mrql/blob/33c9361b/tests/queries/total_aggregation_1.mrql
----------------------------------------------------------------------
diff --git a/tests/queries/total_aggregation_1.mrql b/tests/queries/total_aggregation_1.mrql
new file mode 100644
index 0000000..282677a
--- /dev/null
+++ b/tests/queries/total_aggregation_1.mrql
@@ -0,0 +1,4 @@
+C = source(line,"tests/data/customer.tbl","|",type(<CUSTKEY:int,NAME:string>));
+O = source(line,"tests/data/orders.tbl","|",type(<ORDERKEY:string,CUSTKEY:int,ORDERSTATUS:any,TOTALPRICE:float>));
+
+count(O);