See <http://hudson.drizzle.org/job/drizzle-build-opensolaris-64-test-only/168/>
------------------------------------------
[...truncated 5216 lines...]
schema_dictionary.data_dictionary [ pass ] 1757
schema_dictionary.default_null [ pass ] 20
schema_dictionary.no_default [ pass ] 21
schema_dictionary.show [ fail ]
drizzletest: At line 36: query 'show create table weblog' failed: 20:
drizzle_state_read:lost connection to server (EOF)
The result from queries just before the failure was:
< snip >
Table Create Table
user CREATE TABLE `user` (
`user_id` int NOT NULL AUTO_INCREMENT,
`nick` varchar(20) DEFAULT NULL,
`passwd` varchar(10) DEFAULT NULL,
`realname` varchar(40) DEFAULT NULL,
`email` varchar(40) DEFAULT NULL,
`lasttime` datetime DEFAULT NULL,
`karma` int DEFAULT '0',
`inside_workspace` int NOT NULL DEFAULT '0',
UNIQUE KEY `�4P` (`user_id`)
) ENGINE=InnoDB
show create table version;
Table Create Table
version CREATE TABLE `version` (
`version_id` int NOT NULL DEFAULT '0',
`version` int NOT NULL DEFAULT '1',
UNIQUE KEY `�4P` (`version_id`)
) ENGINE=InnoDB
show create table weblog;
More results from queries before failure can be found in
/export/home/hudson/hudson/workspace/drizzle-build-opensolaris-64-build-only/tests/var/log/show.log
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
schema_dictionary.show_fields [ fail ]
drizzletest: At line 5: query 'show create table a' failed: 20:
drizzle_state_read:lost connection to server (EOF)
The result from queries just before the failure was:
create table a ( a serial);
show fields from a;
Field Type Null Default Default_is_NULL On_Update
a BIGINT FALSE FALSE
show create table a;
More results from queries before failure can be found in
/export/home/hudson/hudson/workspace/drizzle-build-opensolaris-64-build-only/tests/var/log/show_fields.log
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
schema_dictionary.show_table_status [ pass ] 72
schema_dictionary.show_temporary_tables [ pass ] 48
schema_dictionary.slap [ pass ] 1942
rot13.rot13_basic [ pass ] 1
replication_dictionary.data_dictionary [ pass ] 1
replication_dictionary.replication_streams [ pass ] 1
replication_dictionary.slap [ pass ] 57
registry_dictionary.data_dictionary [ pass ] 2
registry_dictionary.plugins [ pass ] 1
registry_dictionary.slap [ pass ] 155
mysql_protocol.mysql_password [ pass ] 1
mysql_protocol.prototest [ pass ] 88667
logging_stats.command [ fail ]
drizzletest: At line 6: query 'ALTER TABLE a ADD COLUMN j int' failed: 1300:
Invalid identifier character string: '�/�'
The result from queries just before the failure was:
DROP TABLE IF EXISTS a;
DROP TABLE IF EXISTS b;
CREATE TABLE a (i int, PRIMARY KEY (i));
ALTER TABLE a ADD COLUMN j int;
More results from queries before failure can be found in
/export/home/hudson/hudson/workspace/drizzle-build-opensolaris-64-build-only/tests/var/log/command.log
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
logging_stats.cumulative [ pass ] 1035
logging_stats.max_session [ pass ] 1101
logging_stats.max_user [ pass ] 5670
logging_stats.slap [ pass ] 417
innobase.innodb_cmp [ pass ] 2
innobase.innodb_cmp_reset [ pass ] 1
innobase.innodb_cmpmem [ pass ] 2
innobase.innodb_cmpmem_reset [ pass ] 2
innobase.innodb_lock_waits [ pass ] 2
innobase.innodb_locks [ pass ] 2
innobase.innodb_status [ pass ] 2
innobase.innodb_trx [ pass ] 2
innobase.slap [ pass ] 500
innobase.table_name_dictionary [ pass ] 1
information_schema_dictionary.show_create_table [ pass ] 8
information_schema_dictionary.slap [ pass ] 1029
hello_world.hello_world [ pass ] 1
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 ] 78
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 ] 20
collation_dictionary.data_dictionary [ pass ] 4
collation_dictionary.slap [ pass ] 109
blackhole.blackhole [ pass ] 6
blackhole.create_max_fields [ pass ] 417
auth_file.basic [ pass ] 4
archive.archive [ fail ]
drizzletest: At line 1404: query 'ALTER TABLE t5 ENGINE=ARCHIVE' failed: 1280:
Incorrect index name ''
The result from queries just before the failure was:
< snip >
INSERT INTO t5 VALUES (32, "foo");
INSERT INTO t5 VALUES (23, "foo");
INSERT INTO t5 VALUES (NULL, "foo");
INSERT INTO t5 VALUES (NULL, "foo");
INSERT INTO t5 VALUES (3, "foo");
INSERT INTO t5 VALUES (NULL, "foo");
SELECT * FROM t5;
a b
5 foo
6 foo
7 foo
8 foo
9 foo
32 foo
23 foo
33 foo
34 foo
3 foo
35 foo
ALTER TABLE t5 ENGINE=ARCHIVE;
More results from queries before failure can be found in
/export/home/hudson/hudson/workspace/drizzle-build-opensolaris-64-build-only/tests/var/log/archive.log
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
archive.archive_aio_posix [ fail ]
drizzletest: At line 1404: query 'ALTER TABLE t5 ENGINE=ARCHIVE' failed: 1280:
Incorrect index name ''
The result from queries just before the failure was:
< snip >
INSERT INTO t5 VALUES (32, "foo");
INSERT INTO t5 VALUES (23, "foo");
INSERT INTO t5 VALUES (NULL, "foo");
INSERT INTO t5 VALUES (NULL, "foo");
INSERT INTO t5 VALUES (3, "foo");
INSERT INTO t5 VALUES (NULL, "foo");
SELECT * FROM t5;
a b
5 foo
6 foo
7 foo
8 foo
9 foo
32 foo
23 foo
33 foo
34 foo
3 foo
35 foo
ALTER TABLE t5 ENGINE=ARCHIVE;
More results from queries before failure can be found in
/export/home/hudson/hudson/workspace/drizzle-build-opensolaris-64-build-only/tests/var/log/archive_aio_posix.log
Stopping All Servers
Restoring snapshot of databases
Resuming Tests
archive.archive_basic [ pass ] 19
archive.archive_discover [ pass ] 16
--------------------------------------------------------------------------------
Stopping All Servers
Failed 154/321 tests, 52.02% 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 183 times
Spent 689.383 of 3141 seconds executing testcases
mysql-test-run in default mode: *** Failing the test(s): main.alter_table
main.alter_table_basic main.auto_increment main.bench_count_distinct
main.bigint main.binary main.cast main.comment_column main.comment_index
main.comment_table main.compare main.connect main.constraints
main.count_distinct main.create main.create_not_windows
main.create_select_column_order main.create_select_tmp main.ctype_utf8
main.data_dictionary_like_info main.default main.delete main.derived
main.distinct main.drizzledump main.drizzleslap main.empty_table main.endspace
main.explain main.flush main.foreign_key main.func_gconcat main.func_group
main.func_group_innodb main.func_in main.func_in_null_scan main.func_isnull
main.func_length main.func_like main.func_str main.func_test main.func_time
main.greedy_optimizer main.group_by main.group_min_max
main.group_min_max_innodb main.having main.heap main.heap_auto_increment
main.heap_btree main.heap_hash main.heap_var main.index_merge_innodb
main.information_schema main.innodb main.innodb_autoinc_lock_mode_zero
main.innodb_mysql main.innodb_notembedded main.innodb_timeout_rollback
main.insert main.insert_select main.insert_update main.join main.join_crash
main.join_nested main.join_outer main.join_outer_innodb main.key main.key_diff
main.key_primary main.kill main.limit main.limit_offset main.loaddata
main.metadata main.mix2_myisam main.myisam main.mysql_bug2397
main.mysql_protocol main.mysqldump-max main.negation_elimination main.null
main.null_key main.odbc main.olap main.order_by main.parser_bug21114_innodb
main.randgen_queries main.range main.regression_385808 main.replace main.row
main.rowid_order_innodb main.savepoints main.select main.select_found
main.select_in_null main.select_safe main.show_check
main.show_create_table_utf8 main.strict main.subselect main.subselect2
main.subselect3 main.subselect_innodb main.subselect_mat
main.subselect_notembedded main.subselect_sj main.subselect_sj2
main.sum_distinct main.temp_table main.transaction main.truncate main.type_blob
main.type_date main.type_datetime main.type_decimal main.type_enum
main.type_float main.type_ranges main.type_timestamp main.type_varbinary
main.type_varchar main.union main.unsafe_binlog_innodb main.update
main.update_is_truncate_on_temp_bug_lp387627 main.user_var main.varbinary
main.variables big.read_many_rows_innodb transaction_log.alter
transaction_log.blob transaction_log.create_select
transaction_log.ddl_transaction_id transaction_log.delete
transaction_log.filtered_replicator transaction_log.insert_on_duplicate_update
transaction_log.insert_select transaction_log.multi_column_primary_key
transaction_log.no_modification transaction_log.rand transaction_log.replace
transaction_log.select_for_update transaction_log.slap
transaction_log.temp_tables transaction_log.update schema_dictionary.show
schema_dictionary.show_fields logging_stats.command csv.csv csv.csv_not_null
archive.archive archive.archive_aio_posix
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
