CREATE PARTITION FUNCTION MY_Partition_Function_RIGHT(BIGINT)
AS RANGE RIGHT
FOR VALUES
(
(1303142400 + 1*3600)*1000,
(1303142400 + 2*3600)*1000,
(1303142400 + 3*3600)*1000
)上面的语句创建一个bigint类型的分区函数。可是提示错误如下:
消息 8115,级别 16,状态 2,第 4 行
将 expression 转换为数据类型 int 时出现算术溢出错误。难道说FOR VALUES列表内仅仅支持int类型的数值?紧急求救!谢谢。
AS RANGE RIGHT
FOR VALUES
(
(convert(bigint,1303142400) + 1*3600)*1000,
(convert(bigint,1303142400) + 2*3600)*1000,
(convert(bigint,1303142400) + 3*3600)*1000
)
AS RANGE RIGHT
FOR VALUES
(
(cast(1303142400 as bigint)+ 1*3600)*1000,
(cast(1303142400 as bigint)+ 2*3600)*1000,
(cast(1303142400 as bigint)+ 3*3600)*1000
)
不指定情况下,默认int