Query Case Sensitive

Liquibase Development
1

We are on MS SQL SERVER

I have the following table structure

Create table test
(
BusId int,
BusName Varchar(20)
)

Create table testbkp
(
BusId int,
BusName Varchar(20)
)

The following query gets deployed
Insert into testbkp ( BusId,BusName) SELECT BusId,BusName from test where BusId =1

But the following query gives error
Insert into testbkp ( BusId,BusName) SELECT BusId,BusName from test where Busid =1

Is Liquibase is case sensitive (in the last query I have used Busid instead on BusId)

1 Like
2

Hello, @Dinesh1 - thanks for posting this question.

Liquibase is not case-sensitive, and since that’s the case, this sounds like it could be a bug. Please visit our GitHub repository and open a bug issue so we can take a look at it. Issues · liquibase/liquibase · GitHub

Regards,
Tabby