I have these classes public class SubMenuItem : SubMenuVariant { public string SubMenuTitle { get; set; } public LinkFieldType Link { get; set; } public List<SubMenuSubItem> SubItems { get; set; } } public class SubMenuHighlightItem : SubMenuVariant { [JsonPropertyName(FieldNames.HighlightTitle)] public…
I have a strange problem: There is a price in a JSON column in a table and the following statements give different results while they should give the same thing: CAST(COALESCE(JSON_EXTRACT(item.price_details, "$.shipping.price"), 0) AS FLOAT) AS shippricecoalfloat COALESCE(CAST(JSON_EXTRACT(item.price_details, "$.shipping.price") AS…
Consider dockerized Laravel (5.7) app running on nginx/php 7.0.33. I'm experiencing weird rounding (?) error: Can anyone explain me how floor($x) is 7256 instead of 7257? Bonus: Bonus 2: the same test in PHP 7.4 / 8 gives good results:
I'm creating a custom DataSet and I'm under some constrains: I want the user to specify the type of the data which they want to store. I want to reduce type-casting because I think it will be VERY expensive. I…