Re: [Firebird-devel] [FB3] result type of negate operation

[Kovalenko Dmitry]

>>>   The question is whether result of negation should keep the type of 
>>> source or can it be expanded if needed.

>>Then it would need to expand for all types.

>And what would be an -INT128?

Result type must be same as result of expression "0-source"?

Note that in Dialect 1:

0-smallint -> integer
0-integer -> double

---
Dmitry Kovalenko



Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB3] result type of negate operation

[Adriano dos Santos Fernandes]

On 10/10/2021 13:11, Dimitry Sibiryakov wrote:
> Mark Rotteveel wrote 10.10.2021 18:08:
>> Yes, this is normal. The range of a smallint is from -32768 to 32767,
>> so you can't negate -32768 as it will overflow back to -32768, hence
>> it will raise the integer overflow error.
> 
>   The question is whether result of negation should keep the type of
> source or can it be expanded if needed.
> 

Then it would need to expand for all types.

And what would be an -INT128?


Adriano


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB3] result type of negate operation

[Dimitry Sibiryakov]

Mark Rotteveel wrote 10.10.2021 18:08:
Yes, this is normal. The range of a smallint is from -32768 to 32767, so you 
can't negate -32768 as it will overflow back to -32768, hence it will raise the 
integer overflow error.


  The question is whether result of negation should keep the type of source or 
can it be expanded if needed.


--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] [FB3] result type of negate operation

[Mark Rotteveel]

On 09-10-2021 21:26, Kovalenko Dmitry wrote:

Hello,

FB3.0.8.22506 (Dialect 3)

Firebird defines a follow result types for Negate operation:

-SMALLINT_COLUMN has result type SMALLINT

-INTEGER_COLUMN has result type INTEGER

As result, I see a work like this:

SQL> create table TTT2 (COL_SMALLINT SMALLINT);

SQL> insert into TTT2 values(-32768);

SQL> select -COL_SMALLINT from TTT2;

===

Statement failed, SQLSTATE = 22003

Integer overflow.  The result of an integer operation caused the most 
significant bit of the result to carry.


It is OK?


Yes, this is normal. The range of a smallint is from -32768 to 32767, so 
you can't negate -32768 as it will overflow back to -32768, hence it 
will raise the integer overflow error.


Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] SRP Is Now Deprecated

[Dimitry Sibiryakov]

Mark Rotteveel wrote 10.10.2021 16:03:
Could you please stop posting random links without further context. And as far 
as I can tell that blogger is just a random person which has no authority to 
'declare' SRP deprecated.


  Besides, Firebird uses SRP for authentication, not just key exchange.

--
  WBR, SD.


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] SRP Is Now Deprecated

[Mark Rotteveel]

On 10-10-2021 15:51, marius adrian popa wrote:
https://news.ycombinator.com/item?id=28802559 



Could you please stop posting random links without further context. And 
as far as I can tell that blogger is just a random person which has no 
authority to 'declare' SRP deprecated.


In other words, this is pure FUD.

Mark
--
Mark Rotteveel


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

[Firebird-devel] SRP Is Now Deprecated

[marius adrian popa]

https://news.ycombinator.com/item?id=28802559
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel