parallel/testsuite/wanted-results/sql01

94 lines
4.9 KiB
Plaintext
Raw Permalink Normal View History

par__dbsize ### Test --db-size --dbsize
par__dbsize 6
par__dbsize 6
par__listproc ### Test --show-processlist|proclist|listproc
par__listproc 2 17
par__listproc 2 17
par__listproc 2 17
par__noheaders ### Test --noheaders --no-headers -n
par__noheaders abc 1
par__noheaders def 3
par__noheaders abc 1
par__noheaders def 3
par__noheaders abc 1
par__noheaders def 3
par__tablesize ### Test --table-size --tablesize
par__tablesize 93
par__tablesize 93
2023-07-21 02:33:22 +00:00
par_dburl_user_password_host_port ### Test dburl with username password host port
par_dburl_user_password_host_port Test dburl with username password host port
par_dburl_user_password_host_port OK
par_debug ### Test --debug
par_debug dburl mysql://tange:tange@/
par_debug databasedriver mysql user tange password tange host port database tange query
par_debug [ | ((sleep 1; rm /TMP/tmpfile') & mysql --defaults-extra-file=/TMP/tmpfile' --user=tange tange)]
par_debug Test if --debug works
par_debug Yes it does
par_help ### Test --help -h
par_help Usage:
par_help sql [-hnr] [--table-size] [--db-size] [-p pass-through] [-s string] dburl [sqlcommand]
par_help sql [-hnr] [--table-size] [--db-size] [-p pass-through] [-s string] dburl < sql_command_file
par_help
par_help See 'man sql' for the options
par_help Usage:
par_help sql [-hnr] [--table-size] [--db-size] [-p pass-through] [-s string] dburl [sqlcommand]
par_help sql [-hnr] [--table-size] [--db-size] [-p pass-through] [-s string] dburl < sql_command_file
par_help
par_help See 'man sql' for the options
par_html ### Test --html
par_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>
par_passthrough ### Test --passthrough -p
par_passthrough <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>
par_passthrough <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>
2023-07-21 02:33:22 +00:00
par_read_sql_from_file ### Test reading sql from file
par_read_sql_from_file Test reading SQL from file works
par_read_sql_from_file Yes it does
par_retry ### Test -r - retry 3 times
par_retry dburl pg://nongood@127.0.0.3:2227/
par_retry databasedriver pg user nongood password host 127.0.0.3 port 2227 database nongood query
par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood]
par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
par_retry Is the server running on that host and accepting TCP/IP connections?
par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood]
par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
par_retry Is the server running on that host and accepting TCP/IP connections?
par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood]
par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
par_retry Is the server running on that host and accepting TCP/IP connections?
par_retry ### Test --retries=s
par_retry dburl pg://nongood@127.0.0.3:2227/
par_retry databasedriver pg user nongood password host 127.0.0.3 port 2227 database nongood query
par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood]
par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
par_retry Is the server running on that host and accepting TCP/IP connections?
par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood]
par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
par_retry Is the server running on that host and accepting TCP/IP connections?
par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood]
par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
par_retry Is the server running on that host and accepting TCP/IP connections?
par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood]
par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused
par_retry Is the server running on that host and accepting TCP/IP connections?
par_sep ### Test --sep -s
par_sep 2 1
par_sep 2 1
2023-07-21 02:33:22 +00:00
par_shebang-Y ### Test of #! -Y with file as input
par_shebang-Y Testing if -Y works
par_shebang-Y Yes it does
par_shebang_file ### Test of #! --shebang with file as input
par_shebang_file Testing if --shebang works
par_shebang_file Yes it does
par_sql_aliases ### Test .sql/aliases
par_sql_aliases Test if .sql/aliases works
par_sql_aliases Yes it does
par_sql_aliases ### Test sql:sql::alias
par_sql_aliases Test sql:sql::alias
par_sql_aliases Yes it works
par_sql_on_cmdline ### Test reading sql on command line
par_sql_on_cmdline Test reading SQL from command line
par_sql_on_cmdline Yes it does
par_version ### Test --version -V
par_version 13 74 535
par_version 13 74 535