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

No integer division possible in dialect 1 [CORE5565] #5832

Closed
firebird-automations opened this issue Jun 10, 2017 · 12 comments
Closed

No integer division possible in dialect 1 [CORE5565] #5832

firebird-automations opened this issue Jun 10, 2017 · 12 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Arkadiusz Wolanski (knuut21)

Following statement:

select d.rdb$relation_id / 1
from rdb$database d

causes following exception:

Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
Dynamic SQL Error.
expression evaluation not supported.
Division in dialect 1 must be between numeric data types.

Commits: 665975a

@firebird-automations
Copy link
Collaborator Author

Commented by: @mrotteveel

Exactly which build did you use?

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Arkadiusz Wolanski (knuut21)

It's 4.0.0.665-0 64 Bit, build 4.0.0.550 work's fine.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Cannot Reproduce [ 5 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Arkadiusz Wolanski (knuut21)

Did you try it with a database dialect 1?

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

I can reproduce it with current master:

#⁠ ./isql -sql 1 employee

WARNING: This database speaks SQL dialect 3 but Client SQL dialect was set to 1 .
Database: employee, User: SYSDBA
SQL> select d.rdb$relation_id / 1
CON> from rdb$database d;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-expression evaluation not supported
-Division in dialect 1 must be between numeric data types
SQL>

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Resolved [ 5 ] => Reopened [ 4 ]

resolution: Cannot Reproduce [ 5 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

summary: No in Division possible in dialect 1 => No integer division possible in dialect 1

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Reopened [ 4 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Arkadiusz, regarding bugs in unreleased versions it's better to use fb-devel instead tracker.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

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

2 participants