Table.AddColumn may display invalid data (out of range) in Query Editor

[marcel_beugelsd]

If you supply a Column.Type with Table.AddColumn (e.g. Byte.Type), then the Query Editor will also display values that are out of range for the Data Type. E.g. for Data Type Byte, values >255 are still displayed in the Query Editor, but they won't load to the table when the query is applied. This differs from Table.TransformColumnTypes which will result in an Expression.Error when data is out of range.

[marcel_beugelsd]

The same issue may occur when a type is supplied as the fourth parameter of Table.DuplicateColumn.