parallel/testsuite/wanted-results/sql01

mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
### Test of #! -Y with file as input
mysql: [Warning] Using a password on the command line interface can be insecure.
Testing if -Y works
Yes it does
### Test of #! --shebang with file as input
mysql: [Warning] Using a password on the command line interface can be insecure.
Testing if --shebang works
Yes it does
### Test reading sql on command line
mysql: [Warning] Using a password on the command line interface can be insecure.
Test reading SQL from command line
Yes it does
### Test reading sql from file
mysql: [Warning] Using a password on the command line interface can be insecure.
Test reading SQL from file works
Yes it does
### Test dburl with username password host port
mysql: [Warning] Using a password on the command line interface can be insecure.
Test reading SQL from file works
Yes it does
### Test .sql/aliases
mysql: [Warning] Using a password on the command line interface can be insecure.
Test if .sql/aliases works
Yes it does
### Test sql:sql::alias
mysql: [Warning] Using a password on the command line interface can be insecure.
Test sql:sql::alias
Yes it works
### Test --noheaders --no-headers -n
mysql: [Warning] Using a password on the command line interface can be insecure.
abc 1
def 3
mysql: [Warning] Using a password on the command line interface can be insecure.
abc 1
def 3
mysql: [Warning] Using a password on the command line interface can be insecure.
abc 1
def 3
### Test --sep -s
2 1
2 1
### Test --passthrough -p
mysql: [Warning] Using a password on the command line interface can be insecure.
<TABLE BORDER=1><TR><TH>id</TH><TH>data</TH></TR><TR><TD>1</TD><TD>abc</TD></TR><TR><TD>3</TD><TD>def</TD></TR></TABLE>
mysql: [Warning] Using a password on the command line interface can be insecure.
<TABLE BORDER=1><TR><TH>id</TH><TH>data</TH></TR><TR><TD>1</TD><TD>abc</TD></TR><TR><TD>3</TD><TD>def</TD></TR></TABLE>
### Test --html
mysql: [Warning] Using a password on the command line interface can be insecure.
<TABLE BORDER=1><TR><TH>id</TH><TH>data</TH></TR><TR><TD>1</TD><TD>abc</TD></TR><TR><TD>3</TD><TD>def</TD></TR></TABLE>
### Test --show-processlist|proclist|listproc
mysql: [Warning] Using a password on the command line interface can be insecure.
      2      17
mysql: [Warning] Using a password on the command line interface can be insecure.
      2      17
mysql: [Warning] Using a password on the command line interface can be insecure.
      2      17
### Test --db-size --dbsize
mysql: [Warning] Using a password on the command line interface can be insecure.
      2       6      54
mysql: [Warning] Using a password on the command line interface can be insecure.
      2       6      54
### Test --table-size --tablesize
mysql: [Warning] Using a password on the command line interface can be insecure.
63
mysql: [Warning] Using a password on the command line interface can be insecure.
63
### Test --debug
dburl mysql://sqlunittest:CB5A1FFFA5A@localhost:3306/sqlunittest
databasedriver mysql user sqlunittest password CB5A1FFFA5A host localhost port 3306 database sqlunittest query 
mysql -C     --host=localhost --user=sqlunittest --port=3306 --password=CB5A1FFFA5A sqlunittest
mysql: [Warning] Using a password on the command line interface can be insecure.
Test if --debug works
Yes it does
### Test --version -V
     12      74     500
     12      74     500
### Test -r
dburl pg://nongood@127.0.0.3:2227/
databasedriver pg user nongood password  host 127.0.0.3 port 2227 database nongood query 
  psql     -h 127.0.0.3 -U nongood -p 2227 -d nongood
psql: could not connect to server: Connection refused
	Is the server running on host "127.0.0.3" and accepting
	TCP/IP connections on port 2227?
  psql     -h 127.0.0.3 -U nongood -p 2227 -d nongood
psql: could not connect to server: Connection refused
	Is the server running on host "127.0.0.3" and accepting
	TCP/IP connections on port 2227?
  psql     -h 127.0.0.3 -U nongood -p 2227 -d nongood
psql: could not connect to server: Connection refused
	Is the server running on host "127.0.0.3" and accepting
	TCP/IP connections on port 2227?
### Test --retries=s
dburl pg://nongood@127.0.0.3:2227/
databasedriver pg user nongood password  host 127.0.0.3 port 2227 database nongood query 
  psql     -h 127.0.0.3 -U nongood -p 2227 -d nongood
psql: could not connect to server: Connection refused
	Is the server running on host "127.0.0.3" and accepting
	TCP/IP connections on port 2227?
  psql     -h 127.0.0.3 -U nongood -p 2227 -d nongood
psql: could not connect to server: Connection refused
	Is the server running on host "127.0.0.3" and accepting
	TCP/IP connections on port 2227?
  psql     -h 127.0.0.3 -U nongood -p 2227 -d nongood
psql: could not connect to server: Connection refused
	Is the server running on host "127.0.0.3" and accepting
	TCP/IP connections on port 2227?
  psql     -h 127.0.0.3 -U nongood -p 2227 -d nongood
psql: could not connect to server: Connection refused
	Is the server running on host "127.0.0.3" and accepting
	TCP/IP connections on port 2227?
### Test --help -h
Usage:
sql [options] dburl [sqlcommand]
sql [options] dburl < sql_command_file

See 'man sql' for the options
Usage:
sql [options] dburl [sqlcommand]
sql [options] dburl < sql_command_file

See 'man sql' for the options