TPC-Council / HammerDB

HammerDB Database Load Testing and Benchmarking Tool
http://www.hammerdb.com
GNU General Public License v3.0
545 stars 115 forks source link

wrong # args: should be " mssql connection string build is wrong when username/password contains semicoin #606

Closed d00lar closed 6 months ago

d00lar commented 10 months ago

Describe the bug the bug is wrong # args: should be "..... when in user password there is ';'

To Reproduce Steps to reproduce the behavior:

  1. Go to sql server deploy OPTIONS
  2. change to sql authentication / enter sql username/password that contains ; in it (usualy in pass) =]
  3. Run workload '....'
  4. See error in Virtual User 1: wrong # args: should be "do_tpcc server port odbc_driver authentication uid pwd tcp azure count_ware db imdb bucket_factor durability num_vu"

Expected behavior it should be possible to have ';' in password. probably it need to be in '' when building connectionstring ;)

HammerDB Version (please complete the following information):

HammerDB Interface (please complete the following information):

Operating System (please complete the following information):

Database Server (please complete the following information):

Database Client (please complete the following information):

sm-shaw commented 10 months ago

This is discussed in issue #561 as a workaround wrap the password with special characters with: {} or {[ concat {} ]}

simple cases use: {}
more complex cases use: {[ concat {} ]}