=======================================================================================
DBT2 REPORT
=======================================================================================
MACHINE: orisndriz01
RUN ID: 1013
RUN DATE: 2011-03-17T16:36:43.118873
SERVER: drizzled
VERSION: staging
REVISION: 2241
COMMENT: 2241: Lee Bieber 2011-03-17 [merge] Merge Stewart - 728855: BLOB
column can have default '' (empty string) in CREATE TABLE but not ALTER TABLE
ALTER
================================================================================================
TRENDING OVER LAST 5 runs
Connections TPM % Diff from Avg Diff Min Max Avg STD
================================================================================================
16 130.75 +2.11% 2.70 123.91 133.29 128.05 3.50
32 125.28 -2.73% -3.52 125.28 134.27 128.80 3.35
64 127.43 -0.64% -0.82 126.06 130.55 128.25 1.85
128 127.43 -1.12% -1.44 127.43 131.14 128.87 1.56
256 129.19 +1.85% 2.35 124.10 129.19 126.84 1.72
512 132.51 +5.98% 7.47 121.56 132.51 125.04 3.84
1024 129.38 -0.10% -0.12 124.89 134.85 129.50 3.18
================================================================================================
TRENDING OVER LAST 20 runs
Connections TPM % Diff from Avg Diff Min Max Avg STD
================================================================================================
16 130.75 +2.74% 3.49 123.91 133.29 127.26 2.28
32 125.28 -1.47% -1.87 120.39 134.27 127.15 3.22
64 127.43 +0.36% 0.46 120.78 130.98 126.97 2.90
128 127.43 -0.07% -0.10 121.17 133.88 127.53 3.22
256 129.19 +0.87% 1.11 123.52 131.34 128.08 2.56
512 132.51 +3.48% 4.46 121.56 135.83 128.05 3.97
1024 129.38 +1.81% 2.30 120.98 134.85 127.08 3.84
================================================================================================
TRENDING OVER ALL runs
Connections TPM % Diff from Avg Diff Min Max Avg STD
================================================================================================
16 130.75 +2.75% 3.50 115.60 136.22 127.25 3.24
32 125.28 -1.83% -2.33 115.60 137.79 127.61 3.36
64 127.43 -0.04% -0.05 115.79 137.45 127.48 3.23
128 127.43 -0.00% 0.00 115.40 136.86 127.43 3.39
256 129.19 +1.32% 1.69 117.06 137.39 127.50 3.35
512 132.51 +3.96% 5.05 115.95 135.83 127.46 3.29
1024 129.38 +1.61% 2.05 115.09 136.81 127.33 3.21
=========================================================================================================================
FULL REVISION COMMENTARY:
2240.1.3: Lee Bieber 2011-03-17 [merge] Merge Stewart - 728856: CREATE TABLE
t1 (a int default 'aoeu'); succeeds
2221.12.14: Stewart Smith 2011-03-17 [merge] merge the cherrypick of bug
728856 into elliott
2221.12.13: Stewart Smith 2011-03-17 [merge] merge elliot
2221.12.12: Stewart Smith 2011-03-17 check for error in converting
default_value to Item in default_value_item(). This means that INT DEFAULT
'aoeu' will properly error out.
2221.12.11: Stewart Smith 2011-03-15 [merge] merge trunk
2221.12.10: Stewart Smith 2011-03-11 fix bug 728856 result file
2221.12.9: Stewart Smith 2011-03-11 [merge] merge trunk
2221.12.8: Stewart Smith 2011-03-07 fix logic for ON UPDATE for TEMPSTAMP
columns in CreateField::setDefaultValue in ALTER TABLE SET DEFAULT code path
(as we're modifying existing CreateField, not just creating one
2221.12.7: Stewart Smith 2011-03-07 in ALTER TABLE SET DEFAULT code path,
use the new CreateField::setDefaultValue method - this means we have the same
logic for setting default values for a CreateField as in CREATE TABLE
2221.12.6: Stewart Smith 2011-03-07 add test for bug lp:728855 - ALTER
TABLE SET DEFAULT '' for a blob column should work (it does in CREATE TABLE).
Currently fails.
2221.12.5: Stewart Smith 2011-03-07 factor out setting default value out
from CreatField::init and into new CreateField::setDefaultValue. This also
means we fix up a error message to be correct in type_blob.
2221.12.4: Stewart Smith 2011-03-07 fix ER_TOO_BIG_FIELDLENGTH error
message to always be number of characters, not sometimes number of bytes
2221.12.3: Stewart Smith 2011-03-07 add a test case for CREATE TABLE with
auto_increment on a decimal column (which isn't supported).
2221.12.2: Stewart Smith 2011-03-07 add a test case for some CREATE TABLE
errors around ER_TOO_BIG_FIELDWIDTH - turns out we had only 1
2240.1.2: Lee Bieber 2011-03-17 [merge] Merge Stewart - 728855: BLOB column
can have default '' (empty string) in CREATE TABLE but not ALTER TABLE ALTER
2239.3.3: Stewart Smith 2011-03-17 merge bug 728856 fix
2239.3.2: Stewart Smith 2011-03-17 merge bug 728856 result file fix
2239.3.1: Stewart Smith 2011-03-17 [merge] merge test for bug 728856
2221.12.1: Stewart Smith 2011-03-07 add test for bug 728856, CREATE TABLE
t1 (a int default 'foo'); succeeds. This is a bug somewhere in the
CreateField/CREATE TABLE logic of not checking type of the default value
provided
2240.1.1: Lee Bieber 2011-03-17 [merge] Merge Stewart - dbqp source (and all
its libs) should use emacs python mode, not emacs C mode
2235.5.2: Stewart Smith 2011-03-17 dbqp source (and all its libs) should
use emacs python mode, not emacs C mode
2235.5.1: Stewart Smith 2011-03-17 dbqp source should use emacs python
mode, not emacs C mode
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-benchmark
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-benchmark
More help : https://help.launchpad.net/ListHelp
