SQL Trigger does not work when deployed to Flex Consumption

[shibayan]

• Azure Functions SQL Extension or Extension Bundle Version: 3.1.490
• Is this a deployed or local function: deployed
• What type of Database are you using? (Run SELECT @@VERSION as Version, SERVERPROPERTY('EngineEdition') as EngineEdition on your database): Microsoft SQL Azure (RTM) - 12.0.2000.8 Apr 9 2025 07:13:50 Copyright (C) 2024 Microsoft Corporation | 5
• List any custom settings for your function app. This could be a custom time-out defined specifically for your database server or optional configuration that can be customized for the app defined here.: none

Steps to Reproduce:

1. Create new sql trigger function from Visual Studio
2. Deploy to Flex Consumption
3. Modify the data in the target table
4. SqlTrigger function not triggered

I deployed a Function App that implements SqlTrigger to Flex Consumption and SqlTrigger is not triggered on table changes. I have confirmed that it works correctly when running Consumption or locally, but only does not work when deployed to Flex Consumption.

When deployed to Flex Consumption, lease-related tables were not automatically created. This is a possible cause of this issue.

[shibayan]

Additional checks show that for Flex Consumption, it works if the Function name that implements SQL Trigger is all lowercase. This is a rather strange behavior.

[MaddyDev]

Additional checks show that for Flex Consumption, it works if the Function name that implements SQL Trigger is all lowercase. This is a rather strange behavior.

Is this an existing function that you were trying to deploy using Flex or a new one?

[shibayan]

This occurred when deploying the newly created SQL Trigger Functions to Flex Consumption. This occurred because C# functions generally contain capital letters.

[MaddyDev]

This occurred when deploying the newly created SQL Trigger Functions to Flex Consumption. This occurred because C# functions generally contain capital letters.

Do you have --always-ready-instances set while deploying your app?

[shibayan]

Yes, we have assigned Always Ready Instance so that the SQL Trigger Function always starts up.