[Firebird-devel] [FB-Tracker] Created: (CORE-3300) "default clause" and "column constraint " in a column definition statement

[Derryck w. (JIRA) <tr...@fi...>]

"default clause" and "column constraint " in a  column definition statement
---------------------------------------------------------------------------

                 Key: CORE-3300
                 URL: http://tracker.firebirdsql.org/browse/CORE-3300
             Project: Firebird Core
          Issue Type: Improvement
          Components: Engine
    Affects Versions: 2.5.0
         Environment: win/linux
            Reporter: Derryck welas


 "SQL:standaard " says i can use  "default clause" and/or  "column constraint " in a  column definition. 
dont know  if this worked before but i'm using  FB 2.5.0 at the moment.

example:
CREATE TABLE test (  
  id BIGINT NOT NULL ,
  description VARCHAR(100) NOT NULL  DEFAULT 'test',
  PRIMARY KEY (id)
); 


Error: *** IBPP::SQLException ***
Context: Statement::Prepare( CREATE TABLE test (  
  id BIGINT NOT NULL ,
  description VARCHAR(100) NOT NULL DEFAULT 'test',
  PRIMARY KEY (id)
) )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code    : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 3, column 37
DEFAULT

=======
2003 sql ref:
  <column definition>    ::= 
         <column name> [ <data type> | <domain name> ] [ <reference scope check> ]
         [ <default clause> | <identity column specification> | <generation clause> ]
         [ <column constraint definition> ... ] [ <collate clause> ]






-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira