× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
arunbhatt(*) reported 2017-07-20T05:15:10Z  · Lwaugh last modified 2019-05-23T22:19:07Z

Teradata : Create script is not generated for Macros object when created with CM instead of CREATE MACRO.


Priority Major
Complexity Unknown
Component DB - Teradata
Version Future

Steps to reproduce the issue:

1) Connect to Teradata server.
2) Execute the following scripts on QA:

CREATE TABLE MACRO_SALARY1(
  empid INTEGER NOT NULL,
   NetPay INTEGER
)
GO
CM MACRO_TAB2(empid INTEGER NOT NULL) AS (
SELECT empid,NetPay FROM MACRO_SALARY1 WHERE empid = empid;
)
GO

3) Now, generate CREATE script from ADS UI of the macros  'MACRO_TAB2' object created above.

Actual result: Script is not generated, only statement separator ('GO') is generated. Please refer screenshot.

Expected result: Complete script of macros should be generated as follows:

CM MACRO_TAB2(empid INTEGER NOT NULL) AS (
SELECT empid,NetPay FROM MACRO_SALARY1 WHERE empid = empid;
)
GO

Observations: 
- Same behaviour is observed in V18.

ADS versions Reproducible
V18 Yes
V19 Yes

Also, In Schema Compare it shows an "Error generating DDL".But if you execute SQL fired on SQL Log, you can see that information of that macro is extracted. Please refer attached sql file for query and screenshot.

- Script is not generated when we use 'CM' to create Macros instead of 'CREATE MACRO'. If Macros are created using 'CREATE MACRO' than correct script is generated by ADS. Please refer screenshot.

logging this issue based on the discussions on VA #10097.

3 attachments

Issue #15395

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017