Bug 1271226 - Dynamic VDB generation - Default value for string column problem (DDL)
Summary: Dynamic VDB generation - Default value for string column problem (DDL)
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Tooling
Version: 6.2.0
Hardware: Unspecified
OS: Mac OS
unspecified
medium
Target Milestone: ---
: ---
Assignee: Barry LaFond
QA Contact: Matus Makovy
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2015-10-13 12:18 UTC by Matus Makovy
Modified: 2016-09-13 12:04 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-12-07 13:27:40 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIIDDES-2687 0 Major Closed Dynamic VDB generation - Default value for string column problem (DDL) 2016-09-13 12:04:53 UTC

Description Matus Makovy 2015-10-13 12:18:19 UTC
I have a model with table that has String column with default value "Stock".
DDL generated by TD for dynamic VDB looks like this:


...
TYPE string(15) DEFAULT ('Stock')  OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'),
...


DEFAULT ('Stock') is not correct, it should be: DEFAULT '("Stock")'

Comment 1 Van Halbert 2015-10-13 12:56:40 UTC
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.

Comment 2 Barry LaFond 2015-12-07 13:27:40 UTC
Using only JIRA now.  Marking as closed

Comment 3 JBoss JIRA Server 2016-08-19 17:20:40 UTC
Barry LaFond <blafond> updated the status of jira TEIIDDES-2687 to Resolved

Comment 4 JBoss JIRA Server 2016-09-13 12:04:54 UTC
Matus Makovy <mmakovy> updated the status of jira TEIIDDES-2687 to Closed


Note You need to log in before you can comment on or make changes to this bug.