SQL Server 2016 SP1 - Is this a bug?
<p>I just installed SQL Server 2016 and SP1 and run this TSQL Script</p>

<pre><code>CREATE TABLE [dbo].TEST(
[id] [INT] IDENTITY(1,1) NOT NULL,
[lat] [DECIMAL](9, 6) NULL,
[lng] [DECIMAL](9, 6) NULL,
[Location]  AS ([geography]::STGeomFromText(((('POINT ('+[lng])+' ')+[lat])+')',(4326))) 
    PERSISTED
)
</code></pre>

<p>The table is created fine.</p>

<p>I then run the following (there is no records in the table)</p>

<pre><code>Select * from TEST
</code></pre>

<p>This returns </p>

<p><strong>Msg 8114, Level 16, State 5, Line 8
Error converting data type varchar to numeric.</strong></p>

<p>It is related to the <code>Location</code> field.</p>

<p><strong>Is this a bug in SQL Server 2016?</strong>  I would not expect this behavior.</p>

<p>The following does not cause any issues</p>

<pre><code>CREATE TABLE [dbo].TEST2(
[id] [INT] IDENTITY(1,1) NOT NULL,
[lat] [DECIMAL](9, 6) NULL,
[lng] [DECIMAL](9, 6) NULL,
[Location]  AS [lng] PERSISTED
)

select * from TEST2
</code></pre>