#28 minor type mismatch on DELETE JAILER_ENTITY

[Alexander Petrossian (PAF)]

(@1 int,@2 tinyint)DELETE [LOAN_MT].[dbo].[JAILER_ENTITY]  WHERE [r_entitygraph]=@1 AND [type]=@2
CREATE TABLE [dbo].[JAILER_ENTITY](
    [r_entitygraph] [int] NOT NULL,
...
    [type] [int] NOT NULL,

Here @2 is tinyint, while type is int.

Probably it's good to balance types?

(Looking at MSSQL)

[Ralf Wisser]

The tool sends the SQL statements without bound variables to the DBMS. Like this:

DELETE FROM JAILER_ENTITY WHERE r_entitygraph=1000 AND type=7

Presumably, MSSQL makes a tinyint from the literal if the number is small.
But I do not think that has any impact on performance.

[Alexander Petrossian (PAF)]

I see a conversion in plan, but it's 0% cost. So I also don't think that.
Suggest to close this.

(How you have patience for me?!)

[Alexander Petrossian (PAF)]

Email notifications test.