See <http://hudson.drizzle.org/job/drizzle-build-opensolaris-64-test-only/132/>
------------------------------------------
[...truncated 1455 lines...]
main.warnings [ pass ] 344
main.warnings_engine_disabled [ pass ] 14
main.weekday [ pass ] 3
main.year [ pass ] 25
big.archive-big [ pass ] 444259
big.concurrent_innodb [ pass ] 1
big.read_many_rows_innodb [ pass ] 157430
big.sum_distinct-big [ pass ] 91986
transaction_log.alter [ pass ] 189
transaction_log.auto_commit [ pass ] 137
transaction_log.bad_replicator [ pass ] 2
transaction_log.blob [ pass ] 142
transaction_log.create_select [ pass ] 157
transaction_log.create_table [ pass ] 96
transaction_log.ddl_transaction_id [ pass ] 98
transaction_log.delete [ pass ] 342
transaction_log.filtered_replicator [ pass ] 1107
transaction_log.information_schema [ pass ] 67
transaction_log.insert [ pass ] 114
transaction_log.insert_multi [ pass ] 83
transaction_log.insert_on_duplicate_update [ pass ] 144
transaction_log.insert_select [ pass ] 157
transaction_log.multi_column_primary_key [ pass ] 252
transaction_log.no_modification [ pass ] 107
transaction_log.no_primary_key [ pass ] 100
transaction_log.rand [ pass ] 117
transaction_log.rename [ pass ] 92
transaction_log.replace [ pass ] 232
transaction_log.rollback [ pass ] 87
transaction_log.schema [ pass ] 75
transaction_log.select_for_update [ pass ] 5771
transaction_log.slap [ pass ] 5759
transaction_log.temp_tables [ pass ] 154
transaction_log.truncate [ pass ] 117
transaction_log.truncate_log [ pass ] 103
transaction_log.udf_print_transaction_message [ pass ] 89
transaction_log.update [ pass ] 430
transaction_log.variables [ pass ] 2
tableprototester.basic [ pass ] 2
tableprototester.drop_table [ pass ] 1
tableprototester.missing_engine [ pass ] 3
table_cache_dictionary.table_cache [ pass ] 25
table_cache_dictionary.table_definition_cache [ pass ] 28
status_dictionary.data_dictionary [ pass ] 4
status_dictionary.select_order [ pass ] 0
status_dictionary.show [ pass ] 2
sleep.sleep [ pass ] 2750
simple_user_policy.basic [ pass ] 4065
show_schema_proto.basic [ pass ] 1
show_dictionary.show_temporary_tables [ pass ] 143
session_dictionary.data_dictionary [ pass ] 1
session_dictionary.show [ pass ] 0
session_dictionary.slap [ pass ] 111
schema_engine.exists [ pass ] 1
schema_dictionary.binary_default [ pass ] 30
schema_dictionary.columns [ pass ] 14
schema_dictionary.data_dictionary [ pass ] 24
schema_dictionary.default_null [ pass ] 13
schema_dictionary.no_default [ pass ] 24
schema_dictionary.show [ fail ]
--- .././plugin/schema_dictionary/tests/r/show.result 2010-05-14
22:47:10.281576969 +0300
+++ .././plugin/schema_dictionary/tests/r/show.reject 2010-05-14
23:17:29.938955037 +0300
@@ -336,36 +336,36 @@
) ;
show tables;
Tables_in_everything
-branch
-container
-document
-genstats_attributes
-htmlcode
-htmlpage
+nodegroup
image
-javascript
+user
+weblog
knowledge_item
-links
mail
-node
-nodegroup
-nodelet
-nodemethod
-nodetype
project
-project_document
-question
-redirects
-releases
+nodetype
+javascript
+htmlcode
revision
-setting
symlink
+question
+branch
+node
+links
+document
+genstats_attributes
+container
+nodelet
+workspace
+releases
themesetting
+redirects
+setting
+nodemethod
typeversion
-user
+htmlpage
+project_document
version
-weblog
-workspace
show create table branch;
Table Create Table
branch CREATE TABLE `branch` (
drizzletest: Result content mismatch
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
schema_dictionary.show_fields [ pass ] 75
schema_dictionary.show_table_status [ pass ] 70
schema_dictionary.show_temporary_tables [ pass ] 47
schema_dictionary.slap [ pass ] 1779
rot13.rot13_basic [ pass ] 1
replication_dictionary.data_dictionary [ pass ] 1
replication_dictionary.replication_streams [ pass ] 1
replication_dictionary.slap [ pass ] 51
registry_dictionary.data_dictionary [ pass ] 2
registry_dictionary.plugins [ pass ] 1
registry_dictionary.slap [ pass ] 133
mysql_protocol.mysql_password [ pass ] 1
mysql_protocol.prototest [ pass ] 88813
logging_stats.command [ pass ] 2112
logging_stats.cumulative [ pass ] 1036
logging_stats.max_session [ pass ] 1109
logging_stats.max_user [ pass ] 6407
logging_stats.slap [ pass ] 408
innobase.innodb_cmp [ pass ] 2
innobase.innodb_cmp_reset [ pass ] 1
innobase.innodb_cmpmem [ pass ] 1
innobase.innodb_cmpmem_reset [ pass ] 1
innobase.innodb_lock_waits [ pass ] 2
innobase.innodb_locks [ pass ] 1
innobase.innodb_status [ pass ] 1
innobase.innodb_trx [ pass ] 1
innobase.slap [ pass ] 446
information_schema_dictionary.show_create_table [ pass ] 7
information_schema_dictionary.slap [ pass ] 1052
hello_world.hello_world [ pass ] 2
errmsg_stderr.stderr [ pass ] 1
csv.csv [ fail ]
drizzletest: At line 1498: query 'create temporary table t1(a enum('foo','bar')
default 'foo') engine=csv' failed with wrong errno 1691: 'Received an invalid
enum value 'foo'.', instead of 1178...
The result from queries just before the failure was:
< snip >
ERROR HY000: Field 'a' doesn't have a default value
select * from t1;
a
drop table t1;
create temporary table t1(a int not null) engine=csv;
insert into t1 values();
ERROR HY000: Field 'a' doesn't have a default value
select * from t1;
a
drop table t1;
create temporary table t1(a blob not null) engine=csv;
insert into t1 values();
ERROR HY000: Field 'a' doesn't have a default value
select * from t1;
a
drop table t1;
create temporary table t1(a enum('foo','bar') default null) engine=csv;
ERROR 42000: The storage engine for the table doesn't support nullable columns
create temporary table t1(a enum('foo','bar') default 'foo') engine=csv;
ERROR HY000: Received an invalid enum value 'foo'.
More results from queries before failure can be found in
/export/home/hudson/hudson/workspace/drizzle-build-opensolaris-64-build-only/tests/var/log/csv.log
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
csv.csv_alter_table [ pass ] 92
csv.csv_not_null [ fail ]
drizzletest: At line 55: query 'INSERT INTO t1
VALUES(0,'abc','def','ghi','bar','1999-12-31')' failed: 1691: Received an
invalid enum value 'bar'.
The result from queries just before the failure was:
< snip >
# === Good CREATE ===
CREATE TEMPORARY TABLE t1 (a int NOT NULL) ENGINE = CSV;
# === Will fail -- ALL columns need NOT NULL ==
CREATE TEMPORARY TABLE t2 (a int NOT NULL, b char(20)) ENGINE = CSV;
ERROR 42000: The storage engine for the table doesn't support nullable columns
DROP TABLE t1;
# ===== csv_not_null.2 =====
DROP TABLE IF EXISTS t1;
Warnings:
Note 1051 Unknown table 't1'
CREATE TEMPORARY TABLE t1 (a int NOT NULL, b blob NOT NULL, c CHAR(20) NOT
NULL,
d VARCHAR(20) NOT NULL, e enum('foo','bar') NOT NULL,f DATE NOT NULL)
ENGINE = CSV;
INSERT INTO t1 VALUES();
ERROR HY000: Field 'a' doesn't have a default value
SELECT * FROM t1;
a b c d e f
SELECT * FROM t1;
a b c d e f
INSERT INTO t1 VALUES(0,'abc','def','ghi','bar','1999-12-31');
More results from queries before failure can be found in
/export/home/hudson/hudson/workspace/drizzle-build-opensolaris-64-build-only/tests/var/log/csv_not_null.log
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
crc32.crc32 [ pass ] 26
collation_dictionary.data_dictionary [ pass ] 5
collation_dictionary.slap [ pass ] 106
blackhole.blackhole [ pass ] 8
blackhole.create_max_fields [ pass ] 381
auth_file.basic [ pass ] 4
archive.archive [ pass ] 706
archive.archive_aio_posix [ pass ] 653
archive.archive_basic [ pass ] 21
archive.archive_discover [ pass ] 16
--------------------------------------------------------------------------------
Stopping All Servers
Failed 31/315 tests, 90.16% were successful.
The log files in var/log may give you some hint
of what went wrong.
If you want to report this error, go to:
http://bugs.launchpad.net/drizzle
The servers were restarted 71 times
Spent 1023.068 of 1327 seconds executing testcases
mysql-test-run in default mode: *** Failing the test(s): main.alter_table
main.cast main.create main.ctype_utf8 main.data_dictionary_like_info
main.default main.drizzledump main.func_group main.func_str main.group_by
main.information_schema main.insert_select main.join main.join_crash
main.join_outer main.key main.mysqldump-max main.rename main.select
main.show_check main.show_create_table_utf8 main.strict main.subselect
main.subselect_sj2 main.type_enum main.type_ranges main.type_varchar main.union
schema_dictionary.show csv.csv csv.csv_not_null
mysql-test-run: *** ERROR: there were failing test cases
gmake[1]: *** [test-all] Error 1
gmake[1]: Leaving directory
`/export/home/hudson/hudson/workspace/drizzle-build-opensolaris-64-build-only'
gmake: *** [test-all] Error 2
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-builds
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-builds
More help : https://help.launchpad.net/ListHelp
