github-actions[bot] commented on PR #24291:
URL: https://github.com/apache/doris/pull/24291#issuecomment-1717051482
#### `sh-checker report`
To get the full details, please check in the
[job]("https://github.com/apache/doris/actions/runs/6169009673";) output.
<details>
<summary>shellcheck errors</summary>
```
'shellcheck ' returned error 1 finding the following syntactical issues:
----------
In tools/tpcds-tools/bin/run-tpcds-queries.sh line 154:
mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
^-----------^ SC2086 (info): Double
quote to prevent globbing and word splitting.
^--^ SC2086
(info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word
splitting.
^--^ SC2086 (info): Double quote to prevent globbing and word
splitting.
Did you mean:
mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
"${RESULT_DIR}"/result"${i}".out 2>"${RESULT_DIR}"/result"${i}".log
In tools/tpcds-tools/bin/run-tpcds-queries.sh line 160:
mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
^-----------^ SC2086 (info): Double
quote to prevent globbing and word splitting.
^--^ SC2086
(info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word
splitting.
^--^ SC2086 (info): Double quote to prevent globbing and word
splitting.
Did you mean:
mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
"${RESULT_DIR}"/result"${i}".out 2>"${RESULT_DIR}"/result"${i}".log
In tools/tpcds-tools/bin/run-tpcds-queries.sh line 166:
mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
^-----------^ SC2086 (info): Double
quote to prevent globbing and word splitting.
^--^ SC2086
(info): Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word
splitting.
^--^ SC2086 (info): Double quote to prevent globbing and word
splitting.
Did you mean:
mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
"${RESULT_DIR}"/result"${i}".out 2>"${RESULT_DIR}"/result"${i}".log
In tools/tpch-tools/bin/run-tpch-queries.sh line 154:
mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > ${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
^-----------^ SC2086 (info): Double quote
to prevent globbing and word splitting.
^--^ SC2086 (info):
Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word
splitting.
^--^ SC2086 (info): Double quote to prevent globbing and word
splitting.
Did you mean:
mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > "${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
In tools/tpch-tools/bin/run-tpch-queries.sh line 160:
mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > ${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
^-----------^ SC2086 (info): Double quote
to prevent globbing and word splitting.
^--^ SC2086 (info):
Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word
splitting.
^--^ SC2086 (info): Double quote to prevent globbing and word
splitting.
Did you mean:
mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > "${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
In tools/tpch-tools/bin/run-tpch-queries.sh line 166:
mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > ${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
^-----------^ SC2086 (info): Double quote
to prevent globbing and word splitting.
^--^ SC2086 (info):
Double quote to prevent globbing and word splitting.
^-----------^ SC2086 (info): Double quote to prevent globbing and word
splitting.
^--^ SC2086 (info): Double quote to prevent globbing and word
splitting.
Did you mean:
mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > "${RESULT_DIR}"/result"${i}".out
2>"${RESULT_DIR}"/result"${i}".log
For more information:
https://www.shellcheck.net/wiki/SC2086 -- Double quote to prevent globbing
...
----------
You can address the above issues in one of three ways:
1. Manually correct the issue in the offending shell script;
2. Disable specific issues by adding the comment:
# shellcheck disable=NNNN
above the line that contains the issue, where NNNN is the error code;
3. Add '-e NNNN' to the SHELLCHECK_OPTS setting in your .yml action file.
```
</details>
<details>
<summary>shfmt errors</summary>
```
'shfmt ' returned error 1 finding the following formatting issues:
----------
--- tools/tpcds-tools/bin/run-tpcds-queries.sh.orig
+++ tools/tpcds-tools/bin/run-tpcds-queries.sh
@@ -151,19 +151,19 @@
hot2=0
echo -ne "query${i}\t" | tee -a result.csv
start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
+ mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql
>${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
end=$(date +%s%3N)
cold=$((end - start))
echo -ne "${cold}\t" | tee -a result.csv
start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
+ mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql
>${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
end=$(date +%s%3N)
hot1=$((end - start))
echo -ne "${hot1}\t" | tee -a result.csv
start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql >
${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
+ mysql -h"${FE_HOST}" -u"${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCDS_QUERIES_DIR}"/query"${i}".sql
>${RESULT_DIR}/result${i}.out 2>${RESULT_DIR}/result${i}.log
end=$(date +%s%3N)
hot2=$((end - start))
echo -ne "${hot2}\t" | tee -a result.csv
--- tools/tpch-tools/bin/run-tpch-queries.sh.orig
+++ tools/tpch-tools/bin/run-tpch-queries.sh
@@ -151,19 +151,19 @@
hot2=0
echo -ne "q${i}\t" | tee -a result.csv
start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > ${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" >${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
end=$(date +%s%3N)
cold=$((end - start))
echo -ne "${cold}\t" | tee -a result.csv
start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > ${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" >${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
end=$(date +%s%3N)
hot1=$((end - start))
echo -ne "${hot1}\t" | tee -a result.csv
start=$(date +%s%3N)
- mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" > ${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
+ mysql -h"${FE_HOST}" -u "${USER}" -P"${FE_QUERY_PORT}" -D"${DB}"
--comments <"${TPCH_QUERIES_DIR}/q${i}.sql" >${RESULT_DIR}/result${i}.out
2>${RESULT_DIR}/result${i}.log
end=$(date +%s%3N)
hot2=$((end - start))
echo -ne "${hot2}\t" | tee -a result.csv
----------
You can reformat the above files to meet shfmt's requirements by typing:
shfmt -w filename
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
