[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL) - teiid-designer-issues

Monday, 21 December 2015

    [
https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu...
] 

Mark Drilling edited comment on TEIIDDES-2687 at 12/21/15 4:58 PM:
-------------------------------------------------------------------

Here is a summary of current Designer behavior.  I set the default value in designer,
exported dynamic vdb, then re-imported the dynamic vdb.

||Case||Designer Default value||Exported DDL||Import back into Designer||
|1|defaultValue|col1 string(4000) DEFAULT defaultValue|defaultValue|    
|2|"defaultValue"|col1 string(4000) DEFAULT
"defaultValue"|"defaultValue"|    
|3|"default Value"|col1 string(4000) DEFAULT "default
Value"|"default Value"|
|4|default Value|col1 string(4000) DEFAULT default Value|FAIL - fails re-import|
|5|'defaultValue'|col1 string(4000) DEFAULT 'defaultValue'|defaultValue -
removes ticks|
|6|'default Value'|col1 string(4000) DEFAULT 'default Value'|default Value
- removes ticks|

was (Author: mdrillin):
Here is a summary of current Designer behavior.  I set the default value in designer,
exported dynamic vdb, then re-imported the dynamic vdb.

||Case||Designer Default value||Exported DDL||Import back into Designer||
|1|defaultValue|col1 string(4000) DEFAULT defaultValue|OK - defaultValue|    
|2|"defaultValue"|col1 string(4000) DEFAULT "defaultValue"|OK -
"defaultValue"|    
|3|"default Value"|col1 string(4000) DEFAULT "default Value"|OK -
"default Value"|
|4|default Value|col1 string(4000) DEFAULT default Value|FAIL - fails re-import|

...
 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)

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)