=========================================================================================================
REGRESSION REPORT
=========================================================================================================
MACHINE: drizzle-build-n01.wc1.dfw1.stabletransit.com
RUN ID: 382
RUN DATE: 2010-08-19T20:47:00.103167
WORKLOAD: innodb_1000K_readonly
SERVER: drizzled
VERSION: lp:drizzle/staging
REVISION: 1721
COMMENT: 1721: Patrick Crews 2010-08-19 [merge] Rollup patch - stewart's show
create table patch + a couple of fixes
=========================================================================================================
TRENDING OVER LAST 5 runs
Conc TPS % Diff from Avg Diff Norm? Min Max
Avg STD
=========================================================================================================
16 2071.90 +2.18% 44.24 outside norms 1986.83
2075.54 2027.66 29.92
32 2631.77 +0.89% 23.12 within norms 2492.04
2673.33 2608.65 45.72
64 2588.27 -0.37% -9.68 within norms 2534.40
2653.08 2597.95 40.14
128 2654.39 +1.29% 33.76 within norms 2547.40
2688.66 2620.63 50.51
256 2629.17 +1.71% 44.21 within norms 2490.69
2639.70 2584.96 45.59
512 2388.28 +0.08% 2.00 within norms 2336.24
2431.60 2386.29 31.20
1024 1705.98 -0.50% -8.53 within norms 1673.20
1772.75 1714.51 27.13
=========================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Norm? Min Max
Avg STD
=========================================================================================================
16 2071.90 +2.24% 45.44 outside norms 1940.14
2104.73 2026.47 32.65
32 2631.77 -0.36% -9.55 within norms 2492.04
2712.75 2641.31 39.23
64 2588.27 -1.73% -45.50 outside norms 2534.40
2699.15 2633.76 36.02
128 2654.39 +0.39% 10.37 within norms 2547.40
2694.85 2644.02 33.11
256 2629.17 +0.18% 4.62 within norms 2490.69
2678.78 2624.54 39.50
512 2388.28 -0.85% -20.59 within norms 2336.24
2469.42 2408.87 31.70
1024 1705.98 -1.05% -18.14 within norms 1673.20
1773.91 1724.12 22.79
=========================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Norm? Min Max
Avg STD
=========================================================================================================
16 2071.90 -0.82% -17.05 within norms 1765.65
2233.42 2088.96 73.40
32 2631.77 -3.95% -108.19 outside norms 2010.47
2909.92 2739.95 106.29
64 2588.27 -7.90% -221.95 outside norms 2191.91
2998.80 2810.22 121.10
128 2654.39 -3.28% -90.10 within norms 2107.33
2911.98 2744.50 92.43
256 2629.17 +4.92% 123.24 outside norms 2174.91
2691.02 2505.93 89.66
512 2388.28 +55.76% 855.02 outside norms 968.50
2470.12 1533.27 392.80
1024 1705.98 +107.08% 882.15 outside norms 485.25
1785.20 823.82 407.19
=========================================================================================================
FULL REVISION COMMENTARY:
1720.1.3: Patrick Crews 2010-08-19 [merge] Merge Monty to make intltool
optional
1719.1.1: Monty Taylor 2010-08-19 _actually_ make OSX work with no
intltool. Sorry.
1720.1.2: Patrick Crews 2010-08-19 Updated pbxt tests due to inclusion of
COLLATE info in SHOW CREATE TABLE output now. Only re-recorded .result files
1720.1.1: Brian Aker 2010-08-19 [merge] Merging Stewart's show create table
patch.
1638.10.120: Stewart Smith 2010-08-17 [merge] merge trunk
1638.10.119: Stewart Smith 2010-08-17 make innobase plugin not directly
access the mysql_query_str for CREATE TABLE, and instead use the table protobuf
message and statement_transform to get a SQL string to pass to innobase for
parsing to get the foreign keys out of it.
1638.10.118: Stewart Smith 2010-08-17 fix naming of constraints to be more
standards compliant and correct. the index_name part of it just doesn't exist
in SQL-99
1638.10.117: Stewart Smith 2010-08-16 update innodb test for auto_increment
behaviour
1638.10.116: Stewart Smith 2010-08-16 only display AUTO_INCREMENT value if
explicitly set by user (and preserve across ALTER TABLE).
1638.10.115: Stewart Smith 2010-08-11 remove auto_increment in TableOptions
in Table protobuf message. It was unused and confusing
1638.10.114: Stewart Smith 2010-08-10 when creating a CreateField from a
Field, a auto_incremen column should not have a default value of 0 as that's
not magic.
1638.10.113: Stewart Smith 2010-08-10 [merge] link fix for
libdrizzled_message
1638.10.112: Stewart Smith 2010-08-10 [merge] fix linking of
drizzled/message lib and libcharset
1638.10.111: Stewart Smith 2010-08-09 fix drizzledump-max test result for
having explicit COLLATE in SHOW CREATE TABLE
1638.10.110: Stewart Smith 2010-08-09 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.109: Stewart Smith 2010-08-05 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.108: Stewart Smith 2010-08-04 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.107: Stewart Smith 2010-08-03 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.106: Stewart Smith 2010-08-03 fix null_values transaction_log
CREATE TABLE result
1638.10.105: Stewart Smith 2010-08-03 fix filesystem_engine test case
results for CREATE TABLE out of proto
1638.10.104: Stewart Smith 2010-08-02 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.103: Stewart Smith 2010-07-30 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.102: Stewart Smith 2010-07-29 [merge] merge trunk
1638.10.101: Stewart Smith 2010-07-28 [merge] merge test fixes for
DATE/DATETIME default
1638.10.100: Stewart Smith 2010-07-28 [merge] merge fix for default value
of DATE in proto
1638.10.99: Stewart Smith 2010-07-28 fix type_datetime.result for explicit
COLLATE in SHOW CREATE TABLE
1638.10.98: Stewart Smith 2010-07-28 update transaction_log/update.result
to reflect correct CREATE TABLE statements. My code is correct, old
statement_transform wasn't reproducing the CREATE TABLE statement correctly.
1638.10.97: Stewart Smith 2010-07-28 [merge] merge in table comment fix
1638.10.96: Stewart Smith 2010-07-28 fix show_check test result for
explicit COLLATE in SHOW CREATE TABLE
1638.10.95: Stewart Smith 2010-07-28 fix archive_aio_posix test result for
explicit COLLATE in SHOW CREATE TABLE
1638.10.94: Stewart Smith 2010-07-28 [merge] merge fix for RENAME TABLE for
ARCHIVE
1638.10.93: Stewart Smith 2010-07-28 ARCHIVE test result for explicit
COLLATE in SHOW CREATE TABLE
1638.10.92: Stewart Smith 2010-07-27 even more fixes due to SHOW CREATE
TABLE now actually working
1638.10.91: Stewart Smith 2010-07-27 test result fixes for the dictionary
suites: table names should be upper case as well as having explicit COLLATE in
SHOW CREATE TABLE
1638.10.90: Stewart Smith 2010-07-27 blackhole create_max_fields test to
have explicit COLLATE in SHOW CREATE TABLE
1638.10.89: Stewart Smith 2010-07-27 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.88: Stewart Smith 2010-07-27 fix SHOW CREATE TABLE tests for
explicit COLLATE in CREATE TABLE
1638.10.87: Stewart Smith 2010-07-27 fix SHOW CREATE TABLE tests for
explicit COLLATE in CREATE TABLE
1638.10.86: Stewart Smith 2010-07-27 fix some more tests for explicit
COLLATE in CREATE TABLE, including transaction_log whitespace changes
1638.10.85: Stewart Smith 2010-07-27 explicit COLLATE in CREATE TABLE test
result fixes for innodb_mysql test
1638.10.84: Stewart Smith 2010-07-27 some CREATE TABLE fixes for
transaction_log tests
1638.10.83: Stewart Smith 2010-07-26 fix some more tests for explicit
COLLATE in CREATE TABLE
1638.10.82: Stewart Smith 2010-07-26 fix some tests for explicit COLLATE in
CREATE TABLE
1638.10.81: Stewart Smith 2010-07-26 fix key.result for explicit COLLATE in
CREATE TABLE
1638.10.80: Stewart Smith 2010-07-26 fix storing and manipulating foreign
keys in the proto around ALTER TABLE, CREATE TABLE and ALTER TABLE ADD/DROP
FOREIGN KEY. We also (mostly) emulate the naming of innodb foreign keys in the
upper layer.
1638.10.79: Stewart Smith 2010-07-26 restore the foreign key names to SHOW
CREATE TABLE in the innodb test result file.
1638.10.78: Stewart Smith 2010-07-26 separate out adding the foreign key to
the table protobuf message from mysql_prepare_create_table and call a function
to do it directly from the parser where we set up the foreign key structures
1638.10.77: Stewart Smith 2010-07-26 table_ident.h was missing a dependency
on session.h for: ./drizzled/table_ident.h:53: error: ?empty_c_string? was not
declared in this scope
1638.10.76: Stewart Smith 2010-07-21 innodb.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.75: Stewart Smith 2010-07-21 heap.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.74: Stewart Smith 2010-07-21 func_system.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.73: Stewart Smith 2010-07-21 func_misc.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.72: Stewart Smith 2010-07-21 func_math.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.71: Stewart Smith 2010-07-21 func_group.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.70: Stewart Smith 2010-07-21 func_gconcat.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.69: Stewart Smith 2010-07-21 foreign_key.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.68: Stewart Smith 2010-07-21 drizzledump.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.67: Stewart Smith 2010-07-21 default_collation.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.66: Stewart Smith 2010-07-21 default.result with explicit COLLATE
in SHOW CREATE TABLE
1638.10.65: Stewart Smith 2010-07-21 ctype_utf8.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.64: Stewart Smith 2010-07-21 create_no_windows.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.63: Stewart Smith 2010-07-21 create.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.62: Stewart Smith 2010-07-21 constraint.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.61: Stewart Smith 2010-07-21 comment_talbe.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.60: Stewart Smith 2010-07-21 comment_index.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.59: Stewart Smith 2010-07-21 comment_column.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.58: Stewart Smith 2010-07-21 case.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.57: Stewart Smith 2010-07-21 binary.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.56: Stewart Smith 2010-07-21 bigint.result with explicit COLLATE in
SHOW CREATE TABLE
1638.10.55: Stewart Smith 2010-07-21 auto_increment.result with explicit
COLLATE in SHOW CREATE TABLE
1638.10.54: Stewart Smith 2010-07-21 alter_table.result: COLLATE and ENGINE
in same line for SHOW CREATE TABLE
1638.10.53: Stewart Smith 2010-07-21 no newline before COLLATE in SHOW
CREATE TABLE
1638.10.52: Stewart Smith 2010-07-21 alter_table test: COLLATE is now
explicit in SHOW CREATE TABLE as table proto has no way to find out if it was
an explicit option or not.
1638.10.51: Stewart Smith 2010-07-21 show_create_table_basic test: COLLATE
is now explicit in SHOW CREATE TABLE as table proto has no way to find out if
it was an explicit option or not.
1638.10.50: Stewart Smith 2010-07-21 revert patch that removse explicitly
setting collation for talbe_function tables.
1638.10.49: Stewart Smith 2010-07-20 [merge] merge trunk
1638.10.48: Stewart Smith 2010-07-19 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.47: Stewart Smith 2010-07-13 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.46: Stewart Smith 2010-07-13 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.45: Stewart Smith 2010-07-12 don't have internal innodb foreign key
names in FOREIGN KEY clauses in innodb.result
1638.10.44: Stewart Smith 2010-07-12 fix spaces in CREATE TABLE ... FOREIGN
KEY statement
1638.10.43: Stewart Smith 2010-07-12 foreign_key test result update: don't
have innodb internal foreign key names in the result (now that we're using
statement_transform for foreign key)
1638.10.42: Stewart Smith 2010-07-12 [merge] Merged
store-foreign-key-in-table-proto into show-create-table-using-table-message.
1638.10.41: Stewart Smith 2010-07-06 [merge] Merged
varchar-text-keylength-in-proto-as-characters-not-bytes into
show-create-table-using-table-message.
1638.10.40: Stewart Smith 2010-07-05 [merge] Merged
bug600635-table-proto-default-null-false into
show-create-table-using-table-message.
1638.10.39: Stewart Smith 2010-07-02 correctly have auto_increment value in
drizzledump test result
1638.10.38: Stewart Smith 2010-07-02 correctly have default COLLATE for
table in SHOW CREATE TABLE result for default_collation test result.
1638.10.37: Stewart Smith 2010-07-02 fix result of default test: varbinary
defaults are now represented as hex in SHOW CREATE TABLE and the COLLATE for
the table wasn't being shown.
1638.10.36: Stewart Smith 2010-07-02 correct the create.result file to show
the COLLATE clause at teh end of the SHOW CREATE TABLE output. Previously, this
wasn't being displayed due to some kind of bug.
1638.10.35: Stewart Smith 2010-07-02 table_function doesn't need to
explicitly set collation for its tables as the default (utf8_general_ci) is
exactly what we want.
1638.10.34: Stewart Smith 2010-07-02 [merge] Merged
bug600635-table-proto-default-null-false into
show-create-table-using-table-message.
1638.10.33: Stewart Smith 2010-07-01 index comments in statement_transform
1638.10.32: Stewart Smith 2010-07-01 statement transform for create table:
formatting of decimal default value doesn't matter
1638.10.31: Stewart Smith 2010-07-01 statement_transform for CREATE TABLE:
only print DEFAULT NULL if default_null is actually set, not just if the proto
has it.
1638.10.30: Stewart Smith 2010-07-01 get USING (BTREE|HASH) index type
syntax correct for statement_transform in CREATE TABLE.
1638.10.29: Stewart Smith 2010-07-01 fix collation detection for BLOB/TEXT
in statement_transform for CREATE TABLE. Also, the DEFAULT NULL for BLOB
columns is implicit, so don't print it.
1638.10.28: Stewart Smith 2010-07-01 fix a lot of quoting and escaping of
things in SHOW CREATE TABLE in statement_transform
1638.10.27: Stewart Smith 2010-07-01 [merge] Merged
bug600088-multibyte-comments-in-show-create into
show-create-table-using-table-message.
1638.10.26: Stewart Smith 2010-06-30 use length of create table string in
appending to packet.
1638.10.25: Stewart Smith 2010-06-30 fix table comment formatting in
statement_transform to have SHOW CREATE work with a table comment
1638.10.24: Stewart Smith 2010-06-30 fix display of VARBINARY default
values in SHOW CREATE TABLE. Always use printable characters by encoding in hex.
1638.10.23: Stewart Smith 2010-06-30 add SHOW CREATE TABLE test for
VARBINARY columns (especially with default values).
1638.10.22: Stewart Smith 2010-06-30 [merge] Merged
use-CURRENT_TIMESTAMP-in-proto into show-create-table-using-table-message.
1638.10.21: Stewart Smith 2010-06-30 [merge] Merged
use-CURRENT_TIMESTAMP-in-proto into show-create-table-using-table-message.
1638.10.20: Stewart Smith 2010-06-30 present DEFAULT and ON UPDATE
correctly in statement_transform
1638.10.19: Stewart Smith 2010-06-30 [merge] Merged
table-proto-default-update-expression into
show-create-table-using-table-message.
1638.10.18: Stewart Smith 2010-06-29 [merge] merge
1638.10.17: Stewart Smith 2010-06-29 fix SHOW CREATE TABLE
(statement_transform) for auto_increment, including the (now correct)
auto_increment test result.
1638.10.16: Stewart Smith 2010-06-29 fix up AUTO_INCREMENT must be after
NOT NULL in statement_transform
1638.10.15: Stewart Smith 2010-06-29 TIMESTAMP fields are default NOT NULL
for some bonghits reason, so we get to have explicit NULLability.
1638.10.14: Stewart Smith 2010-06-28 if a DOUBLE column has scale and
precision, display them
1638.10.13: Stewart Smith 2010-06-28 NOT NULL comes after COLLATE in CREATE
TABLE
1638.10.12: Stewart Smith 2010-06-28 fix the bonghits quoting rules in
field CREATE TABLE definitions for quotes around the identifier, comment and
default value.
1638.10.11: Stewart Smith 2010-06-28 fix varchar/varbinary and blob/text
for statement_transform of table definition
1638.10.10: Stewart Smith 2010-06-28 fix statement_transform for producing
list of engine options
1638.10.9: Stewart Smith 2010-06-28 [merge] merge
1638.10.8: Stewart Smith 2010-06-28 fix DEFAULT NULL and NOT NULL for
statement_transform
1638.10.7: Stewart Smith 2010-06-28 [merge] Merged
default-collation-in-table-message into show-create-table-using-table-message.
1638.10.6: Stewart Smith 2010-06-28 statement_transform: ENGINE clause of
CREATE TABLE doesn't have spaces around equals sign
1638.10.5: Stewart Smith 2010-06-28 statement_transform: only print index
name iff it's not PRIMARY for a pkey. Also get indenting correct for index
names.
1638.10.4: Stewart Smith 2010-06-28 statement_transform for CREATE TABLE:
field types are lower case.
1638.10.3: Stewart Smith 2010-06-28 statement_transform for CREATE TABLE:
fields are indented by 2 spaces
1638.10.2: Stewart Smith 2010-06-28 for store_create_info() (called in SHOW
CREATE TABLE code path) call transformTableDefinitionToSql() in
statement_transform lib instead of doing manual things on Table. This is the
initial step in getting SHOW CREATE TABLE to be run from proto.
1638.10.1: Stewart Smith 2010-06-28 add really simple SHOW CREATE TABLE
test to help with migrating SHOW CREATE to use proto
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
