Update of /cvsroot/monetdb/sql/src/backends/monet5
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv24677
Modified Files:
sql_optimizer.mx
Log Message:
Update of the MAL coverage section.
Index: sql_optimizer.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/backends/monet5/sql_optimizer.mx,v
retrieving revision 1.158
retrieving revision 1.159
diff -u -d -r1.158 -r1.159
--- sql_optimizer.mx 29 Jul 2007 16:08:22 -0000 1.158
+++ sql_optimizer.mx 18 Aug 2007 09:11:44 -0000 1.159
@@ -24,59 +24,106 @@
the client record. They are initialized as part of the initialization
phase of the scenario.
-The SQL compiler uses only a small subset of the MAL language.
-This involves ca 70 different operators, divided into the
-catalog management (?) and query processing (?)
@{
-[Make complete list of MAL instructions used in the compilation]
-alarm.usec
-algebra.count
-algebra.join
-algebra.kunique
-algebra.likeselect
-algebra.markT
-algebra.outerjoin
-algebra.semijoin
-algebra.sintersect
-algebra.slice
-algebra.tunique
-algebra.uselect
-bat.append
-batcalc.project
-bat.insert
-bat.mirror
-bat.new
-bat.replace
-bat.reverse
-bat.seqbase
-bat.{setReadMode, setWriteMode}
-bat.sort
-bat.tsort
-bbp.project
-calc.{<,<=,=,!=,>,>=}
-calc.{-.+.*,/,%}
-calc.{oid,int,flt,dbl,str,chr,bit}
-group.group
-group.refine
-group.refine_reverse
-io.printf
-optimizer.multiplex
-sql.assert
-sql.bind
-sql.bind_dbat
-sql.bind_idxbat
-sql.clear_table
-sql.column
-sql.columnBind
-sql.eval
-sql.output
-sql.print
-sql.setVariable
-str.codeset
-stream.close
-stream.openRead
-str.iconv
-??.{sum,min,max,count}
+August 18, 2007 the following coverage list was extracted from the SQL test set
+
+The SQL compiler uses only a small subset of the MAL language
+using the default optimizer sequence.
+This reference list is illustrative for optimizer developers .
+
+ 2429 sql.bind 17 algebra.select
+ 1734 algebra.join 14 sql.append_idxbat
+ 1337 bat.reverse 14 algebra.selectNotNil
+ 966 sql.rsColumn 13 str.toLower
+ 964 constraints.emptySet 12 mmath.cos
+ 816 algebra.markT 12 batcalc.hash
+ 688 bat.append 12 batcalc.*
+ 517 algebra.joinPath 12 algebra.markH
+ 506 algebra.project 10 sql.bbp
+ 495 algebra.uselect 9 sql.bind_idxbat
+ 408 bat.mirror 9 aggr.sum
+ 366 bat.setWriteMode 8 sql.setVariable
+ 343 sql.resultSet 8 batcalc.length
+ 343 sql.exportResult 7 sql.getVariable
+ 225 group.new 7 batcalc.isnil
+ 214 algebra.semijoin 7 batcalc.int
+ 158 group.derive 7 algebra.thetajoin
+ 158 aggr.count 7 algebra.find
+ 143 algebra.kdifference 6 sql.next_value
+ 113 sql.columnBind 6 sql.exportOperation
+ 111 bat.new 6 mmath.sin
+ 106 sql.assert 6 calc.or
+ 104 bat.hasMoreElements 6 calc.lng
+ 99 bat.replace 6 calc.abs
+ 98 aggr.count_no_nil 6 calc.>
+ 85 calc.int 6 batcalc.-
+ 85 algebra.kunion 5 sql.importTable
+ 82 mkey.bulk_rotate_xor_hash 5 mtime.current_timestamp
+ 80 sql.bind_dbat 5 calc.ifthenelse
+ 67 sql.exportValue 5 batcalc.bte
+ 64 bat.insert 5 algebra.slice
+ 56 calc.sht 5 aggr.avg
+ 52 exit MALException:str 4 str.stringlength
+ 52 exit 4 sql.clear_table
+ 52 catch MALException:str 4 io.stdin
+ 52 bat.newIterator 4 calc.dbl
+ 51 sql.append 4 batcalc./
+ 51 algebra.sortTail 4 aggr.max
+ 50 sql.affectedRows 3 str.trim
+ 50 group.refine 3 sql.zero_or_one
+ 48 batcalc.== 3 mtime.current_date
+ 45 calc.!= 3 calc.second_interval
+ 40 pcre.like 3 bat.inplace
+ 37 calc.str 3 batcalc.<
+ 34 calc.* 3 algebra.groupby
+ 34 batcalc.str 3 aggr.min
+ 33 nil:dbl 2 str.like
+ 30 algebra.reuse 2 sql.sql_environment
+ 28 str.stringleft 2 sql.not_unique
+ 23 sql.dump_opt_stats 2 sql.dump_cache
+ 23 calc.isnil 2 nil:lng
+ 23 calc.- 2 mtime.hours
+ 21 calc./ 2 mtime.diff
+ 20 calc.== 2 mmath.sqrt
+ 17 calc.+ 2 mmath.rand
+ 17 batcalc.+ 2 mmath.atan
+ 2 mmath.acos 1 mserver.disconnect
+ 2 calc.not 1 mmath.floor
+ 2 calc.date 1 group.refine_reverse
+ 2 batcalc.not 1 calc.month_interval
+ 2 batcalc.!= 1 calc.min
+ 2 batcalc.<= 1 calc.length
+ 2 aggr.rank_grp 1 calc.flt
+ 2 aggr.exist 1 calc.daytime
+ 1 str.substring 1 calc.bte
+ 1 streams.openRead 1 calc.and
+ 1 streams.close 1 calc.<
+ 1 sql.round 1 bstream.destroy
+ 1 sql.restart 1 bstream.create
+ 1 sql.dec_round 1 batcalc.sht
+ 1 pqueue.topn_max 1 batcalc.>
+ 1 mtime.minutes 1 algebra.kunique
+ 1 mtime.date_add_sec_interval
+
+Organized by module:
+ 4657 algebra
+ 4652 sql
+ 3232 bat
+ 964 constraints
+ 434 group
+ 409 calc
+ 281 aggr
+ 171 batcalc
+ 82 mkey
+ 51 str
+ 40 pcre
+ 27 mmath
+ 14 mtime
+ 4 io
+ 2 streams
+ 2 bstream
+ 1 pqueue
+ 1 mserver
@}
@h
#ifndef _SQL_OPTIMIZER_H_
@@ -418,9 +465,10 @@
"commonTerms,"
"accumulators,"
"joinPath,"
+ /*"partitions,"*/
+ /* "mergetable,"*/
"deadcode,"
"reduce,"
- /* "partitions,"*/
"garbageCollector,"
"multiplex";
static str minimalPlan=
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
