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)
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