You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
What type of Database are you using? (Run SELECT @@VERSION as Version, SERVERPROPERTY('EngineEdition') as EngineEdition on your database):
Version
EngineEdition
Microsoft SQL Azure (RTM) - 12.0.2000.8 Jan 3 2024 16:32:18 Copyright (C) 2022 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.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[my_table](
[ID1] [varchar](4) NOT NULL,
[Foo1] [varchar](255) NULL,
[Foo2] [tinyint] NULL,
[Foo/Bar3] [tinyint] NULL,
) ON [PRIMARY]
GO
SET ANSI_PADDING ON
GO
ALTERTABLE [dbo].[my_table] ADD CONSTRAINT [PK_my_table] PRIMARY KEY CLUSTERED
(
[ID1] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This is my database table' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'my_table'
GO
In the above Azure Function, the output_rowlist which is used to set the output binding consists of SqlRows which look like this:
{'ID1': '9999', 'Foo1': None, 'Foo2': '1', 'Foo/Bar3': '1'}
When the function runs, all of the columns are updated properly except for 'Foo/Bar3', which is always set to NULL regardless of the value present in output_rowlist.
When I update my_table using an SQL statement in Azure Data Studio, the column 'Foo/Bar3' updates without issue.
I have since changed the name of the column in the database to 'FooBar3' and the output binding updates the column correctly. I have not seen similar issues when updating columns that contain non-alphanumeric characters ie %, #.
The text was updated successfully, but these errors were encountered:
Issue is present on both deployed and local
SELECT @@VERSION as Version, SERVERPROPERTY('EngineEdition') as EngineEdition
on your database):The contents of function.json:
Contents of
__init__.py
:SQL create statement for the target table:
In the above Azure Function, the output_rowlist which is used to set the output binding consists of SqlRows which look like this:
{'ID1': '9999', 'Foo1': None, 'Foo2': '1', 'Foo/Bar3': '1'}
When the function runs, all of the columns are updated properly except for 'Foo/Bar3', which is always set to NULL regardless of the value present in output_rowlist.
When I update my_table using an SQL statement in Azure Data Studio, the column 'Foo/Bar3' updates without issue.
I have since changed the name of the column in the database to 'FooBar3' and the output binding updates the column correctly. I have not seen similar issues when updating columns that contain non-alphanumeric characters ie %, #.
The text was updated successfully, but these errors were encountered: