parallel/testsuite/wanted-results/sql01

86 lines
3 KiB
Plaintext
Raw Permalink Normal View History

### Test of #! -Y with file as input
Testing if -Y works
Yes it does
### Test of #! --shebang with file as input
Testing if --shebang works
Yes it does
### Test reading sql on command line
Test reading SQL from command line
Yes it does
### Test reading sql from file
Test reading SQL from file works
Yes it does
### Test dburl with username password host port
Test reading SQL from file works
Yes it does
### Test .sql/aliases
Test if .sql/aliases works
Yes it does
### Test sql:sql::alias
Test sql:sql::alias
Yes it works
### Test --noheaders --no-headers -n
abc 1
def 3
abc 1
def 3
abc 1
def 3
### Test --sep -s
2 1
2 1
### Test --passthrough -p
<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>
<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
<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
2 17
2 17
2 17
### Test --db-size --dbsize
6
6
### Test --table-size --tablesize
2020-11-22 15:22:54 +00:00
82
82
### Test --debug
dburl mysql://tange:tange@localhost:3306/tange
databasedriver mysql user tange password tange host localhost port 3306 database tange query
Test if --debug works
Yes it does
### Test --version -V
13 74 535
13 74 535
### Test -r
2010-09-10 00:26:01 +00:00
dburl pg://nongood@127.0.0.3:2227/
2016-07-22 16:10:28 +00:00
databasedriver pg user nongood password host 127.0.0.3 port 2227 database nongood query
2022-05-22 08:36:45 +00:00
psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
### Test --retries=s
2010-09-10 00:26:01 +00:00
dburl pg://nongood@127.0.0.3:2227/
2016-07-22 16:10:28 +00:00
databasedriver pg user nongood password host 127.0.0.3 port 2227 database nongood query
2022-05-22 08:36:45 +00:00
psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
### 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