>The BLOB_APPEND is not CONCATENATION, it is non-standard function
> with custom semantics.
Yes, it's non-standard function. But even non-standard function can behave in
similar way other functions behave in SQL world. It's not the first
non-standard function we have.
--
Mgr. Jiří Činčura
On Thu, Aug 11, 2022, at 17:58, Vlad Khorsun wrote:
>The answer is the same - for user convenience. When I want to append
> something to the
> already existing blob, I doesn't expect to destroy my blob just because
> nothing is
> appended to it.
How is that different from `update foo set bar
On Thu, Aug 11, 2022, at 18:56, Vlad Khorsun wrote:
>I replied to Jiří who definitely read that discussion ;)
But I read it like last week, completely, because I discovered it as part of
reading RN. I wasn't in the discussion as it was unfolding.
--
Mgr. Jiří Činčura
https://www.tabsoverspa
Em 11/08/2022 12:58, Vlad Khorsun escreveu:
11.08.2022 17:26, Mark Rotteveel wrote:
On 11-08-2022 16:21, Vlad Khorsun wrote:
11.08.2022 17:10, Mark Rotteveel wrote:
Why was this NULL behaviour chosen?
To make BLOB_APPEND more convenient for users.
I don't understand how using a differen
While I’m hardly entitled to a vote, it is almost impossible to find a use
case where making a concatenation with a NULL a NULL is useful. NULL
should be interpreted as “there ain’t nothing there” rather than a poison
pill for other contexts.
In Amorphous, concatenation of a NULL treats the NULL
11.08.2022 19:31, Mark Rotteveel wrote:
On 11-08-2022 18:04, Vlad Khorsun wrote:
11.08.2022 17:46, Jiří Činčura wrote:
I was thinking the same when reading the discussion on GH.
There was a LOT of time to write something at that discussion.
Nobody asked about NULL's there, while it was doc
On 11-08-2022 18:09, Alex Peshkoff via Firebird-devel wrote:
On 8/11/22 19:04, Vlad Khorsun wrote:
So far I don't see it as mistake.
+1
Function is anyway damned non-standard.
And as soon as we have documented behavior - no problems at all.
Time will tell. I think deviating NULL behaviou
On 11-08-2022 18:04, Vlad Khorsun wrote:
11.08.2022 17:46, Jiří Činčura wrote:
I was thinking the same when reading the discussion on GH.
There was a LOT of time to write something at that discussion.
Nobody asked about NULL's there, while it was documented since a very
beginning.
Unfort
On 11-08-2022 17:58, Vlad Khorsun wrote:
11.08.2022 17:26, Mark Rotteveel wrote:
On 11-08-2022 16:21, Vlad Khorsun wrote:
11.08.2022 17:10, Mark Rotteveel wrote:
Why was this NULL behaviour chosen?
To make BLOB_APPEND more convenient for users.
I don't understand how using a different N
On 8/11/22 19:04, Vlad Khorsun wrote:
So far I don't see it as mistake.
+1
Function is anyway damned non-standard.
And as soon as we have documented behavior - no problems at all.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
11.08.2022 17:46, Jiří Činčura wrote:
I was thinking the same when reading the discussion on GH.
There was a LOT of time to write something at that discussion.
Nobody asked about NULL's there, while it was documented since a very beginning.
I believe it's not late to make correction (hey, w
11.08.2022 17:26, Mark Rotteveel wrote:
On 11-08-2022 16:21, Vlad Khorsun wrote:
11.08.2022 17:10, Mark Rotteveel wrote:
Why was this NULL behaviour chosen?
To make BLOB_APPEND more convenient for users.
I don't understand how using a different NULL behaviour then standard for operations
+1
András
Feladó: Jiří Činčura
Elküldve: 2022. augusztus 11. 16:46
Címzett: For discussion among Firebird Developers
Tárgy: Re: [Firebird-devel] BLOB_APPEND and NULL
I was thinking the same when reading the discussion on GH. I believe it's not
la
I was thinking the same when reading the discussion on GH. I believe it's not
late to make correction (hey, we all make mistakes) and have consistent
behavior.
--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lis
On 11-08-2022 16:21, Vlad Khorsun wrote:
11.08.2022 17:10, Mark Rotteveel wrote:
Why was this NULL behaviour chosen?
To make BLOB_APPEND more convenient for users.
I don't understand how using a different NULL behaviour then standard
for operations in SQL/Firebird is convenient. To me it
15 matches
Mail list logo
