Issue Details (XML | Word | Printable)

Key: CORE-1386
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Trivial Trivial
Assignee: Dmitry Yemanov
Reporter: lacak
Votes: 0
Watchers: 2
Operations

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

Generated columns

Created: 30/Jul/07 08:57 AM   Updated: 23/Feb/11 10:45 AM
Component/s: None
Affects Version/s: None
Fix Version/s: 2.1 Beta 2

Time Tracking:
Not Specified

File Attachments: 1. Text File keywords.cpp.diff (0.6 kB)
2. Text File parse.y.diff (1 kB)

Issue Links:
Relate


 Description  « Hide
Make "compute by" column definition SQL:2003 compliant

Now:
 <column name> <type or domain> COMPUTED [BY] ( <expr> )

SQL:2003
 <column name> <type or domain> GENERATED ALWAYS AS ( <expr> )


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 16/Mar/09 12:04 PM
Ok, but you can't use a domain
so the syntax are :
 <column name> <type> COMPUTED [BY] ( <expr> )
or
<column name> <type> GENERATED ALWAYS AS ( <expr> )