search

databrickslabs / remorph

Accelerates migrations to Databricks by automating code conversion and migration validation
Other
47 stars 31 forks source link

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

Open Mailendiran98 opened 3 weeks ago

Mailendiran98 commented 3 weeks ago

Is there an existing issue for this?

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 commented 2 weeks ago

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 commented 2 weeks ago

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) );