Changeset: 56ecf2ec76e4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=56ecf2ec76e4
Added Files:
sql/test/delete-from-value-list/.monetdb
sql/test/delete-from-value-list/debugpath.txt
sql/test/delete-from-value-list/delete-query.sql
sql/test/delete-from-value-list/generate-query.py
sql/test/delete-from-value-list/init.sh
sql/test/delete-from-value-list/init.sql
sql/test/delete-from-value-list/server.pid
sql/test/delete-from-value-list/start.sh
sql/test/delete-from-value-list/stop.sh
Modified Files:
sql/test/delete-from-value-list/Tests/delete-from-value-list.py
Branch: delete_in_vlist
Log Message:
Add personal development tools for safety.
diffs (208 lines):
diff --git a/sql/test/delete-from-value-list/.monetdb
b/sql/test/delete-from-value-list/.monetdb
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/.monetdb
@@ -0,0 +1,2 @@
+user=monetdb
+password=monetdb
diff --git a/sql/test/delete-from-value-list/Tests/delete-from-value-list.py
b/sql/test/delete-from-value-list/Tests/delete-from-value-list.py
--- a/sql/test/delete-from-value-list/Tests/delete-from-value-list.py
+++ b/sql/test/delete-from-value-list/Tests/delete-from-value-list.py
@@ -21,7 +21,7 @@ def client(lang, file):
def delete_where_in_mega_value_list_query_statement(size, period):
values = [str(x) for x in range(0, size-1) if x % period == 0]
- return "delete from table1 where id in ({});select count(*) from
table1;".format(','.join(values))
+ return "delete from table1 where id in ({});".format(','.join(values))
def main():
srv = server_start([])
diff --git a/sql/test/delete-from-value-list/debugpath.txt
b/sql/test/delete-from-value-list/debugpath.txt
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/debugpath.txt
@@ -0,0 +1,103 @@
+mal_scenario.c:runScenarioBody(cleint c, int once)
+ In this functions where going to loop multiple times over a couple of
phases:
+ initclient, reader, parser, optimize, scheduler, engine, repeat...
+
+sql_scenario.c:SQLparser (first run)
+ We start with a Client c
+ we instantiate local references to the client's in- and outputstream
(in = c->fdin, out = c->fdout)
+
+ c has sqlcontext of type backend (be = c->sqlcontext)
+ c has a malblock (c->curprg->def)
+
+ we define a local reference m to the mvc(whatever that is) of the
backend (sqlcontext) of the client
+ and later on we intialize it with a sqlallocator(whatever that is)
(m->sa = sa_create())
+ be-> language is set to 'X'
+ and it seems that the first string in the inputstream in contains
"Xreply_size 100\n"
+ mvc->reply_size is initialized with this value.
+ then we exit and return to the loop in mal_scenario.
+
+
+
+sql_scenario.c:SQLparser (second run)
+ In the second run the input stream is "Xreply_size -1\n"
+
+
+sql_scenario.c:SQLparser (third run)
+ In the third run the input stream the language is 'S'
+ we start a sqltransaction (SQLtrans(m);)
+ we assign a sql_allocator (m->sa = sa_create();)
+ we finally are going to parse the actual query (if( (err = sqlparse(m))
|| )
+
+
+sqlparse:
+ This part is done by the yacc created parser based on sql_parser.y
grammar.
+ specificallt for keyword 'IN' (in_predicate : pred_exp sqlIN '('
value_commalist ')')
+ we initialize a list l;
+ we associate symbol pred_expr(which seems to be the name of the
column) with the list value_commalist to l
+ we create and return a symbol representing a tuple of the form
("SQL_IN", l);
+ delete seems to be done in the delete_stmt: sqlDELETE FROM qname
opt_where_clause(pred_exp)
+ we initialize a dlist l;
+ we append the name of the relation and the where_clause
(pred_exp with in) to l;
+ and we create and return a symbol from tuple (SQL_DELETE, l),
i.e. we get something like
+ SQL_DELETE(symbol)
+ - qname(a list because it can concern multiple
relations)
+ - pred_exp()
+
+ in symbol_create_list (sql_symbol.c)
+ we allocate a symbol s
+ initialize s with the token(id)
+ we add the list field (data) of type dlist to s (s->data.lval
= data)
+
+ dlist_append_list
+ creates a dnode of type list where dnode has a union type
member and sets a pointer to the data(of type dlist) to be appended
+ that dnode is then added to dlist in a linked list way.
+ Samething for dlist_append_symbol Only the type is now symbol.
+
+
+
+
+rel_updates(mvc* sql, symbol* s):
+ This is where the function seems to start understanding the semantics
of a delete statement (switch s->token: ... case SQL_DELETE:)
+ it takes out the pred_exp associated with s (l = s->data.lval;)
+ and finally performs (or prepares?) a delete statement (ret =
delete_table(sql, l->h->data.lval, l->h->next->data.sym);)
+
+
+
+
+
+
+
+
+sql_execute.c:SQLrun
+ we have two malblkptr's mc, mb
+ and one Instrptr p
+ mb is set to Client c->curprg->def and later it is replaced with
+ mb = copyMalBlk(c->curprg->def) // locate and inline the query template
instruction
+ in mb the the stop is 3
+
+ mb should have an instructionptr
+
+ this instruction pointer's malblockptr is copied to mc (mc =
copyMalBlk(p->blk))
+ the original mb is freed (freeMalBlk(mb))
+
+ so mb seems to consist of 3 instructions (mb->stop is 3)
+
+
+ One by one each instruction is copied to p (p = GetInstrPtr(mb, i));
+ the first instruction pointer has name function name "s0 1"
+
+ it sho
+
+
+ so it seems you start with a malblock mb consisting of a (couple of)
instruction(s)
+ you pick the first instruction
+ you take out the inner blk which is also a MALBLOCK and store a pointer
to this inner malblock in mb
+
+ we then optimize the query (msg = SQLoptimizeQuery(c, mb);)
+
+ At some point we get a sql optimizer in the form of string
called a 'pipe' from getSQLoptimizer.
+ This is based on the sql mvc (whatever that is, seems to deal
with the sql query and user session)
+ we can then finally start to optimize the query (parse the
query?) (msg = optimizeMalBlock(c, mb))
+
+
+
diff --git a/sql/test/delete-from-value-list/delete-query.sql
b/sql/test/delete-from-value-list/delete-query.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/delete-query.sql
@@ -0,0 +1,1 @@
+delete from table1 where id in
(0,100,200,300,400,500,600,700,800,900,1000,1100,1200,1300,1400,1500,1600,1700,1800,1900,2000,2100,2200,2300,2400,2500,2600,2700,2800,2900,3000,3100,3200,3300,3400,3500,3600,3700,3800,3900,4000,4100,4200,4300,4400,4500,4600,4700,4800,4900,5000,5100,5200,5300,5400,5500,5600,5700,5800,5900,6000,6100,6200,6300,6400,6500,6600,6700,6800,6900,7000,7100,7200,7300,7400,7500,7600,7700,7800,7900,8000,8100,8200,8300,8400,8500,8600,8700,8800,8900,9000,9100,9200,9300,9400,9500,9600,9700,9800,9900,10000,10100,10200,10300,10400,10500,10600,10700,10800,10900,11000,11100,11200,11300,11400,11500,11600,11700,11800,11900,12000,12100,12200,12300,12400,12500,12600,12700,12800,12900,13000,13100,13200,13300,13400,13500,13600,13700,13800,13900,14000,14100,14200,14300,14400,14500,14600,14700,14800,14900,15000,15100,15200,15300,15400,15500,15600,15700,15800,15900,16000,16100,16200,16300,16400,16500,16600,16700,16800,16900,17000,17100,17200,17300,17400,17500,17600,17700,17800,179
00,18000,18100,18200,18300,18400,18500,18600,18700,18800,18900,19000,19100,19200,19300,19400,19500,19600,19700,19800,19900,20000,20100,20200,20300,20400,20500,20600,20700,20800,20900,21000,21100,21200,21300,21400,21500,21600,21700,21800,21900,22000,22100,22200,22300,22400,22500,22600,22700,22800,22900,23000,23100,23200,23300,23400,23500,23600,23700,23800,23900,24000,24100,24200,24300,24400,24500,24600,24700,24800,24900,25000,25100,25200,25300,25400,25500,25600,25700,25800,25900,26000,26100,26200,26300,26400,26500,26600,26700,26800,26900,27000,27100,27200,27300,27400,27500,27600,27700,27800,27900,28000,28100,28200,28300,28400,28500,28600,28700,28800,28900,29000,29100,29200,29300,29400,29500,29600,29700,29800,29900,30000,30100,30200,30300,30400,30500,30600,30700,30800,30900,31000,31100,31200,31300,31400,31500,31600,31700,31800,31900,32000,32100,32200,32300,32400,32500,32600,32700,32800,32900,33000,33100,33200,33300,33400,33500,33600,33700,33800,33900,34000,34100,34200,34300,34400,3450
0,34600,34700,34800,34900,35000,35100,35200,35300,35400,35500,35600,35700,35800,35900,36000,36100,36200,36300,36400,36500,36600,36700,36800,36900,37000,37100,37200,37300,37400,37500,37600,37700,37800,37900,38000,38100,38200,38300,38400,38500,38600,38700,38800,38900,39000,39100,39200,39300,39400,39500,39600,39700,39800,39900,40000,40100,40200,40300,40400,40500,40600,40700,40800,40900,41000,41100,41200,41300,41400,41500,41600,41700,41800,41900,42000,42100,42200,42300,42400,42500,42600,42700,42800,42900,43000,43100,43200,43300,43400,43500,43600,43700,43800,43900,44000,44100,44200,44300,44400,44500,44600,44700,44800,44900,45000,45100,45200,45300,45400,45500,45600,45700,45800,45900,46000,46100,46200,46300,46400,46500,46600,46700,46800,46900,47000,47100,47200,47300,47400,47500,47600,47700,47800,47900,48000,48100,48200,48300,48400,48500,48600,48700,48800,48900,49000,49100,49200,49300,49400,49500,49600,49700,49800,49900,50000,50100,50200,50300,50400,50500,50600,50700,50800,50900,51000,51100
,51200,51300,51400,51500,51600,51700,51800,51900,52000,52100,52200,52300,52400,52500,52600,52700,52800,52900,53000,53100,53200,53300,53400,53500,53600,53700,53800,53900,54000,54100,54200,54300,54400,54500,54600,54700,54800,54900,55000,55100,55200,55300,55400,55500,55600,55700,55800,55900,56000,56100,56200,56300,56400,56500,56600,56700,56800,56900,57000,57100,57200,57300,57400,57500,57600,57700,57800,57900,58000,58100,58200,58300,58400,58500,58600,58700,58800,58900,59000,59100,59200,59300,59400,59500,59600,59700,59800,59900,60000,60100,60200,60300,60400,60500,60600,60700,60800,60900,61000,61100,61200,61300,61400,61500,61600,61700,61800,61900,62000,62100,62200,62300,62400,62500,62600,62700,62800,62900,63000,63100,63200,63300,63400,63500,63600,63700,63800,63900,64000,64100,64200,64300,64400,64500,64600,64700,64800,64900,65000,65100,65200,65300,65400,65500,65600,65700,65800,65900,66000,66100,66200,66300,66400,66500,66600,66700,66800,66900,67000,67100,67200,67300,67400,67500,67600,67700,
67800,67900,68000,68100,68200,68300,68400,68500,68600,68700,68800,68900,69000,69100,69200,69300,69400,69500,69600,69700,69800,69900,70000,70100,70200,70300,70400,70500,70600,70700,70800,70900,71000,71100,71200,71300,71400,71500,71600,71700,71800,71900,72000,72100,72200,72300,72400,72500,72600,72700,72800,72900,73000,73100,73200,73300,73400,73500,73600,73700,73800,73900,74000,74100,74200,74300,74400,74500,74600,74700,74800,74900,75000,75100,75200,75300,75400,75500,75600,75700,75800,75900,76000,76100,76200,76300,76400,76500,76600,76700,76800,76900,77000,77100,77200,77300,77400,77500,77600,77700,77800,77900,78000,78100,78200,78300,78400,78500,78600,78700,78800,78900,79000,79100,79200,79300,79400,79500,79600,79700,79800,79900,80000,80100,80200,80300,80400,80500,80600,80700,80800,80900,81000,81100,81200,81300,81400,81500,81600,81700,81800,81900,82000,82100,82200,82300,82400,82500,82600,82700,82800,82900,83000,83100,83200,83300,83400,83500,83600,83700,83800,83900,84000,84100,84200,84300,8
4400,84500,84600,84700,84800,84900,85000,85100,85200,85300,85400,85500,85600,85700,85800,85900,86000,86100,86200,86300,86400,86500,86600,86700,86800,86900,87000,87100,87200,87300,87400,87500,87600,87700,87800,87900,88000,88100,88200,88300,88400,88500,88600,88700,88800,88900,89000,89100,89200,89300,89400,89500,89600,89700,89800,89900,90000,90100,90200,90300,90400,90500,90600,90700,90800,90900,91000,91100,91200,91300,91400,91500,91600,91700,91800,91900,92000,92100,92200,92300,92400,92500,92600,92700,92800,92900,93000,93100,93200,93300,93400,93500,93600,93700,93800,93900,94000,94100,94200,94300,94400,94500,94600,94700,94800,94900,95000,95100,95200,95300,95400,95500,95600,95700,95800,95900,96000,96100,96200,96300,96400,96500,96600,96700,96800,96900,97000,97100,97200,97300,97400,97500,97600,97700,97800,97900,98000,98100,98200,98300,98400,98500,98600,98700,98800,98900,99000,99100,99200,99300,99400,99500,99600,99700,99800,99900,100000,100100,100200,100300,100400,100500,100600,100700,100800
,100900,101000,101100,101200,101300,101400,101500,101600,101700,101800,101900,102000,102100,102200,102300,102400,102500,102600,102700,102800,102900,103000,103100,103200,103300,103400,103500,103600,103700,103800,103900,104000,104100,104200,104300,104400,104500,104600,104700,104800,104900,105000,105100,105200,105300,105400,105500,105600,105700,105800,105900,106000,106100,106200,106300,106400,106500,106600,106700,106800,106900,107000,107100,107200,107300,107400,107500,107600,107700,107800,107900,108000,108100,108200,108300,108400,108500,108600,108700,108800,108900,109000,109100,109200,109300,109400,109500,109600,109700,109800,109900,110000,110100,110200,110300,110400,110500,110600,110700,110800,110900,111000,111100,111200,111300,111400,111500,111600,111700,111800,111900,112000,112100,112200,112300,112400,112500,112600,112700,112800,112900,113000,113100,113200,113300,113400,113500,113600,113700,113800,113900,114000,114100,114200,114300,114400,114500,114600,114700,114800,114900,115000,11
5100,115200,115300,115400,115500,115600,115700,115800,115900,116000,116100,116200,116300,116400,116500,116600,116700,116800,116900,117000,117100,117200,117300,117400,117500,117600,117700,117800,117900,118000,118100,118200,118300,118400,118500,118600,118700,118800,118900,119000,119100,119200,119300,119400,119500,119600,119700,119800,119900,120000,120100,120200,120300,120400,120500,120600,120700,120800,120900,121000,121100,121200,121300,121400,121500,121600,121700,121800,121900,122000,122100,122200,122300,122400,122500,122600,122700,122800,122900,123000,123100,123200,123300,123400,123500,123600,123700,123800,123900,124000,124100,124200,124300,124400,124500,124600,124700,124800,124900,125000,125100,125200,125300,125400,125500,125600,125700,125800,125900,126000,126100,126200,126300,126400,126500,126600,126700,126800,126900,127000,127100,127200,127300,127400,127500,127600,127700,127800,127900,128000,128100,128200,128300,128400,128500,128600,128700,128800,128900,129000,129100,129200,12930
0,129400,129500,129600,129700,129800,129900,130000,130100,130200,130300,130400,130500,130600,130700,130800,130900,131000,131100,131200,131300,131400,131500,131600,131700,131800,131900,132000,132100,132200,132300,132400,132500,132600,132700,132800,132900,133000,133100,133200,133300,133400,133500,133600,133700,133800,133900,134000,134100,134200,134300,134400,134500,134600,134700,134800,134900,135000,135100,135200,135300,135400,135500,135600,135700,135800,135900,136000,136100,136200,136300,136400,136500,136600,136700,136800,136900,137000,137100,137200,137300,137400,137500,137600,137700,137800,137900,138000,138100,138200,138300,138400,138500,138600,138700,138800,138900,139000,139100,139200,139300,139400,139500,139600,139700,139800,139900,140000,140100,140200,140300,140400,140500,140600,140700,140800,140900,141000,141100,141200,141300,141400,141500,141600,141700,141800,141900,142000,142100,142200,142300,142400,142500,142600,142700,142800,142900,143000,143100,143200,143300,143400,143500,1
43600,143700,143800,143900,144000,144100,144200,144300,144400,144500,144600,144700,144800,144900,145000,145100,145200,145300,145400,145500,145600,145700,145800,145900,146000,146100,146200,146300,146400,146500,146600,146700,146800,146900,147000,147100,147200,147300,147400,147500,147600,147700,147800,147900,148000,148100,148200,148300,148400,148500,148600,148700,148800,148900,149000,149100,149200,149300,149400,149500,149600,149700,149800,149900,150000,150100,150200,150300,150400,150500,150600,150700,150800,150900,151000,151100,151200,151300,151400,151500,151600,151700,151800,151900,152000,152100,152200,152300,152400,152500,152600,152700,152800,152900,153000,153100,153200,153300,153400,153500,153600,153700,153800,153900,154000,154100,154200,154300,154400,154500,154600,154700,154800,154900,155000,155100,155200,155300,155400,155500,155600,155700,155800,155900,156000,156100,156200,156300,156400,156500,156600,156700,156800,156900,157000,157100,157200,157300,157400,157500,157600,157700,1578
00,157900,158000,158100,158200,158300,158400,158500,158600,158700,158800,158900,159000,159100,159200,159300,159400,159500,159600,159700,159800,159900,160000,160100,160200,160300,160400,160500,160600,160700,160800,160900,161000,161100,161200,161300,161400,161500,161600,161700,161800,161900,162000,162100,162200,162300,162400,162500,162600,162700,162800,162900,163000,163100,163200,163300,163400,163500,163600,163700,163800,163900,164000,164100,164200,164300,164400,164500,164600,164700,164800,164900,165000,165100,165200,165300,165400,165500,165600,165700,165800,165900,166000,166100,166200,166300,166400,166500,166600,166700,166800,166900,167000,167100,167200,167300,167400,167500,167600,167700,167800,167900,168000,168100,168200,168300,168400,168500,168600,168700,168800,168900,169000,169100,169200,169300,169400,169500,169600,169700,169800,169900,170000,170100,170200,170300,170400,170500,170600,170700,170800,170900,171000,171100,171200,171300,171400,171500,171600,171700,171800,171900,172000,
172100,172200,172300,172400,172500,172600,172700,172800,172900,173000,173100,173200,173300,173400,173500,173600,173700,173800,173900,174000,174100,174200,174300,174400,174500,174600,174700,174800,174900,175000,175100,175200,175300,175400,175500,175600,175700,175800,175900,176000,176100,176200,176300,176400,176500,176600,176700,176800,176900,177000,177100,177200,177300,177400,177500,177600,177700,177800,177900,178000,178100,178200,178300,178400,178500,178600,178700,178800,178900,179000,179100,179200,179300,179400,179500,179600,179700,179800,179900,180000,180100,180200,180300,180400,180500,180600,180700,180800,180900,181000,181100,181200,181300,181400,181500,181600,181700,181800,181900,182000,182100,182200,182300,182400,182500,182600,182700,182800,182900,183000,183100,183200,183300,183400,183500,183600,183700,183800,183900,184000,184100,184200,184300,184400,184500,184600,184700,184800,184900,185000,185100,185200,185300,185400,185500,185600,185700,185800,185900,186000,186100,186200,186
300,186400,186500,186600,186700,186800,186900,187000,187100,187200,187300,187400,187500,187600,187700,187800,187900,188000,188100,188200,188300,188400,188500,188600,188700,188800,188900,189000,189100,189200,189300,189400,189500,189600,189700,189800,189900,190000,190100,190200,190300,190400,190500,190600,190700,190800,190900,191000,191100,191200,191300,191400,191500,191600,191700,191800,191900,192000,192100,192200,192300,192400,192500,192600,192700,192800,192900,193000,193100,193200,193300,193400,193500,193600,193700,193800,193900,194000,194100,194200,194300,194400,194500,194600,194700,194800,194900,195000,195100,195200,195300,195400,195500,195600,195700,195800,195900,196000,196100,196200,196300,196400,196500,196600,196700,196800,196900,197000,197100,197200,197300,197400,197500,197600,197700,197800,197900,198000,198100,198200,198300,198400,198500,198600,198700,198800,198900,199000,199100,199200,199300,199400,199500,199600,199700,199800,199900,200000,200100,200200,200300,200400,200500
,200600,200700,200800,200900,201000,201100,201200,201300,201400,201500,201600,201700,201800,201900,202000,202100,202200,202300,202400,202500,202600,202700,202800,202900,203000,203100,203200,203300,203400,203500,203600,203700,203800,203900,204000,204100,204200,204300,204400,204500,204600,204700,204800,204900,205000,205100,205200,205300,205400,205500,205600,205700,205800,205900,206000,206100,206200,206300,206400,206500,206600,206700,206800,206900,207000,207100,207200,207300,207400,207500,207600,207700,207800,207900,208000,208100,208200,208300,208400,208500,208600,208700,208800,208900,209000,209100,209200,209300,209400,209500,209600,209700,209800,209900,210000,210100,210200,210300,210400,210500,210600,210700,210800,210900,211000,211100,211200,211300,211400,211500,211600,211700,211800,211900,212000,212100,212200,212300,212400,212500,212600,212700,212800,212900,213000,213100,213200,213300,213400,213500,213600,213700,213800,213900,214000,214100,214200,214300,214400,214500,214600,214700,21
4800,214900,215000,215100,215200,215300,215400,215500,215600,215700,215800,215900,216000,216100,216200,216300,216400,216500,216600,216700,216800,216900,217000,217100,217200,217300,217400,217500,217600,217700,217800,217900,218000,218100,218200,218300,218400,218500,218600,218700,218800,218900,219000,219100,219200,219300,219400,219500,219600,219700,219800,219900,220000,220100,220200,220300,220400,220500,220600,220700,220800,220900,221000,221100,221200,221300,221400,221500,221600,221700,221800,221900,222000,222100,222200,222300,222400,222500,222600,222700,222800,222900,223000,223100,223200,223300,223400,223500,223600,223700,223800,223900,224000,224100,224200,224300,224400,224500,224600,224700,224800,224900,225000,225100,225200,225300,225400,225500,225600,225700,225800,225900,226000,226100,226200,226300,226400,226500,226600,226700,226800,226900,227000,227100,227200,227300,227400,227500,227600,227700,227800,227900,228000,228100,228200,228300,228400,228500,228600,228700,228800,228900,22900
0,229100,229200,229300,229400,229500,229600,229700,229800,229900,230000,230100,230200,230300,230400,230500,230600,230700,230800,230900,231000,231100,231200,231300,231400,231500,231600,231700,231800,231900,232000,232100,232200,232300,232400,232500,232600,232700,232800,232900,233000,233100,233200,233300,233400,233500,233600,233700,233800,233900,234000,234100,234200,234300,234400,234500,234600,234700,234800,234900,235000,235100,235200,235300,235400,235500,235600,235700,235800,235900,236000,236100,236200,236300,236400,236500,236600,236700,236800,236900,237000,237100,237200,237300,237400,237500,237600,237700,237800,237900,238000,238100,238200,238300,238400,238500,238600,238700,238800,238900,239000,239100,239200,239300,239400,239500,239600,239700,239800,239900,240000,240100,240200,240300,240400,240500,240600,240700,240800,240900,241000,241100,241200,241300,241400,241500,241600,241700,241800,241900,242000,242100,242200,242300,242400,242500,242600,242700,242800,242900,243000,243100,243200,2
43300,243400,243500,243600,243700,243800,243900,244000,244100,244200,244300,244400,244500,244600,244700,244800,244900,245000,245100,245200,245300,245400,245500,245600,245700,245800,245900,246000,246100,246200,246300,246400,246500,246600,246700,246800,246900,247000,247100,247200,247300,247400,247500,247600,247700,247800,247900,248000,248100,248200,248300,248400,248500,248600,248700,248800,248900,249000,249100,249200,249300,249400,249500,249600,249700,249800,249900,250000,250100,250200,250300,250400,250500,250600,250700,250800,250900,251000,251100,251200,251300,251400,251500,251600,251700,251800,251900,252000,252100,252200,252300,252400,252500,252600,252700,252800,252900,253000,253100,253200,253300,253400,253500,253600,253700,253800,253900,254000,254100,254200,254300,254400,254500,254600,254700,254800,254900,255000,255100,255200,255300,255400,255500,255600,255700,255800,255900,256000,256100,256200,256300,256400,256500,256600,256700,256800,256900,257000,257100,257200,257300,257400,2575
00,257600,257700,257800,257900,258000,258100,258200,258300,258400,258500,258600,258700,258800,258900,259000,259100,259200,259300,259400,259500,259600,259700,259800,259900,260000,260100,260200,260300,260400,260500,260600,260700,260800,260900,261000,261100,261200,261300,261400,261500,261600,261700,261800,261900,262000,262100,262200,262300,262400,262500,262600,262700,262800,262900,263000,263100,263200,263300,263400,263500,263600,263700,263800,263900,264000,264100,264200,264300,264400,264500,264600,264700,264800,264900,265000,265100,265200,265300,265400,265500,265600,265700,265800,265900,266000,266100,266200,266300,266400,266500,266600,266700,266800,266900,267000,267100,267200,267300,267400,267500,267600,267700,267800,267900,268000,268100,268200,268300,268400,268500,268600,268700,268800,268900,269000,269100,269200,269300,269400,269500,269600,269700,269800,269900,270000,270100,270200,270300,270400,270500,270600,270700,270800,270900,271000,271100,271200,271300,271400,271500,271600,271700,
271800,271900,272000,272100,272200,272300,272400,272500,272600,272700,272800,272900,273000,273100,273200,273300,273400,273500,273600,273700,273800,273900,274000,274100,274200,274300,274400,274500,274600,274700,274800,274900,275000,275100,275200,275300,275400,275500,275600,275700,275800,275900,276000,276100,276200,276300,276400,276500,276600,276700,276800,276900,277000,277100,277200,277300,277400,277500,277600,277700,277800,277900,278000,278100,278200,278300,278400,278500,278600,278700,278800,278900,279000,279100,279200,279300,279400,279500,279600,279700,279800,279900,280000,280100,280200,280300,280400,280500,280600,280700,280800,280900,281000,281100,281200,281300,281400,281500,281600,281700,281800,281900,282000,282100,282200,282300,282400,282500,282600,282700,282800,282900,283000,283100,283200,283300,283400,283500,283600,283700,283800,283900,284000,284100,284200,284300,284400,284500,284600,284700,284800,284900,285000,285100,285200,285300,285400,285500,285600,285700,285800,285900,286
000,286100,286200,286300,286400,286500,286600,286700,286800,286900,287000,287100,287200,287300,287400,287500,287600,287700,287800,287900,288000,288100,288200,288300,288400,288500,288600,288700,288800,288900,289000,289100,289200,289300,289400,289500,289600,289700,289800,289900,290000,290100,290200,290300,290400,290500,290600,290700,290800,290900,291000,291100,291200,291300,291400,291500,291600,291700,291800,291900,292000,292100,292200,292300,292400,292500,292600,292700,292800,292900,293000,293100,293200,293300,293400,293500,293600,293700,293800,293900,294000,294100,294200,294300,294400,294500,294600,294700,294800,294900,295000,295100,295200,295300,295400,295500,295600,295700,295800,295900,296000,296100,296200,296300,296400,296500,296600,296700,296800,296900,297000,297100,297200,297300,297400,297500,297600,297700,297800,297900,298000,298100,298200,298300,298400,298500,298600,298700,298800,298900,299000,299100,299200,299300,299400,299500,299600,299700,299800,299900,300000,300100,300200
,300300,300400,300500,300600,300700,300800,300900,301000,301100,301200,301300,301400,301500,301600,301700,301800,301900,302000,302100,302200,302300,302400,302500,302600,302700,302800,302900,303000,303100,303200,303300,303400,303500,303600,303700,303800,303900,304000,304100,304200,304300,304400,304500,304600,304700,304800,304900,305000,305100,305200,305300,305400,305500,305600,305700,305800,305900,306000,306100,306200,306300,306400,306500,306600,306700,306800,306900,307000,307100,307200,307300,307400,307500,307600,307700,307800,307900,308000,308100,308200,308300,308400,308500,308600,308700,308800,308900,309000,309100,309200,309300,309400,309500,309600,309700,309800,309900,310000,310100,310200,310300,310400,310500,310600,310700,310800,310900,311000,311100,311200,311300,311400,311500,311600,311700,311800,311900,312000,312100,312200,312300,312400,312500,312600,312700,312800,312900,313000,313100,313200,313300,313400,313500,313600,313700,313800,313900,314000,314100,314200,314300,314400,31
4500,314600,314700,314800,314900,315000,315100,315200,315300,315400,315500,315600,315700,315800,315900,316000,316100,316200,316300,316400,316500,316600,316700,316800,316900,317000,317100,317200,317300,317400,317500,317600,317700,317800,317900,318000,318100,318200,318300,318400,318500,318600,318700,318800,318900,319000,319100,319200,319300,319400,319500,319600,319700,319800,319900,320000,320100,320200,320300,320400,320500,320600,320700,320800,320900,321000,321100,321200,321300,321400,321500,321600,321700,321800,321900,322000,322100,322200,322300,322400,322500,322600,322700,322800,322900,323000,323100,323200,323300,323400,323500,323600,323700,323800,323900,324000,324100,324200,324300,324400,324500,324600,324700,324800,324900,325000,325100,325200,325300,325400,325500,325600,325700,325800,325900,326000,326100,326200,326300,326400,326500,326600,326700,326800,326900,327000,327100,327200,327300,327400,327500,327600,327700,327800,327900,328000,328100,328200,328300,328400,328500,328600,32870
0,328800,328900,329000,329100,329200,329300,329400,329500,329600,329700,329800,329900,330000,330100,330200,330300,330400,330500,330600,330700,330800,330900,331000,331100,331200,331300,331400,331500,331600,331700,331800,331900,332000,332100,332200,332300,332400,332500,332600,332700,332800,332900,333000,333100,333200,333300,333400,333500,333600,333700,333800,333900,334000,334100,334200,334300,334400,334500,334600,334700,334800,334900,335000,335100,335200,335300,335400,335500,335600,335700,335800,335900,336000,336100,336200,336300,336400,336500,336600,336700,336800,336900,337000,337100,337200,337300,337400,337500,337600,337700,337800,337900,338000,338100,338200,338300,338400,338500,338600,338700,338800,338900,339000,339100,339200,339300,339400,339500,339600,339700,339800,339900,340000,340100,340200,340300,340400,340500,340600,340700,340800,340900,341000,341100,341200,341300,341400,341500,341600,341700,341800,341900,342000,342100,342200,342300,342400,342500,342600,342700,342800,342900,3
43000,343100,343200,343300,343400,343500,343600,343700,343800,343900,344000,344100,344200,344300,344400,344500,344600,344700,344800,344900,345000,345100,345200,345300,345400,345500,345600,345700,345800,345900,346000,346100,346200,346300,346400,346500,346600,346700,346800,346900,347000,347100,347200,347300,347400,347500,347600,347700,347800,347900,348000,348100,348200,348300,348400,348500,348600,348700,348800,348900,349000,349100,349200,349300,349400,349500,349600,349700,349800,349900,350000,350100,350200,350300,350400,350500,350600,350700,350800,350900,351000,351100,351200,351300,351400,351500,351600,351700,351800,351900,352000,352100,352200,352300,352400,352500,352600,352700,352800,352900,353000,353100,353200,353300,353400,353500,353600,353700,353800,353900,354000,354100,354200,354300,354400,354500,354600,354700,354800,354900,355000,355100,355200,355300,355400,355500,355600,355700,355800,355900,356000,356100,356200,356300,356400,356500,356600,356700,356800,356900,357000,357100,3572
00,357300,357400,357500,357600,357700,357800,357900,358000,358100,358200,358300,358400,358500,358600,358700,358800,358900,359000,359100,359200,359300,359400,359500,359600,359700,359800,359900,360000,360100,360200,360300,360400,360500,360600,360700,360800,360900,361000,361100,361200,361300,361400,361500,361600,361700,361800,361900,362000,362100,362200,362300,362400,362500,362600,362700,362800,362900,363000,363100,363200,363300,363400,363500,363600,363700,363800,363900,364000,364100,364200,364300,364400,364500,364600,364700,364800,364900,365000,365100,365200,365300,365400,365500,365600,365700,365800,365900,366000,366100,366200,366300,366400,366500,366600,366700,366800,366900,367000,367100,367200,367300,367400,367500,367600,367700,367800,367900,368000,368100,368200,368300,368400,368500,368600,368700,368800,368900,369000,369100,369200,369300,369400,369500,369600,369700,369800,369900,370000,370100,370200,370300,370400,370500,370600,370700,370800,370900,371000,371100,371200,371300,371400,
371500,371600,371700,371800,371900,372000,372100,372200,372300,372400,372500,372600,372700,372800,372900,373000,373100,373200,373300,373400,373500,373600,373700,373800,373900,374000,374100,374200,374300,374400,374500,374600,374700,374800,374900,375000,375100,375200,375300,375400,375500,375600,375700,375800,375900,376000,376100,376200,376300,376400,376500,376600,376700,376800,376900,377000,377100,377200,377300,377400,377500,377600,377700,377800,377900,378000,378100,378200,378300,378400,378500,378600,378700,378800,378900,379000,379100,379200,379300,379400,379500,379600,379700,379800,379900,380000,380100,380200,380300,380400,380500,380600,380700,380800,380900,381000,381100,381200,381300,381400,381500,381600,381700,381800,381900,382000,382100,382200,382300,382400,382500,382600,382700,382800,382900,383000,383100,383200,383300,383400,383500,383600,383700,383800,383900,384000,384100,384200,384300,384400,384500,384600,384700,384800,384900,385000,385100,385200,385300,385400,385500,385600,385
700,385800,385900,386000,386100,386200,386300,386400,386500,386600,386700,386800,386900,387000,387100,387200,387300,387400,387500,387600,387700,387800,387900,388000,388100,388200,388300,388400,388500,388600,388700,388800,388900,389000,389100,389200,389300,389400,389500,389600,389700,389800,389900,390000,390100,390200,390300,390400,390500,390600,390700,390800,390900,391000,391100,391200,391300,391400,391500,391600,391700,391800,391900,392000,392100,392200,392300,392400,392500,392600,392700,392800,392900,393000,393100,393200,393300,393400,393500,393600,393700,393800,393900,394000,394100,394200,394300,394400,394500,394600,394700,394800,394900,395000,395100,395200,395300,395400,395500,395600,395700,395800,395900,396000,396100,396200,396300,396400,396500,396600,396700,396800,396900,397000,397100,397200,397300,397400,397500,397600,397700,397800,397900,398000,398100,398200,398300,398400,398500,398600,398700,398800,398900,399000,399100,399200,399300,399400,399500,399600,399700,399800,399900
,400000,400100,400200,400300,400400,400500,400600,400700,400800,400900,401000,401100,401200,401300,401400,401500,401600,401700,401800,401900,402000,402100,402200,402300,402400,402500,402600,402700,402800,402900,403000,403100,403200,403300,403400,403500,403600,403700,403800,403900,404000,404100,404200,404300,404400,404500,404600,404700,404800,404900,405000,405100,405200,405300,405400,405500,405600,405700,405800,405900,406000,406100,406200,406300,406400,406500,406600,406700,406800,406900,407000,407100,407200,407300,407400,407500,407600,407700,407800,407900,408000,408100,408200,408300,408400,408500,408600,408700,408800,408900,409000,409100,409200,409300,409400,409500,409600,409700,409800,409900,410000,410100,410200,410300,410400,410500,410600,410700,410800,410900,411000,411100,411200,411300,411400,411500,411600,411700,411800,411900,412000,412100,412200,412300,412400,412500,412600,412700,412800,412900,413000,413100,413200,413300,413400,413500,413600,413700,413800,413900,414000,414100,41
4200,414300,414400,414500,414600,414700,414800,414900,415000,415100,415200,415300,415400,415500,415600,415700,415800,415900,416000,416100,416200,416300,416400,416500,416600,416700,416800,416900,417000,417100,417200,417300,417400,417500,417600,417700,417800,417900,418000,418100,418200,418300,418400,418500,418600,418700,418800,418900,419000,419100,419200,419300,419400,419500,419600,419700,419800,419900,420000,420100,420200,420300,420400,420500,420600,420700,420800,420900,421000,421100,421200,421300,421400,421500,421600,421700,421800,421900,422000,422100,422200,422300,422400,422500,422600,422700,422800,422900,423000,423100,423200,423300,423400,423500,423600,423700,423800,423900,424000,424100,424200,424300,424400,424500,424600,424700,424800,424900,425000,425100,425200,425300,425400,425500,425600,425700,425800,425900,426000,426100,426200,426300,426400,426500,426600,426700,426800,426900,427000,427100,427200,427300,427400,427500,427600,427700,427800,427900,428000,428100,428200,428300,42840
0,428500,428600,428700,428800,428900,429000,429100,429200,429300,429400,429500,429600,429700,429800,429900,430000,430100,430200,430300,430400,430500,430600,430700,430800,430900,431000,431100,431200,431300,431400,431500,431600,431700,431800,431900,432000,432100,432200,432300,432400,432500,432600,432700,432800,432900,433000,433100,433200,433300,433400,433500,433600,433700,433800,433900,434000,434100,434200,434300,434400,434500,434600,434700,434800,434900,435000,435100,435200,435300,435400,435500,435600,435700,435800,435900,436000,436100,436200,436300,436400,436500,436600,436700,436800,436900,437000,437100,437200,437300,437400,437500,437600,437700,437800,437900,438000,438100,438200,438300,438400,438500,438600,438700,438800,438900,439000,439100,439200,439300,439400,439500,439600,439700,439800,439900,440000,440100,440200,440300,440400,440500,440600,440700,440800,440900,441000,441100,441200,441300,441400,441500,441600,441700,441800,441900,442000,442100,442200,442300,442400,442500,442600,4
42700,442800,442900,443000,443100,443200,443300,443400,443500,443600,443700,443800,443900,444000,444100,444200,444300,444400,444500,444600,444700,444800,444900,445000,445100,445200,445300,445400,445500,445600,445700,445800,445900,446000,446100,446200,446300,446400,446500,446600,446700,446800,446900,447000,447100,447200,447300,447400,447500,447600,447700,447800,447900,448000,448100,448200,448300,448400,448500,448600,448700,448800,448900,449000,449100,449200,449300,449400,449500,449600,449700,449800,449900,450000,450100,450200,450300,450400,450500,450600,450700,450800,450900,451000,451100,451200,451300,451400,451500,451600,451700,451800,451900,452000,452100,452200,452300,452400,452500,452600,452700,452800,452900,453000,453100,453200,453300,453400,453500,453600,453700,453800,453900,454000,454100,454200,454300,454400,454500,454600,454700,454800,454900,455000,455100,455200,455300,455400,455500,455600,455700,455800,455900,456000,456100,456200,456300,456400,456500,456600,456700,456800,4569
00,457000,457100,457200,457300,457400,457500,457600,457700,457800,457900,458000,458100,458200,458300,458400,458500,458600,458700,458800,458900,459000,459100,459200,459300,459400,459500,459600,459700,459800,459900,460000,460100,460200,460300,460400,460500,460600,460700,460800,460900,461000,461100,461200,461300,461400,461500,461600,461700,461800,461900,462000,462100,462200,462300,462400,462500,462600,462700,462800,462900,463000,463100,463200,463300,463400,463500,463600,463700,463800,463900,464000,464100,464200,464300,464400,464500,464600,464700,464800,464900,465000,465100,465200,465300,465400,465500,465600,465700,465800,465900,466000,466100,466200,466300,466400,466500,466600,466700,466800,466900,467000,467100,467200,467300,467400,467500,467600,467700,467800,467900,468000,468100,468200,468300,468400,468500,468600,468700,468800,468900,469000,469100,469200,469300,469400,469500,469600,469700,469800,469900,470000,470100,470200,470300,470400,470500,470600,470700,470800,470900,471000,471100,
471200,471300,471400,471500,471600,471700,471800,471900,472000,472100,472200,472300,472400,472500,472600,472700,472800,472900,473000,473100,473200,473300,473400,473500,473600,473700,473800,473900,474000,474100,474200,474300,474400,474500,474600,474700,474800,474900,475000,475100,475200,475300,475400,475500,475600,475700,475800,475900,476000,476100,476200,476300,476400,476500,476600,476700,476800,476900,477000,477100,477200,477300,477400,477500,477600,477700,477800,477900,478000,478100,478200,478300,478400,478500,478600,478700,478800,478900,479000,479100,479200,479300,479400,479500,479600,479700,479800,479900,480000,480100,480200,480300,480400,480500,480600,480700,480800,480900,481000,481100,481200,481300,481400,481500,481600,481700,481800,481900,482000,482100,482200,482300,482400,482500,482600,482700,482800,482900,483000,483100,483200,483300,483400,483500,483600,483700,483800,483900,484000,484100,484200,484300,484400,484500,484600,484700,484800,484900,485000,485100,485200,485300,485
400,485500,485600,485700,485800,485900,486000,486100,486200,486300,486400,486500,486600,486700,486800,486900,487000,487100,487200,487300,487400,487500,487600,487700,487800,487900,488000,488100,488200,488300,488400,488500,488600,488700,488800,488900,489000,489100,489200,489300,489400,489500,489600,489700,489800,489900,490000,490100,490200,490300,490400,490500,490600,490700,490800,490900,491000,491100,491200,491300,491400,491500,491600,491700,491800,491900,492000,492100,492200,492300,492400,492500,492600,492700,492800,492900,493000,493100,493200,493300,493400,493500,493600,493700,493800,493900,494000,494100,494200,494300,494400,494500,494600,494700,494800,494900,495000,495100,495200,495300,495400,495500,495600,495700,495800,495900,496000,496100,496200,496300,496400,496500,496600,496700,496800,496900,497000,497100,497200,497300,497400,497500,497600,497700,497800,497900,498000,498100,498200,498300,498400,498500,498600,498700,498800,498900,499000,499100,499200,499300,499400,499500,499600
,499700,499800,499900,500000,500100,500200,500300,500400,500500,500600,500700,500800,500900,501000,501100,501200,501300,501400,501500,501600,501700,501800,501900,502000,502100,502200,502300,502400,502500,502600,502700,502800,502900,503000,503100,503200,503300,503400,503500,503600,503700,503800,503900,504000,504100,504200,504300,504400,504500,504600,504700,504800,504900,505000,505100,505200,505300,505400,505500,505600,505700,505800,505900,506000,506100,506200,506300,506400,506500,506600,506700,506800,506900,507000,507100,507200,507300,507400,507500,507600,507700,507800,507900,508000,508100,508200,508300,508400,508500,508600,508700,508800,508900,509000,509100,509200,509300,509400,509500,509600,509700,509800,509900,510000,510100,510200,510300,510400,510500,510600,510700,510800,510900,511000,511100,511200,511300,511400,511500,511600,511700,511800,511900,512000,512100,512200,512300,512400,512500,512600,512700,512800,512900,513000,513100,513200,513300,513400,513500,513600,513700,513800,51
3900,514000,514100,514200,514300,514400,514500,514600,514700,514800,514900,515000,515100,515200,515300,515400,515500,515600,515700,515800,515900,516000,516100,516200,516300,516400,516500,516600,516700,516800,516900,517000,517100,517200,517300,517400,517500,517600,517700,517800,517900,518000,518100,518200,518300,518400,518500,518600,518700,518800,518900,519000,519100,519200,519300,519400,519500,519600,519700,519800,519900,520000,520100,520200,520300,520400,520500,520600,520700,520800,520900,521000,521100,521200,521300,521400,521500,521600,521700,521800,521900,522000,522100,522200,522300,522400,522500,522600,522700,522800,522900,523000,523100,523200,523300,523400,523500,523600,523700,523800,523900,524000,524100,524200,524300,524400,524500,524600,524700,524800,524900,525000,525100,525200,525300,525400,525500,525600,525700,525800,525900,526000,526100,526200,526300,526400,526500,526600,526700,526800,526900,527000,527100,527200,527300,527400,527500,527600,527700,527800,527900,528000,52810
0,528200,528300,528400,528500,528600,528700,528800,528900,529000,529100,529200,529300,529400,529500,529600,529700,529800,529900,530000,530100,530200,530300,530400,530500,530600,530700,530800,530900,531000,531100,531200,531300,531400,531500,531600,531700,531800,531900,532000,532100,532200,532300,532400,532500,532600,532700,532800,532900,533000,533100,533200,533300,533400,533500,533600,533700,533800,533900,534000,534100,534200,534300,534400,534500,534600,534700,534800,534900,535000,535100,535200,535300,535400,535500,535600,535700,535800,535900,536000,536100,536200,536300,536400,536500,536600,536700,536800,536900,537000,537100,537200,537300,537400,537500,537600,537700,537800,537900,538000,538100,538200,538300,538400,538500,538600,538700,538800,538900,539000,539100,539200,539300,539400,539500,539600,539700,539800,539900,540000,540100,540200,540300,540400,540500,540600,540700,540800,540900,541000,541100,541200,541300,541400,541500,541600,541700,541800,541900,542000,542100,542200,542300,5
42400,542500,542600,542700,542800,542900,543000,543100,543200,543300,543400,543500,543600,543700,543800,543900,544000,544100,544200,544300,544400,544500,544600,544700,544800,544900,545000,545100,545200,545300,545400,545500,545600,545700,545800,545900,546000,546100,546200,546300,546400,546500,546600,546700,546800,546900,547000,547100,547200,547300,547400,547500,547600,547700,547800,547900,548000,548100,548200,548300,548400,548500,548600,548700,548800,548900,549000,549100,549200,549300,549400,549500,549600,549700,549800,549900,550000,550100,550200,550300,550400,550500,550600,550700,550800,550900,551000,551100,551200,551300,551400,551500,551600,551700,551800,551900,552000,552100,552200,552300,552400,552500,552600,552700,552800,552900,553000,553100,553200,553300,553400,553500,553600,553700,553800,553900,554000,554100,554200,554300,554400,554500,554600,554700,554800,554900,555000,555100,555200,555300,555400,555500,555600,555700,555800,555900,556000,556100,556200,556300,556400,556500,5566
00,556700,556800,556900,557000,557100,557200,557300,557400,557500,557600,557700,557800,557900,558000,558100,558200,558300,558400,558500,558600,558700,558800,558900,559000,559100,559200,559300,559400,559500,559600,559700,559800,559900,560000,560100,560200,560300,560400,560500,560600,560700,560800,560900,561000,561100,561200,561300,561400,561500,561600,561700,561800,561900,562000,562100,562200,562300,562400,562500,562600,562700,562800,562900,563000,563100,563200,563300,563400,563500,563600,563700,563800,563900,564000,564100,564200,564300,564400,564500,564600,564700,564800,564900,565000,565100,565200,565300,565400,565500,565600,565700,565800,565900,566000,566100,566200,566300,566400,566500,566600,566700,566800,566900,567000,567100,567200,567300,567400,567500,567600,567700,567800,567900,568000,568100,568200,568300,568400,568500,568600,568700,568800,568900,569000,569100,569200,569300,569400,569500,569600,569700,569800,569900,570000,570100,570200,570300,570400,570500,570600,570700,570800,
570900,571000,571100,571200,571300,571400,571500,571600,571700,571800,571900,572000,572100,572200,572300,572400,572500,572600,572700,572800,572900,573000,573100,573200,573300,573400,573500,573600,573700,573800,573900,574000,574100,574200,574300,574400,574500,574600,574700,574800,574900,575000,575100,575200,575300,575400,575500,575600,575700,575800,575900,576000,576100,576200,576300,576400,576500,576600,576700,576800,576900,577000,577100,577200,577300,577400,577500,577600,577700,577800,577900,578000,578100,578200,578300,578400,578500,578600,578700,578800,578900,579000,579100,579200,579300,579400,579500,579600,579700,579800,579900,580000,580100,580200,580300,580400,580500,580600,580700,580800,580900,581000,581100,581200,581300,581400,581500,581600,581700,581800,581900,582000,582100,582200,582300,582400,582500,582600,582700,582800,582900,583000,583100,583200,583300,583400,583500,583600,583700,583800,583900,584000,584100,584200,584300,584400,584500,584600,584700,584800,584900,585000,585
100,585200,585300,585400,585500,585600,585700,585800,585900,586000,586100,586200,586300,586400,586500,586600,586700,586800,586900,587000,587100,587200,587300,587400,587500,587600,587700,587800,587900,588000,588100,588200,588300,588400,588500,588600,588700,588800,588900,589000,589100,589200,589300,589400,589500,589600,589700,589800,589900,590000,590100,590200,590300,590400,590500,590600,590700,590800,590900,591000,591100,591200,591300,591400,591500,591600,591700,591800,591900,592000,592100,592200,592300,592400,592500,592600,592700,592800,592900,593000,593100,593200,593300,593400,593500,593600,593700,593800,593900,594000,594100,594200,594300,594400,594500,594600,594700,594800,594900,595000,595100,595200,595300,595400,595500,595600,595700,595800,595900,596000,596100,596200,596300,596400,596500,596600,596700,596800,596900,597000,597100,597200,597300,597400,597500,597600,597700,597800,597900,598000,598100,598200,598300,598400,598500,598600,598700,598800,598900,599000,599100,599200,599300
,599400,599500,599600,599700,599800,599900,600000,600100,600200,600300,600400,600500,600600,600700,600800,600900,601000,601100,601200,601300,601400,601500,601600,601700,601800,601900,602000,602100,602200,602300,602400,602500,602600,602700,602800,602900,603000,603100,603200,603300,603400,603500,603600,603700,603800,603900,604000,604100,604200,604300,604400,604500,604600,604700,604800,604900,605000,605100,605200,605300,605400,605500,605600,605700,605800,605900,606000,606100,606200,606300,606400,606500,606600,606700,606800,606900,607000,607100,607200,607300,607400,607500,607600,607700,607800,607900,608000,608100,608200,608300,608400,608500,608600,608700,608800,608900,609000,609100,609200,609300,609400,609500,609600,609700,609800,609900,610000,610100,610200,610300,610400,610500,610600,610700,610800,610900,611000,611100,611200,611300,611400,611500,611600,611700,611800,611900,612000,612100,612200,612300,612400,612500,612600,612700,612800,612900,613000,613100,613200,613300,613400,613500,61
3600,613700,613800,613900,614000,614100,614200,614300,614400,614500,614600,614700,614800,614900,615000,615100,615200,615300,615400,615500,615600,615700,615800,615900,616000,616100,616200,616300,616400,616500,616600,616700,616800,616900,617000,617100,617200,617300,617400,617500,617600,617700,617800,617900,618000,618100,618200,618300,618400,618500,618600,618700,618800,618900,619000,619100,619200,619300,619400,619500,619600,619700,619800,619900,620000,620100,620200,620300,620400,620500,620600,620700,620800,620900,621000,621100,621200,621300,621400,621500,621600,621700,621800,621900,622000,622100,622200,622300,622400,622500,622600,622700,622800,622900,623000,623100,623200,623300,623400,623500,623600,623700,623800,623900,624000,624100,624200,624300,624400,624500,624600,624700,624800,624900,625000,625100,625200,625300,625400,625500,625600,625700,625800,625900,626000,626100,626200,626300,626400,626500,626600,626700,626800,626900,627000,627100,627200,627300,627400,627500,627600,627700,62780
0,627900,628000,628100,628200,628300,628400,628500,628600,628700,628800,628900,629000,629100,629200,629300,629400,629500,629600,629700,629800,629900,630000,630100,630200,630300,630400,630500,630600,630700,630800,630900,631000,631100,631200,631300,631400,631500,631600,631700,631800,631900,632000,632100,632200,632300,632400,632500,632600,632700,632800,632900,633000,633100,633200,633300,633400,633500,633600,633700,633800,633900,634000,634100,634200,634300,634400,634500,634600,634700,634800,634900,635000,635100,635200,635300,635400,635500,635600,635700,635800,635900,636000,636100,636200,636300,636400,636500,636600,636700,636800,636900,637000,637100,637200,637300,637400,637500,637600,637700,637800,637900,638000,638100,638200,638300,638400,638500,638600,638700,638800,638900,639000,639100,639200,639300,639400,639500,639600,639700,639800,639900,640000,640100,640200,640300,640400,640500,640600,640700,640800,640900,641000,641100,641200,641300,641400,641500,641600,641700,641800,641900,642000,6
42100,642200,642300,642400,642500,642600,642700,642800,642900,643000,643100,643200,643300,643400,643500,643600,643700,643800,643900,644000,644100,644200,644300,644400,644500,644600,644700,644800,644900,645000,645100,645200,645300,645400,645500,645600,645700,645800,645900,646000,646100,646200,646300,646400,646500,646600,646700,646800,646900,647000,647100,647200,647300,647400,647500,647600,647700,647800,647900,648000,648100,648200,648300,648400,648500,648600,648700,648800,648900,649000,649100,649200,649300,649400,649500,649600,649700,649800,649900,650000,650100,650200,650300,650400,650500,650600,650700,650800,650900,651000,651100,651200,651300,651400,651500,651600,651700,651800,651900,652000,652100,652200,652300,652400,652500,652600,652700,652800,652900,653000,653100,653200,653300,653400,653500,653600,653700,653800,653900,654000,654100,654200,654300,654400,654500,654600,654700,654800,654900,655000,655100,655200,655300,655400,655500,655600,655700,655800,655900,656000,656100,656200,6563
00,656400,656500,656600,656700,656800,656900,657000,657100,657200,657300,657400,657500,657600,657700,657800,657900,658000,658100,658200,658300,658400,658500,658600,658700,658800,658900,659000,659100,659200,659300,659400,659500,659600,659700,659800,659900,660000,660100,660200,660300,660400,660500,660600,660700,660800,660900,661000,661100,661200,661300,661400,661500,661600,661700,661800,661900,662000,662100,662200,662300,662400,662500,662600,662700,662800,662900,663000,663100,663200,663300,663400,663500,663600,663700,663800,663900,664000,664100,664200,664300,664400,664500,664600,664700,664800,664900,665000,665100,665200,665300,665400,665500,665600,665700,665800,665900,666000,666100,666200,666300,666400,666500,666600,666700,666800,666900,667000,667100,667200,667300,667400,667500,667600,667700,667800,667900,668000,668100,668200,668300,668400,668500,668600,668700,668800,668900,669000,669100,669200,669300,669400,669500,669600,669700,669800,669900,670000,670100,670200,670300,670400,670500,
670600,670700,670800,670900,671000,671100,671200,671300,671400,671500,671600,671700,671800,671900,672000,672100,672200,672300,672400,672500,672600,672700,672800,672900,673000,673100,673200,673300,673400,673500,673600,673700,673800,673900,674000,674100,674200,674300,674400,674500,674600,674700,674800,674900,675000,675100,675200,675300,675400,675500,675600,675700,675800,675900,676000,676100,676200,676300,676400,676500,676600,676700,676800,676900,677000,677100,677200,677300,677400,677500,677600,677700,677800,677900,678000,678100,678200,678300,678400,678500,678600,678700,678800,678900,679000,679100,679200,679300,679400,679500,679600,679700,679800,679900,680000,680100,680200,680300,680400,680500,680600,680700,680800,680900,681000,681100,681200,681300,681400,681500,681600,681700,681800,681900,682000,682100,682200,682300,682400,682500,682600,682700,682800,682900,683000,683100,683200,683300,683400,683500,683600,683700,683800,683900,684000,684100,684200,684300,684400,684500,684600,684700,684
800,684900,685000,685100,685200,685300,685400,685500,685600,685700,685800,685900,686000,686100,686200,686300,686400,686500,686600,686700,686800,686900,687000,687100,687200,687300,687400,687500,687600,687700,687800,687900,688000,688100,688200,688300,688400,688500,688600,688700,688800,688900,689000,689100,689200,689300,689400,689500,689600,689700,689800,689900,690000,690100,690200,690300,690400,690500,690600,690700,690800,690900,691000,691100,691200,691300,691400,691500,691600,691700,691800,691900,692000,692100,692200,692300,692400,692500,692600,692700,692800,692900,693000,693100,693200,693300,693400,693500,693600,693700,693800,693900,694000,694100,694200,694300,694400,694500,694600,694700,694800,694900,695000,695100,695200,695300,695400,695500,695600,695700,695800,695900,696000,696100,696200,696300,696400,696500,696600,696700,696800,696900,697000,697100,697200,697300,697400,697500,697600,697700,697800,697900,698000,698100,698200,698300,698400,698500,698600,698700,698800,698900,699000
,699100,699200,699300,699400,699500,699600,699700,699800,699900,700000,700100,700200,700300,700400,700500,700600,700700,700800,700900,701000,701100,701200,701300,701400,701500,701600,701700,701800,701900,702000,702100,702200,702300,702400,702500,702600,702700,702800,702900,703000,703100,703200,703300,703400,703500,703600,703700,703800,703900,704000,704100,704200,704300,704400,704500,704600,704700,704800,704900,705000,705100,705200,705300,705400,705500,705600,705700,705800,705900,706000,706100,706200,706300,706400,706500,706600,706700,706800,706900,707000,707100,707200,707300,707400,707500,707600,707700,707800,707900,708000,708100,708200,708300,708400,708500,708600,708700,708800,708900,709000,709100,709200,709300,709400,709500,709600,709700,709800,709900,710000,710100,710200,710300,710400,710500,710600,710700,710800,710900,711000,711100,711200,711300,711400,711500,711600,711700,711800,711900,712000,712100,712200,712300,712400,712500,712600,712700,712800,712900,713000,713100,713200,71
3300,713400,713500,713600,713700,713800,713900,714000,714100,714200,714300,714400,714500,714600,714700,714800,714900,715000,715100,715200,715300,715400,715500,715600,715700,715800,715900,716000,716100,716200,716300,716400,716500,716600,716700,716800,716900,717000,717100,717200,717300,717400,717500,717600,717700,717800,717900,718000,718100,718200,718300,718400,718500,718600,718700,718800,718900,719000,719100,719200,719300,719400,719500,719600,719700,719800,719900,720000,720100,720200,720300,720400,720500,720600,720700,720800,720900,721000,721100,721200,721300,721400,721500,721600,721700,721800,721900,722000,722100,722200,722300,722400,722500,722600,722700,722800,722900,723000,723100,723200,723300,723400,723500,723600,723700,723800,723900,724000,724100,724200,724300,724400,724500,724600,724700,724800,724900,725000,725100,725200,725300,725400,725500,725600,725700,725800,725900,726000,726100,726200,726300,726400,726500,726600,726700,726800,726900,727000,727100,727200,727300,727400,72750
0,727600,727700,727800,727900,728000,728100,728200,728300,728400,728500,728600,728700,728800,728900,729000,729100,729200,729300,729400,729500,729600,729700,729800,729900,730000,730100,730200,730300,730400,730500,730600,730700,730800,730900,731000,731100,731200,731300,731400,731500,731600,731700,731800,731900,732000,732100,732200,732300,732400,732500,732600,732700,732800,732900,733000,733100,733200,733300,733400,733500,733600,733700,733800,733900,734000,734100,734200,734300,734400,734500,734600,734700,734800,734900,735000,735100,735200,735300,735400,735500,735600,735700,735800,735900,736000,736100,736200,736300,736400,736500,736600,736700,736800,736900,737000,737100,737200,737300,737400,737500,737600,737700,737800,737900,738000,738100,738200,738300,738400,738500,738600,738700,738800,738900,739000,739100,739200,739300,739400,739500,739600,739700,739800,739900,740000,740100,740200,740300,740400,740500,740600,740700,740800,740900,741000,741100,741200,741300,741400,741500,741600,741700,7
41800,741900,742000,742100,742200,742300,742400,742500,742600,742700,742800,742900,743000,743100,743200,743300,743400,743500,743600,743700,743800,743900,744000,744100,744200,744300,744400,744500,744600,744700,744800,744900,745000,745100,745200,745300,745400,745500,745600,745700,745800,745900,746000,746100,746200,746300,746400,746500,746600,746700,746800,746900,747000,747100,747200,747300,747400,747500,747600,747700,747800,747900,748000,748100,748200,748300,748400,748500,748600,748700,748800,748900,749000,749100,749200,749300,749400,749500,749600,749700,749800,749900,750000,750100,750200,750300,750400,750500,750600,750700,750800,750900,751000,751100,751200,751300,751400,751500,751600,751700,751800,751900,752000,752100,752200,752300,752400,752500,752600,752700,752800,752900,753000,753100,753200,753300,753400,753500,753600,753700,753800,753900,754000,754100,754200,754300,754400,754500,754600,754700,754800,754900,755000,755100,755200,755300,755400,755500,755600,755700,755800,755900,7560
00,756100,756200,756300,756400,756500,756600,756700,756800,756900,757000,757100,757200,757300,757400,757500,757600,757700,757800,757900,758000,758100,758200,758300,758400,758500,758600,758700,758800,758900,759000,759100,759200,759300,759400,759500,759600,759700,759800,759900,760000,760100,760200,760300,760400,760500,760600,760700,760800,760900,761000,761100,761200,761300,761400,761500,761600,761700,761800,761900,762000,762100,762200,762300,762400,762500,762600,762700,762800,762900,763000,763100,763200,763300,763400,763500,763600,763700,763800,763900,764000,764100,764200,764300,764400,764500,764600,764700,764800,764900,765000,765100,765200,765300,765400,765500,765600,765700,765800,765900,766000,766100,766200,766300,766400,766500,766600,766700,766800,766900,767000,767100,767200,767300,767400,767500,767600,767700,767800,767900,768000,768100,768200,768300,768400,768500,768600,768700,768800,768900,769000,769100,769200,769300,769400,769500,769600,769700,769800,769900,770000,770100,770200,
770300,770400,770500,770600,770700,770800,770900,771000,771100,771200,771300,771400,771500,771600,771700,771800,771900,772000,772100,772200,772300,772400,772500,772600,772700,772800,772900,773000,773100,773200,773300,773400,773500,773600,773700,773800,773900,774000,774100,774200,774300,774400,774500,774600,774700,774800,774900,775000,775100,775200,775300,775400,775500,775600,775700,775800,775900,776000,776100,776200,776300,776400,776500,776600,776700,776800,776900,777000,777100,777200,777300,777400,777500,777600,777700,777800,777900,778000,778100,778200,778300,778400,778500,778600,778700,778800,778900,779000,779100,779200,779300,779400,779500,779600,779700,779800,779900,780000,780100,780200,780300,780400,780500,780600,780700,780800,780900,781000,781100,781200,781300,781400,781500,781600,781700,781800,781900,782000,782100,782200,782300,782400,782500,782600,782700,782800,782900,783000,783100,783200,783300,783400,783500,783600,783700,783800,783900,784000,784100,784200,784300,784400,784
500,784600,784700,784800,784900,785000,785100,785200,785300,785400,785500,785600,785700,785800,785900,786000,786100,786200,786300,786400,786500,786600,786700,786800,786900,787000,787100,787200,787300,787400,787500,787600,787700,787800,787900,788000,788100,788200,788300,788400,788500,788600,788700,788800,788900,789000,789100,789200,789300,789400,789500,789600,789700,789800,789900,790000,790100,790200,790300,790400,790500,790600,790700,790800,790900,791000,791100,791200,791300,791400,791500,791600,791700,791800,791900,792000,792100,792200,792300,792400,792500,792600,792700,792800,792900,793000,793100,793200,793300,793400,793500,793600,793700,793800,793900,794000,794100,794200,794300,794400,794500,794600,794700,794800,794900,795000,795100,795200,795300,795400,795500,795600,795700,795800,795900,796000,796100,796200,796300,796400,796500,796600,796700,796800,796900,797000,797100,797200,797300,797400,797500,797600,797700,797800,797900,798000,798100,798200,798300,798400,798500,798600,798700
,798800,798900,799000,799100,799200,799300,799400,799500,799600,799700,799800,799900,800000,800100,800200,800300,800400,800500,800600,800700,800800,800900,801000,801100,801200,801300,801400,801500,801600,801700,801800,801900,802000,802100,802200,802300,802400,802500,802600,802700,802800,802900,803000,803100,803200,803300,803400,803500,803600,803700,803800,803900,804000,804100,804200,804300,804400,804500,804600,804700,804800,804900,805000,805100,805200,805300,805400,805500,805600,805700,805800,805900,806000,806100,806200,806300,806400,806500,806600,806700,806800,806900,807000,807100,807200,807300,807400,807500,807600,807700,807800,807900,808000,808100,808200,808300,808400,808500,808600,808700,808800,808900,809000,809100,809200,809300,809400,809500,809600,809700,809800,809900,810000,810100,810200,810300,810400,810500,810600,810700,810800,810900,811000,811100,811200,811300,811400,811500,811600,811700,811800,811900,812000,812100,812200,812300,812400,812500,812600,812700,812800,812900,81
3000,813100,813200,813300,813400,813500,813600,813700,813800,813900,814000,814100,814200,814300,814400,814500,814600,814700,814800,814900,815000,815100,815200,815300,815400,815500,815600,815700,815800,815900,816000,816100,816200,816300,816400,816500,816600,816700,816800,816900,817000,817100,817200,817300,817400,817500,817600,817700,817800,817900,818000,818100,818200,818300,818400,818500,818600,818700,818800,818900,819000,819100,819200,819300,819400,819500,819600,819700,819800,819900,820000,820100,820200,820300,820400,820500,820600,820700,820800,820900,821000,821100,821200,821300,821400,821500,821600,821700,821800,821900,822000,822100,822200,822300,822400,822500,822600,822700,822800,822900,823000,823100,823200,823300,823400,823500,823600,823700,823800,823900,824000,824100,824200,824300,824400,824500,824600,824700,824800,824900,825000,825100,825200,825300,825400,825500,825600,825700,825800,825900,826000,826100,826200,826300,826400,826500,826600,826700,826800,826900,827000,827100,82720
0,827300,827400,827500,827600,827700,827800,827900,828000,828100,828200,828300,828400,828500,828600,828700,828800,828900,829000,829100,829200,829300,829400,829500,829600,829700,829800,829900,830000,830100,830200,830300,830400,830500,830600,830700,830800,830900,831000,831100,831200,831300,831400,831500,831600,831700,831800,831900,832000,832100,832200,832300,832400,832500,832600,832700,832800,832900,833000,833100,833200,833300,833400,833500,833600,833700,833800,833900,834000,834100,834200,834300,834400,834500,834600,834700,834800,834900,835000,835100,835200,835300,835400,835500,835600,835700,835800,835900,836000,836100,836200,836300,836400,836500,836600,836700,836800,836900,837000,837100,837200,837300,837400,837500,837600,837700,837800,837900,838000,838100,838200,838300,838400,838500,838600,838700,838800,838900,839000,839100,839200,839300,839400,839500,839600,839700,839800,839900,840000,840100,840200,840300,840400,840500,840600,840700,840800,840900,841000,841100,841200,841300,841400,8
41500,841600,841700,841800,841900,842000,842100,842200,842300,842400,842500,842600,842700,842800,842900,843000,843100,843200,843300,843400,843500,843600,843700,843800,843900,844000,844100,844200,844300,844400,844500,844600,844700,844800,844900,845000,845100,845200,845300,845400,845500,845600,845700,845800,845900,846000,846100,846200,846300,846400,846500,846600,846700,846800,846900,847000,847100,847200,847300,847400,847500,847600,847700,847800,847900,848000,848100,848200,848300,848400,848500,848600,848700,848800,848900,849000,849100,849200,849300,849400,849500,849600,849700,849800,849900,850000,850100,850200,850300,850400,850500,850600,850700,850800,850900,851000,851100,851200,851300,851400,851500,851600,851700,851800,851900,852000,852100,852200,852300,852400,852500,852600,852700,852800,852900,853000,853100,853200,853300,853400,853500,853600,853700,853800,853900,854000,854100,854200,854300,854400,854500,854600,854700,854800,854900,855000,855100,855200,855300,855400,855500,855600,8557
00,855800,855900,856000,856100,856200,856300,856400,856500,856600,856700,856800,856900,857000,857100,857200,857300,857400,857500,857600,857700,857800,857900,858000,858100,858200,858300,858400,858500,858600,858700,858800,858900,859000,859100,859200,859300,859400,859500,859600,859700,859800,859900,860000,860100,860200,860300,860400,860500,860600,860700,860800,860900,861000,861100,861200,861300,861400,861500,861600,861700,861800,861900,862000,862100,862200,862300,862400,862500,862600,862700,862800,862900,863000,863100,863200,863300,863400,863500,863600,863700,863800,863900,864000,864100,864200,864300,864400,864500,864600,864700,864800,864900,865000,865100,865200,865300,865400,865500,865600,865700,865800,865900,866000,866100,866200,866300,866400,866500,866600,866700,866800,866900,867000,867100,867200,867300,867400,867500,867600,867700,867800,867900,868000,868100,868200,868300,868400,868500,868600,868700,868800,868900,869000,869100,869200,869300,869400,869500,869600,869700,869800,869900,
870000,870100,870200,870300,870400,870500,870600,870700,870800,870900,871000,871100,871200,871300,871400,871500,871600,871700,871800,871900,872000,872100,872200,872300,872400,872500,872600,872700,872800,872900,873000,873100,873200,873300,873400,873500,873600,873700,873800,873900,874000,874100,874200,874300,874400,874500,874600,874700,874800,874900,875000,875100,875200,875300,875400,875500,875600,875700,875800,875900,876000,876100,876200,876300,876400,876500,876600,876700,876800,876900,877000,877100,877200,877300,877400,877500,877600,877700,877800,877900,878000,878100,878200,878300,878400,878500,878600,878700,878800,878900,879000,879100,879200,879300,879400,879500,879600,879700,879800,879900,880000,880100,880200,880300,880400,880500,880600,880700,880800,880900,881000,881100,881200,881300,881400,881500,881600,881700,881800,881900,882000,882100,882200,882300,882400,882500,882600,882700,882800,882900,883000,883100,883200,883300,883400,883500,883600,883700,883800,883900,884000,884100,884
200,884300,884400,884500,884600,884700,884800,884900,885000,885100,885200,885300,885400,885500,885600,885700,885800,885900,886000,886100,886200,886300,886400,886500,886600,886700,886800,886900,887000,887100,887200,887300,887400,887500,887600,887700,887800,887900,888000,888100,888200,888300,888400,888500,888600,888700,888800,888900,889000,889100,889200,889300,889400,889500,889600,889700,889800,889900,890000,890100,890200,890300,890400,890500,890600,890700,890800,890900,891000,891100,891200,891300,891400,891500,891600,891700,891800,891900,892000,892100,892200,892300,892400,892500,892600,892700,892800,892900,893000,893100,893200,893300,893400,893500,893600,893700,893800,893900,894000,894100,894200,894300,894400,894500,894600,894700,894800,894900,895000,895100,895200,895300,895400,895500,895600,895700,895800,895900,896000,896100,896200,896300,896400,896500,896600,896700,896800,896900,897000,897100,897200,897300,897400,897500,897600,897700,897800,897900,898000,898100,898200,898300,898400
,898500,898600,898700,898800,898900,899000,899100,899200,899300,899400,899500,899600,899700,899800,899900,900000,900100,900200,900300,900400,900500,900600,900700,900800,900900,901000,901100,901200,901300,901400,901500,901600,901700,901800,901900,902000,902100,902200,902300,902400,902500,902600,902700,902800,902900,903000,903100,903200,903300,903400,903500,903600,903700,903800,903900,904000,904100,904200,904300,904400,904500,904600,904700,904800,904900,905000,905100,905200,905300,905400,905500,905600,905700,905800,905900,906000,906100,906200,906300,906400,906500,906600,906700,906800,906900,907000,907100,907200,907300,907400,907500,907600,907700,907800,907900,908000,908100,908200,908300,908400,908500,908600,908700,908800,908900,909000,909100,909200,909300,909400,909500,909600,909700,909800,909900,910000,910100,910200,910300,910400,910500,910600,910700,910800,910900,911000,911100,911200,911300,911400,911500,911600,911700,911800,911900,912000,912100,912200,912300,912400,912500,912600,91
2700,912800,912900,913000,913100,913200,913300,913400,913500,913600,913700,913800,913900,914000,914100,914200,914300,914400,914500,914600,914700,914800,914900,915000,915100,915200,915300,915400,915500,915600,915700,915800,915900,916000,916100,916200,916300,916400,916500,916600,916700,916800,916900,917000,917100,917200,917300,917400,917500,917600,917700,917800,917900,918000,918100,918200,918300,918400,918500,918600,918700,918800,918900,919000,919100,919200,919300,919400,919500,919600,919700,919800,919900,920000,920100,920200,920300,920400,920500,920600,920700,920800,920900,921000,921100,921200,921300,921400,921500,921600,921700,921800,921900,922000,922100,922200,922300,922400,922500,922600,922700,922800,922900,923000,923100,923200,923300,923400,923500,923600,923700,923800,923900,924000,924100,924200,924300,924400,924500,924600,924700,924800,924900,925000,925100,925200,925300,925400,925500,925600,925700,925800,925900,926000,926100,926200,926300,926400,926500,926600,926700,926800,92690
0,927000,927100,927200,927300,927400,927500,927600,927700,927800,927900,928000,928100,928200,928300,928400,928500,928600,928700,928800,928900,929000,929100,929200,929300,929400,929500,929600,929700,929800,929900,930000,930100,930200,930300,930400,930500,930600,930700,930800,930900,931000,931100,931200,931300,931400,931500,931600,931700,931800,931900,932000,932100,932200,932300,932400,932500,932600,932700,932800,932900,933000,933100,933200,933300,933400,933500,933600,933700,933800,933900,934000,934100,934200,934300,934400,934500,934600,934700,934800,934900,935000,935100,935200,935300,935400,935500,935600,935700,935800,935900,936000,936100,936200,936300,936400,936500,936600,936700,936800,936900,937000,937100,937200,937300,937400,937500,937600,937700,937800,937900,938000,938100,938200,938300,938400,938500,938600,938700,938800,938900,939000,939100,939200,939300,939400,939500,939600,939700,939800,939900,940000,940100,940200,940300,940400,940500,940600,940700,940800,940900,941000,941100,9
41200,941300,941400,941500,941600,941700,941800,941900,942000,942100,942200,942300,942400,942500,942600,942700,942800,942900,943000,943100,943200,943300,943400,943500,943600,943700,943800,943900,944000,944100,944200,944300,944400,944500,944600,944700,944800,944900,945000,945100,945200,945300,945400,945500,945600,945700,945800,945900,946000,946100,946200,946300,946400,946500,946600,946700,946800,946900,947000,947100,947200,947300,947400,947500,947600,947700,947800,947900,948000,948100,948200,948300,948400,948500,948600,948700,948800,948900,949000,949100,949200,949300,949400,949500,949600,949700,949800,949900,950000,950100,950200,950300,950400,950500,950600,950700,950800,950900,951000,951100,951200,951300,951400,951500,951600,951700,951800,951900,952000,952100,952200,952300,952400,952500,952600,952700,952800,952900,953000,953100,953200,953300,953400,953500,953600,953700,953800,953900,954000,954100,954200,954300,954400,954500,954600,954700,954800,954900,955000,955100,955200,955300,9554
00,955500,955600,955700,955800,955900,956000,956100,956200,956300,956400,956500,956600,956700,956800,956900,957000,957100,957200,957300,957400,957500,957600,957700,957800,957900,958000,958100,958200,958300,958400,958500,958600,958700,958800,958900,959000,959100,959200,959300,959400,959500,959600,959700,959800,959900,960000,960100,960200,960300,960400,960500,960600,960700,960800,960900,961000,961100,961200,961300,961400,961500,961600,961700,961800,961900,962000,962100,962200,962300,962400,962500,962600,962700,962800,962900,963000,963100,963200,963300,963400,963500,963600,963700,963800,963900,964000,964100,964200,964300,964400,964500,964600,964700,964800,964900,965000,965100,965200,965300,965400,965500,965600,965700,965800,965900,966000,966100,966200,966300,966400,966500,966600,966700,966800,966900,967000,967100,967200,967300,967400,967500,967600,967700,967800,967900,968000,968100,968200,968300,968400,968500,968600,968700,968800,968900,969000,969100,969200,969300,969400,969500,969600,
969700,969800,969900,970000,970100,970200,970300,970400,970500,970600,970700,970800,970900,971000,971100,971200,971300,971400,971500,971600,971700,971800,971900,972000,972100,972200,972300,972400,972500,972600,972700,972800,972900,973000,973100,973200,973300,973400,973500,973600,973700,973800,973900,974000,974100,974200,974300,974400,974500,974600,974700,974800,974900,975000,975100,975200,975300,975400,975500,975600,975700,975800,975900,976000,976100,976200,976300,976400,976500,976600,976700,976800,976900,977000,977100,977200,977300,977400,977500,977600,977700,977800,977900,978000,978100,978200,978300,978400,978500,978600,978700,978800,978900,979000,979100,979200,979300,979400,979500,979600,979700,979800,979900,980000,980100,980200,980300,980400,980500,980600,980700,980800,980900,981000,981100,981200,981300,981400,981500,981600,981700,981800,981900,982000,982100,982200,982300,982400,982500,982600,982700,982800,982900,983000,983100,983200,983300,983400,983500,983600,983700,983800,983
900,984000,984100,984200,984300,984400,984500,984600,984700,984800,984900,985000,985100,985200,985300,985400,985500,985600,985700,985800,985900,986000,986100,986200,986300,986400,986500,986600,986700,986800,986900,987000,987100,987200,987300,987400,987500,987600,987700,987800,987900,988000,988100,988200,988300,988400,988500,988600,988700,988800,988900,989000,989100,989200,989300,989400,989500,989600,989700,989800,989900,990000,990100,990200,990300,990400,990500,990600,990700,990800,990900,991000,991100,991200,991300,991400,991500,991600,991700,991800,991900,992000,992100,992200,992300,992400,992500,992600,992700,992800,992900,993000,993100,993200,993300,993400,993500,993600,993700,993800,993900,994000,994100,994200,994300,994400,994500,994600,994700,994800,994900,995000,995100,995200,995300,995400,995500,995600,995700,995800,995900,996000,996100,996200,996300,996400,996500,996600,996700,996800,996900,997000,997100,997200,997300,997400,997500,997600,997700,997800,997900,998000,998100
,998200,998300,998400,998500,998600,998700,998800,998900,999000,999100,999200,999300,999400,999500,999600,999700,999800,999900);
diff --git a/sql/test/delete-from-value-list/generate-query.py
b/sql/test/delete-from-value-list/generate-query.py
new file mode 100755
--- /dev/null
+++ b/sql/test/delete-from-value-list/generate-query.py
@@ -0,0 +1,12 @@
+#!/usr/bin/env python3
+
+def delete_where_in_mega_value_list_query_statement(size, period):
+ values = [str(x) for x in range(0, size-1) if x % period == 0]
+
+ return "delete from table1 where id in ({});".format(','.join(values))
+
+delete_query_sql_file = open("delete-query.sql", "w")
+
+delete_query_sql_file.write(delete_where_in_mega_value_list_query_statement(1000000,
100))
+
+delete_query_sql_file.close()
diff --git a/sql/test/delete-from-value-list/init.sh
b/sql/test/delete-from-value-list/init.sh
new file mode 100755
--- /dev/null
+++ b/sql/test/delete-from-value-list/init.sh
@@ -0,0 +1,2 @@
+#! /bin/bash
+mclient -d debugdb init.sql
diff --git a/sql/test/delete-from-value-list/init.sql
b/sql/test/delete-from-value-list/init.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/init.sql
@@ -0,0 +1,17 @@
+drop table if exists table1 cascade;
+
+create table table1 (id int);
+
+create procedure fill_table1(maximum_size bigint)
+begin
+ declare val bigint;
+ set val = 0;
+
+ while val < maximum_size do
+ insert into table1 values (val);
+
+ set val = val + 1;
+ end while;
+end;
+
+call fill_table1(1000000);
diff --git a/sql/test/delete-from-value-list/server.pid
b/sql/test/delete-from-value-list/server.pid
new file mode 100644
--- /dev/null
+++ b/sql/test/delete-from-value-list/server.pid
@@ -0,0 +1,1 @@
+19489
diff --git a/sql/test/delete-from-value-list/start.sh
b/sql/test/delete-from-value-list/start.sh
new file mode 100755
--- /dev/null
+++ b/sql/test/delete-from-value-list/start.sh
@@ -0,0 +1,10 @@
+#! /bin/bash
+
+REL_DIR=`dirname $0`
+DB_DIR=`cd ${REL_DIR} && pwd`/debugdb
+
+mserver5 --daemon=yes --dbpath=${DB_DIR} > output.txt 2>&1 &
+
+SERVER_PID=$!
+
+echo ${SERVER_PID} > server.pid
diff --git a/sql/test/delete-from-value-list/stop.sh
b/sql/test/delete-from-value-list/stop.sh
new file mode 100755
--- /dev/null
+++ b/sql/test/delete-from-value-list/stop.sh
@@ -0,0 +1,3 @@
+#! /bin/bash
+
+kill -15 `cat server.pid`
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
