Fix detection of column types with DEFAULT CURRENT_TIMESTAMP(123). See …

…https://www.heidisql.com/forum.php?t=17585
HeidiSQL · Apr 1, 2017 · 38cfdd0 · 38cfdd0
1 parent 444a5bd
commit 38cfdd0
Showing 1 changed file with 2 additions and 2 deletions.
diff --git a/source/dbconnection.pas b/source/dbconnection.pas
@@ -4969,9 +4969,9 @@ procedure TDBConnection.ParseTableStructure(CreateTable: String; Columns: TTable
           if rxCol.Match[3] <> '' then
             Col.DefaultType := cdtNullUpdateTS;
           Delete(ColSpec, 1, rxCol.MatchLen[0]);
-        end else if rxCol.Match[1] = 'CURRENT_TIMESTAMP' then begin
+        end else if StartsText('CURRENT_TIMESTAMP', rxCol.Match[1]) then begin
           Col.DefaultType := cdtCurTS;
-          Col.DefaultText := 'CURRENT_TIMESTAMP';
+          Col.DefaultText := rxCol.Match[1];
           if rxCol.Match[3] <> '' then
             Col.DefaultType := cdtCurTSUpdateTS;
           Delete(ColSpec, 1, rxCol.MatchLen[0]);