|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
winVista; FB2.1.2.18118; IBO4.8.5(Delphi) / FlameRobin / IBExpert 2008.12
|
|
Issue Links:
|
Relate
|
|
|
|
This issue is related to:
|
|
|
|
|
|
|
|
| Planning Status: |
Unspecified
|
|
/* 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 "�".
|
|
Description
|
/* 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 "�".
|
Show » |
|
Bug
Minor
select rdb$db_key from a view with a more than 1 table joined, results in conversion error
BTW, no idea why does IBExpert crash when order by is missing - isql works fine. Quite possible after fix IBExpert will crash with order by clause too.