TPC-Council/HammerDB

Can't change default SQL Server database in GUI from tpcc or tpch

Closed this issue · 0 comments

Guidance
Bug reports are for when HammerDB is not behaving as expected.
Bug reports should not be submitted for help in understanding database performance related questions.
General questions on database performance or HammerDB usability should be submitted under Discussions.

Describe the bug
When using the GUI and change the name of the database in SQL Server to something other than the default, it remains as tpcc for TPROC-C or tpch for TPROC-H

To Reproduce
Use the GUI to set the database options. Change the default database name to something else and click OK. When re-opening the options, the database name stays as previous.

In the CLI the database can still be changed:

hammerdb>diset tpcc mssqls_dbase tpcc1
Changed tpcc:mssqls_dbase from tpcc to tpcc1 for MSSQLServer

hammerdb>print dict
Dictionary Settings for MSSQLServer
connection {
 mssqls_server             = (local)\SQLDEVELOP
 mssqls_linux_server       = localhost
 mssqls_tcp                = false
 mssqls_port               = 1433
 mssqls_azure              = false
 mssqls_authentication     = windows
 mssqls_msi_object_id      = null
 mssqls_linux_authent      = sql
 mssqls_odbc_driver        = ODBC Driver 18 for SQL Server
 mssqls_linux_odbc         = ODBC Driver 18 for SQL Server
 mssqls_uid                = sa
 mssqls_pass               = admin
 mssqls_encrypt_connection = true
 mssqls_trust_server_cert  = true
}
tpcc       {
 mssqls_count_ware       = 30
 mssqls_num_vu           = 8
 mssqls_dbase            = tpcc1
 mssqls_imdb             = false
 mssqls_bucket           = 1
 mssqls_durability       = SCHEMA_AND_DATA
 mssqls_use_bcp          = true
 mssqls_total_iterations = 10000000
 mssqls_raiseerror       = false
 mssqls_keyandthink      = false
 mssqls_checkpoint       = false
 mssqls_driver           = timed
 mssqls_rampup           = 2
 mssqls_duration         = 5
 mssqls_allwarehouse     = true
 mssqls_timeprofile      = false
 mssqls_async_scale      = false
 mssqls_async_client     = 10
 mssqls_async_verbose    = false
 mssqls_async_delay      = 1000
 mssqls_connect_pool     = false
}

hammerdb>

Expected behavior
We should be able to change the database name from the default (and can still do so with the CLI)

Screenshots
image

HammerDB Version (please complete the following information):

  • Version: 4.11

HammerDB Interface (please complete the following information):

  • UI: GUI

Operating System (please complete the following information):

  • Server OS: All
  • Client OS: All

Database Server (please complete the following information):

  • Database name: SQL Server
  • Database Release Version All

Database Client (please complete the following information):

  • Database client name: [e.g. ODBC Driver 18 for SQL Server]

Additional context
Issue has been caused by the move to tabbed dialogs #678