[BUG]: #Tredence . Transpile - "autoincrement start 1 increment 1 order" constraint skips the entire sql file

[Mailendiran98]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

TranspileParserError

Current Behavior

I have a .sql file with 10 scripts (DDL,DML etc,..) . If anyone of script has constraint - "autoincrement start 1 increment 1 order"
Transpile is skipping the entire .sql file and not the respective script.

Expected Behavior

Skip only those script has constraint - "autoincrement start 1 increment 1 order" and not the entire .sql file while parsing.

Steps To Reproduce

No response

Relevant log output or Exception details

No response

Sample Query

No response

Operating System

Windows

Version

latest via Databricks CLI

[sriram251-code]

Hi @Mailendiran98 please provide us with an example that will allow us to replicate the issue on our end. We are suspecting it should be solved with the fix of #1185

[Mailendiran98]

HI @sriram251-code , please find the example where i'm facing the issue.

Assume i have below 2 DDL in one sql file.
Because of autoincrement start 1 increment 1 noorder in STUDENTS table, entire sql file is getitng skipped in conversion.

create or replace TABLE SAMPLEDB (
NAME VARCHAR(16777216),
CITY VARCHAR(16777216),
SALARY VARCHAR(16777216)
);
create or replace TABLE STUDENTS (
STUDENTS_ID NUMBER(38,0) NOT NULL autoincrement start 1 increment 1 noorder,
FIRST_NAME VARCHAR(255),
LAST_NAME VARCHAR(255),
PIN_CODE VARCHAR(10),
CITY VARCHAR(255),
GRADE VARCHAR(2),
primary key (STUDENTS_ID)
);