Is there a way to link back from replay warnings to the event_sequence column in sqlite? about workloadtools HOT 5 CLOSED

Thanks for filing this issue. Some things to clarify:

1. SqlWorkload does respect the SET options of the original session. This means that the SET options on the original session could be perfectly OK and not trigger errors on filtered indexes, while the replay displays the problematic behavior. I know this is a problem that needs to be fixed.
2. I set up everything to capture the error events to log them to a table in the analysis database, but I never had the time to implement it. Sorry, it's in the backlog.

from workloadtools.

Hi Gianluca,

thanks for the quick reply. I don't get your first point "SqlWorkload does respect the SET options of the original session."...did you intend to write "SqlWorkload does not respect the SET options..."?
If it does respect them how can the problem arise just in the replay and not in the workload itself on prod as well?

Best regards
Martin

from workloadtools.

Oh my... yes, I meant to write SqlWorkload does not respect the SET options. Fingers refused to write what brain was thinking...

from workloadtools.

And it doesn't take the default set options set at the instance level (properties --> connections) either? Because they set QUOTED_IDENTIFIER correctly.

from workloadtools.

At the moment it starts connections using the default set options.

from workloadtools.