firebird icon indicating copy to clipboard operation
firebird copied to clipboard

Fix #8590 - Line "BLR to Source mapping:" may look broken when procedures.rdb$debug_info is queried using remote protocol.

Open asfernandes opened this issue 6 months ago • 10 comments

When transforming a blob of an internal type (say, isc_blob_debug_info) to text, the segments are generated without new line information.

ISQL treats it segment as a line, putting some leading spaces and the new line.

I have no idea why.

But this causes problems when remote batches segments and some are split, causing the extra new line as reported in #8590.

This change is not always backward incompatible, specially when different versions of engine x ISQL is used or non-ISQL clients converting internal blobs to text.

asfernandes avatar Jun 10 '25 00:06 asfernandes

ISQL treats it segment as a line, putting some leading spaces and the new line.

I have no idea why.

I guess - because new line on server could be different from new line on client, for example - Linux server and Windows client.

Your change broke this. I would just make ISQL correctly handle RESULT_SEGMENT.

hvlad avatar Jun 10 '25 06:06 hvlad

This problem has been resolved in stdout around the 1900 years.

asfernandes avatar Jun 10 '25 09:06 asfernandes

This problem has been resolved in stdout around the 1900 years.

How your patch is relatied with it ?

hvlad avatar Jun 10 '25 10:06 hvlad

I would just make ISQL correctly handle RESULT_SEGMENT.

If you looked at details of the problem, you would saw that ISQL does not receives RESULT_SEGMENT at all.

asfernandes avatar Jun 10 '25 10:06 asfernandes

If you looked at details of the problem, you would saw that ISQL does not receives RESULT_SEGMENT at all.

Then this is an another bug to be fixed.

aafemt avatar Jun 10 '25 10:06 aafemt

I would just make ISQL correctly handle RESULT_SEGMENT.

If you looked at details of the problem, you would saw that ISQL does not receives RESULT_SEGMENT at all.

Then, what do you mean here ?

But this causes problems when remote batches segments and some are split, causing the extra new line as reported in https://github.com/FirebirdSQL/firebird/issues/8590.

hvlad avatar Jun 10 '25 10:06 hvlad

Lets fix the real bug - in string_filter()

hvlad avatar Jun 10 '25 11:06 hvlad

See #8594

hvlad avatar Jun 10 '25 11:06 hvlad

The Firebird team thanks you for effort duplication. And I'd say this is a problem here too, the way it does is inefficient and more complex than necessary.

asfernandes avatar Jun 10 '25 11:06 asfernandes

The Firebird team thanks you for effort duplication.

Are you present the whole team ? Or you going to tell me what to do ?

And I'd say this is a problem here too, the way it does is inefficient and more complex than necessary.

The issue should be fixed correctly and not broke old code, when possible, like you it or not. Your fix is wrong, by my opinion, and I offer a correct one.

hvlad avatar Jun 10 '25 11:06 hvlad