【Bug?】(v7.5.0) KeyNotFoundException when joining metadata.attribute and metadata.globaloptionset

MarkMpn / Sql4Cds

SQL 4 CDS core engine and XrmToolbox tool

MIT License

74 stars 22 forks source link

Closed hiroyuki0415 closed 1 year ago

hiroyuki0415 commented 1 year ago

SELECT a.*
FROM   metadata.attribute AS a
       LEFT OUTER JOIN
       metadata.globaloptionset AS os
       ON a.optionset = os.metadataid;

In v7.5.0, when I run this SQL, I get the below error:

KeyNotFoundException

Thanks in advance for your support.