This is a very dangerous one:
If you open multiple AML Studio windows and select different connections in them, it may happen that a query is run on the different database!
To reproduce:
Create two connections with different user ids. Open one AML Studio window and execute the "GetCurrentUserID" action. The result will be userid1.
Now open a second window and select the other connection with a different user id.
Run the "GetCurrentUserID" action in the second window. The result will be userid2.
Now re-run the query in window 1. Although you would assume that connection 1 is still active there, you will get userid2 here.
This is totally unexpected and can lead to data loss or corruption!
This is a very dangerous one: If you open multiple AML Studio windows and select different connections in them, it may happen that a query is run on the different database! To reproduce: Create two connections with different user ids. Open one AML Studio window and execute the "GetCurrentUserID" action. The result will be userid1. Now open a second window and select the other connection with a different user id. Run the "GetCurrentUserID" action in the second window. The result will be userid2.
Now re-run the query in window 1. Although you would assume that connection 1 is still active there, you will get userid2 here. This is totally unexpected and can lead to data loss or corruption!