forked from liquibase/liquibase
-
Notifications
You must be signed in to change notification settings - Fork 0
/
changelog.txt
2040 lines (1867 loc) · 122 KB
/
changelog.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
Liquibase Core Changelog
===========================================
Changes in version 4.4.2 (2021.07.22)
- Changed NullPointerException to ChangeLogParseException for the output when there is a typo in a changeSet node (#1593)
- Added the support method to DatabaseConnection (#1784)
- Fixed the issue with handling serial and bigserial if liquibase.convertDataTypes=false (#1883)
- Improved the ConfigurationValueProvider performance (#1952)
- Added the ability to allow an empty string for the defaultValue attribute (#1963)
- Reintroduced support for the - arguments in the CLI (#1943)
- Restored the updateTestingRollback command (#1939)
- Added the Maven goal for unexpectedChangeSets (#1972)
- Extended the dropAll command with optional hubConnectionId and hubProjectId attributes. For more information, check our [dropAll command]documentation.
- Fixed nested properties and the substitution of variables in YML changelogs.
- Implemented the ability to use connectionjdbcurl when there is no project or connection ID with the dropAll command.
- Improved the Liquibase Pro License key messaging.
- Added the ability to handle a declined auto-registration when running the dropAll command.
- Fixed auto-registration issues.
- [PRO] Added the ability to handle special characters in procedures when using the generateChangeLog command.
- [PRO] Fixed the issue with formatted SQL changesets and runwith:sqlplus being stopped unless Liquibase includes a quit statement.
- [PRO] Fixed the SQL Plus spool log issue.
Changes in version 4.4.1 (2021.07.09)
- GH PR#1869 ⁃ HubUpdater releases lock even though registration is skipped
- GH PR#1861 ⁃ Only snapshot tables/columns in loadData
- GH PR#1843 ⁃ [LB-704] fixed generating sequences for Postgres versions prior to 10
- GH Issue#1829 ⁃ Fixes MySQL Snapshot/Generated ChangeLog output for table key constraints when multiple tables
- Postgres: Rollback of rename target fails due to malformed SQL.
- Liquibase Hub registerChangeLog messaging fixes
- Liquibase Hub, Maven, and liquibase.properties file fixes
- Using --liquibaseProLicenseKey is on the left side of the command
- Update Liquibase installer adoptopenjdk from 11.0.10 to 11.0.11
- [PRO] SQL Plus handles backslashes in changeset attributes' values
- [PRO] SQL Plus passing arguments during runtime fixes
- [PRO] SQL Plus handles Oracle proxy user setups
- [PRO] SQL Plus improve temp file handling
- [PRO] Fixes snapshot on MySQL Stored Logic Objects with Integer Types
Changes in version 4.4.0 (2021.06.08)
- Refactor Configuration API
-- [PRO] including native use of Environment variables
- Refactor Command API
- Rewrote CLI to use new library
-- including new command options and help content
- Fixes an issue with Maven logs and username password (#1859)
- Fixes an issue with resolving properties files (#1723)
- Fixes an issue with diffChangelog dependency order (#1722)
- Fixes an issue with generating changlogs with DB2 on z/OS (#1506)
- Fixes an issue with long table names in Postgres (#1483)
- Fixes an issue with update flags for Postegres(#1213)
- Fixes an issue with loadData and loadUpdateData(#964)
Changes in version 4.3.5 (2021.04.29)
- Better error handling in runWith=sqlplus when user doesn't have create/drop table permissions
Changes in version 4.3.4 (2021.04.15)
- Reverts changes from #1722 because they broke other diffChangeLog/generateChangeLog use cases.
Changes in version 4.3.3 (2021.04.09)
- Fixes an issue with changelogsync and hub
- Fixes an issue with diff and NullPointerException (#1631)
- Fixes an issue with NullPointerException and DateTimeType (#1366)
- Fixes an issue with maven resolving/using properties file (#1723)
- Fixes an issue with diffChangeLog and addColumn -> addPrimaryKey ordering (#1722)
Changes in version 4.3.2 (2021.03.25)
- Added new changelogSyncToTag command #1133
- Support for working with deactivated changelogs in hub
- Added ability to create hub projects with parameters instead of only via prompts
- Only enable console prompting when explicitly enabled by the CLI #1711 #1689
- Handle includeAll better in spring boot #1595 and #1436
- Changed JRE bundled with installers to use the latest LTS version
- Better handle dropAll on postgresql partitioned tables #1650
- Fixed sample liquibase.sqlplus.conf file #1448 and #1416
- Fixed loadData's usePreparedStatement attribute #1098
- Send hub logs at the same log level as configured in the CLI
Changes in version 4.3.1 (2021.02.12)
- Fixed handling of `classpath*:` in includeAll #1595
- ClassCastException on moving to mysql-connector-java 8.0.23 #1639
- Passwords sent to Hub when using jTDS driver
- ChangeExecListener cannot be used to to HubChangeExecListener #1651
- RelativePathError when using includeAll tag and Spring Boot #1657
- Liquibase 4.3.0 throws NullPointerExceptions without snakeyaml in the classpath #1682
Changes in version 4.3.0 (2021.02.06)
- MariaDB is now fully certified for Liquibase Pro users
- Added ability to register for Hub during update operations
- Receive Liquibase Hub report links in the CLI after running commands
- Fixed NPE when an output writer is null #1625
- Fixed filename + Id + author to be treated as unique in ValidatingVisitor.findChangeSet method #1622
- Fixed EntityResolver to check the classpath even if the standard ResourceAccessor does not include it #1621
- Fixed the CVE-2017-18640 issue on snakeyaml-1.2.4 #1608
- Fixed HistoryCommandTest to run on systems having a non-US default locale #1078
- Added quotes around ${JAVA_PATH} in Liquibase shell script to avoid spaces in path issues #1062
- Fixed the issue with automatic dropping of default values on MS SQL #1003
- Allow --changeset to have a space after -- in formatted sql files
- Modified SetColumnRemarks support for MySQL #942
- Implemented boolean data type support for DB2 LUW #966
- Added deprecated LogFactory.getInstance() to smooth the upgrade to 4.x #1642 and #1641
- Included the existing dropPrimaryKey.dropIndex attribute in XSD #1629
- Implemented auto-registration and operation report capabilities for Liquibase Hub
Changes in version 4.2.2 (2020.12.09)
- Handle null statement objects coming from JdbcConnection objects #1576
Changes in version 4.2.1 (2020.12.03)
- Fixed invalid casting to JdbcConnection in CockroachDatabase #1536
- Fixed missing unique constraints in snapshot #1477
- Fixed unexpectedChangeSets command throwing a null pointer exception
- If error occurs during generating SQL, Liquibase stops and does not send POST to Hub
- Use ConcurrentHashMap in ExecutorService #1402
- DropDefaultValue on postgresql now drops the default value vs. setting the default value to null #931
- Updated banner to reference to hub.liquibase.com
- [PRO] GenerateChangeLog on postgresql stored logic now hashes parameters in filenames instead of listing them all out
- [PRO] Fix in postgresql check constraints snapshot
- [HUB] Command registerChangeLog now supports YAML and JSON changelog files
Changes in version 4.2.0 (2020.11.12)
- [PRO] Support for snapshotting Mysql stored logic
- GH PR#373 - Added option "updateable" to the column tag.
- GH Issue#1523 - Fix xsd, remove surplus space after validateForeignKey (4.1.xsd / 4.2.xsd
- GH Issue#1510 - MySql 8.0 requires create and drop of temporary tables to run generateChangeLog
- GH PR#1496 - Move banner.txt to new location
- GH PR#1495 - Fix issue with loadUpdateData GH-1489
- GH Issue#1489 - loadUpdateData broken for clob/text fields in 3.10.3
- GH Issue#1476 - Consider alternative location for banner.txt
- GH Issue#1438 - XML Export adds ',xxx' instead of ','
- GH Issue#1389 - Precondition onFail="WARN" doesn't work properly
- GH PR#1427 - Update Ant Tasks to use DatabaseFactory rather than create connection itself
Changes in version 4.1.1 (2020.10.09)
- GH #1276 Rewrote SpringResourceAccessor
- GH PR#1285 Remove deprecated code in Ant tasks
- GH PR#1286 Fix usage of AntTaskLogger
- GH #1097 diffChangeLog overwrites first changeset in formatted sql changelog
Changes in version 3.10.3 (2020.10.09)
- GH PR#912 - CORE-3379 escaping postgres questionmark operators to prevent unwanted parameter syntax
- GH PR#936 - SpringLiquibase createResourceOpener() now returns a ResourceAccessor, which allows it to be overridden with any kind of ResourceAccessor
- GH PR#983 - Fixes for loadData to support Postgres enums with java.sql.Types.OTHER
- GH PR#1010 - Potential fix for generated columns on postgres
- GH PR#1258 - Reduced the verbosity of logging by moving SQL logging from info to debug logging
- GH PR#1239 - Fix xsd, remove surplus space after validateForeignKey
- GH PR#1296 - Put the banner in an external file for easier editing.
- GH PR#1327 - Fix varchar(max) extrainfo in 3.10 branch
- GH PR#1406 - Fixed integration tests for 983
- GH PR#781 - feat: Maven Liquibase Plugin generateChangeLog mysql sql comment supported
- GH PR#945 - [CORE-3523] Consistently map Liquibase integer types to Oracle integer types. MERGED THEN UNMERGED
- GH PR#1140 - fix root paths for spring boot fat jar
- GH PR#1332 - Update FileSystemResourceAccessor.java
- GH PR#1372 - Fix for PR 1001 in 3.10.x branch
- Fixed priority for JDBC Connections
- GH PR#1140 - Added json and sql to the list
- GH PR#1418 - Revert "[CORE-3523] Consistently map Liquibase integer types to Oracle integer types" UNMERGE 945
- GH PR#1422 - Updates for #1081 in 3.10.x
- GH PR#1431 - Fix merge issue in OracleDatabase
- GH PR#1443 - Handle MSSQL computed columns in generate changelog LB-366
- GH PR#1447 - Do not use batched statements for Postgres LoadDataChange LB-744
- Fixed schema version number for 3.10
Changes in version 4.1.0 (2020.9.28)
- Added support for hub.liquibase.com to CLI and Maven integrations
- New registerChangeLog command
- New syncHub command
- Added hubApiKey argument
- Added hubConnectionId argument
- CLI commands and arguments are now case insensitive
- Includes changes from 3.10.2
Changes in version 3.10.2 (2020.7.27)
- Dependency cycle error during generateChangeLog with --diffTypes=tables,columns,data
- liquibase maven:: unable to run tests on java > 8
- Add Banner in log out put that directs users to online resources.
- GH PR#980 - fixed invalid carriage return coming from oracle ojdbc8 12.2.0.1
- GH PR#976 - Changes databasechangelog sql to use legacy mode
- [CORE-3525] Add support for java.sql.Types.TIMESTAMP_WITH_TIMEZONE.
- GH PR#929 - Fix #CORE-3493 Inconsistent resolution of ChangeLogParameters
- GH PR#744 - Informix data type generation with Default Value cause
- GH PR#1176 - Add MariaDB sequence support to the 3.10.x branch
- GH PR#1177 - CORE-3643: fixed the 'shouldValidateX' methods in the Constraints
- GH PR#1201 - H2 unknown reserved word
Changes in version 4.0.0 (2020.07.14)
- No changes since 4.0.0 beta2
Changes in version 4.0.0 Beta2 (2020.07.1)
- Re-introduced deprecated versions of commonly used 3.x methods that had been removed for 4.0
- Fix to handle --logLevel=debug/fine CLI argument
- Do not include root filesystem in default CLI search paths
Changes in version 3.10.1 (2020.7.2)
- GH PR#913 - [CORE-3471] Fixed NPE in LiquibaseUtil when MANIFEST.MF doesn't contain Bundle-Version or Build-Time
- GH PR#917 - [Core 3463] Fix for validateX attributes of constraintsConfig
- GH PR#919 - Fixed issued with bundling in shaded jars
- GH PR#941 - [CORE-3520] Add support for ALWAYS generation type with PostgreSQL auto-increment column.
- GH PR#946 - [CORE-3524] Prevent auto-increment column silently failing on Oracle.
- GH PR#949 - [CORE-3526] TABLE is a reserved keyword in H2database since 1.4.197
- GH PR#963 - [CORE-3556] No default values for changes' properties
- GH PR#965 - [CORE-3558] Unique constraint name is ignored when using the addColumn change
- GH PR#970 - Fix Java 1.9+ versions require jaxb as separate dependency
- GH PR#971 - Add Class-Path entry to the manifest file to simplify command line execution
- GH PR#975 - NULL date value in prepared statement requires type in MSSQL
- GH PR#986 - XMLSerializer: Correct Map value serialization
- GH PR#993 - Improve ChangeFactory initialization time
- GH Issue#1035 - Change how Liquibase produces debug logs
- GH Issue#1051 - Update liquibase-core.jar to exclude ServiceLoader files
- GH PR#1053 - Update liquibase_autocomplete.shape
- GH PR#1059 - Allow multiple column unique constraints on table creation.
- GH Issue#1069 - Patch Liquibase Runner plugin for Jenkins
- GH Issue#1070 - Enable <command>--help without databse connection
- GH PR#1082 - Correct include bash script
- GH PR#1096 - Fix sequence statement generation for PostgreSQL <= 9.4
- GH Issue#1104 - Fix maven-liquibase offline diff to prevent errors
- GH Issue#1113 - Fix schema name using "--defaultSchemaName" on a non-default schema
- GH PR#1120 - LiquibaseServletListener.contextInitialized() improved with Embedded Derby
- GH Issue#1220 - Fix how JAVA_HOME env variable is handled
Changes in version 3.10.0 (2020.6.12)
- [Pro] Built-in runWith="sqlplus"
- New "runWith" changeSet extension point
- Added liquibase_autocomplete_mac.bash completion script
Changes in version 3.9.0 (2020.5.13)
- [Pro] New ""--format=json" argument for diff command
Changes in version 4.0.0 Beta1 (2020.4.20)
- MAJOR CHANGE: Replaced old custom classpath scanner with java.util.ServiceLoader for finding extensions
- MAJOR CHANGE: Refactored logging system to clean up API and use java.util.Logging
- Fixes to ConstraintsConfig https://github.com/liquibase/liquibase/pull/954
- ignoreLines command in formatted sql log https://github.com/liquibase/liquibase/pull/877
- postgresql >= 10: use identity columns for autoincrement https://github.com/liquibase/liquibase/pull/874
- Using proxy user for Oracle Connections https://github.com/liquibase/liquibase/pull/894
- Capture table remarks on mysql https://github.com/liquibase/liquibase/pull/895
- Add PERIOD to reserved words for MariaDB https://github.com/liquibase/liquibase/pull/896
- Don't require columnDataType on H2 for addNotNullConstraint https://github.com/liquibase/liquibase/pull/851
- Do not remove trailing /'s of comments like /* dsds */ https://github.com/liquibase/liquibase/pull/853
- Require type xsd:string to where element of update element https://github.com/liquibase/liquibase/pull/875/files
- runOnChange change set runs every time even if there wasn't changed https://github.com/liquibase/liquibase/pull/891
- Indexes with DESC sorting are not created for PostgreSQL https://github.com/liquibase/liquibase/pull/880
- Added Ingress support https://github.com/liquibase/liquibase/pull/683
- Support boolean in firebird 3.0 https://github.com/liquibase/liquibase/pull/757
- Change Log Parameters from Environment Variable https://github.com/liquibase/liquibase/pull/758
- Adds clearCheckSums property in spring integration https://github.com/liquibase/liquibase/pull/792
- Oracle datatype translation changes https://github.com/liquibase/liquibase/pull/797
- Implement Sequence Support for MariaDB https://github.com/liquibase/liquibase/pull/852
- Cleanup checksum classes https://github.com/liquibase/liquibase/pull/869
- Fix Turkish uppercase column keys bug https://github.com/liquibase/liquibase/pull/857
- Generate diff with onDelete and onUpdate https://github.com/liquibase/liquibase/pull/858
- PrimaryKeySnapshotGenerator throws NPE for SQLite https://github.com/liquibase/liquibase/pull/856
- Handle java.sql.Time when setting prepared statement parameter values in CSV filese https://github.com/liquibase/liquibase/pull/859
- DB2 LUW supports boolean data type column from version 11.1.1.1 https://github.com/liquibase/liquibase/pull/865
- Offline history support not correctly closing files https://github.com/liquibase/liquibase/pull/863
- Use computeIfAbsent to avoid Liquibase concurrency issues https://github.com/liquibase/liquibase/pull/866
- Firebird does not support RESTRICT option on Foreign Keys https://github.com/liquibase/liquibase/pull/761
- Liquibase was ignoring DatabaseFunction value and processing only SequenceNextValueFunction when creating tables and generating column default value. https://github.com/liquibase/liquibase/pull/785
- Restore usage of `DatabaseList.definitionMatches` to match the `dbms` tag against the database type https://github.com/liquibase/liquibase/pull/811
- DEPLOYMENT_ID column header not included in offline updateSql CSV https://github.com/liquibase/liquibase/pull/813
- Can't set some parameters for snapshot & generate changelog https://github.com/liquibase/liquibase/pull/822
- UUID type handling improvements https://github.com/liquibase/liquibase/pull/838
- Correctly close yaml file in generateChagneLog https://github.com/liquibase/liquibase/pull/844
- Adding restricted words for MSSQL Server Database https://github.com/liquibase/liquibase/pull/825
- Getting a java.io.FileNotFoundException using Liquibase with Spring reactive web https://github.com/liquibase/liquibase/pull/814
- FileSystemResourceAccessor fails with non-hierarchical URLS on classpath https://github.com/liquibase/liquibase/pull/830
- fix oracle date literal without millis https://github.com/liquibase/liquibase/pull/828
- fix nullPointerException when migrating RedShift https://github.com/liquibase/liquibase/pull/823
- Prints the SQL error code on Exception https://github.com/liquibase/liquibase/pull/833
- Fixed SetColumnRemarks for mysql https://github.com/liquibase/liquibase/pull/835
- Allow "NOW" and "Today" literal capabilities in CSV filese https://github.com/liquibase/liquibase/pull/808
- Add ability to disable running of Liquibase via CDILiquibaseConfig https://github.com/liquibase/liquibase/pull/804
Changes in version 3.8.9 (2020.4.06)
- Fixed an issue with how Liquibase handles SMALLINT columns in PostgreSQL when generating a changelog.
- Improved `generateChangeLog` command to assume a `diffTypes` that includes "data" when the `dataOutputDirectory` parameter is used. Most users looking to export data as part of `generateChangeLog` can now simply use the `dataOuputDirectory` parameter without needing to specify `diffTypes`.
- Enabled the use of the `--schemas` parameter to work on either side of the `snapshot` command.
- Enabled `generatechangelog` in PostgreSQL to correctly order `create`, `function`, and `trigger` statements.
- Improved the use of dblink objects when using `diff` command.
Changes in version 3.8.8 (2020.3.19)
- `rollbackOneChangeSetSQL` now works correctly with the Liquibase Maven plugin.
- Liquibase Pro no longer generates procedural code with incorrect SQL syntax when running `generateChangeLog` against a MySQL database.
Changes in version 3.8.7 (2020.2.21)
- New liquibase history command
- [Pro] New liquibase rollbackOneUpdate command
- PR#927 CompositeClassLoader does not implement getResource(String)
- `liquibase --help` was improved to include missing commands and correct information
Changes in version 3.8.6 (2020.2.6)
- New graphical installer for Windows and Mac
- New examples directory with sample xml and sql changelogs and test h2 database
- [Pro] New RollbackOneChangeSet and RollbackOneChangeSetSQL commands
- Updated default Mysql driver to com.mysql.cj.jdbc.Driver
- Removed non-jdbc compatible "SET DEFINE OFF" from generated SQL on Oracle
- Fixed --excludeObjects/--includeObjects arguments in diff
Changes in version 3.8.5 (2020.1.13)
- Fixes issue in which Liquibase did not add `DESC` to an `id` column
- CLI once again accepts sqlFile, delimiter, rollbackScript, and outputSchemaAs arguments
- Fixes Stored Procedure whitespace impacting update calls
- Fixes generateChangelog failure when there are missing NOT NULL constraints.
- Fixes updateSQL, which was not including schemaName for package bodies.
- Fixes bug in which Liquibase was not always capturing `create package body` while generating changeLog
- Liquibase CLI now gives a more useful error message when an invalid character is passed to a command.
- Fixes an MSSQL issue, which threw an exception when doing diff/diffChangeLog between offline connections (such as when snapshotting json files)
- Fixes an MSSQL issue, which incorrectly generated `datetime` data type column when using`diff` & `diffChangeLog`
- Liquibase Maven plugin fails while executing/using "diff" and "generateChangeLog" with PostgreSQL)
Changes in version 3.8.4 (2019.12.23)
- Fixed a 'Class not Found' exception error when using Java +9.
- Fixed a 'Cannot Use Default Schema Name' error when users diff against an SQL Server snapshot file.
- Fixed an 'Unexpected type: java.util.Date' error when using a defaultValueDate attribute in a YAML changelog.
Changes in version 3.8.3 (2019.12.19)
- Liquibase-Maven plugin now works with Java 9+.
- Expired license messages should be far less verbose and excitable.
Changes in version 3.8.2 (2019.11.26)
- Pro stored logic snapshot logic now supports postgresql and db2
- Using generateChangeLog/diffChangeLog to generate formatted sql changelogs now works with Liquibase Pro's stored logic support
- CDI-related classes moved back out of the main liquibase jar into an optional jar
- Fixed issue with indexes backing foreign keys not always being caputured in diffChangeLog/generateChangeLog
- Fixed issue with diffChangeLog/generateChangeLog generating primary keys when column order doesn't match the table's column order
Changes in version 3.8.1 (2019.11.5)
- [PRO] Oracle and SQL Server users can now reverse engineer database changes for stored logic such as triggers, functions & procedures using generateChangeLog, snapshot, diff, and diffChangeLog commands.
- diff command writes to an external file using --outputFile flag
- updateSQL command no longer outputs to liquibase.log
- Cleaned up unexpected entries in diffchangelog.xml for SQL Server
Changes in version 3.8.0 (2019.8.16)
- [CORE-3462] - Add new procedural database code change types for Liquibase Pro
Changes in version 3.7.0 (2019.7.16)
- [CORE-3303] - Allow disabling shouldRun configuration via CDI integration
- [CORE-3388] - DB2 LUW supports boolean data type column from version 11.1.1.1
- [CORE-3400] - add "manifoldclass:" to list of skipped URL protocols in DefaultPackageScanClassResolver
- [CORE-2377] - Using replaceIfExists with <createView> generates DROP statements
- [CORE-2971] - Comments at end of statements are incorrectly parsed
- [CORE-3124] - Indexes with DESC sorting are not created for PostgreSQL
- [CORE-3159] - class cast exception when running command line
- [CORE-3174] - Plugin does not create parent directory
- [CORE-3211] - Firebird does not support RESTRICT option on Foreign Keys
- [CORE-3251] - SQL Server Changesets Not Escaping Keywords
- [CORE-3365] - PrimaryKeySnapshotGenerator throws NPE for SQLite
- [CORE-3375] - addNotNullConstraint on h2 still requires (unused) columnDataType
- [CORE-3386] - includeAll can't resolve relativeToChangelogFile path within a jar file
- [CORE-3437] - MariaDB 10.3.4+ problem with add column PERIOD
- [CORE-2235] - Support priority-based selection of Precondition implementation
- [CORE-3205] - Change Log Parameters from Environment Variable
Changes in version 3.6.3 (2019.1.29)
- [CORE-3100] - diff with uppercase reference database name
- [CORE-3141] - ForeignKeySnapshotGenerator broken with recent SQL Server driver
- [CORE-3192] - Error while including resources with includeAll directive
- [CORE-3221] - Parsing valueDate Attribute of column Tag leads to precision loss and generating SQL for Oracle DB is broken
- [CORE-3222] - Bin zip doesn't work due to missing slf4j-api JAR
- [CORE-3231] - NPE in LogService.pushContext for MDCs that don't allow null values
- [CORE-3242] - MS SQL Server 2008 support issue
- [CORE-3256] - Verbose flag not getting interperated during 'status' command.
- [CORE-3293] - Non global change log parameters are wrongly resolved in inner files
- [CORE-3296] - CommandLineUtils::getBanner fails if manifest entries are missing
- [CORE-3335] - Not possible to register/unregister SqlGenerators during execution of changeSet
- [CORE-3348] - MSSQLDatabase class has a bug when connecting to SQL Server 2008 databases
Changes in version 3.6.2 (2018.06.30)
- [CORE-3129] - PostgreSQL dropPrimaryKey with objectQuotingStrategy="QUOTE_ALL_OBJECTS"
- [CORE-3206] - Liquibase 3.6.x is binary api-incompatible with 3.5.x
- [CORE-3213] - Changelog with includeAll will not find child changelogs in multi-modules Spring Boot's executable JAR
- [CORE-3229] - Oracle 11g doesn't support TIMESTAMP WITHOUT TIME ZONE data type
Changes in version 3.6.1 (2018.04.11)
- [CORE-3200] - Wrong SQL generator is selected
- [CORE-3201] - Command line missing required dependencies in 3.6.0 tarball
- [CORE-3198] - Configuration option to prefer internal XSD usage
Changes in version 3.6.0 (2018.04.5)
- [CORE-1609] - Command Prompt: Can't connect to database with a special character in pwd
- [CORE-1852] - checksums depend on environment
- [CORE-1888] - Sybase error for TINYINT, INT, BIGINT: Can't specify a length, scale or storage property on type 'int/tinyint/bigint'.
- [CORE-2008] - H2 Supports minValue and maxValue in Sequences since Version 1.3.175, but Liquibase does not
- [CORE-2033] - NPE during Diff when case sensitive table missing
- [CORE-2135] - liquibase corrupting UTF-8 changesets
- [CORE-2162] - MSSQL: Multiple inserts in sqlFile do not fail as expected
- [CORE-2191] - Update on SQL Azure database fails due to unavailable sys.extended_properties
- [CORE-2527] - Sybase create table fails because column name is too long
- [CORE-2631] - dbdoc does not specify content type
- [CORE-2739] - --delimiter parameter in liquibase --help
- [CORE-2747] - CreateView / Oracle: Keyword REPLACE in view definition prohibits "or replace" in DDL statement
- [CORE-2772] - primaryKeyExists check fails on Turkish locale for some chars
- [CORE-2773] - DB2 AS/400 - generateChangeLog throwing Exception
- [CORE-2796] - Handle TimeStamps with nano second precision correctly
- [CORE-2797] - Determine the DB2 data server type correctly
- [CORE-2820] - Unsupported ReorganizeTable for DB2 z/OS causes changelog validation to fail
- [CORE-2821] - AddForeignKey statement generates incorrect SQL for DB2 z/OS
- [CORE-2826] - indexExists precondition fails on AS400 + JDBCDatabaseSnapshot/Snapshot generator code is not coded generically
- [CORE-2843] - Sql wrong lexical analysis for string literals - escaped single quotes are misparsed
- [CORE-2875] - UTF-8 character not understood
- [CORE-2894] - Oracle snapshot not detecting custom datatypes in different schemas
- [CORE-2909] - column remarks for mysql should be escaped
- [CORE-2911] - Oracle: generateChangeLog on RAW types not including the size param
- [CORE-2928] - Invalid snapshot of "duplicate" foreign keys
- [CORE-2929] - Views with definitions that start with a comment are not captured correctly in generateChangeLog
- [CORE-2940] - Do not print warning when DBA_RECYCLEBIN is not available
- [CORE-2944] - outputDefaultSchema and outputDefaultCatalog command line parameters not respected
- [CORE-2953] - update with valueSequenceNext and schema produces wrong SQL on oracle
- [CORE-2965] - Custom Properties XML Changelog
- [CORE-2992] - liquibase.util.grammar.TokenMgrError: Lexical error at line 1, column 71. Encountered: "\u00b4" (180), after : ""
- [CORE-2993] - createSequence with order denied on DB2
- [CORE-3002] - SQLAnywhere: Revert Unique Index failed
- [CORE-3006] - Oracle CSV-Import: "String index out of range: -1"
- [CORE-3009] - SQLAnywhere: Drop Default Value failed
- [CORE-3020] - No warning when included file doesn't exist (missing extension)
- [CORE-3033] - typo in postgresql reserverd word
- [CORE-3040] - onlyUpdate="true" flag generates empty statements for MySQL DB
- [CORE-3046] - Fix faulty snakeyaml class-path entry after upgrade to 1.17
- [CORE-3051] - SQLAnywhere: Drop Table does not support CASCADE
- [CORE-3054] - SQLAnywhere: java-coredump on changeSet-SQL
- [CORE-3055] - SQLAnywhere: supports Sequences
- [CORE-3063] - Integration tests failing on master
- [CORE-3069] - Checksum: line endings not standardized on windows if multiple lines
- [CORE-3072] - Add usePreparedStatements="true|false" flag to loadData
- [CORE-3076] - SUM is not reserved word for HsqlDB
- [CORE-3099] - Non English environment; invalid tablename and column name can be generated because of toUpperCase toLowerCase method which is dependent to locale in java
- [CORE-3101] - dropPrimaryKey TABLE_SCHEMA = 'null'
- [CORE-3106] - SQLAnywhere: DROP INDEX should use tablename
- [CORE-3115] - Prefix space in column type causing the Unknown LiquibaseDataType with the latest release
- [CORE-3117] - TIMESTAMP WITH TIME ZONE datatype is changed to TIMESTAMP in H2
- [CORE-3119] - Maven failing to use driverPropertiesFile from Liquibase Properties File
- [CORE-3135] - Column t1.tgconstrname does not exist
- [CORE-3138] - SQLAnywhere: AddAutoIncrement-Statement is wrong
- [CORE-3140] - MSSQL2005 doesn't support built-in function original_db_name()
- [CORE-3155] - CSV line content behind inline comment character doesn't contribute to checksum
- [CORE-3162] - Diff problem with MSSQL case sensitive database
- [CORE-3171] - LoadUpdateData doesn't work on SAP SQLAnywhere
- [CORE-3180] - A DBMS-specific change set referencing a DBMS-specific rollback can't be parsed on a different DBMS
- [CORE-2735] - Add possibility to test rollback with SpringLiquibase
- [CORE-1225] - Add support for tablespace assigned to liquibase metadata tables
- [CORE-2628] - defaultSchema parameter doesn't do Connection.setCatalog() for SpringLiquibase
- [CORE-2842] - MSSQL: Support creating clustered unique constraints
- [CORE-2891] - Liquibase "Command" objects can be extended and overridden
- [CORE-2919] - Make all variants of Liquibase.listUnrunChangeSets public
- [CORE-2952] - Use the clustered index if duplicate indexes are defined
- [CORE-2955] - MSSQL: Capture explicit null default values on snapshot and generate/diffChangeLog
- [CORE-2970] - MSSQL: Support default value constraint names
- [CORE-2977] - Generated primary key constraint name doesn't match Postgres default
- [CORE-2985] - MSSQL Snapshot performance improvements
- [CORE-3000] - Oracle JDBC batch for load_data
- [CORE-3005] - Consideration of DB2/400 system views
- [CORE-3017] - Add path attribute to createView
- [CORE-3018] - Oracle: support remarks on createView
- [CORE-3045] - Support indexes on views
- [CORE-3079] - Make includeObjects and excludeObjects affect which objects are snapshotted
- [CORE-3094] - HSQLDB UUID support
- [CORE-2920] - Using "//" as an endDelimiter stopped working 3.5.0
Changes in version 3.5.5 (2018.02.5)
- [CORE-2851] - includeAll tag with a relative path duplicates the database changes with an absolute and with a relative changelog
Changes in version 3.5.4 (2018.02.5)
- [CORE-2863] - Issue with Spring boot 1.4.0 - 1.4.3
- [CORE-2898] - includeAll broken in 3.5.1
- [CORE-2948] - Changelog with includeAll will not find child changelogs in Spring Boot's executable JAR
- [CORE-2978] - AddAutoIncrement on Postgres does not work when no schema is specified
- [CORE-3123] - ResourceComparator is not applied for includeAll
- [CORE-3139] - ClassLoaderResourceAccessor cannot read jar path resources from SpringLiquibase
- [CORE-3015] - Oracle: diffChangeLog TIMESTAMP WITH LOCAL TIME ZONE correctly
Changes in version 3.5.3 (2016.10.13)
- No changes
Changes in version 3.5.2 (2016.09.21)
- [CORE-1863] - PostgreSQL blob is mapped to bytea instead of oid
- [CORE-2693] - Postgresql dropAll with serial columns fails because tables are dropped then sequences which no longer exist
- [CORE-2698] - <sqlFile> Oracle scripts with ending / are not actually getting executed even with splitStatements="false"
- [CORE-2752] - Jtds has silent exceptions in db.getConnectionSchemaName
- [CORE-2753] - defaultValueSequenceNext forgets schema name
- [CORE-2754] - update table columns are not quoted when requested
- [CORE-2756] - Null pointer exception from FileSystemResourceAccessor
- [CORE-2757] - Databasechangelog ORDEREXECUTED and DEPLOYMENT_ID not updated when a changeSet is reran
- [CORE-2758] - Debian package shouldn't symlink liquibase binary to absolute path
- [CORE-2761] - 3.5.1: includeAll from the command line uses the absolute path as the changeSet path
- [CORE-2763] - Postgresql schemas should default to lower case
- [CORE-2765] - dbms in preConditions yaml changelog causes parsing error
- [CORE-2770] - Can't read remarks from mssql 2000
- [CORE-2774] - Can't read all columns from mssql2000
- [CORE-2775] - Oracle Sequences not Generated in generateChangeLog after 3.4.1
- [CORE-2778] - Sybase ASE: Incorrect syntax near the keyword 'ALTER'
- [CORE-2780] - java.sql.SQLException: PooledConnection has already been closed
- [CORE-2781] - DB2: custom-generated indexes for primary keys are not preserved in diff/generateChangeLog
- [CORE-2784] - REGRESSION: Column creation of type 'TIMESTAMP WITHOUT TIMEZONE' fails on PostgreSQL
- [CORE-2785] - Status command inconsistent with databasechangelog table
- [CORE-2786] - Incorrect xml scheme for changlog file
- [CORE-2787] - YAML Snapshot parser not handling strings that get stored as binary
- [CORE-2789] - Postgres does not have a type "BINARY"
- [CORE-2791] - Strip off trailing end delimiter in createProcedure on update, include on updateSql
- [CORE-2793] - using property as startWith attribute
- [CORE-2794] - Make CSV files created by Liquibase readable by Liquibase
- [CORE-2795] - Fix a NullPointerException in DiffToChangeLog.sortMissingObjects
- [CORE-2804] - defaultValueSequenceNext forgets schema name H2/PG/etc
- [CORE-2805] - Multiple calls to generateChecksum() impacting deploy performance
- [CORE-2806] - JsonSnapshotParser does not close stream after parsing
- [CORE-2807] - Column data type "real" incorrectly translated to "double precision" for PostgreSQL, should be "real"
- [CORE-2810] - defaultValueBoolean="false" generates wrong SQL for MySQL
- [CORE-2811] - FileSystemResourceAccessor basepath/includeAll
- [CORE-2813] - java.lang.NullPointerException when creating new ClassLoaderResourceAccessor();
- [CORE-2814] - DB2: Quoting strategy not respected, objects are always saved as upper case
- [CORE-2815] - Rollback by tag doesn't roll back tagDatabase changeSet
- [CORE-2816] - Snapshot error when snapshotting an index or primary key against a case-sensitive column
- [CORE-2818] - DEPLOYMENT_ID not created for Sybase in DATABASECHANGELOG, liquibase 3.5.1
- [CORE-2819] - AbstractJdbcData getConnectionSchemaName() methods fails for Sybase
- [CORE-2823] - DROP PRIMARY KEY fails for Sybase database update
- [CORE-2827] - MSSQL: misc default value fixes
- [CORE-2828] - MSSQL not capturing that primary key are non-clustered in generateChangeLog
- [CORE-2830] - GenerateChangeLog does not handle tables with compound primary keys
- [CORE-2831] - MySql BIT(1) defaultValue not snapshotted as Boolean
- [CORE-2835] - GenerateChangeLog doesn't correctly "numeric DEFAULT '" " columns
- [CORE-2836] - addAutoIncrement generates inconsistent sequence name for mixed-case table
- [CORE-2837] - addAutoIncrement doesn't apply default schema in nextval call (PostgreSQL)
- [CORE-2838] - createProcedure schema in the changelog is overwritten by defaultSchemaName
- [CORE-2840] - MSSQL createProcedure for CREATE MERGE AS procedures need a trailing semicolon
- [CORE-2843] - Sql wrong lexical analysis for string literals - escaped single quotes are misparsed
- [CORE-2846] - DATABASECHANGELOG table query failed on postgres on first run
- [CORE-2849] - Fail to execute with sequences
- [CORE-2853] - Diff comparisions reporting differences between '0.0' and '0' in decimals
- [CORE-2863] - Issue with Spring boot 1.4.0
- [CORE-2864] - Regression for defaultSchemaName on MSSQL
- [CORE-2867] - liquibase with MySQL raises exception "Table 'DATABASECHANGELOG' already exists" when using separate liquibase schema
- [CORE-2868] - <createProcedure> Adds schema/username to package and package body in oracle making them invalid
- [CORE-2869] - Without a specified classpath, using includeAll with relativeToChangelogFile="true" fails
- [CORE-2872] - "ON DELETE" not supported for FK constraints in Sybase
- [CORE-2876] - Issue with Spring boot 1.4.0 Repackaged
- [CORE-2878] - MSSQL setTableRemarks limited to 200 chars
- [CORE-2881] - DiffChangeLog unnecessarily includes referenceTableCatalogName attribute if comparing Schema with different names
- [CORE-2885] - AddColumn with defaultValueSequenceNext generated incorrect SQL for PostgreSQL
- [CORE-2788] - handle VARBINARY type in Oracle and H2
- [CORE-2800] - Add flag to diff command that suppresses reporting of column order difference in tables
- [CORE-1984] - Support for non-split rollback statements in Formatted SQL
- [CORE-2768] - Have the .deb and .rpm part of the release on github
- [CORE-2782] - Update SnakeYAML version to 1.17
- [CORE-2801] - Add method to Logger to allow closing of the output file stream
- [CORE-2844] - Traverse parent changelogs for rollbacks
- [CORE-2848] - Oracle: primary keys that use a pre-existing index drop the index along with the primary key on rollback
- [CORE-2852] - Postgresql snapshots not correctly handling serial-backing sequences
- [CORE-2857] - Support clustered primary keys in postgresql
- [CORE-2873] - Postgresql custom types are snapshotted as having length 2147483647
- [CORE-2874] - Ensure consistent charset encoding usage
Changes in version 3.5.1 (2016.05.10)
- [CORE-2727] - NPE in DiffToReport.print() method
- [CORE-2728] - Classloading broken in 3.5.0 with nested jars
- [CORE-2729] - NullPointerException on Diff
- [CORE-2731] - diff fails with NullPointerException
- [CORE-2732] - releaseLock fails because ObjectQuotingStrategy is reset to LEGACY
- [CORE-2733] - relativeToChangelogFile fails with FileSystemResourceAccessor
- [CORE-2734] - Liquibase no longer handle newline correctly in endDelimiter when using sqlFile change
- [CORE-2743] - CSV whitespace trimmed in 3.5.0
- [CORE-2744] - changeset with loadUpdateData changes checksum in 3.5.0
- [CORE-2745] - Performance degradation of sqlFile change
- [CORE-2746] - Oracle: handle case when schema name contains a hyphen
- [CORE-2750] - MSSQL catalog/database included all the time
Changes in version 3.5.0 (2016.04.21)
- New "created" attribute on changeSet
- New runOrder="first|last" attribute on changeSet to override where in the changelog it is ran
- New "context" attribute on <include> and <includeAll> to control when changelogs are included
- Support for AND/OR context expressions in formatted SQL changelogs
- Support for changelog parameters in formatted SQL chagnelogs
- Improved multi-schema snapshot and comparison
- Improved SQL parsing
- Performance improvements
- Lots of bug fixes
- [CORE-155] - Default-context attribute in databaseChangeLog tag
- [CORE-575] - foreign key constraint is generated with onUpdate and onDelete restrict
- [CORE-910] - Lock is not released if nocount is on for sql server 2008
- [CORE-1166] - Diff doesn't detect 'on delete cascade' statements
- [CORE-1447] - Inconsistent line endings in updateSQL produced files
- [CORE-1468] - Number / Numeric handling must differ between different database systems
- [CORE-1679] - Changelog SQL routines are partially aware of Database quoting strategy
- [CORE-1690] - OSGiPackageScanClassResolver does not search extensions in Fragment bundles
- [CORE-1836] - Oracle Integer mapping
- [CORE-1839] - H2 multicolumn unique constraints
- [CORE-1883] - Performance issue with large datamodels
- [CORE-1887] - Including the same ChangeSet twice causes ValidationFailedException
- [CORE-1897] - stripComments from SQL is trimming quoted string
- [CORE-1935] - Formatted SQL generateChangeLog failed
- [CORE-1966] - Invalid object name 'INFORMATION_SCHEMA.SEQUENCES' when running generateChangeLog with SQL Azure
- [CORE-1985] - constraints tag is missing referencedTableSchemaName
- [CORE-2024] - Move SDK to its own module
- [CORE-2056] - generateChangeLog generates too many 'constraints'
- [CORE-2059] - escapeObjectName has no respect for quotingStrategy QUOTE_ONLY_RESERVED_WORDS on Postgres
- [CORE-2184] - diff doesn't write correct Changesets for foreign key constraints with ON DELETE CASCADE
- [CORE-2211] - Liquibase tries to execute commented lines in custom SQL file
- [CORE-2213] - Liquibase does not support comments in a line after the semicolon
- [CORE-2333] - loadData fails with quoted string containing a comma
- [CORE-2376] - LiquibaseCatalogName in commandLine not working correctly
- [CORE-2438] - DeleteGenerator does not handle parameter names and values with $ or \ properly
- [CORE-2456] - includeObjects/excludeObjects not work for UniqueConstraint
- [CORE-2474] - dropFirst does not drop objects in not default schemas on Postgres 9+ using sql format with multiple schemas
- [CORE-2483] - Liquibase does not delete unzip directories from temporary directory
- [CORE-2501] - Derby sequenceCurrentValue Incorrect SQL
- [CORE-2502] - Handle single-tag <databaseChangeLog/> tag on diffChangeLog
- [CORE-2504] - NumberFormatException while checking precondition
- [CORE-2508] - GlobalConfiguration liquibase.should.run alias is incorrect
- [CORE-2512] - Both defautValueComputed and defaultValue included in addColumn diffChangeLog outputs if value is a computed value
- [CORE-2513] - DiffChangeLog fixing changed indexes misses "unique" attribute
- [CORE-2514] - bad Maven documentation for outputDefaultCatalog and outputDefaultSchema
- [CORE-2517] - Foreign key snapshot improvements for DB2
- [CORE-2518] - DB2: snapshot sees DATE types as TIMESTAMP
- [CORE-2520] - Spurious warning with includeAll: file is not a recognized file type
- [CORE-2521] - addAutoIncrement on Postgres generates invalid SQL when specific schema is used
- [CORE-2522] - Derby: support for findForeignKeyConstraints
- [CORE-2523] - H2: use "REAL" as datatype for "FLOAT"
- [CORE-2524] - MSSQL: need to escape default value constraint names
- [CORE-2525] - Error on dropping sequence
- [CORE-2526] - Oracle 12: TIMESTAMP(3) not handled
- [CORE-2528] - Oracle: improve unique constraint snapshot query performance
- [CORE-2529] - MSSQL auto_increment numeric is 1 smaller in generateChangeLog
- [CORE-2531] - Wrong type mapping of BINARY type in MySQL, H2, HSQLDB and Postgresql
- [CORE-2533] - Poor runtime performance
- [CORE-2538] - regenerate maven documentation for liqubase on website
- [CORE-2545] - MSSQL: createProcedure fails if replaceIfExists=true and body uses "create proc" rather than "create procedure"
- [CORE-2547] - liquibase.database.core.DB2Database - Improper Resource Shutdown or Release
- [CORE-2548] - primaryKeyTablespace is ignored in PostgreSQL
- [CORE-2550] - Proper handling BINARY type in MySQL and H2
- [CORE-2552] - Oracle performance: fetch view definition along with original view to reduce the number of needed queries
- [CORE-2553] - DB2: add ability to disable automatic reorg statements
- [CORE-2556] - Cannot execute update code including quoted strings containing semicolons
- [CORE-2558] - includeAll incorrectly sorting by including WEB-INF/classes when running in an ear
- [CORE-2561] - Add "cycle" attribute to alterSequence
- [CORE-2562] - MSSQL: Snapshot errors if table names have single quote marks in them
- [CORE-2563] - DiffChangeLog that adds columns does not preserve column order
- [CORE-2565] - Escaping of the sequence names with schema generates invalid statements for Oracle DB
- [CORE-2581] - mysql update emits incorrect sql for BIT(1) when default specified
- [CORE-2587] - Validation not performed before rollback
- [CORE-2591] - autoincrement problem with ORA 12c + COMPATIBLE param to 11
- [CORE-2595] - DefaultPackageScanClassResolver fails if "fat" jar has dirs and files with same name
- [CORE-2599] - generateChangelog produces incorrect values for binary type
- [CORE-2601] - ORDER keyword isn't escaped for Oracle
- [CORE-2602] - StackOverflowError generating snapshot
- [CORE-2604] - PostgreSQL datatype bit(n) column gives BOOLEAN(n) type for CreateTableChange genearated sql statement
- [CORE-2605] - addColumn with multiple columns, does not create the constraints
- [CORE-2606] - PostgreSQL : Table creation with datatype smallserial fails.
- [CORE-2609] - Liquibase command line fails when using JTDS driver with SSO
- [CORE-2611] - Sybase ASE generated table name is wrong. Roll back CORE-2447
- [CORE-2615] - Multi-schema snapshot bugfixes
- [CORE-2623] - Oracle: primary keys on tables recovered from recyclebin are not properly snapshotted
- [CORE-2624] - MSSQL: better support for user defined types
- [CORE-2625] - Diff: should not be case sensitive in column default value functions
- [CORE-2629] - SQL syntax doesn't allow commenting indepenrent parts.
- [CORE-2632] - Postgres index drop needs schema
- [CORE-2635] - Applied changeset not detected
- [CORE-2636] - includeAll uses full file path
- [CORE-2637] - Creating column with tinyint(1) instead created as default tinyint
- [CORE-2641] - runOnChange change set runs every time even if there wasn't changed
- [CORE-2642] - Xsd files are not resolved from classpath when resolving from resourceAccessor fails.
- [CORE-2643] - loadData
- [CORE-2645] - Rollback referencing a change set in current child file cannot be parsed
- [CORE-2653] - Liquibase show difference for some UniqueConstraint and Views in SQL SERVER databases but Actually there is NO difference when i compare the SQL scripts manually
- [CORE-2660] - Multiple contexts not recognized in formatted SQL when using AND
- [CORE-2662] - NumberFormatException with default values of type 'real' in postgresql
- [CORE-2663] - New MySQL 5.7.x reserved keywords are not being escaped
- [CORE-2664] - createChangeLog has incorrect nesting of constraints in YAML format
- [CORE-2666] - InsertSetGenerator hard-codes the InsertGenerator
- [CORE-2669] - Impossible to extend BaseLiquibaseTask in a non-deprecated way
- [CORE-2670] - Impossible to create table on mssql with remarks containing apostrophes
- [CORE-2671] - oracle timestamps with time zone
- [CORE-2672] - createSequence with order produces invalid statement on postgresql
- [CORE-2673] - includeAll relativeToChangelogFile doesn't work for FileSystemResourceAccessor
- [CORE-2674] - LoadUpdateData with onlyUpdate="true" generates invalid statements for Oracle DB
- [CORE-2677] - Dropping a postgres index fails
- [CORE-2679] - Hibernate diffChangeLog NullPointerException @ MissingPrimaryKeyChangeGenerator.fixMissing(MissingPrimaryKeyChangeGenerator.java:76)
- [CORE-2680] - Generating a futureRollbackSql when using "classpath:" prefix doesn't recognise any of the ran change sets.
- [CORE-2681] - H2 (automatic mixed mode): createTable: columns remarks ignored
- [CORE-2683] - dropAll dropping sequences that have been dropped via earlier cascade
- [CORE-2684] - Context is ignored with runOnChange and including file (sqlFile/loadUpdateData)
- [CORE-2686] - StandardChangeLogHistoryService.hasDatabaseChangeLogTable value is cached too aggressively
- [CORE-2687] - <sqlFile endDelimiter="go" if endDelimiter has whitespace in my sql it is not spliting
- [CORE-2688] - Loading data from csv with number of rows dividable by 51
- [CORE-2689] - TIMESTAMP parameters dropped for DB2
- [CORE-2690] - SetTableRemarksGenerator double escapes remark
- [CORE-2693] - Postgresql dropAll with serial columns fails because tables are dropped then sequences which no longer exist
- [CORE-2694] - "national character varying" type is not recognized
- [CORE-2698] - <sqlFile> Oracle scripts with ending / are not actually getting executed even with splitStatements="false"
- [CORE-2699] - concurrency causes NullPointerException in DatabaseObjectComparatorFactory.getInstance()
- [CORE-2705] - diffChangeLog generates dropColumn when dropping an index with a computed column
- [CORE-2706] - Two sides of equal are the same
- [CORE-2709] - endDelimiter regexp problem
- [CORE-2711] - Cannot load CSV via loadData
- [CORE-2713] - CreateView disregards replaceIfExists=true when fullDefinition=true
- [CORE-2715] - tableExists and columnExists preconditions fail on MySQL
- [CORE-2718] - H2 Database should query for default schema instead always use PUBLIC
- [CORE-2719] - Oracle: Cannot snapshot primary keys on lower-case tables
- [CORE-2720] - DB2: Capture full view definition in snapshot/generateChangeLog to support column options
- [CORE-2721] - endDelimiter regex does not work in SQL changelogs/changesets
- [CORE-2725] - DB2: Don't include system-generated indexes
- [CORE-521] - Handle Timestamp with Time Zone types where supported
- [CORE-2448] - New "created" attribute on changeSet
- [CORE-2478] - Liquibase dropAll command line does not allow dropping multiple schemas
- [CORE-2540] - Allow vendor independent SEQUENCE definition
- [CORE-2541] - Add support for registering a Change Exec Listener on command line
- [CORE-2560] - Add new runOrder="first|last" attribute to control when a changeSet is ran
- [CORE-2577] - Add resourceComparator attribute to includeAll to override sorting
- [CORE-2578] - Added addUniqueConstraint deferrable"support for Postgresql
- [CORE-449] - Same changeLog can be included multiple times
- [CORE-1969] - Support for AND/OR context expressions in formatted sql
- [CORE-2100] - formatted sql validCheckSum
- [CORE-2115] - Really slow when using fat jars
- [CORE-2225] - please add the OLD check sum to the validation error message
- [CORE-2336] - Use a grammer for parsing SQL rather than regexps
- [CORE-2419] - Support fluent/builder-style change properties
- [CORE-2455] - Improve messages in databasechangelog.description column
- [CORE-2463] - Don't include liquibase tables in dbdoc
- [CORE-2493] - ExecuteShellCommand improvements
- [CORE-2497] - Support setColumnRemarks and setTableRemarks on MSSQL
- [CORE-2499] - Support for commenting lines in csv files
- [CORE-2539] - Ensure each data row in CSV has same # cols as header
- [CORE-2584] - ValidCheckSum is valid for both stored database values and current changeSet checksum
- [CORE-2589] - Output xml changelogs as xml version="1.1"
- [CORE-2612] - Oracle: include BYTE in CHAR and VARCHAR types from snapshot/generateChangeLog
- [CORE-2619] - Make changeLogFile optional for changeSetExecuted
- [CORE-2622] - Maven: Support ISO date syntax for rollback
- [CORE-2626] - Use schemaName in createProcedure
- [CORE-2638] - GenerateChangeLog should include replaceIfExists=true for changed views
- [CORE-2640] - Better handling of replaceIfExists in createProcedure
- [CORE-2651] - Derby: Default unknown version to 10.6 to support sequences
- [CORE-2652] - Formatted sql precondition not expanding changelog parameters
- [CORE-2657] - Add new DATABASECHANGELOG.DEPLOYMENT_ID column to track changeSets deployed together
- [CORE-2658] - Move the liquibase-debian module to a separate profile
- [CORE-2703] - MySQL NCLOB should conver to LONGTEXT CHARACTER SET utf8
- [CORE-2724] - Support offline databases in ant-tasks
Changes in version 3.4.2 (2015.11.24)
- [CORE-2328] - AbstractExecutor should implement execute(Change)
- [CORE-2475] - Informix: Insert valueComputed not used correctly
- [CORE-2543] - Improved support for time stamps in oracle insert change data types
- [CORE-1778] - createSequence doesn't work on MSSQL
- [CORE-1840] - Liquibase fails when run on a computer that can't connect to the internet
- [CORE-2273] - Oracle char column snapshot not differentiating between a default value of 0 and '0'
- [CORE-2285] - Code in Liquibase class inconsistent
- [CORE-2317] - Custom ConfigurationValueProvider not working
- [CORE-2349] - loadUpdateData does not escape column names in "ON DUPLICATE" clause
- [CORE-2407] - Derby keywords not escaped when used as column/table names
- [CORE-2447] - In sybase, schema is bad preixed
- [CORE-2466] - Rollback referencing a change set in another file cannot be parsed
- [CORE-2467] - SSO with jtds MSSQL doesn't work after 3.3.5 for update - null user error
- [CORE-2469] - Error in method ColumnConfig.setValueNumeric(String)
- [CORE-2470] - MSSQL: FindForeignKeyConstraintsGeneratorMSSQL doesn't honor specified schema
- [CORE-2480] - Primary key exist works fine with 3.3.3 not with 3.4.0 in SQL SERVER
- [CORE-2481] - Primary key creation issue with informix
- [CORE-2482] - Number type issue with informix
- [CORE-2484] - dropAll command crashes because it drops sequences before tables
- [CORE-2487] - updateSql does not output anything for prepared statements
- [CORE-2490] - If you have more than one :name token in the where clause of a delete change, you get an Exception
- [CORE-2491] - Shouldn't a custom change produce a warning if run in updateSql mode
- [CORE-2492] - Logger extension liquibase-slf4j no longer usable with 3.4.1
- [CORE-2494] - Pgsql: Exporting/generating badly formatted SQL
- [CORE-2498] - Generation of TIMESTAMP(29) causing error in PSQL log TIMESTAMP(6) WITHOUT TIME ZONE
- [CORE-2500] - Fast check of ColumnExistsPrecondition causing transaction abort on PostgreSQL database
- [CORE-2505] - Missing keywords for H2 database
- [CORE-2510] - loadData on MySQL with > 50 rows fails
- [CORE-2544] - LogFactory does not get reset
- [CORE-2549] - Performance regression in resolving local host
- [CORE-2554] - updateSql command fails on validation when upgrading (2.0.5 ->3.4.1)
- [CORE-2566] - Maven - setting skip= true does not work
- [CORE-2571] - primaryKeyExists precondition generating wrong query
- [CORE-2576] - The 'dbms' attribute on <createProcedure> is not not taken into account when parsing changes
- [CORE-2579] - dropAll failed for Oracle 12c
- [CORE-2580] - Escape column, table and schema on ColumnExistsPrecondition
- [CORE-2588] - Bad cast
- [CORE-2590] - Default constraint names are not quoted
- [CORE-2596] - DatabaseChangeLogLock race condition exists if two nodes both try to create the table
- [CORE-2598] - Postgres generateChangeLog: "length for type varchar cannot exceed 10485760"
Changes in version 3.4.1 (2015.07.28)
- [CORE-998] - Changing index columns leads to wrong output order in the change log xml file.
- [CORE-2104] - ConcurrentModificationException iterating over System.getProperties().entrySet()
- [CORE-2385] - IncludeAll does not work when runing liquibase from inside a jar
- [CORE-2405] - Collation not preserved, depending on configuration
- [CORE-2406] - Escaped built-in data types should be lower case
- [CORE-2408] - Unknown column 'LABELS' in 'field list'
- [CORE-2410] - Snapshot should not include paramaters for MSSQL geometry, geography or sql_variant types
- [CORE-2411] - BLOB string default values not quoted
- [CORE-2412] - Handle Oracle BFILE types
- [CORE-2414] - CLONE - generateChangeLog creates DOUBLE(22) instead of double in MySql
- [CORE-2415] - Custom Logger configuration does not work anymore
- [CORE-2416] - Diff drops and creates primary keys for all tables
- [CORE-2418] - Liquibase 3.4.0 tries to do INSERT instead of UPDATE-Statements with Postgres
- [CORE-2421] - MySQL column sizes are off by 1 in BIGINT and INT for diffChangeLog
- [CORE-2422] - Liquibase intialisation failed
- [CORE-2423] - Sybase IQ : strange procedure called
- [CORE-2426] - Default schema name missing quotes.
- [CORE-2427] - Better handle MSSQL stored procedures with a different defaultSchema and replaceOnExists=true
- [CORE-2428] - liquibase 2.0.3 to 3.3.3
- [CORE-2435] - includeSystemClasspath switch actually includes SystemClassLoader if false
- [CORE-2436] - Logging in ClassLoaderResourceAccessor prevents installation of custom Logger
- [CORE-2437] - Index.toString() contains "unique" if and only if index is NOT unique
- [CORE-2438] - DeleteGenerator does not handle parameter names and values with $ or \ properly
- [CORE-2440] - Not possible to override DefaultLogger using a Logger in a non-liquibase package.
- [CORE-2441] - Creation of foreign key fails in MySQL if database name contains dashes
- [CORE-2442] - Creating MD5 checksum fails if changeSet id contains the character "?"
- [CORE-2443] - Liquibase 3.4.0 ignores third party loggers in certain situations
- [CORE-2446] - endDelimiter splitting does not work in plain SQL files (regression)
- [CORE-2452] - Index names should be quoted on SQL Server
- [CORE-2458] - loadUpdateData will not update
- [CORE-2460] - Postgres index names cannot include schema name
- [CORE-2433] - quoting error in table creation
- [CORE-2359] - Consistently read dataTypeId for all databases
- [CORE-2419] - Support fluent/builder-style change properties
- [CORE-2449] - Correctly detect "Sybase IQ"
- [CORE-2450] - Non-bash /bin/sh gives "[[ not found" error
- [CORE-2451] - SQL scripts should have "USE <database>" in the header on SQL Server
- [CORE-2453] - Informix: Return null for connection schema name
- [CORE-2459] - Un-change Formatted SQL stripComments default back to true
- [CORE-2461] - Don't do DATABASECHANGELOG ALTER statements if column types are different
Changes in version 3.4.0 (2015.06.24)
- [CORE-14] - Dropping default values with MS-SQL
- [CORE-822] - Add a tag to add/update table/column remarks
- [CORE-864] - loaddata performance enhancement
- [CORE-1411] - MariaDB support
- [CORE-2254] - Ability to save snapshot for later comparison
- [CORE-2257] - Ability to use a previously saved database snapshot in diff and generateChangeLog
- [CORE-2302] - Add ability to load nested object/collection properties and BigDecimal properties automatically
- [CORE-2306] - Support passing in a script for rollback to override rollback logic included in the changelog
- [CORE-2308] - Track changeSet contexts and labels in databasechangelog table
- [CORE-2345] - Add XML Type
- [CORE-419] - Allowing ASC and DESC in index definitions
- [CORE-562] - Allow naming of not null constraints
- [CORE-715] - indexExists does a full snapshot
- [CORE-1731] - Support autoincrement in oracle 12c
- [CORE-2124] - Ability to pass properties to a JDBC driver required
- [CORE-2132] - Error message for missing sqlFile reference should be more descriptive
- [CORE-2147] - HsqlDatabase should emit uppercase names when quoting reserved words to preserve case insensitivity
- [CORE-2171] - New ChangeExecListener.runFailed method
- [CORE-2177] - Support NOT(X) syntax for labels
- [CORE-2185] - Few fields needs to be changed as protected and need additional field in RanChangeSet
- [CORE-2217] - Add DataTypeFactory support for delimited data type names, improve resolution of MSSQL data types
- [CORE-2228] - New usingIndexName attribute on addPrimaryKey
- [CORE-2236] - Support .yml extension in YamlChangeLogSerializer
- [CORE-2244] - Handle generating SQL Server DDL where ANSI NULL Default is false
- [CORE-2249] - Index and UniqueConstraint equivalence check should take name into account
- [CORE-2288] - Do not check/updatedatabasechangelog table on status
- [CORE-2292] - New tagExists command for command line
- [CORE-2298] - Allow HSQL to use defaultValueComputed for certain allowed functions on datetime type columns
- [CORE-2299] - Add capability to ignore missing or empty folder with includeAll
- [CORE-2307] - ChangeLog table name option in command line tool
- [CORE-2309] - global/local properties on changesets
- [CORE-2320] - MinGW (Git Bash) support for shell
- [CORE-2334] - Disable CREATE TABLE DATABASECHANGELOG generation when running on OfflineConnection
- [CORE-2336] - Use a grammer for parsing SQL rather than regexps
- [CORE-2358] - Improve data types for Liquibase tables in MSSQL
- [CORE-2359] - Consistently read dataTypeId for all databases
- [CORE-2363] - Improve robustness of MSSQL database case-insensitivity check
- [CORE-2371] - Improve Oracle snapshot performance
- [CORE-2386] - Set the connection default catalog/schema if defaultCatalogName or defaultSchemaName is set
- [CORE-2397] - MSSQL View Snapshot should not use sp_helptext
- [CORE-2399] - DBDoc improvements
- [CORE-2404] - Ability to preserve TEXT type in mssql snapshot and update
- [CORE-842] - Tag database not taking orderexecuted into account
- [CORE-1296] - drop column on ms sql server
- [CORE-1424] - SQL Generation ignores DATETIME parameters
- [CORE-1542] - Sequence is dropped not until a second run of dropAllDatabaseObjects on PostgreSQL
- [CORE-1738] - loadData from csv fails for boolean column (if another column present)
- [CORE-1749] - Update change command does not respect whereParams
- [CORE-1803] - DropAll doesn't delete sequences if they are used as default value in postgres
- [CORE-1904] - Slow indexExists performance in Oracle
- [CORE-1924] - SQLServer diff - DATETIME2 not being handled correctly
- [CORE-2005] - /usr/bin/liquibase: Syntax error: "else" unexpected
- [CORE-2018] - Quotes stripped from index filter_conditions on snapshot
- [CORE-2019] - Comments in empty rollback prevent execution
- [CORE-2041] - Escaping of reserved keywords in HSQLDB
- [CORE-2096] - DiffChangeLog with changed indexes generates drop/add in the wrong order
- [CORE-2109] - dropAll fails for statements the database requires to run non-transactionally
- [CORE-2113] - Informix text datatype fixes
- [CORE-2133] - Oracle: GenerateChangeLog of a table with DEFAULT VALUE NULL creates defaultValueComputed="NULL"
- [CORE-2167] - Issues with generateChangeLog of unique constraints on DB2
- [CORE-2169] - offline mode seems non-deterministic
- [CORE-2178] - Fatal exception acquiring lock in SQL Server databases with case-sensitive collation
- [CORE-2196] - Ant: "Unable to update database." without explanation
- [CORE-2209] - Oracle snapshot sometimes creates "GENERATED ALWAYS AS (null)"
- [CORE-2211] - Liquibase tries to execute commented lines in custom SQL file
- [CORE-2219] - DB2 for zOs - adding primary key always emits REORG but REORG does not exist on Db2 for zOs
- [CORE-2222] - TIMESTAMP parameters dropped for PostgreSQL
- [CORE-2224] - Index uniqueness is not always recognized correctly
- [CORE-2227] - CLONE - UpdateSQL needs to append a "/" to the end of createProcedure for Oracle
- [CORE-2232] - Support schema other than public on PostgreSQL
- [CORE-2233] - Oracle Timestamp precision lost in generateChangeLog
- [CORE-2234] - columnExists precondition could be much faster (Oracle, mssql)
- [CORE-2237] - YamlChangeLogSerializer does not correctly serialize a changeset
- [CORE-2251] - Adding column with type DATETIME doesn't work for PostgreSQL
- [CORE-2252] - XMLChangeLogSerializer writes array object for rollback tag content
- [CORE-2253] - Handle oracle varchar <-> clob conversions in diffChangeLog
- [CORE-2256] - Drop Sequences before Tables
- [CORE-2266] - DiffChangeLog: Invalid changelog when a primary key backing index is changed
- [CORE-2267] - Rollback fails for mixed-case objects created with QUOTE_ALL_OBJECTS
- [CORE-2270] - Doubledash inside quoted text causes parsing error
- [CORE-2271] - CLONE - DiffChangeLog: Invalid changelog when a unique constraint backing index is changed
- [CORE-2272] - DiffChangeLog must drop foreign keys before primary keys
- [CORE-2273] - Oracle char column snapshot not differentiating between a default value of 0 and '0'
- [CORE-2275] - YAML update fails with Unexpected error running Liquibase: java.util.LinkedHashMap cannot be cast to java.util.List
- [CORE-2281] - Oracle snapshot performance issue with many multiple views
- [CORE-2291] - ObjectQuotingStrategy not reset correctly after changeSet
- [CORE-2295] - includeAll tries to load all files instead only *.xml
- [CORE-2300] - Unsigned Int / Bigint cannot be created
- [CORE-2305] - Snapshot output too verbose
- [CORE-2316] - Data type registry occasionally returns wrong data type implementation
- [CORE-2321] - Liquibase tag command tags too much
- [CORE-2324] - diffChangeLog does not handle changes in sequence incrementBy, maxValue or ordered
- [CORE-2331] - Support for MSSQL collation in data type description broken
- [CORE-2340] - Add support for extensions to override the built-in change log, snapshot serializers
- [CORE-2355] - Improve updateSQL performance
- [CORE-2361] - preConditions, rollback, property, include, includeAll cannot be serialized
- [CORE-2373] - Local DTD files not found in subdirectory
- [CORE-2378] - Adding a new "CustomChange" triggers ClassNotFoundException
- [CORE-2380] - Support reading of gzip files
- [CORE-2381] - Fix unique constraint generator for informix
- [CORE-2383] - Change formatted SQL stripComments default from "true" to "false"
- [CORE-2385] - IncludeAll does not work when runing liquibase from inside a jar
- [CORE-2387] - dropPrimaryKey without constraint name on sql server doesn't query schema correctly
- [CORE-2388] - Views not equal in different schemas
- [CORE-2390] - NullPointerException when generating changelog
- [CORE-2391] - column type doesn't respect unsigned
- [CORE-2393] - changeSet contexts created with maven generateChangeLog are in parentheses
- [CORE-2401] - MSSQL handling timestamp according to sql standard, not sqlserver usage
- [CORE-2402] - Oracle NCLOB defaultValues not read correctly
Changes in version 3.3.5 (2015.05.28)
- [CORE-2379] - Project.version set to 3.3.4-SNAPSHOT in 3.3.4 final
Changes in version 3.3.4 (2015.05.27)
- [CORE-2360] - Maven - Skip is active by default
- [CORE-2199] - Liquibase adds a semicolon after a stored proc definition making the stored proc unusable
- [CORE-2344] - Unknown host exception on OS RHEL 6.5
- [CORE-2346] - IncludeAll does not work when runing liquibase from inside a jar
- [CORE-2357] - alterSequence does not work as expected when you need to change the cache size
- [CORE-2366] - Derby Network server works with command line but not with maven "Liquibase skipped due to maven configuration"
- [CORE-2368] - No SQL outputted for <update> change
Changes in version 3.3.3 (2015.04.28)
- [CORE-1768] - Oracle dropAll fails on spatial tables and sequences
- [CORE-1840] - Liquibase fails when run on a computer that can't connect to the internet
- [CORE-1857] - Wrong column size detection on varchar2 fields with char as datatype
- [CORE-1866] - Filtering changelog list by includeAll tag is not working
- [CORE-1943] - Handle Error: InetAddress.getLocalHost().getHostName() UnknownHostException results in NoClassDefFoundError
- [CORE-1958] - Column type of "TIMESTAMP(6)" under MySql converted to TIMESTAMP dropping fractional seconds
- [CORE-1967] - includeAll uses full file path for sql changelogs
- [CORE-2023] - Problem using includeAll with SpringLiquibase
- [CORE-2126] - Postgres 9.3 - Drop table With Cascade - Not Supported
- [CORE-2156] - Resource loader can't load changelog file
- [CORE-2186] - AbstractResourceAccessor#convertToPath(String, String) fails for processing includeAll from Classpath
- [CORE-2192] - NoSuchMethodException when generating offline Oracle migration script
- [CORE-2199] - Liquibase adds a semicolon after a stored proc definition making the stored proc unusable
- [CORE-2202] - liquibase.should.run inverted boolean
- [CORE-2204] - valueNumeric not being set when using prepared statements
- [CORE-2206] - diffChangeLog with JPA-annotated entities causes ConcurrentModificationException
- [CORE-2208] - Typo in message
- [CORE-2210] - java.lang.NullPointerException when file is empty
- [CORE-2214] - When inserting string value starting and ending with apostrophes (quotes) the value is not quoted in the generated SQL
- [CORE-2218] - Regression on modifyDataType : VARCHAR2 was supported on 3.2...and fails on 3.3