Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
ER Modeler should not be scripting view comments in the sql preview. This is caused because extraction of the view source is stored into the AFView._veiwtext parameter without CREATE key word. When we extract view information, if the database does not store the CREATE keyword in the statement, we rebuild the view with the CREATE statement keywords and store it in _viewText field.
ERModeler should then use this statement instead of rebuilding the view DDL script unless the user physically modifies the sql area and removes the CREATE keyword.
ExtractView.java class line : 1290
|
|
65 KB
Fixed BigQuery to display view comment in the View node but not include view comment in SQL Preview in ER Modeler. This change requires updates to the Create View and View Properties dialogs and Script View code to include view comment.
Verified in ADS 17.0.0-ga-28.
Now for BigQuery view comment is not displayed in View Properties window in SQL Preview tab in ER Modeler.
Please refer attached screen-shot "14196_ASD17-ga-28.png".
Verified in ADS 17.0.0-ga-28.
Now for BigQuery view comment is not displayed in View Properties window in SQL Preview tab in ER Modeler.
Please refer attached screen-shot "14196_ASD17-ga-28.png".
Issue #14196 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 17.0.0-ga-28 |
| No time estimate |
1 issue link |
relates to #14179
Issue #14179SAP HANA-1.0 : View comment script is not displayed in ER-Modeler->view properties->SQL preview tab. |
Fixed BigQuery to display view comment in the View node but not include view comment in SQL Preview in ER Modeler. This change requires updates to the Create View and View Properties dialogs and Script View code to include view comment.