Issue Details (XML | Word | Printable)

Key: CORE-2578
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Alexander Peshkov
Reporter: Manuel Troia
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

select rdb$db_key from a view with a more than 1 table joined, results in conversion error

Created: 31/Jul/09 05:11 AM   Updated: 29/Jun/11 01:58 PM
Component/s: None
Affects Version/s: 2.1.2, 2.5 Beta 1, 2.5 Beta 2, 3.0 Initial
Fix Version/s: 2.5 RC1, 2.1.4, 3.0 Alpha 1

Time Tracking:
Not Specified

Environment: winVista; FB2.1.2.18118; IBO4.8.5(Delphi) / FlameRobin / IBExpert 2008.12
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
/* 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 "�".


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 04/Nov/09 10:03 PM
Fixed errors when sorting dbkey's.
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.

Pavel Cisar added a comment - 29/Jun/11 01:58 PM
QA test added.