Changeset: 6942918c41da for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6942918c41da Modified Files: sql/benchmarks/tpch/dbgen/BUGS sql/benchmarks/tpch/dbgen/CHANGES sql/benchmarks/tpch/dbgen/HISTORY sql/benchmarks/tpch/dbgen/PORTING.NOTES sql/benchmarks/tpch/dbgen/bcd2.c sql/benchmarks/tpch/dbgen/bcd2.h sql/benchmarks/tpch/dbgen/bm_utils.c sql/benchmarks/tpch/dbgen/build.c sql/benchmarks/tpch/dbgen/config.h sql/benchmarks/tpch/dbgen/dists.dss sql/benchmarks/tpch/dbgen/driver.c sql/benchmarks/tpch/dbgen/dss.ddl sql/benchmarks/tpch/dbgen/dss.h sql/benchmarks/tpch/dbgen/dss.ri sql/benchmarks/tpch/dbgen/dsstypes.h sql/benchmarks/tpch/dbgen/history.html sql/benchmarks/tpch/dbgen/load_stub.c sql/benchmarks/tpch/dbgen/makefile.suite sql/benchmarks/tpch/dbgen/permute.c sql/benchmarks/tpch/dbgen/permute.h sql/benchmarks/tpch/dbgen/print.c sql/benchmarks/tpch/dbgen/qgen.c sql/benchmarks/tpch/dbgen/rnd.c sql/benchmarks/tpch/dbgen/rnd.h sql/benchmarks/tpch/dbgen/shared.h sql/benchmarks/tpch/dbgen/speed_seed.c sql/benchmarks/tpch/dbgen/text.c sql/benchmarks/tpch/dbgen/tpcd.h sql/benchmarks/tpch/dbgen/varsub.c Branch: Dec2011 Log Message:
Removed TPC-H dbgen sources. These sources aren't ours, so we shouldn't do as if they are. If you need them, you can get them from http://www.tpc.org/tpch/. diffs (truncated from 10133 to 300 lines): diff --git a/sql/benchmarks/tpch/dbgen/BUGS b/sql/benchmarks/tpch/dbgen/BUGS deleted file mode 100644 --- a/sql/benchmarks/tpch/dbgen/BUGS +++ /dev/null @@ -1,987 +0,0 @@ -# @(#) BUGS 2.1.8.20@(#) -# The following is a list of the various DBGEN/QGEN bugs that have been -# and are being fixed. Each entry is of the form: -# -# Problem #xx: STATUS -- MR ID and OPEN/closed -# followed by a detailed explanation -# TYPE: -- classification of the bug or issue -# SPEC FIX: -- details of any change to the spec -# DBGEN FIX: -- details of any change needed to QGEN/DBGEN -# ANSWER SETS: -- any effect on answer sets -# WORKAROUND: -- temporary fix, if available -# HELP NEEDED: -- any work/assistance required -# AUDITORS NOTIFIED: -- date auditors were notified, if appropriate -# OPENED AGAINST: -- date and effected versions -# CLOSED IN: -- date and fixed version -# -# OPEN BUGS -# ========== -# Problem #33: Parallel load doesn't work under NT -# -# OPEN Feature Requests -# ================= -# Problem #9: would like to include answer set formatting in query templates -# Problem #37: need way to validate DBGEN without large storage requriement -# Problem #58: Need way to track changes from one release to the next -# -# OPEN Documentation Errors -# ================= -# None -#--------------------------------------------------------------------- -#Complete Bug List -#================== -Problem #1: closed -Summary: Q10 returns no rows - Since orders can only be returned (l_returnflag = 'R') after they - have been received, and can't be received in the future, the - number of permissible orders for query 10 tails off early in - 1995. If you are lucky enough to get a parameter substitution - after February '95 (allowed in 2.12.3), things can go "quickly". -SEVERITY: -SPEC FIX: replace 2.12.3 (1) with "DATE is the first day in a - rundomly selected month between the first month of 1993 and the - last month of 1994" -DBGEN FIX: change permisible substitution range for query 10, - parameter 1 -ANSWER SETS: not effected. -WORKAROUND: use a different seed for qgen parameter substitution -HELP NEEDED: -AUDITORS NOTIFIED: -OPENED AGAINST: 1.0 -CLOSED IN: 1.0.1 (dbgen and qgen) - -Problem #2: closed -Summary: parallelism in load to gen differing data sets -the parallel load code was based on extensible data sets; since - each "extension" made an assumption of scale factor, the data - could end up clustered. Further, since the RNG is - self-modifying, different numbers of extension led to different - final data sets. -SEVERITY: -SPEC FIX: none. -DBGEN FIX: remove -E(xtensible) option and implement pure parallel -load with a known scale factor; rebuild seed files -ANSWER SETS: not effected. (parallelism not implemented for SF <= 1) -WORKAROUND: don't use the parallel load (-C) option to DBGEN -HELP NEEDED: testers needed. -AUDITORS NOTIFIED: yes. -OPENED AGAINST: 1.0 -CLOSED IN: 1.0.1 - -Problem #3: closed -Summary: some arithmetic tends to overflow at large SF -retailprice tends to SF/10 as SF increases. this can lead to - data corruption in extendedprice and aggregate calculations -SEVERITY: -SPEC FIX: will need rework of 1.3 wrt retailprice calculation -DBGEN FIX: modification to second term of rpb_routine() calcuation -to limit contibution of second term to the maximum seen at - SF=.1 -ANSWER SETS: not effected -WORKAROUND: code retail/extended price calculations as long long; -build smaller data sets -HELP NEEDED: -AUDITORS NOTIFIED: -OPENED AGAINST: 1.0 -CLOSED IN: 1.0.1 - -Problem #4: closed -Summary: dbgen not ported to NT -SEVERITY: -SPEC FIX: none -DBGEN FIX: need to roll in changes supplied by IBM -ANSWER SETS: not effected -WORKAROUND: N/A -HELP NEEDED: N/A -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0 -CLOSED IN: 1.1.0 - -Problem #5: closed -Summary: QGEN seed init inconsistent -A prior fix assured that parameter values were query order - independent when a seed was provided on the command line. need - to make this true when no seed is provided -SEVERITY: -SPEC FIX: none -DBGEN FIX: rework seed init loop in qgen.c -ANSWER SETS: not effected -WORKAROUND: supply seeds on command line -HELP NEEDED: none -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0 -CLOSED IN: 1.0.1 - -Problem #6: closed -Summary: command line options with abutting arguments mishandled -SEVERITY: -SPEC FIX: none -DBGEN FIX: minor fix to getopt routine in bm_utils.c -ANSWER SETS: not effected -WORKAROUND: separate options and arguments with a space -HELP NEEDED: none -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0 -CLOSED IN: 1.0.1 - -Problem #7: closed -Summary: '-O f' asking for new file names twice -SEVERITY: -SPEC FIX: none -DBGEN FIX: rework of set_files() in driver.c -ANSWER SETS: not effected -WORKAROUND: none -HELP NEEDED: none -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0 -CLOSED IN: 1.0.1 - -Problem #8: closed -Summary: Seed generation taking too long -SEVERITY: -SPEC FIX: N/A -DBGEN FIX: implement "skip and trudge" as discussed -ANSWER SETS: not effected -WORKAROUND: none -HELP NEEDED: -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0 -CLOSED IN: 1.0.1 - -Problem #9: OPEN -Summary: would like to include answer set formatting in query templates -SEVERITY: feature request -SPEC FIX: none -DBGEN FIX: additional flag in qgen() -ANSWER SETS: not effected -WORKAROUND: N/A -HELP NEEDED: asked for reproduction info 25 Oct 95 -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0 -CLOSED IN: - -Problem #10: closed -Summary: need to re-introduce ability to do incremental, flat file builds -SEVERITY: feature request -SPEC FIX: none -DBGEN FIX: add -S(tep) option to build one of many partial data sets -ANSWER SETS: not effected -WORKAROUND: N/A -HELP NEEDED: -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0 -CLOSED IN: 1.0.1 - -Problem #11: closed -Summary: Row count for first delete at 10/100 is incorrect -SEVERITY: Error -SPEC FIX: None -DBGEN FIX: -ANSWER SETS: No Effect -WORKAROUND: hand edit of first delete file -HELP NEEDED: -AUDITORS NOTIFIED: No -OPENED AGAINST: 1.0.1 -CLOSED IN: 2.0.0 (not sure of precise release) -CLOSED BY: [email protected] - -Problem #12: closed -Summary: Bad default rowcount generated for query 17 -SEVERITY: Error -SPEC FIX: None -DBGEN FIX: corrected rowcnt[] entries to be 1-based -ANSWER SETS: N/A -WORKAROUND: hand edit query or add explicit row count to template -HELP NEEDED: -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0.0 -CLOSED IN: 1.1.0 - -Problem #13: closed -Summary: Bad expansion of SET_OUTPUT for Teradata -SEVERITY: Error -SPEC FIX: N/A -DBGEN FIX: new macro in tpcd.h -ANSWER SETS: N/A -WORKAROUND: Hand edit query or hardcode output directive in templates -HELP NEEDED: -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0.1 -CLOSED IN: 1.1.0 - -Problem #14: closed -Summary: Badly formed range deletes -SEVERITY: Error -SPEC FIX: N/A -DBGEN FIX: TBD -ANSWER SETS: N/A -WORKAROUND: hand edit delete files -HELP NEEDED: asked for reproduction info 25 Oct 95 -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0.1 -CLOSED IN: 2.0.0 (not sure of precise release) -CLOSED BY: [email protected] - -Problem #15: closed -Summary: in a multi-stage load, parent tables are not properly named -when parent and child are build simultaneously -SEVERITY: Error -SPEC FIX: N/A -DBGEN FIX: reworked tdef[].name in pr_X_Y routines for master/detail -tables -ANSWER SETS: N/A -WORKAROUND: Build master/detail tables separately -HELP NEEDED: -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0.1 -CLOSED IN: 1.1.0 - -Problem #16: closed -Summary: update generation at large scale factors produced the wrong number -of rows due to overflow of 32-bit integer -SEVERITY: BUG -SPEC FIX: N/A -DBGEN FIX: corrected order of operations in row count calcuation in -driver.c -ANSWER SETS: N/A -WORKAROUND: use 64 bit integers -HELP NEEDED: None -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0.1 -CLOSED IN: 1.1.0 - -Problem #17: closed -Summary: comment fields may be truncated when using columnar output, due to -rounding/truncation in the length calculation -SEVERITY: BUG -SPEC FIX: N/A -DBGEN FIX: add ceil() calls around all PR_VSTR() calls in print.c -ANSWER SETS: N/A -WORKAROUND: N/A -HELP NEEDED: None -AUDITORS NOTIFIED: N/A -OPENED AGAINST: 1.0.1 -CLOSED IN: 1.1.0 - -Problem #18: closed -Summary: the output format for identifier fields in columnar output is -unneccessarily large, and is inconsistant -SEVERITY: minor -SPEC FIX: N/A -DBGEN FIX: revised PR_BCD2 macro -ANSWER SETS: N/A -WORKAROUND: avoid columnar output, or rework macro -HELP NEEDED: none -AUDITORS NOTIFIED: no -OPENED AGAINST: 1.1.0 -OPENED BY: [email protected] -CLOSED IN: 1.1.0A -CLOSED BY: [email protected] - -Problem #19: closed -Summary: the case statement used to decipher substitution points in the -query template allowed extraneous :'s to re-initialize the -parameter substitution -SEVERITY: bug -SPEC FIX: N/A -DBGEN FIX: rework flag switch in qgen.c to explicitly call out numerics -ANSWER SETS: N/A -WORKAROUND: be sure that there are no "unknown" flags in the template -HELP NEEDED: none -AUDITORS NOTIFIED: yes -OPENED AGAINST: 1.0.1 -OPENED BY: [email protected] -CLOSED IN: 1.1.0A -CLOSED BY: [email protected] _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
