// Simulate the user switching the statement separator for the session
SessionProperties result = EasyMock.createMock(SessionProperties.class);
expect(result.getSQLStatementSeparator()).andReturn(";").once();
expect(result.getSQLStatementSeparator()).andReturn("FOO").once();
expect(result.getStartOfLineComment()).andReturn("--").anyTimes();
expect(result.clone()).andReturn(result);
expect(result.getRemoveMultiLineComment()).andReturn(true).anyTimes();
result.setSQLStatementSeparator(isA(String.class));
expectLastCall().anyTimes();
result.setStartOfLineComment(isA(String.class));
expectLastCall().anyTimes();