Skip to Content
0
May 11, 2018 at 09:00 AM

Strange Case depencies ? on column names

118 Views

I have a serious issue here, we had a daatbase server go down and when it came up athe application that uses the datbase became very slow. The issue after investigation is that it appears that

For instance if the Table Test has a column named TEXTDATA

Then a select statement select textdata from Test will return approximately 5 times as long as select TEXTDATA from Tests. It appears that the case conversion process is broken

Help, we are in the process of losing a client with this as I have only just identified the issue.

Terry Hastings

Senior DBA