=========================================================================================================
REGRESSION REPORT
=========================================================================================================
MACHINE: drizzle-build-n02.wc1.dfw1.stabletransit.com
RUN ID: 377
RUN DATE: 2010-08-19T20:20:29.052393
WORKLOAD: innodb_1000K_readwrite
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 1303.71 +0.38% 4.96 within norms 1260.74
1324.37 1298.76 16.24
32 1600.62 +0.47% 7.45 within norms 1499.04
1668.97 1593.17 50.03
64 1739.95 +2.43% 41.27 outside norms 1633.36
1753.27 1698.68 38.39
128 1764.02 -0.61% -10.87 within norms 1731.60
1834.43 1774.90 33.97
256 1753.77 +0.65% 11.32 within norms 1706.89
1777.71 1742.46 22.71
512 1520.13 +0.32% 4.90 within norms 1490.66
1536.46 1515.23 11.97
1024 1036.32 -0.13% -1.34 within norms 988.43
1075.86 1037.66 25.11
=========================================================================================================
TRENDING OVER Last 20 runs
Conc TPS % Diff from Avg Diff Norm? Min Max
Avg STD
=========================================================================================================
16 1303.71 +1.97% 25.18 outside norms 1241.27
1324.37 1278.53 21.10
32 1600.62 +0.40% 6.42 within norms 1403.17
1668.97 1594.19 48.31
64 1739.95 +0.82% 14.22 within norms 1633.36
1774.97 1725.73 32.97
128 1764.02 -1.62% -29.01 outside norms 1731.60
1834.43 1793.04 24.59
256 1753.77 +0.21% 3.69 within norms 1706.89
1784.12 1750.08 16.59
512 1520.13 +0.10% 1.54 within norms 1487.66
1545.16 1518.59 14.15
1024 1036.32 +0.91% 9.37 within norms 887.55
1075.86 1026.96 37.87
=========================================================================================================
TRENDING OVER ALL runs
Conc TPS % Diff from Avg Diff Norm? Min Max
Avg STD
=========================================================================================================
16 1303.71 -0.30% -3.86 within norms 1130.73
1503.03 1307.57 55.19
32 1600.62 -5.79% -98.28 outside norms 1403.17
1870.18 1698.90 88.06
64 1739.95 -6.35% -117.95 outside norms 1621.67
2059.46 1857.90 104.42
128 1764.02 -6.12% -114.97 outside norms 1563.60
2051.37 1879.00 91.21
256 1753.77 +1.77% 30.50 within norms 1340.97
1824.49 1723.28 73.97
512 1520.13 +28.41% 336.35 outside norms 828.88
1550.54 1183.78 163.67
1024 1036.32 +64.30% 405.57 outside norms 450.29
1080.73 630.75 167.45
=========================================================================================================
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
