Bug #35399 test invalid_hostname" 2>&1" succeeded - should have failed with errno 1...
Submitted: 18 Mar 2008 15:11 Modified: 22 Apr 2008 6:28
Reporter: Vicki Brown Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.0.51a OS:Mac OS X
Assigned to: CPU Architecture:Any

[18 Mar 2008 15:11] Vicki Brown
Description:
It would appear to me that this test should have passed but it's returning the "wrong" exit status. It's happily producing "unknown" errors.

It also seems odd to me that MySQL would build and pass all of its tests and then "fail" on one test where it does seem to think there's something wrong.

Bug? User misunderstanding?

How to repeat:
make
make test
wait
[18 Mar 2008 15:11] Vicki Brown
typo fixed
[18 Mar 2008 19:08] Sveta Smirnova
Thank you for the report.

Please indicate accurate version of MySQL server you use. Also please paste output of `make test` which you consider wrong.
[21 Mar 2008 15:18] Vicki Brown
accurate version of server?  I don't know what you mean.

this was built from source: mysql-5.0.51a.tar.gz
[21 Mar 2008 15:19] Vicki Brown
accurate version of server?  I don't know what you mean.

this was built from source: mysql-5.0.51a.tar.gz

The output of make test that I consider wroong is the summary of this report

here'es the whole thing

mysqltest: At line 210: command "$MYSQL test -e "\r test invalid_hostname" 2>&1" succeeded - should have failed with errno 1...

The result from queries just before the failure was:
< snip >
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
insert into t17583 select a from t17583;
select count(*) from t17583;
count(*)
1280
drop table t17583;
Test connect without db- or host-name => reconnect
Test connect with dbname only => new dbname, old hostname
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'connecttest' at line 1
Test connect with _invalid_ dbname only => new invalid dbname, old hostname
ERROR 1049 (42000) at line 1: Unknown database 'invalid'
ERROR 1049 (42000) at line 1: Unknown database 'invalid'
Test connect with dbname + hostname
Test connect with dbname + _invalid_ hostname
exec of '/usr/local/src/DB/mysql-5.0.51a/client/mysql --no-defaults --host=localhost  --user=root --password= --port=9306 --socket=/usr/local/src/DB/mysql-5.0.51a/mysql-test/var/tmp/master.sock --character-sets-dir=/usr/local/src/DB/mysql-5.0.51a/sql/share/charsets test -e "\r test invalid_hostname" 2>&1 failed, error: 0, errno: 0

More results from queries before failure can be found in /usr/local/src/DB/mysql-5.0.51a/mysql-test/var/log/mysql.log

Aborting: mysql failed in default mode. 
To continue, re-run with '--force'.
Stopping All Servers
[22 Mar 2008 6:28] Sveta Smirnova
Thank you for the feedback.

I can not repeat described behavior. Please provide configure line you used to compile sources. Also please indicate if your operating system is Mac OS X 10.4 or 10.5
[22 Mar 2008 7:43] Sveta Smirnova
Your case looks like bug #35485. Please check /etc/resolv.conf
[22 Apr 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".