search

Azure / data-api-builder

Data API builder provides modern REST and GraphQL endpoints to your Azure Databases and on-prem stores.
https://aka.ms/dab/docs
MIT License
852 stars 172 forks source link

[Bug]: Maybe by design? #2309

Open ErikEJ opened 1 month ago

ErikEJ commented 1 month ago

What happened?

Running 'dab validate' against the following schema:

CREATE TABLE [dbo].[Specials]( [Id] [int] NOT NULL, [Test1] [hierarchyid] NOT NULL, [Test2] [geometry] NOT NULL, [Test3] [geography] NOT NULL, [TheDate] [date] NULL, [TheTime] time NULL, [testname] [sysname] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )

Version

1.1.7

What database are you using?

Azure SQL

What hosting model are you using?

Local (including CLI)

Which API approach are you accessing DAB through?

REST

Relevant log output

Error: Cannot obtain Schema for entity Specials with underlying database object source: dbo.Specials due to: DataReader.GetFieldType(1) returned null.
Error: Config is invalid. Check above logs for details.

Code of Conduct

ErikEJ commented 1 month ago

Looks like a duplicate of #1397 - I will exclude these columns for now!

ErikEJ commented 1 month ago

Hmmm.. Looks like I have to exclude the entire table...