[BUG] MSQL Resource Ignores Database Name

[alexwijoyo]

Description

When I query select * from MyTable; and try to run it. It will cause error: Invalid object name 'MyTable'

Steps to reproduce

0. Run SQL Server Profiler trace from your database server. Show Database Name column.
1. Go to Resource
2. Click Create New
3. Choose Microsoft SQL
4. Fill Name input
5. Fill Hostname/Port input
6. Fill Database input
7. Fill Username/Password input
8. Click Test Connection button
9. It will show Test successfully message
10. Check from SQL Server Profiler trace the query called from Master database not from specified Database in resource

Version

self-host

ILLA Builder Version

latest

Browser

No response

Operating System

• macOS
• Windows
• Linux

Additional Information

No response

[naj1n]

This issue has been fixed in the latest version. Please pull the latest illasoft/illa-builder:latest image to verify if the fix is effective. If you encounter any further issues, feel free to reach out.

[alexwijoyo]

@naj1n I will test it

[alexwijoyo]

@naj1n problem solved thank you.