* cherry pick from develop branch.

* [TD-5136]<feature>: taosdemo simulate real senario.

* update test case according to taosdemo change

* adjust range of semi-random data.

* make demo mode use different tag name and value.

* change malloc to calloc for pid allocation.

* fix typo.

* fix binary length default value and group id logic.

* fix help msg.

* fix aggregation func test.

* minor typo fix.
Co-authored-by: NShuduo Sang <sdsang@taosdata.com>

* cherry pick from develop branch.

* fix conflict and reformat by autopep8.

Co-authored-by: NMinglei Jin <mljin@taosdata.com>

* cherry pick from develop branch.

* cherry pick 54813175

* [TD-5872]<fix>: taosdemo stmt csv perf improve.

* rand func back to early impl.

* fix windows/mac compile error.

* cherry pick from develop branch.

* merge with develop branch.

* rename MAX_SAMPLES_ONCE_FROM_FILE to reflect reality.

* split func for stmt interlace.

* fix bug that get build path.

* stmt batch interlace works.

* fix start time issue.
Co-authored-by: NShuduo Sang <sdsang@taosdata.com>

* [TD-3197]<fix>: taosdemo and taosdump coverity scan issues.

* exit if read sample file failed.

* fix converity scan issue.

* fix coverity scan issue.

* fix coverity scan memory leak.

* fix resource leak reported by coverity scan.

* fix taosdemo coverity scan issue.

* fix tcsetattr and getchar return value determination bug.

* fix coverity scan issue.

* fix two more coverity scan issues.
Co-authored-by: NShuduo Sang <sdsang@taosdata.com>

* cherry pick from develop branch.

* cherry pick 54813175

* [TD-5872]<fix>: taosdemo stmt csv perf improve.

* rand func back to early impl.

* fix windows/mac compile error.

* cherry pick from develop branch.

* merge with develop branch.

* rename MAX_SAMPLES_ONCE_FROM_FILE to reflect reality.

* split func for stmt interlace.
Co-authored-by: NShuduo Sang <sdsang@taosdata.com>

* [TD-5844]<feature>: make cmd line parameter similar.

* fix test case align with taosdemo change.

* fix windows stack overflow issue.

* fix mac compile error.

* fix taosdemo cmdline parameter in tests/pytest/tools/taosdemoAllTest/NanoTestCase/taosdemoTestSupportNanoInsert.py

* make taos.exe use mysql style password input.

* make taos shell and taosdump use mysql style password input.

* determine scanf return value.

* cherry pick from develop/feature branch.

* cherry pick with ab6cde02

* cherry pick with d6bfe443

* fix password echo on darwin.

* fix few lines.
Co-authored-by: NShuduo Sang <sdsang@taosdata.com>

* cherry pick from develop branch.

* cherry pick 54813175

* [TD-5872]<fix>: taosdemo stmt csv perf improve.

* rand func back to early impl.

* fix windows/mac compile error.

* cherry pick from develop branch.

* merge with develop branch.

* rename MAX_SAMPLES_ONCE_FROM_FILE to reflect reality.
Co-authored-by: NShuduo Sang <sdsang@taosdata.com>

* [TD-5844]<feature>: make cmd line parameter similar.

* fix test case align with taosdemo change.

* fix windows stack overflow issue.

* fix mac compile error.

* fix taosdemo cmdline parameter in tests/pytest/tools/taosdemoAllTest/NanoTestCase/taosdemoTestSupportNanoInsert.py

* make taos.exe use mysql style password input.

* make taos shell and taosdump use mysql style password input.

* determine scanf return value.

* cherry pick from develop/feature branch.

* cherry pick with ab6cde02

* cherry pick with d6bfe443

* fix password echo on darwin.
Co-authored-by: NShuduo Sang <sdsang@taosdata.com>