Skip to content
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

Division of numbers that wre written in scientific notation ( "1.23e4" ) was broken in dialect 1 (FB 4.0 only) [CORE5541] #5809

Closed
firebird-automations opened this issue May 17, 2017 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Run this:

set sqlda_display on;
set wng off;
set list on;
set echo on;

set sql dialect 1;

select 1e2 + 1e1 from rdb$database;
select 1e2 - 1e1 from rdb$database;
select 1e2 * 1e1 from rdb$database;
select 1e2 / 1e1 from rdb$database;

Expected result should finish with:

select 1e2 / 1e1 from rdb$database;

INPUT message field count: 0

OUTPUT message field count: 1
01: sqltype: 480 DOUBLE scale: 0 subtype: 0 len: 8
: name: DIVIDE alias: DIVIDE
: table: owner:

DIVIDE 10.00000000000000

But on WI-T4.0.0.639 output will finish like this:

select 1e2 / 1e1 from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-expression evaluation not supported
-Division in dialect 1 must be between numeric data types

No troubles with dialect 3. No troubles in current 3.0.2 builds.

====== Test Details ======

See test for CORE3972

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Sorry, this ticket seems to be duplicate of CORE3972 (which test is broken last weeks), scientific notation no matters.

set sql dialect 1;

select 100 / 50 from rdb$database;

Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-expression evaluation not supported
-Division in dialect 1 must be between numeric data types

This ticket can be closed as duplicate.

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

Duplicate of CORE3972

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Open [ 1 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Covered by another test(s)

Test Details: See test for CORE3972

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant