New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Negative infinity (double) shown incorrectly without sign in isql [CORE5570] #5837
Comments
Modified by: @cincuranetdescription: Storing Double.NegativeInfinity (https://msdn.microsoft.com/en-us/library/system.double.negativeinfinity(v=vs.110).aspx) stores it correctly (correct value is read back), but in isql the sign is not shown. => Storing Double.NegativeInfinity (https://msdn.microsoft.com/en-us/library/system.double.negativeinfinity(v=vs.110).aspx) stores it correctly (correct value is read back), but in isql the sign is not shown. SQL> select * from test;
======================= The second value should be negative (was stored as negative). |
Commented by: @asfernandes Please test in the next snapshot. |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Alpha 1 [ 10731 ] Fix Version: 3.0.3 [ 10810 ] assignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Resolved [ 5 ] => Reopened [ 4 ] resolution: Fixed [ 1 ] => Fix Version: 4.0 Alpha 1 [ 10731 ] => Fix Version: 3.0.3 [ 10810 ] => |
Commented by: @cincuranet So far the 3.0.3 still shows wrong values. |
Commented by: @asfernandes Fix was temporary reopened and now just committed in master only for testing. |
Modified by: @asfernandesstatus: Reopened [ 4 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Alpha 1 [ 10731 ] Fix Version: 3.0.3 [ 10810 ] |
Commented by: @pavel-zotov Which numeric literals should be passed to ISQL in order to get such results on console ("+/- Infinity") ?
|
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: See comment 27.07.2017 07:11. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] Test Details: See comment 27.07.2017 07:11. => See comment 27/Jul/17 04:11 AM |
Commented by: @asfernandes I do not know, really. I did the test internally modifying the engine to produce -Infinity. |
Commented by: @cincuranet I can confirm the Firebird-3.0.3.32794 shows the negative infinity correctly. |
Commented by: Slavomir Skopalik (skopaliks) Will be nice if there will be a UDF/Internal set of functions that will provide +-Nan constant and test for Nan. |
Commented by: @pavel-zotov > I can confirm the Firebird-3.0.3.32794 shows the negative infinity correctly. Using ISQL ? Which values for numbers do you use ? |
Commented by: @cincuranet No, using .NET. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred => Done successfully Test Details: See comment 27/Jul/17 04:11 AM => |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @cincuranet
Storing Double.NegativeInfinity (https://msdn.microsoft.com/en-us/library/system.double.negativeinfinity(v=vs.110).aspx) stores it correctly (correct value is read back), but in isql the sign is not shown.
SQL> select * from test;
=======================
Infinity
Infinity
The second value should be negative (was stored as negative).
Commits: 830372f 8c5c9bd c365bf4 1b670ae 43e662a 63080ab
The text was updated successfully, but these errors were encountered: