Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1271226

Summary: Dynamic VDB generation - Default value for string column problem (DDL)
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Matus Makovy <mmakovy>
Component: ToolingAssignee: Barry LaFond <blafond>
Status: CLOSED NOTABUG QA Contact: Matus Makovy <mmakovy>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Mac OS   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-12-07 13:27:40 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

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