Issue Details (XML | Word | Printable)

Key: CORE-1891
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0
Operations

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

SHOW VIEW shows non-sense information for view fields with expressions

Created: 09/May/08 01:34 PM   Updated: 21/Apr/11 09:15 AM
Component/s: ISQL
Affects Version/s: 2.0.0, 2.0.1, 2.0.2, 2.0.3, 2.5 Initial, 2.1.0, 2.0.4
Fix Version/s: 2.5 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
SQL> create table test (n integer);
SQL> create view view_test (x, y) as select n, n * 2 from test;
SQL> show view view_test;
X INTEGER Nullable
Y Computed by:
View Source:
==== ======
 select n, n * 2 from test

I'll change to:
SQL> show view view_test;
X INTEGER Nullable
Y BIGINT Expression
View Source:
==== ======
 select n, n * 2 from test


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 21/Apr/11 09:15 AM
QA test added.