SQL报错 BIGINT UNSIGNED value is out of range in xxx

框架： thinkPhp5.1

PHP 7.3

create_time 是 unsigned类型，相减出现负数，所以报错。

mysql 当两个字段想减时，如果其中一个或两个字段的类型的unsigned无签名类型，如果想减的值小于0则会报错（BIGINT UNSIGNED value is out of range）

$list =  $MdShopOrderModel
            ->field('s_o.id,g.goods_id,g.goods_name,s_o.create_time,g_s.goods_cycle,((g_s.goods_cycle*86400)+s_o.create_time -' . $time . ') as goods_cycle_time,s_o.start_time,s_o.end_time')
            ->alias('s_o')
            ->join('order_goods og', 's_o.order_goods_id=og.order_goods_id', 'LEFT')
            ->join('goods g', 'og.goods_id=g.goods_id', 'LEFT')
            ->join('goods_image i', 'g.goods_id=i.goods_id', 'LEFT')
            ->join('upload_file f', 'i.image_id=f.file_id', "LEFT")
            ->join('goods_sku g_s', 'g.goods_id=g_s.goods_id', "LEFT")
            ->join('user u', 's_o.user_id = u.user_id', 'LEFT')
            ->select()
            ->toArray();

 修改后

$list =  $MdShopOrderModel
            ->field('s_o.id,g.goods_id,s_o.create_time,g_s.goods_cycle,((cast(g_s.goods_cycle as signed)*86400)+cast(s_o.create_time as signed)-' . $time . ') as goods_cycle_time,s_o.start_time,s_o.end_time')
            ->alias('s_o')
            ->join('order_goods og', 's_o.order_goods_id=og.order_goods_id', 'LEFT')
            ->join('goods g', 'og.goods_id=g.goods_id', 'LEFT')
            ->join('goods_image i', 'g.goods_id=i.goods_id', 'LEFT')
            ->join('upload_file f', 'i.image_id=f.file_id', "LEFT")
            ->join('goods_sku g_s', 'g.goods_id=g_s.goods_id', "LEFT")
            ->join('user u', 's_o.user_id = u.user_id', 'LEFT')
            ->select()
            ->toArray();