Changing autoincrement from always to by default

PeterDKay · PeterDKay · commit e0315bc9340a · 2024-01-25T09:51:51.000Z
diff --git a/src/databricks/sqlalchemy/dialect/base.py b/src/databricks/sqlalchemy/dialect/base.py
@@ -102,7 +102,7 @@ def visit_create_table(self, create, **kw):
                     create_column, first_pk=column.primary_key and not first_pk
                 )
                 if column.autoincrement is True:   # If doesn't work try 'is True' and == 'True'
-                    processed = "`".join(processed.split("`")[:-1]) + "` " + "BIGINT GENERATED ALWAYS AS IDENTITY"
+                    processed = "`".join(processed.split("`")[:-1]) + "` " + "BIGINT GENERATED BY DEFAULT AS IDENTITY"
                 if processed is not None:
                     text += separator
                     separator = ", \n"

Original file line number	Diff line number	Diff line change
`@@ -102,7 +102,7 @@ def visit_create_table(self, create, **kw):`
`102`	`102`	`create_column, first_pk=column.primary_key and not first_pk`
`103`	`103`	`)`
`104`	`104`	`if column.autoincrement is True: # If doesn't work try 'is True' and == 'True'`
`105`		- processed = "`".join(processed.split("`")[:-1]) + "` " + "BIGINT GENERATED ALWAYS AS IDENTITY"
	`105`	+ processed = "`".join(processed.split("`")[:-1]) + "` " + "BIGINT GENERATED BY DEFAULT AS IDENTITY"
`106`	`106`	`if processed is not None:`
`107`	`107`	`text += separator`
`108`	`108`	`separator = ", \n"`