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
select rdb$db_key from a view with a more than 1 table joined, results in conversion error [CORE2578] #2988
Comments
Modified by: @dyemanovdescription: /* Metadata */ SET SQL DIALECT 3; CREATE TABLE TABLE_A ( CREATE TABLE TABLE_B( CREATE VIEW VIEW_A( /*Command test case*/ /* result */ Overflow occurred during data type conversion. => /* Metadata */ SET SQL DIALECT 3; CREATE TABLE TABLE_A ( CREATE TABLE TABLE_B( CREATE VIEW VIEW_A( /*Command test case*/ /* result */ Overflow occurred during data type conversion. security: Developers [ 10012 ] => |
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesVersion: 3.0 Initial [ 10301 ] Version: 2.5 Beta 2 [ 10300 ] Version: 2.5 Beta 1 [ 10251 ] Version: 2.5 RC1 [ 10362 ] |
Modified by: @AlexPeshkoffassignee: Adriano dos Santos Fernandes [ asfernandes ] => Alexander Peshkov [ alexpeshkoff ] |
Commented by: @AlexPeshkoff Fixed errors when sorting dbkey's. |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 RC2 [ 10372 ] Fix Version: 2.1.4 [ 10361 ] Fix Version: 3.0 Initial [ 10301 ] |
Modified by: @dyemanovVersion: 2.5 RC1 [ 10362 ] => |
Commented by: @pcisar QA test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: Manuel Troia (mtr)
Is related to QA244
/* Metadata */
SET SQL DIALECT 3;
SET NAMES NONE;
PAGE_SIZE 16384
DEFAULT CHARACTER SET NONE;
CREATE TABLE TABLE_A (
F_A INTEGER,
F_B INTEGER
);
CREATE TABLE TABLE_B(
F_A INTEGER,
F_C INTEGER
);
CREATE VIEW VIEW_A(
K1,
K2,
F_A,
F_B,
F_C)
AS
select A.rdb$db_key, B.rdb$db_key, A.F_A, A.F_B, B.F_C from table_A A
left join table_B B on A.F_A = B.F_A;
/*Command test case*/
select rdb$db_key from VIEW_A order by 1 /* if order clause omitted crashes IBExpert ?!*/
/* result */
Overflow occurred during data type conversion.
conversion error from string "�".
Commits: 39f3ec8 513a44b e8d9f05
The text was updated successfully, but these errors were encountered: