We're updating the issue view to help you get more done. 

SequenceHiLoGeneratorTest fails due to wrong select string on SQL Server

Description

Mssql database has sys.sequences table. However test run this statement that causes failures when db is case-sensitive.

1 SELECT CONVERT(varchar(200), Current_value) FROM SYS.Sequences WHERE name

Moreover if this fails, the test leaks an open session. this causes problems if the database is configured so that a user can login only once at a time, because subsequent tests are unable to login.

Environment

None

Status

Assignee

Gail Badner

Reporter

Jan Martiška

Fix versions

Labels

None

backPortable

Backport?

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

5.2.7
5.1.4

Priority

Major