[
https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2687:
----------------------------------------
Van's comment from BZ: I don't think DEFAULT '("Stock")' is
correct, even though it may work. Its not consistent with defining other attributes.
Now, if you would have said something like: DEFAULT ('"Stock"') ,
then possibly.
Dynamic VDB generation - Default value for string column problem
(DDL)
----------------------------------------------------------------------
Key: TEIIDDES-2687
URL:
https://issues.jboss.org/browse/TEIIDDES-2687
Project: Teiid Designer
Issue Type: Bug
Components: Dynamic VDBs, Patch Release, VDB & Execution
Affects Versions: 9.0.4
Reporter: Matus Makovy
Assignee: Mark Drilling
Fix For: 9.2.1
I have a model with table that has String column with default value "Stock".
DDL generated by TD for dynamic VDB looks like this:
{quote}
...
TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE
'"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'),
...
{quote}
*DEFAULT ('Stock')* is not correct, it should be: *DEFAULT
'("Stock")'*
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)