Method addSqlTime

src/dsql/ExprNodes.cpp:2813–2928

Perform time arithmetic. TIME - TIME Result is SLONG, scale -4 TIME +/- NUMERIC Numeric is interpreted as seconds DECIMAL(*,4). NUMERIC +/- TIME Numeric is interpreted as seconds DECIMAL(*,4).

// TIME +/- NUMERIC		Numeric is interpreted as seconds DECIMAL(*,4).
// NUMERIC +/- TIME		Numeric is interpreted as seconds DECIMAL(*,4).
dsc* ArithmeticNode::addSqlTime(thread_db* tdbb, const dsc* desc, impure_value* value) const
{
	fb_assert(blrOp == blr_add || blrOp == blr_subtract);

	dsc* result = &value->vlu_desc;
	Attachment* const attachment = tdbb->getAttachment();

	fb_assert(value->vlu_desc.isTime() || desc->isTime());

	const dsc* op1_desc = &value->vlu_desc;
	const dsc* op2_desc = desc;

	bool op1_is_time = op1_desc->isTime();
	bool op2_is_time = op2_desc->isTime();

	Nullable<USHORT> op1_tz, op2_tz;

	if (op1_desc->dsc_dtype == dtype_sql_time_tz)
		op1_tz = ((ISC_TIME_TZ*) op1_desc->dsc_address)->time_zone;

	if (op2_desc->dsc_dtype == dtype_sql_time_tz)
		op2_tz = ((ISC_TIME_TZ*) op2_desc->dsc_address)->time_zone;

	dsc op1_tz_desc, op2_tz_desc;
	ISC_TIME_TZ op1_time_tz, op2_time_tz;

	if (op1_desc->dsc_dtype == dtype_sql_time && op2_is_time && op2_tz.specified)
	{
		op1_tz_desc.makeTimeTz(&op1_time_tz);
		MOV_move(tdbb, const_cast<dsc*>(op1_desc), &op1_tz_desc);
		op1_desc = &op1_tz_desc;
	}

	if (op2_desc->dsc_dtype == dtype_sql_time && op1_is_time && op1_tz.specified)
	{
		op2_tz_desc.makeTimeTz(&op2_time_tz);
		MOV_move(tdbb, const_cast<dsc*>(op2_desc), &op2_tz_desc);
		op2_desc = &op2_tz_desc;
	}

	// Coerce operand1 to a count of seconds
	SINT64 d1;

	if (op1_is_time)
	{
		d1 = *(GDS_TIME*) op1_desc->dsc_address;
		fb_assert(d1 >= 0 && d1 < TimeStamp::ISC_TICKS_PER_DAY);
	}
	else
		d1 = MOV_get_int64(tdbb, op1_desc, ISC_TIME_SECONDS_PRECISION_SCALE);

	// Coerce operand2 to a count of seconds
	SINT64 d2;

	if (op2_is_time)
	{
		d2 = *(GDS_TIME*) op2_desc->dsc_address;
		fb_assert(d2 >= 0 && d2 < TimeStamp::ISC_TICKS_PER_DAY);