Function iscArrayLookupBoundsImpl

src/yvalve/array.cpp:145–190

void iscArrayLookupBoundsImpl(Why::YAttachment* attachment,
	Why::YTransaction* transaction, const SCHAR* relationName, const SCHAR* fieldName, ISC_ARRAY_DESC* desc)
{
	LocalStatus status;
	CheckStatusWrapper statusWrapper(&status);

	MetaString globalField;
	iscArrayLookupDescImpl(attachment, transaction, relationName, fieldName, desc, &globalField);

	ISC_ARRAY_BOUND* tail = desc->array_desc_bounds;

	constexpr auto sql = R"""(
		select fd.rdb$lower_bound,
		       fd.rdb$upper_bound
		    from rdb$field_dimensions fd
		    where fd.rdb$field_name = ?
		    order by fd.rdb$dimension
	)""";

	FB_MESSAGE(InputMessage, CheckStatusWrapper,
		(FB_VARCHAR(MAX_SQL_IDENTIFIER_LEN), fieldName)
	) inputMessage(&statusWrapper, MasterInterfacePtr());
	inputMessage.clear();

	FB_MESSAGE(OutputMessage, CheckStatusWrapper,
		(FB_INTEGER, lowerBound)
		(FB_INTEGER, upperBound)
	) outputMessage(&statusWrapper, MasterInterfacePtr());

	inputMessage->fieldNameNull = FB_FALSE;
	inputMessage->fieldName.set(globalField.c_str());

	auto resultSet = makeNoIncRef(attachment->openCursor(&statusWrapper, transaction, 0, sql,
		SQL_DIALECT_CURRENT, inputMessage.getMetadata(), inputMessage.getData(),
		outputMessage.getMetadata(), nullptr, 0));
	status.check();

	while (resultSet->fetchNext(&statusWrapper, outputMessage.getData()) == IStatus::RESULT_OK)
	{
		tail->array_bound_lower = outputMessage->lowerBoundNull ? 0 : outputMessage->lowerBound;
		tail->array_bound_upper = outputMessage->upperBoundNull ? 0 : outputMessage->upperBound;
		++tail;
	}

	status.check();
}


void iscArrayLookupDescImpl(Why::YAttachment* attachment,