forked from liquibase/liquibase
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathchangelog.txt
5065 lines (4425 loc) · 366 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
===========================================
### Liquibase 4.30.0 is a major release
> [!IMPORTANT]
> Liquibase 4.30.0 contains new capabilities and notable enhancements for Liquibase OSS and Pro users including Anonymous Analytics and deprecation of the MacOS dmg installer.
> [!NOTE]
> See the [Liquibase 4.30.0 Release Notes](https://docs.liquibase.com/start/release-notes/liquibase-release-notes/liquibase-4.30.0.html) for the complete set of release information.
## Notable Changes
### [PRO]
#### Anonymous Analytics:
* Liquibase can now gather anonymous usage analytics when commands are run. No user-specific data will be gathered.
For Liquibase OSS users, this functionality is enabled by default, but can be opted-out of before any data is sent. For Liquibase Pro users, this is disabled by default with the ability to opt-in.
Gathering anonymous usage analytics allows us to better understand how Liquibase is actually being used by a very wide, diverse set of millions of users.
* Learn more https://docs.liquibase.com/analytics
#### Flow Enhancements: Detect pending changesets, and variable-variables
* There are two exciting Flow enhancements: the ability to condition action on presence of pending changesets, and the ability to use a global variable inside other global or stage variables, enabling variable-variables within flows.
* Learn more https://docs.liquibase.com/flow
### [OSS]
#### Deprecated: MacOS .dmg installer
* The MacOS dmg installer no longer ships with release artifacts. Please use the tar.gz or .zip release artifacts, or install via homebrew by running brew install liquibase
### [PRO] Changelog
## New Features
* DAT-18202 Implement wildcard check name argument for enable/disable in https://github.com/liquibase/liquibase-pro/pull/2000 by @wwillard7800
* DAT-17058: Add analytics in https://github.com/liquibase/liquibase-pro/pull/1995 by @liquibot
* DAT-17568 Added exit command action in https://github.com/liquibase/liquibase-pro/pull/1689 by @wwillard7800
* DAT-18689: Add extra information to failed changesets summary in https://github.com/liquibase/liquibase-pro/pull/1996 by @filipelautert
* DAT-18114 Added more logging for formatted SQL parsing in https://github.com/liquibase/liquibase-pro/pull/1994 by @wwillard7800
* DAT-18455 Add SQL file path to policy checks output in https://github.com/liquibase/liquibase-pro/pull/1944 by @wwillard7800
## Changes
* DAT-17581 Exit with a non-zero if the changelog did not validate in https://github.com/liquibase/liquibase-pro/pull/1870 by @wwillard7800
* DAT-18540 Create new ReportWriter.open(String path) method that default to no-op in https://github.com/liquibase/liquibase-pro/pull/1962 by @wwillard7800
* DAT-18092: Use xdg-open to open reports in browser on linux operating systems in https://github.com/liquibase/liquibase-pro/pull/1948 by @abrackx
* DAT-18531 Clear out DBCL fast check cache before each Flow action in https://github.com/liquibase/liquibase-pro/pull/1933 by @wwillard7800
* DAT-18362 Handle comments when parsing include/includeAll statements in https://github.com/liquibase/liquibase-pro/pull/1959 by @wwillard7800
* DAT-18463 Implement a class to be used to capture the start/end positions of a regex check for line number output in https://github.com/liquibase/liquibase-pro/pull/1979 by @wwillard7800
* DAT-18869: Obfuscate IO arguments in https://github.com/liquibase/liquibase-pro/pull/1999 by @abrackx
## [PRO] Bug Fixes
* DAT-18819: Fix dropall behavior with snowflake in https://github.com/liquibase/liquibase-pro/pull/1987 by @abrackx
* DAT-18517 Handle expansion of variables when default values are involved in https://github.com/liquibase/liquibase-pro/pull/1969 by @wwillard7800
* DAT-18327: improve startup performance in https://github.com/liquibase/liquibase-pro/pull/1972 by @StevenMassaro
* Fix tests to use new CommandFactory.reset() method in https://github.com/liquibase/liquibase-pro/pull/1952 by @wwillard7800
## [PRO] Security, Driver and Other Updates
(#1973) Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.17.2 to 2.18.0 by dependabot
(#1974) Bump com.fasterxml.jackson.core:jackson-annotations from 2.17.2 to 2.18.0 by dependabot
(#1976) Bump com.fasterxml.jackson.core:jackson-databind from 2.17.2 to 2.18.0 by dependabot
(#1975) Bump com.fasterxml.jackson.core:jackson-core from 2.17.2 to 2.18.0 by dependabot
(#1988) Bump org.apache.maven.plugins:maven-failsafe-plugin from 2.22.2 to 3.5.1 by dependabot
(#1991) Bump org.apache.maven.plugins:maven-surefire-plugin from 2.22.2 to 3.5.1 by dependabot
(#2003) Bump org.junit.vintage:junit-vintage-engine from 5.10.3 to 5.11.3 by dependabot
(#2002) Bump org.junit:junit-bom from 5.10.3 to 5.11.3 by dependabot
(#1963) Bump com.networknt:json-schema-validator from 1.5.0 to 1.5.2 by dependabot
(#1947) Bump org.yaml:snakeyaml from 2.2 to 2.3 by dependabot
(#1984) Bump org.codehaus.gmavenplus:gmavenplus-plugin from 1.13.1 to 4.0.1 by dependabot
(#2005) Bump org.nanohttpd:nanohttpd from 2.2.0 to 2.3.1 by dependabot
### [OSS] Changelog
## New Features
- (#6414) When using `failOnError=false`, changesets that failed will now show up in the default output. Thanks, @filipelautert
- (#6413) Ensure all failed changesets show in the exceptionChangesets. Previously, output summaries did not include changesets that failed when running `failOnError=false` (DAT-18689). Thanks, @filipelautert
- (#6169) When using STRICT mode, `update-to-tag` will now throw an error when there is no tag specified or the tag specified does not exist. Thanks, @MalloD12
- (#6410) Modified `clob` handling in `loadData` by checking the string passed to a CLOB type column. Thanks, @tati-qalified
- (#6067) Added additional modes for `duplicateFileMode`. Thanks, @k4pran
- (#6432) Added a `Customizer` that allows discovery of changesets that are not known to an application. This can be used to prevent an application's startup when discovering new, unexpected changesets before an update is made. Thanks, @raphw
- (#6288) Avoid ignoring caught exceptions, and instead return the exception and append the reason for better debugging. Thanks, @asolntsev
- (#6265) Enhanced `include` and `includeAll` to support `logicalFilePath` (DAT-18350). Thanks, @wwillard7800
- (#6300) Added method to reset command definitions cache in CommandFactory for testing. Thanks, @wwillard7800
- (#6280) Undeprecated StringUtil class (DAT-18538). Thanks, @MalloD12
- (#5223) Improved empty check style by using `isEmpty` String method. Thanks, @MalloD12
- (#6294) Suppress UnsupportedClassVersionErrors for Bigquery at info level (DAT-18534). Thanks, @filipelautert
- (#6263) Fix generated column value for Databricks (DAT-18148). Thanks, @filipelautert
- (#6129) Support Hashicorp Vault settings in the Maven Plugin POM. Thanks, @wwillard7800
- (#6138) Added support for `include` columns in indexes. Thanks, @stephenatwell
- (#6402) Added `pg_stat_statements` and `pg_stat_statements_info` views to the list of system tables and views to prevent them from being dropped. Thank you, @rozenshteyn
- (#6211) Updated PostgreSQL database major and minor versions. Thanks, @MalloD12
## Bug Fixes
- (#6266) Fix CustomTaskRollback rollback bug where it was being called twice. Thanks, @momosetkn
- (#6205) Removed usage of the deprecated isEmpty() method. Thanks, @anton-erofeev
- (#6366) Improve startup performance (DAT-18327). Thanks, @StevenMassaro
- (#6407) Added filterable flag to ChangeLogParameter class (DAT-18811). Thanks, @abrackx
- (#6416) When determining the schema name make sure a value was found (DAT-18673). Thanks, @abrackx
- (#6418) Fix issue where context filters with `@` symbols were not being executed properly (DAT-18843). Thanks, @abrackx
- (#6406) Test assertion code modification. (DAT-17568). Thanks, @wwillard7800
- (#6429) Check that getPriority method is correct for snapshot generators (DAT-18730). Thanks, @StevenMassaro
- (#6417) Revert "Remove unneeded inclusion of commons-io in liquibase-core pom.xml". Thanks, @catull
- (#6385) Do not check for nested database objects when using foreignKeyConstraintExists precondition (DAT-18624). Thanks, @abrackx
- (#5894) Do not strip "classpath:" when normalizing the path. Thanks, @andrus
- (#6359) Fix issue where change set with blank ID was allowed to run (DAT-18687). Thanks, @wwillard7800
- (#6109) Fix classpath loading and incorrect configuration for addForeignKeyConstraint (DAT-18191 and DAT-18192). Thanks, @filipelautert
- (#6287) Fix NPE when default value is null. Thanks, @asolntsev
- (#6330) Unhide tag parameter for UpdateTestingRollback command (DAT-18563). Thanks, @MalloD12
- (#6375) Initialize member variable in method to fix tests. Thanks, @wwillard7800
- (#6358) Make global argument definitions static so that they are visible across all threads. Thanks, @StevenMassaro
- (#6309) Fix Locale test. Thanks, @filipelautert
- (#6463) Fix flakey test (DAT-18921). Thanks, @abrackx
- (#6165) fix splitting SQL statements containing @begin or #begin. Thanks, @chrstnbrn
- (#4668) Expanded variables in the `--sql` argument to `executeSql` so that variables can be substituted in `execute-sql --sql-file` command. Thanks, @wwillard7800
- (#6222) Fix: Handle command arguments static behavior. Thanks, @filipelautert
- (#6286) Append the cause of the problem to thrown exception for better debugging. Thanks, @asolntsev
- (#6187) Update JdbcDatabaseSnapshot.java. Thanks, @bmoers
- (#6409) Added more logging (DAT-18114). Thanks, @wwillard7800
- (#6241) Verify existence of the lock table to remove 'table does not exist' error messages. Thanks, @wwillard7800
- (#6339) Added filter to the command scope so include/excludeObjects parameters get properly applied. Thanks, @Evan-Christensen!
- (#6332) Updated project variables used in Maven configuration to reduce build warnings. Thanks, @catull!
- (#6128) 'MANUAL' MySQL reserved word added. Thanks, @MalloD12
- (#6305) Allow generateChangelog to run against Oracle databases with blank schema names (DAT-18199). Thanks, @wwillard7800
- (#6350) allow replaceIfExists in Postgres procedures (DAT-18495). Thanks, @StevenMassaro
- (#6341) Fix sqlite hsqldb and environment variable tests (DAT-18646). Thanks, @abrackx
- (#6391) Handle Snowflake add NOT NULL constraint (DAT-18798). Thanks, @wwillard7800
- (#6308) Handle offline connection for Snowflake during diff (DAT-18652). Thanks, @wwillard7800
- (#6345) When using default schema for MultiTenantSpringLiquibase the log level is now info instead of warning. Thanks, @deblockt
- (#6261) Fix: do not throw an unchecked exception for SpringBoot. Thanks, @filipelautert
## Security, Driver and Other Updates
- (#6457) Update jreBundle to latest in install4j @abrackx
- (#6377) Bump org.testcontainers:testcontainers-bom from 1.20.1 to 1.20.2 @dependabot
- (#6443) Bump org.junit.platform:junit-platform-suite from 1.11.0 to 1.11.3 @dependabot
- (#6384) Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.10.0 to 3.10.1 @dependabot
- (#6387) Bump org.codehaus.gmavenplus:gmavenplus-plugin from 3.0.2 to 4.0.1 @dependabot
- (#6400) Bump org.apache.maven.plugins:maven-surefire-plugin from 3.5.0 to 3.5.1 @dependabot
- (#6445) Bump org.junit.jupiter:junit-jupiter from 5.11.0 to 5.11.3 @dependabot
- (#6408) Bump actions/cache from 4.0.2 to 4.1.1 @dependabot
- (#6444) Bump junit-jupiter.version from 5.11.0 to 5.11.3 @dependabot
- (#6401) Bump org.apache.maven.plugins:maven-failsafe-plugin from 3.5.0 to 3.5.1 @dependabot
- (#6399) Bump codex-/return-dispatch from 1 to 2 @dependabot
- (#6368) Bump org.xerial:sqlite-jdbc from 3.46.1.0 to 3.46.1.3 @dependabot
- (#6319) Bump groovy.version from 4.0.22 to 4.0.23 @dependabot
- (#6337) Bump commons-io:commons-io from 2.16.1 to 2.17.0 @dependabot
- (#6290) Bump org.yaml:snakeyaml from 2.2 to 2.3 @dependabot
- (#6274) Bump org.jboss.weld.se:weld-se-core from 5.1.2.Final to 5.1.3.Final @dependabot
- (#6276) Bump org.apache.maven.plugins:maven-surefire-plugin from 3.3.1 to 3.5.0 @dependabot
- (#6275) Bump org.apache.maven.plugins:maven-failsafe-plugin from 3.3.1 to 3.5.0 @dependabot
- (#6273) Bump org.apache.maven.plugins:maven-plugin-plugin from 3.13.1 to 3.15.0 @dependabot
- (#6284) Bump actions/setup-python from 5.1.1 to 5.2.0 @dependabot
- (#6282) Bump ant.version from 1.10.14 to 1.10.15 @dependabot
- (#6283) Bump org.apache.commons:commons-lang3 from 3.16.0 to 3.17.0 @dependabot
- (#6272) Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.8.0 to 3.10.0 @dependabot
- (#6247) Bump com.microsoft.sqlserver:mssql-jdbc from 12.6.1.jre8 to 12.8.1.jre8 @dependabot
- (#6246) Bump org.postgresql:postgresql from 42.7.3 to 42.7.4 @dependabot
- (#6221) Bump org.xerial:sqlite-jdbc from 3.46.0.0 to 3.46.1.0 @dependabot
- (#6220) Bump org.apache.maven.plugins:maven-install-plugin from 3.1.2 to 3.1.3 @dependabot
- (#6219) Bump org.apache.maven.plugins:maven-deploy-plugin from 3.1.2 to 3.1.3 @dependabot
- (#6213) Bump targetMavenVersion from 3.9.8 to 3.9.9 @dependabot
- (#6202) Bump org.junit.jupiter:junit-jupiter from 5.10.3 to 5.11.0 @dependabot
- (#6201) Bump org.junit.platform:junit-platform-suite from 1.10.3 to 1.11.0 @dependabot
- (#6200) Bump spring.version from 5.3.37 to 5.3.39 @dependabot
- (#6245) Bump actions/delete-package-versions from 3 to 5 @dependabot
- (#6199) Bump junit-jupiter.version from 5.10.3 to 5.11.0 @dependabot
**Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.29.2...v4.30.0
Changes in version 4.29.2 (2024.09.03)
### Liquibase 4.29.2 is a patch release
> Liquibase 4.29.2 patches minor issues found in Liquibase 4.29.1 release.
## Notable Changes
### [PRO]
#### Custom Policy Checks updates: Create and run Python-based checks which fit your specific needs.
* Liquibase checks have been opened to the world of Python development! This release fixes some minor issues so you can use your custom Python scripts as policy checks to solve your nuanced and techstack specific conditions for better risk mitigation, compliance, code quality, security, and more.
* Learn more https://docs.liquibase.com/custom-policy-checks
* Get the Checks extension to enable this capability: https://docs.liquibase.com/pro-extensions
## Deprecation Notice
#### MacOS .dmg Installer to be removed in next release.
* This is the final Liquibase release in which the MacOS installer will be shipped. Both the tarball (the liquibase-x.y.z.tar.gz) and the .zip (liquibase-x.y.x.zip) are the preferred replaced options for MacOS users.
* Questions or comments? https://www.liquibase.com/contact-us
### [PRO] Changelog
## Changes
* DAT-18013: optionally suppress Liquibase SQL for *-sql commands in https://github.com/liquibase/liquibase-pro/pull/1877 by @StevenMassaro
* DAT-17659: tagDatabase changes in formatted sql files in https://github.com/liquibase/liquibase-pro/pull/1833 by @StevenMassaro
* DAT-18310: update CustomCheckDefaultValuesTest to check all parameters in https://github.com/liquibase/liquibase-pro/pull/1887 by @StevenMassaro
* Now that report files are enabled by default, suppress them with git in https://github.com/liquibase/liquibase-pro/pull/1886 by @wwillard7800
* DAT-17390: global setting for stripComments option in https://github.com/liquibase/liquibase-pro/pull/1879 by @StevenMassaro
* DAT-18111: add "Report" word to title of update reports in https://github.com/liquibase/liquibase-pro/pull/1890 by @StevenMassaro
* DAT-18182: show correct message when license expires on same day in https://github.com/liquibase/liquibase-pro/pull/1885 by @StevenMassaro
* DAT-18342: Store Pro License Key in AWS Secrets Manager in https://github.com/liquibase/liquibase-pro/pull/1896 by @sayaliM0412
* DAT-18063 Release lock after SQLPLUS timeout error in https://github.com/liquibase/liquibase-pro/pull/1892 by @wwillard7800
* DAT-18360: only show expiration date message in checks run if expiration date is not null in https://github.com/liquibase/liquibase-pro/pull/1895 by @StevenMassaro
* DAT-18396 - fix scripts resource caching in https://github.com/liquibase/liquibase-pro/pull/1899 by @filipelautert
* DAT-18420 Change check that controls database checks to make sure they don't run just because we took a snapshot for a custom check in https://github.com/liquibase/liquibase-pro/pull/1902 by @wwillard7800
* DAT-18440 Handle strict mode setting when doing auto rollback in https://github.com/liquibase/liquibase-pro/pull/1909 by @wwillard7800
* DAT-18196: add method to LicenseService to allow custom invalid license message in https://github.com/liquibase/liquibase-pro/pull/1917 by @StevenMassaro
* DAT-18389 Changing Quality Checks -> Policy Checks in https://github.com/liquibase/liquibase-pro/pull/1906 by @wwillard7800
### [OSS] Changelog
## Changes
* Make Scope ID RNG no longer use SecureRandom (fix #6178 in https://github.com/liquibase/liquibase/pull/6179 by @danielthegray
* optionally suppress Liquibase SQL for *-sql commands (DAT-18013) in https://github.com/liquibase/liquibase/pull/6132 by @StevenMassaro
* changes in support of globally setting stripComments option (DAT-1739) in https://github.com/liquibase/liquibase/pull/6137 by @StevenMassaro
* Handle reporting of changes which are skipped due to license issues (DAT-17659) in https://github.com/liquibase/liquibase/pull/6114 by @wwillard7800
* [DAT-17993] Improve diffChangelog between MSSQL and Oracle in https://github.com/liquibase/liquibase/pull/6094 by @filipelautert
* DAT-18250 DevOps :: Clean up branch build not working in https://github.com/liquibase/liquibase/pull/6162 by @jandroav
* compare contents of zip file against baseline (DAT-18324) in https://github.com/liquibase/liquibase/pull/6166 by @StevenMassaro
* maven flag for suppressLiquibaseSql (DAT-18273) in https://github.com/liquibase/liquibase/pull/6163 by @StevenMassaro
* Append included labels to the changeset labels when matching (DAT-16636) in https://github.com/liquibase/liquibase/pull/6159 by @wwillard7800
* chore: upgrade installer jdk version to 21.0.4+7 in https://github.com/liquibase/liquibase/pull/6119 by @filipelautert
* Fix serialization of DatabaseChangeLog with 'preConditions' for yaml in https://github.com/liquibase/liquibase/pull/6118 by @MalloD12
* Add additional duplicateFileMode options in https://github.com/liquibase/liquibase/pull/6067 by @k4pran
* Do not show update summary when using update-sql via maven plugin (DAT-18323) in https://github.com/liquibase/liquibase/pull/6168 by @abrackx
* Bump org.mariadb.jdbc:mariadb-java-client from 3.3.3 to 3.4.1 in https://github.com/liquibase/liquibase/pull/6113 by @dependabot
* fix case where expiration date is null in --version output (DAT-18360) in https://github.com/liquibase/liquibase/pull/6170 by @StevenMassaro
* Use correct method for Maven updateSQL * DAT-18142 in https://github.com/liquibase/liquibase/pull/6198 by @wwillard7800
* DAT-18398 - Do not add version to shipped extensions + ignore current ones in https://github.com/liquibase/liquibase/pull/6197 by @filipelautert
* Fixes issue 6054: incorrect system table query on DB2 AS/400 platform in https://github.com/liquibase/liquibase/pull/6185 by @AlexCoolen
* Do not throw exception if data type is not supported by database in https://github.com/liquibase/liquibase/pull/6226 by @wwillard7800
* Do not release lock if not locked by this update * DAT-18370 in https://github.com/liquibase/liquibase/pull/6218 by @wwillard7800
* add method to LicenseService to allow custom invalid license message( DAT-18196) in https://github.com/liquibase/liquibase/pull/6232 by @StevenMassaro
* fix: EndDelimiter not working as expected since 4.29 in https://github.com/liquibase/liquibase/pull/6157 by @filipelautert
* Changing Quality Checks -> Policy Checks in https://github.com/liquibase/liquibase/pull/6204 by @wwillard7800
* fix release workflows in https://github.com/liquibase/liquibase/pull/6260 by @jandroav
## Security, Driver and Other Updates
* Bump org.testcontainers:testcontainers-bom from 1.19.8 to 1.20.1 in https://github.com/liquibase/liquibase/pull/6155 by @dependabot
* Bump org.apache.commons:commons-lang3 from 3.14.0 to 3.15.0 in https://github.com/liquibase/liquibase/pull/6112 by @dependabot
* Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.7.0 to 3.8.0 in https://github.com/liquibase/liquibase/pull/6116 by @dependabot
**Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.29.1...v4.29.2
Changes in version 4.29.1 (2024.07.31)
### Liquibase 4.29.1 is a patch release
* Liquibase 4.29.1 patches a pom mismatch in the Liquibase BigQuery Commercial Extension.
* Liquibase 4.29.1 resolves an issue with the zip distribution where all files were incorrectly placed inside liquibase-4.29.1 directory. This update ensures proper file organization and installation.
### [PRO] Changelog
## [PRO] Bug Fixes
* DAT-18294: Correctly default check scope parameter in https://github.com/liquibase/liquibase-pro/pull/1880 by @wwillard7800
**Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.29.0...v4.29.1
Changes in version 4.29.0 (2024.07.25)
### Liquibase 4.29.0 is a major release
> [!IMPORTANT]
> Liquibase 4.29.0 contains several New Capabilities and Notable Enhancements for Liquibase Pro users: Python-based Custom Policy Checks and a new Big Query extension.
> [!NOTE]
> See the [Liquibase 4.29.0 Release Notes](https://docs.liquibase.com/start/release-notes/liquibase-release-notes/liquibase-4.29.0.html) for the complete set of release information.
## Notable Changes
### [PRO]
#### Custom Policy Checks: Create and run Python-based checks which fit your specific needs.
* Liquibase checks have been opened to the world of Python development! With this release, you can point your custom checks to your custom Python scripts to solve your nuanced conditions for better risk mitigation, compliance, code quality, security, and more.
* Learn more https://docs.liquibase.com/custom-policy-checks
#### Big Query Extension: using Liquibase Pro with Google Big Query
* With Liquibase 4.29.0, Google BigQuery is now supported as an ‘out of the box’ database enabling users to more quickly achieve value. Also included is support for Liquibase Pro features such as Flows, Policy Checks, and Reports with Google BigQuery so that users will have the efficiency and productivity benefits of Liquibase Pro when working with the platform.
* Learn more https://docs.liquibase.com/bigquery
### [PRO] Changelog
## New Features
* DAT-16671: Custom policy checks in https://github.com/liquibase/liquibase-pro/pull/1671 by @wwillard7800
* DAT-17725: Enable reporting by default, swallow all report generation exceptions in https://github.com/liquibase/liquibase-pro/pull/1763 by @abrackx
* DAT-17871: allow multiple checks to be specified in checks enable/disable commands in https://github.com/liquibase/liquibase-pro/pull/1814 by @StevenMassaro
* DAT-17490: Enhance up* DATe report to split skipped changesets into their own collapsible section in https://github.com/liquibase/liquibase-pro/pull/1752 by @abrackx
* DAT-17635: add wildcard support for check-name param for checks run, show, bulkset in https://github.com/liquibase/liquibase-pro/pull/1787 by @StevenMassaro
## Changes
* DAT-17988: PRO: checks run --checks-output=nonapplicablechecks is broken in https://github.com/liquibase/liquibase-pro/pull/1792 by @wwillard7800
* DAT-17870: add aliases for parameters in checks run, show, and create commands in https://github.com/liquibase/liquibase-pro/pull/1799 by @StevenMassaro
* DAT-17972: abstract report writing to interface for IO in https://github.com/liquibase/liquibase-pro/pull/1795 by @StevenMassaro
* DAT-18086: update minor versions for Azure Uber Jar in https://github.com/liquibase/liquibase-pro/pull/1868 by @filipelautert
* DAT-17654: add test for starting and stopping H2 in detached mode in https://github.com/liquibase/liquibase-pro/pull/1735 by @StevenMassaro
* DAT-17883 Actually expand java and defaults file properties when using --property-substitution-enabled flag in https://github.com/liquibase/liquibase-pro/pull/1782 by @abrackx
* DAT-15723: include arguments in generated drop function changes for Postgres in https://github.com/liquibase/liquibase-pro/pull/1765 by @StevenMassaro
* DAT-17621: add ChangesetAttributesSetTrueOrFalse check in https://github.com/liquibase/liquibase-pro/pull/1754 by @StevenMassaro
* DAT-17657 Handle non-String arguments in Flow in https://github.com/liquibase/liquibase-pro/pull/1721 by wwillard7800
* DAT-16603 Do not append to open stream in flow in https://github.com/liquibase/liquibase-pro/pull/1738 by @wwillard7800
* DAT-8223: add split statements option to SqlUserDefinedPatternCheck in https://github.com/liquibase/liquibase-pro/pull/1744 by @StevenMassaro
* DAT-17535: update parameters for regex helper checks in https://github.com/liquibase/liquibase-pro/pull/1716 by @StevenMassaro
* DAT-15916 Give each SQLCMD log file a unique name by adding the change set author and id in https://github.com/liquibase/liquibase-pro/pull/1732 by @wwillard7800
* DAT-16597: fully qualify names when loading DDL of sprocs and funcs in Snowflake in https://github.com/liquibase/liquibase-pro/pull/1724 by @StevenMassaro
## [PRO] Bug Fixes
* DAT-18207: Do not open report when headless is true in https://github.com/liquibase/liquibase-pro/pull/1843 by @abrackx
* DAT-18052: make check-name case-insensitive for checks bulk-set in https://github.com/liquibase/liquibase-pro/pull/1815 by @StevenMassaro
## [PRO] Security, Driver and Other Updates
(#1825) Bump org.assertj:assertj-core from 3.26.0 to 3.26.3 by @dependabot
(#1824) Bump net.snowflake:snowflake-jdbc from 3.16.1 to 3.17.0 by @dependabot
(#1819) Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.17.1 to 2.17.2 by @dependabot
(#1820) Bump com.fasterxml.jackson.core:jackson-* DATabind from 2.17.1 to 2.17.2 by @dependabot
(#1818) Bump com.fasterxml.jackson.core:jackson-annotations from 2.17.1 to 2.17.2 by @dependabot
(#1807) Bump org.apache.groovy:groovy-all from 4.0.21 to 4.0.22 by @dependabot
(#1804) Bump org.junit.vintage:junit-vintage-engine from 5.10.2 to 5.10.3 by @dependabot
(#1803) Bump org.junit:junit-bom from 5.10.2 to 5.10.3 by @dependabot
(#1805) Bump org.projectlombok:lombok from 1.18.32 to 1.18.34 by @dependabot
(#1791) Bump org.apache.maven.plugins:maven-jar-plugin from 3.4.1 to 3.4.2 by @dependabot
(#1817) Bump com.fasterxml.jackson.core:jackson-core from 2.17.1 to 2.17.2 by @dependabot
(#1816) Bump com.networknt:json-schema-vali* DATor from 1.4.2 to 1.5.0 by @dependabot
(#1786) Bump com.github.xmlet:xsdParser from 1.2.14 to 1.2.15 by @dependabot
(#1794) Bump com.networknt:json-schema-vali* DATor from 1.4.0 to 1.4.2 by @dependabot
(#1783) Bump com.azure:azure-identity from 1.8.1 to 1.12.2 in /liquibase-azure-deps by @dependabot
(#1781) Bump com.microsoft.azure:msal4j from 1.13.8 to 1.15.1 in /liquibase-azure-deps by @dependabot
(#1746) Bump net.snowflake:snowflake-jdbc from 3.16.0 to 3.16.1 by @dependabot
(#1737) Bump org.mariadb.jdbc:mariadb-java-client from 3.3.3 to 3.4.0 by @dependabot
(#1760) Bump org.hsqldb:hsqldb from 2.7.2 to 2.7.3 by @dependabot
(#1758) Bump liquibase/build-logic from 0.7.7 to 0.7.8 by @dependabot
(#1718) Bump org.mockito:mockito-core from 5.11.0 to 5.12.0 by @dependabot
(#1717) Bump com.oracle.* DATabase.jdbc:ojdbc8 from 19.22.0.0 to 19.23.0.0 by @dependabot
(#1736) Bump org.codehaus.mojo:build-helper-maven-plugin from 3.5.0 to 3.6.0 by @dependabot
(#1745) Bump org.assertj:assertj-core from 3.25.3 to 3.26.0 by @dependabot
(#1762) Bump org.apache.maven.plugins:maven-shade-plugin from 3.5.3 to 3.6.0 by @dependabot
### [OSS] Changelog
## Breaking Changes
- (#6089) refactor history command to use command framework (DAT-17970) @StevenMassaro
## Changes
- (#5988) High Level API (aka undeprecate Liquibase class) @filipelautert
- (#5704) Fix SQL execution issue with endDelimiter '/' and splitStatements @MalloD12
- (#6032) DAT-17939 Add ability to generate Liquibase zip with extensions for any PR @jandroav
- (#6017) Fix issue 5944 @MalloD12
- (#5925) feat: FastCheck refactoring @filipelautert
- (#5802) refactored data clumps @compf
- (#6022) Changed condition to trigger tests @rberezen
- (#5929) add detached mode for running H2 (DAT-17654) @StevenMassaro
- (#5993) Move ChangeLogParameters helper methods to ChangeLogParameters class (DAT-17883) @abrackx
- (#5766) Use lombok getter and setter. @asashour
- (#5982) DAT-17770 Package BQ commercial jar inside liquibase tar ball \& zip @jandroav
- (#5986) fix incorrect line breaks and wrapping when generating table output (DAT-17891 and DAT-17288) @StevenMassaro
- (#5911) Fix sequenceExists check that became case sensitive for Postgresql @davidecavestro
- (#5598) Changeset execution information properties @jasonlyle88
- (#5774) Prevent spurious SET SEARCH\_PATH SQL statements for Postgres during update-sql command. Fixes #5316 @mpvvliet
- (#5875) GH issue #5872 improve regex for endDelimiter and rollbackEndDelimiter @wwillard7800
- (#5957) retain original dbms string (DAT-17621) @StevenMassaro
- (#5980) DAT-17768 - Add new directory internal/extension to classpath @filipelautert
- (#5977) fully qualify names of tables when snapshotting unique constraints in Snowflake (DAT-17880) @StevenMassaro
- (#5950) add default constructor + setters to `DatabaseChangeLogLock` @rursprung
- (#5961) Make the message be more accurate when an exception occurs during database close @wwillard7800
- (#5898) Do not log stack trace if isExpected flag is true for CommandFailedException @wwillard7800
- (#1826) Prevent silent failures when two "databaseChangeLog" tags are present @danielthegray
- (#5953) `CheckSum`: add getter for `storedCheckSum` @rursprung
- (#901) Microsoft SQL Server doesn't support ORDER in sequences @danielthegray
- (#5915) Added connect command to Maven DAT-17411 @wwillard7800
- (#5932) use Commons-IO where possible (DAT-17634) @StevenMassaro
- (#5812) DAT-16825 :: RawSqlStatement refactoring @MalloD12
- (#5922) generated addPrimaryKey changes should not include column direction (DAT-17467) @StevenMassaro
- (#5939) Adding property to build so that liquibase-scripting shows up in the tarball @wwillard7800
- (#5941) Run-Test configuration updated to avoid buidling jakarta.enterprise jakarta.enterprise.cdi api with Java 11 @MalloD12
- (#5903) [DAT-16377] Verify if supports method is implemented in a change to prevent unexpected behaviors @filipelautert
- (#5919) fully qualify names for Snowflake unique constraints (DAT-16598) @StevenMassaro
- (#5937) DAT-17536: Update weekly-integration-tests.yml @sayaliM0412
- (#5926) throw exception from diff-changelog when failure occurs (DAT-17623) @StevenMassaro
## New Features
- (#5850) Change visibility of useful methods to support custom checks (DAT-16671) @wwillard7800
- (#1379) Added liquibase:snapshot command to the liquibase-maven-plugin @malikin
- (#6036) feat: allow setting row-level dependency tracking in the create table statement on Oracle Database @matheusviegas
- (#6085) feat: release liquibase-cli package to maven @filipelautert
- (#5975) Update diff summary results in mdc to not be recalculated (DAT-17725) @abrackx
- (#6099) chore: include slf4j-simple and pin version to allow dependabot to upgrade it for us @filipelautert
- (#6046) feat: add current java version to Banner @filipelautert
- (#6039) command argument aliases that can be printed to help (DAT-17870) @StevenMassaro
- (#5965) Do not show message for bigquery database (DAT-17497) @vitaliimak
- (#5966) Add support for NULL placeholders on loadData @davidecavestro
- (#5924) Optimize parsing big xml files @asolntsev
- (#6021) feat: Add dependencies for apache commons libraries that are being used @filipelautert
- (#6034) feat: Add status command output + tests to make sure that ir runs at same time than update. @filipelautert
## Bug Fixes
- (#6117) Remove unneeded inclusion of commons-io in liquibase-core pom.xml @wwillard7800
- (#6097) Fixed performance issue with valueBlobFile on Postgres databases introduced in v4.18.0 @Shauren
- (#6083) Fix defaultValueComputed inside addColumn producing bad SQL with Postgres @micopiira
- (#6045) Add osgi.serverloader manifest header entries for liquibase.changelog.visitor.ValidatingVisitorGenerator #6040 fix @steinarb
- (#6024) fix #6019 NullPointerException when using CharType or VarcharType with H2 database @cchoz
- (#6015) Fix OSGi import for `org.apache.commons.io` @vkolomeyko
- (#6041) Rawsqlstatement refactoring fixes @MalloD12
- (#6027) chore: allow slf4j library to be included in liquibase zip/installer @filipelautert
- (#5958) Clone system properties to prevent ConcurrentModificationException @Alf-Melmac
## Security, Driver and Other Updates
- (#6028) Bump spring.version from 5.3.28 to 5.3.37 @dependabot
- (#6013) Bump org.firebirdsql.jdbc:jaybird from 5.0.4.java8 to 5.0.5.java8 @dependabot
- (#6029) Bump org.apache.maven.plugins:maven-jar-plugin from 3.4.1 to 3.4.2 @dependabot
- (#6011) Bump org.apache.maven.plugins:maven-failsafe-plugin from 3.2.5 to 3.3.0 @dependabot
- (#6018) Bump targetMavenVersion from 3.9.7 to 3.9.8 @dependabot
- (#6012) Bump org.apache.maven.plugins:maven-surefire-plugin from 3.2.5 to 3.3.0 @dependabot
- (#5952) Bump net.snowflake:snowflake-jdbc from 3.16.0 to 3.16.1 @dependabot
- (#5969) Bump org.hsqldb:hsqldb from 2.7.2 to 2.7.3 @dependabot
- (#5951) Bump org.xerial:sqlite-jdbc from 3.45.3.0 to 3.46.0.0 @dependabot
- (#5971) Bump org.apache.maven.plugins:maven-javadoc-plugin from 3.6.3 to 3.7.0 @dependabot
- (#5973) Bump org.apache.maven.plugins:maven-shade-plugin from 3.5.3 to 3.6.0 @dependabot
- (#5972) Bump org.apache.maven.plugins:maven-plugin-plugin from 3.13.0 to 3.13.1 @dependabot
- (#5970) Bump org.sonarsource.scanner.maven:sonar-maven-plugin from 3.11.0.3922 to 4.0.0.4121 @dependabot
- (#5964) Bump org.apache.maven.plugins:maven-enforcer-plugin from 3.4.1 to 3.5.0 @dependabot
- (#5959) Bump liquibase/build-logic from 0.7.7 to 0.7.8 @dependabot
- (#5949) Bump org.assertj:assertj-core from 3.25.3 to 3.26.0 @dependabot
- (#5948) Bump targetMavenVersion from 3.9.6 to 3.9.7 @dependabot
- (#5900) Bump com.oracle.database.jdbc:ojdbc8 from 19.22.0.0 to 19.23.0.0 @dependabot
- (#5931) Bump org.codehaus.mojo:build-helper-maven-plugin from 3.5.0 to 3.6.0 @dependabot
- (#5889) Bump info.picocli:picocli from 4.7.5 to 4.7.6 @dependabot
- (#5895) Bump org.testcontainers:testcontainers-bom from 1.19.7 to 1.19.8 @dependabot
- (#6090) Bump org.apache.maven.plugins:maven-surefire-plugin from 3.3.0 to 3.3.1 @dependabot
- (#6091) Bump org.apache.maven.plugins:maven-failsafe-plugin from 3.3.0 to 3.3.1 @dependabot
- (#6092) Bump actions/setup-python from 5.1.0 to 5.1.1 @dependabot
- (#6088) Bump org.assertj:assertj-core from 3.26.0 to 3.26.3 @dependabot
- (#6048) Bump junit-jupiter.version from 5.10.2 to 5.10.3 @dependabot
- (#6047) Bump org.junit.jupiter:junit-jupiter from 5.10.2 to 5.10.3 @dependabot
- (#6043) Bump org.apache.commons:commons-text from 1.11.0 to 1.12.0 @dependabot
- (#6049) Bump org.projectlombok:lombok from 1.18.32 to 1.18.34 @dependabot
- (#6050) Bump org.junit.platform:junit-platform-suite from 1.10.2 to 1.10.3 @dependabot
- (#6060) Bump groovy.version from 4.0.21 to 4.0.22 @dependabot
- (#6059) Bump robinraju/release-downloader from 1.10 to 1.11 @dependabot
- (#6026) Bump Spring-core version to 5.3.37 @filipelautert
- (#5810) Bump jakarta.enterprise:jakarta.enterprise.cdi-api from 4.0.1 to 4.1.0 @dependabot
- (#5790) Bump stCarolas/setup-maven from 4.5 to 5 @dependabot
- (#5824) Bump peter-evans/repository-dispatch from 1 to 3 @dependabot
**Full Changelog**: https://github.com/liquibase/liquibase/compare/v4.28.0...v4.29.0
### Get Certified
Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at https://learn.liquibase.com/.
### Read the Documentation
Please check out and contribute to the continually improving docs, now at https://docs.liquibase.com/.
### Meet the Community
Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to making it stronger:
[Contribute code](https://www.liquibase.org/development/contribute.html)
[Make doc updates](https://github.com/Datical/liquibase-docs)
[Help by asking and answering questions](https://forum.liquibase.org/)
[Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback)
Thanks to everyone who helps make the Liquibase community strong!
Changes in version 4.28.0 (2024.05.15)
### Liquibase 4.28.0 is a major release
### [PRO] Changelog
* DAT-17543: Handle chained checks which have been skipped because of a scope mismatch in https://github.com/liquibase/liquibase-pro/pull/1697 by wwillard7800
* DAT-16725: automatically open generated reports in browser in https://github.com/liquibase/liquibase-pro/pull/1703 by StevenMassaro
* DAT-17485: always show update summary message in update report in https://github.com/liquibase/liquibase-pro/pull/1708 by StevenMassaro
* DAT-17630: Rework logic for checking for database connection in https://github.com/liquibase/liquibase-pro/pull/1706 by wwillard7800
* DAT-17400: add Snowflake integration tests in https://github.com/liquibase/liquibase-pro/pull/1693 by StevenMassaro
* DAT-17540: Rename MaxRowsAllowed and added two more checks for update and delete in https://github.com/liquibase/liquibase-pro/pull/1686 by wwillard7800
* DAT-17348: add condition evaluation details to conditions which evaluate to true in https://github.com/liquibase/liquibase-pro/pull/1688 by StevenMassaro
* DAT-15920: error if native executor conf file or rollback file is not found and pro-strict is true in https://github.com/liquibase/liquibase-pro/pull/1663 by StevenMassaro
* DAT-17601: Expand variables that are included in flow files in https://github.com/liquibase/liquibase-pro/pull/1694 by wwillard7800
## [PRO] Security, Driver and Other Updates
(#1652) Bump org.apache.groovy:groovy-all from 4.0.20 to 4.0.21 @dependabot
(#1673) Bump org.apache.maven.plugins:maven-shade-plugin from 3.5.2 to 3.5.3 @dependabot
(#1700) Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.17.0 to 2.17.1 @dependabot
(#1701) Bump com.fasterxml.jackson.core:jackson-databind from 2.17.0 to 2.17.1 @dependabot
(#1710) Bump info.picocli:picocli from 4.7.5 to 4.7.6 @dependabot
(#1702) Bump liquibase/build-logic from 0.7.5 to 0.7.7 @dependabot
(#1699) Bump com.fasterxml.jackson.core:jackson-annotations from 2.17.0 to 2.17.1 @dependabot
(#1698) Bump com.fasterxml.jackson.core:jackson-core from 2.17.0 to 2.17.1 @dependabot
(#1684) Bump commons-codec:commons-codec from 1.16.1 to 1.17.0 @dependabot
(#1668) Bump org.apache.maven.plugins:maven-jar-plugin from 3.3.0 to 3.4.1 @dependabot
(#1707) Bump net.snowflake:snowflake-jdbc from 3.15.1 to 3.16.0 @dependabot
(#1695) Bump com.github.spullara.mustache.java:compiler from 0.9.11 to 0.9.13 @dependabot
(#1690) Bump liquibase/build-logic from 0.7.2 to 0.7.5 @dependabot
(#1680) Bump liquibase/build-logic from 0.7.2 to 0.7.5 AI Generated Code @dependabot
(#1666) Bump actions/upload-artifact from 2 to 3 @dependabot
### [OSS] Changelog
## Breaking Changes
- (#5619) Improve snapshot extensibility for NoSQL databases @fbiville
- (#5729) remove ValueHandlerUtil and improve CLI argument parsing (DAT-15398) @StevenMassaro
## New Features
- (#5899) H2 tests may end up with an incorrect list of the standard DatabaseObject types, so we need to reset the factory @wwillard7800
- (#5897) chore: invoke deprecated methods in default supports method for backwards compatibility @filipelautert
- (#5870) only run drop all if database was used in the test @StevenMassaro
- (#5848) do not allow arguments with default values to be required (DAT-17436) @StevenMassaro
- (#5833) Use Java 8 features @asashour
- (#5767) Ensure a new-line at the end of text files. @asashour
- (#5814) refactor ValidatingVisitor to use factory pattern, error if strict is set and defaults file does not exist (DAT-15920) @StevenMassaro
- (#5716) Fix typos @asashour
- (#5782) Update ChangeSetService to handle new ModifyChangeset creation (DAT-17322) @wwillard7800
- (#5715) Add `@Deprecated` annotation. @asashour
- (#5828) Improve diffChangelog error message @filipelautert
- (#5799) Add new lifecycle methods for UpdateTestingRollbackCommandStep (DAT-15641) @abrackx
- (#5780) Deprecate ThreadLocalScopeManager as it is no longer required @filipelautert
- (#5714) Introduce a method with a correct name of `StringUtil.randomIdentifer()`. @asashour
- (#5793) move output file handling into factory pattern (DAT-17290) @StevenMassaro
- (#5741) Implement Customizer for SpringLiquibase. @asashour
- (#5777) Prevent error when unlocking the changelog in MySQL affects zero rows and useAffectedRows is true. Fixes #5502 @mpvvliet
- (#5619) Improve snapshot extensibility for NoSQL databases @fbiville
- (#5658) User lombok Getter and Setter. @asashour
- (#5532) Record current Liquibase version on a RERUN changeset (#5529) @jdvorak001
- (#5745) Add method that can be used to verify database connection (DAT-16600) @vitaliimak
- (#5705) upgrade groovy, spock and mockito to later versions (DAT-10403) @StevenMassaro
- (#5861) Update db2 docker location by @filipelautert
- (#5860) chore: increasing test coverage by @filipelautert
- (#5853) use Apache Commons where possible, instead of homegrown solutions (DAT-17303) by @StevenMassaro
- (#5867) cleanup weekly-integration-tests.yml (DAT-17400) by @StevenMassaro
- (#4240) PD-3241: failOnError syntax by @adrian-velonis1
- (#5871) load shared database fields in tests by @StevenMassaro
## Bug Fixes
- (#5795) Fixes issue with incorrect schema in column exists precondition when checking using a snapshot @mpvvliet
- (#5783) Fixed issue that unique constraint precondition does not honor schemaName attribute on MySQL @mpvvliet
- (#5874) refactor cached prepared statement to become ThreadLocal (#5635) @adaryin
- (#5888) normalize paths in DatabaseChangeLog using commons-io (DAT-17592) @StevenMassaro
- (#5887) Fix ordering of clause for Oracle global temporary tables SQL generation @wwillard7800
- (#5869) Update diff summary results in mdc to not be recalculated (DAT-17096) @abrackx
- (#5756) Fix (MSSQL): end delimiter logic broken by BEGIN DIALOG/BEGIN CONVERSATION @MalloD12
- (#5781) Fix (MSSQL): default end delimiter applied when there is an endDelimiter applied for a given chanset @MalloD12
- (#5883) Issue 5654 includeall min max depth fixes @jasonlyle88
- (#5842) optimize DBCL checksum query and set fetch size on all statements (DAT-17267) @StevenMassaro
- (#5794) fix calculation of total change sets in update summary (DAT-17262) @StevenMassaro
- (#5792) fix: keep indexes list in the order returned by database @filipelautert
- (#5703) Also replace '@' character in temporary file names DAT-17292 @wwillard7800
- (#5727) fixes #5724: compare normalized file paths @jgarec
- (#5755) detect duplicate jars that do not have a version (DAT-16044) @StevenMassaro
- (#5687) fix: addColumn changes are not respecting Datatypes definitions @filipelautert
- (#5580) Support to generate a ChangeSetStatus with setting all its attributes when a changeset will be skipped @MalloD12
- (#5751) New boolean input logic allows 'off' to be valid, so fix test @wwillard7800
## Security, Driver and Other Updates
- (#5864) Bump net.snowflake:snowflake-jdbc from 3.15.1 to 3.16.0 @dependabot
- (#5797) Bump org.slf4j:slf4j-jdk14 from 2.0.12 to 2.0.13 @dependabot
- (#5884) Bump org.objenesis:objenesis from 3.3 to 3.4 @dependabot
- (#5863) Bump org.apache.maven.plugins:maven-install-plugin from 3.1.1 to 3.1.2 @dependabot
- (#5839) Bump org.apache.maven.plugins:maven-shade-plugin from 3.5.2 to 3.5.3 @dependabot
- (#5829) Bump org.apache.maven.plugins:maven-jar-plugin from 3.3.0 to 3.4.1 @dependabot
- (#5811) Bump org.xerial:sqlite-jdbc from 3.45.2.0 to 3.45.3.0 @dependabot
- (#5785) Bump groovy.version from 4.0.20 to 4.0.21 @dependabot
- (#5879) Bump org.apache.maven.plugins:maven-plugin-plugin from 3.12.0 to 3.13.0 @dependabot
- (#5880) Bump liquibase/build-logic from 0.7.6 to 0.7.7 @dependabot
- (#5865) Bump org.apache.maven.plugins:maven-deploy-plugin from 3.1.1 to 3.1.2 @dependabot
- (#5851) Bump liquibase/build-logic from 0.7.2 to 0.7.5 @dependabot
- (#5845) Bump liquibase/build-logic from 0.7.2 to 0.7.5 @dependabot
- (#5841) Bump liquibase/build-logic from 0.6.9 to 0.7.3 @dependabot
- (#5779) Bump net.snowflake:snowflake-jdbc from 3.15.0 to 3.15.1 @dependabot
- (#5787) Bump robinraju/release-downloader from 1.9 to 1.10 @dependabot
- (#5699) Bump org.postgresql:postgresql from 42.7.2 to 42.7.3 @dependabot
- (#5675) Bump org.firebirdsql.jdbc:jaybird from 5.0.3.java8 to 5.0.4.java8 @dependabot
- (#5689) Bump org.xerial:sqlite-jdbc from 3.44.1.0 to 3.45.2.0 @dependabot
- (#5757) Bump org.jacoco:jacoco-maven-plugin from 0.8.11 to 0.8.12 @dependabot
- (#5764) Bump org.apache.maven.plugins:maven-plugin-plugin from 3.11.0 to 3.12.0 @dependabot
- (#5765) Bump liquibase/build-logic from 0.6.7 to 0.6.9 @dependabot
- (#5773) Bump org.apache.maven.plugins:maven-source-plugin from 3.3.0 to 3.3.1 @dependabot
- (#5752) Bump actions/setup-python from 5.0.0 to 5.1.0 @dependabot
- (#5713) Bump actions/cache from 3.3.1 to 4.0.2 @dependabot
- (#5678) Bump softprops/action-gh-release from 1 to 2 @dependabot
- (#5711) Bump org.apache.maven.plugins:maven-compiler-plugin from 3.12.1 to 3.13.0 @dependabot
- (#5710) Bump org.apache.maven.plugins:maven-assembly-plugin from 3.6.0 to 3.7.1 @dependabot
- (#5673) Bump org.glassfish.jaxb:jaxb-core from 4.0.4 to 4.0.5 @dependabot
- (#5672) Bump org.glassfish.jaxb:jaxb-runtime from 4.0.4 to 4.0.5 @dependabot
- (#5662) Bump org.testcontainers:testcontainers-bom from 1.19.6 to 1.19.7 @dependabot
- (#5690) Bump org.sonarsource.scanner.maven:sonar-maven-plugin from 3.10.0.2594 to 3.11.0.3922 @dependabot
- (#5685) Bump net.snowflake:snowflake-jdbc from 3.14.4 to 3.15.0 @dependabot
- (#5868) Bump liquibase/build-logic from 0.7.5 to 0.7.6 by @dependabot
### Get Certified
Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at https://learn.liquibase.com/.
### Read the Documentation
Please check out and contribute to the continually improving docs, now at https://docs.liquibase.com/.
### Meet the Community
Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to making it stronger:
[Contribute code](https://www.liquibase.org/development/contribute.html)
[Make doc updates](https://github.com/Datical/liquibase-docs)
[Help by asking and answering questions](https://forum.liquibase.org/)
[Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback)
Thanks to everyone who helps make the Liquibase community strong!
Changes in version 4.27.0 (2024.03.26)
### Liquibase 4.27.0 is a major release
> Liquibase 4.27.0 contains several New Capabilities and Notable Enhancements for Liquibase Pro users: DATABASECHANGELOGHISTORY table, Quality Checks Chains, Rollback Reports
> See the [Liquibase 4.27.0 Release Notes](https://docs.liquibase.com/start/release-notes/liquibase-release-notes/liquibase-4.27.0.html) for the complete set of release information.
## Notable Changes
### [PRO]
#### Liquibase DATABASECHANGELOGHISTORY table: See all changes that have been applied to your database
* With the new DatabaseChangeLogHistory (DBCLH) Table, get a complete history of changes made to your database through Liquibase operations, including updates, rollbacks, dropAlls, tags, changelogsyncs, and repeated updates to the same ChangeSet. The DBCLH table is disabled by default, so Users must turn it on to start capturing historical data.
* Learn more https://docs.liquibase.com/databasechangeloghistory
#### Quality Checks Chains: Perform multiple policy evaluations with a single Quality Check
* Chain multiple Quality Checks together with logic conditionals (AND, OR, and NOT) for more flexibility to perform multiple evaluations in a single check. Useful to confirm complex best practices or governance issues. Check Chains are run like traditional single-condition existing Quality Checks
* Learn more https://docs.liquibase.com/quality-checks
#### Observability: Rollback Reports: Understand and share the data on the execution of rollback commands
* Easily scan and understand a high-level overview of the ChangeSets rolled back. Get a detailed view of both successful and failed rollbacks. Collaborate with your team with shareable report in PDF format
* Learn more https://docs.liquibase.com/observability
## Breaking Change
- (#5584) throw exception if drop all fails (DAT-16718) @StevenMassaro
### [PRO] Changelog
* DAT-16798: Style rollback reports in https://github.com/liquibase/liquibase-pro/pull/1534 by @abrackx
* DAT-16857: record operationOutcome in MDC in https://github.com/liquibase/liquibase-pro/pull/1606 by StevenMassaro
* DAT-16853: Chained checks reports in https://github.com/liquibase/liquibase-pro/pull/1580 by @abrackx
* DAT-16127 Checks chaining implementation in https://github.com/liquibase/liquibase-pro/pull/1500 by wwillard7800
* DAT-16178: database changelog history record-keeping in https://github.com/liquibase/liquibase-pro/pull/1334 by StevenMassaro
* DAT-16092 Implemented checkStatus argument for filtering by enabled/disabled status in https://github.com/liquibase/liquibase-pro/pull/1577 by wwillard7800
* DAT-17187: Add check rollbacks to runtime metadata in https://github.com/liquibase/liquibase-pro/pull/ by @abrackx
* DAT-16920: add path filter option to SqlUserDefinedPatternCheck in https://github.com/liquibase/liquibase-pro/pull/1575 by StevenMassaro
* DAT-17072 Added new autoEnableNewChecks option and fix bug with autoUpdate in https://github.com/liquibase/liquibase-pro/pull/1566 by wwillard7800
* DAT-16420: add propertySubstitutionEnabled flag to checks run command in https://github.com/liquibase/liquibase-pro/pull/1569 by StevenMassaro
* DAT-16845: exclude unnecessary directories/files from built jar in https://github.com/liquibase/liquibase-pro/pull/1565 by StevenMassaro
* DAT-15170: add EndDelimiterExistsWhenPatternExists QC in https://github.com/liquibase/liquibase-pro/pull/1517 by StevenMassaro
* DAT-16559: Add copy url button to checks run and update reports in https://github.com/liquibase/liquibase-pro/pull/1521 by @abrackx
* DAT-16770: Fix table styling in details by check in https://github.com/liquibase/liquibase-pro/pull/1531 by @abrackx
* DAT-16683 Implement snapshot filters for snapshotReference command in https://github.com/liquibase/liquibase-pro/pull/1506 by wwillard7800
* DAT-15980 Added new CheckRunInTransactionValue rule in https://github.com/liquibase/liquibase-pro/pull/1516 by wwillard7800
* DAT-16544 Fix issue with bad SQL generation in https://github.com/liquibase/liquibase-pro/pull/1512 by wwillard7800
* DAT-14830: warn if running checks bulk-set without arguments in https://github.com/liquibase/liquibase-pro/pull/1592 by StevenMassaro
* DAT-16105: improve interactive prompting through Powershell ISE in https://github.com/liquibase/liquibase-pro/pull/1581 by StevenMassaro
* DAT-16765: throw exception when using init copy on non-s3 paths in https://github.com/liquibase/liquibase-pro/pull/1539 by StevenMassaro
* PD-3246: init copy --source/--target descriptions in https://github.com/liquibase/liquibase-pro/pull/946 by adrian-velonis1
* DAT-16271: properly handle creating procedure with no args and external name in https://github.com/liquibase/liquibase-pro/pull/1494 by StevenMassaro
* DAT-16567 Handle logFormat when set in a flow file in https://github.com/liquibase/liquibase-pro/pull/1522 by wwillard7800
* DAT-16306: wrap INITCOND of Postgres aggregate functions in single quotes in https://github.com/liquibase/liquibase-pro/pull/1502 by StevenMassaro
## [PRO] Security, Driver and Other Updates
* Bump liquibase/build-logic from 0.6.4 to 0.6.6 dependencies github_actions #1616 by dependabot bot
* Bump org.projectlombok:lombok from 1.18.30 to 1.18.32 #1614 by dependabot bot
* Bump org.apache.maven.plugins:maven-assembly-plugin from 3.6.0 to 3.7.1 #1613 by dependabot bot
* Bump org.apache.maven.plugins:maven-compiler-plugin from 3.12.1 to 3.13.0 #1612 by dependabot bot
* Bump com.networknt:json-schema-validator from 1.3.3 to 1.4.0 #1610 by dependabot bot
* Bump actions/delete-package-versions from 3 to 5 dependencies github_actions #1551 by dependabot bot
* Bump org.postgresql:postgresql from 42.7.2 to 42.7.3 #1604 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-core from 2.16.2 to 2.17.0 #1597 by dependabot bot
* Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.16.2 to 2.17.0 #1595 by dependabot bot
* Bump org.sonarsource.scanner.maven:sonar-maven-plugin from 3.10.0.2594 to 3.11.0.3922 #1599 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-databind from 2.16.2 to 2.17.0 #1596 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-annotations from 2.16.2 to 2.17.0 #1594 by dependabot bot
* Bump com.github.jsqlparser:jsqlparser from 4.8 to 4.9 #1583 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-annotations from 2.16.1 to 2.16.2 #1588 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-core from 2.16.1 to 2.16.2 #1586 by dependabot bot
* Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.16.1 to 2.16.2 #1584 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-databind from 2.16.1 to 2.16.2 #1585 by dependabot bot
* Bump ch.qos.logback:logback-classic from 1.5.1 to 1.5.2 #1568 by dependabot bot
* Bump com.fasterxml.jackson.module:jackson-module-jaxb-annotations from 2.15.3 to 2.16.1 #1449 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-annotations from 2.15.3 to 2.16.1 #1450 by dependabot bot
* Bump com.oracle.database.jdbc:ojdbc8 from 19.21.0.0 to 19.22.0.0 #1563 by dependabot bot
* Bump org.mariadb.jdbc:mariadb-java-client from 3.2.0 to 3.3.3 #1555 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-core from 2.15.3 to 2.16.1 #1451 by dependabot bot
* Bump com.fasterxml.jackson.core:jackson-databind from 2.15.3 to 2.16.1 #1452 by dependabot bot
* Bump com.github.jsqlparser:jsqlparser from 4.7 to 4.8 #1558 by dependabot bot
* Bump com.github.wvengen:proguard-maven-plugin from 2.6.0 to 2.6.1 #1557 by dependabot bot
* Bump org.apache.maven.plugins:maven-shade-plugin from 3.5.1 to 3.5.2 #1559 by dependabot bot
* Bump org.codehaus.mojo:flatten-maven-plugin from 1.5.0 to 1.6.0 #1560 by dependabot bot
* Bump commons-codec:commons-codec from 1.16.0 to 1.16.1 #1561 by dependabot bot
* Bump org.mvel:mvel2 from 2.5.0.Final to 2.5.2.Final #1562 by dependabot bot
* Bump com.fasterxml.jackson.dataformat:jackson-dataformat-yaml from 2.15.3 to 2.16.1 #1453 by dependabot bot
* Bump org.jacoco:jacoco-maven-plugin from 0.8.10 to 0.8.11 dependencies java #1309 by dependabot bot
* Bump org.apache.maven.plugins:maven-compiler-plugin from 3.11.0 to 3.12.1 #1547 by dependabot bot
* Bump org.assertj:assertj-core from 3.24.2 to 3.25.3 #1548 by dependabot bot
* Bump ch.qos.logback:logback-classic from 1.4.11 to 1.5.1 #1543 by dependabot bot
* Revert * Bump actions/delete-package-versions from 3 to 5 #1546 by StevenMassaro
* Bump org.postgresql:postgresql from 42.6.0 to 42.7.2 #1530 by dependabot bot
* Bump org.postgresql:postgresql from 42.6.0 to 42.6.1 in /pro dependencies java #1541 by dependabot bot
* Bump org.postgresql:postgresql from 42.6.0 to 42.7.2 in /liquibase-pro-extension-testing dependencies java #1527 by dependabot bot
### [OSS] Changelog
## Breaking Changes
- (#5584) throw exception if drop all fails (DAT-16718) @StevenMassaro
## New Features
- (#5692) Add force option to dropAll DAT-16418 @wwillard7800
- (#5630) DAT-16798: Add new parameters to rollback report @abrackx
- (#5649) Add CustomChangeChecksum interface @robinjhector
- (#5147) database changelog history record-keeping (DAT-16178) @StevenMassaro
- (#5709) feat: add commons-lang3 as a required dependency for core @filipelautert
- (#5670) 5507-performance\_improvements @filipelautert
- (#5667) Exception handler for when a service cannot be loaded @filipelautert
- (#5650) DAT-16513 - Upgrade installer Java version to 21 @filipelautert
- (#5456) Extended formatted sql preconditions by table-/viewExists @JulienMa94
- (#5597) Format spring package. @asashour
- (#5592) Bring update summary options to all update-related goals of the maven plugin @KeepItSimpleStupid
- (#5530) Use static final Pattern to avoid regexp compilation each time replaceAll is called @turbanoff
- (#3185) Better error message when no test system has been found @abrackx
- (#5501) add sqlParserExceptionLogAtLevel param to checks.run maven target (DAT-16309) @StevenMassaro
- (#5593) Format sql server urls in reports (DAT-16559) @abrackx
- (#5506) fix: Parse all utf8 symbols @filipelautert
- (#5500) Adding maven wrapper support @filipelautert
- (#5548) Allow override of snapshot control creation for snapshotReference command DAT-16683 @wwillard7800
- (#5545) Handle java.lang.StackOverflowError when running generate-changelog (DAT-16812) @filipelautert
- (#5469) enable DB2 tests (DAT-16658) @StevenMassaro
- (#5527) expand values for url, username, password that use secrets vaults in maven plugin (DAT-16431) @StevenMassaro
- (#5525) Add labels, context and rollback on error info to report (DAT-16531) @abrackx
- (#5490) DAT-16675: add support for command aliases @StevenMassaro
- (#5406) Allow snapshot control creation to be overridden for snapshot filters DAT-16054 @wwillard7800
- (#5256) Added exclusion for MVEL DAT-16282 @wwillard7800
- (#5494) skip integration tests during unit test build (DAT-16719) @StevenMassaro
- (#5329) Support runWith executors committing after the change set completes @dzeigler
- (#5493) automatically run dropall before and after all integration tests @StevenMassaro
- (#5452) Log the exception in case of failure in ChangeSet.execute @bignoncedric
- (#5043) Improve support for DB2[z] empty table precondition @MichaelKern-IVV
- (#5424) Moved saved\_state/compareGenerateSql.. directory from java source to resources bundle @MalloD12
- (#5336) add default constructor + setters to `RanChangeSet` \& related classes @rursprung
- (#5340) Fixes #2352 by adding support for loading embedded jar files @hayeskl
- (#5462) map testcontainers to random available host port @StevenMassaro
- (#5457) prevent multiple databases in test classes @StevenMassaro
- (#5416) do not clear a subset of MDC keys when scope exits (DAT-16500) @StevenMassaro
- (#5164) Write changelog only if changes exist @brachi-wernick
- (#5360) Introduce support for primitive types in new changes @fbiville
- (#5417) switch integration tests to use h2 where possible (DAT-16015) @StevenMassaro
- (#5274) Use mariadb UUID when specify UUID type @mohamed-ahrrass-nw
- (#5347) Added extra space for command help arguments display DAT-13864 @wwillard7800
- (#5413) add changeset identifier to exceptions thrown from LiquibaseSqlParser (DAT-16397) @StevenMassaro
- (#5402) Adds pending changesets to update report (DAT-16332) @abrackx
- (#3581) Support create table if not exists @taeyeon-Kim
- (#4635) generateChangelog optionally creates runOnChange=true and replaceIfExists=true for createView changes @mkarg
- (#5329) Support runWith executors committing after the change set completes @dzeigler
## Bug Fixes
- (#5707) [DAT-16135] add new scope flag for modifyChangeSet flow @KushnirykOleh
- (#5695) Handle empty or null schema for CreateView with replace option DAT-16446 @wwillard7800
- (#5686) add ignore property to includeAll XSD (DAT-14921) @StevenMassaro
- (#5700) FIX: SimpleSQLGrammar quote parsing regression @jasonlyle88
- (#5668) load driver from global argument as well as command argument (DAT-16381) @StevenMassaro
- (#5634) improve update summary count calculations (DAT-16656 and DAT-16357) @StevenMassaro
- (#5629) Fix SQL generation when having a column defined with startWith and incrementBy in Postgres @MalloD12
- (#5626) Add support for SnakeYaml to be able to parse timestamps correctly when timezone is set or not @MalloD12
- (#5657) [DAT-16428] Reenable ChangelogSyncIntegrationTest tests @filipelautert
- (#5665) fix: ClearChecksums should not throw Exception in empty databases @filipelautert
- (#5660) Default implementation of handleInvalidEmptyPreconditionCase added in AbtractFormattedChangeLogParser to avoid breaking extensions @MalloD12
- (#5555) Fix unique constraint and primary key generator issues for Postgres and H2 @Guschtel
- (#5583) Add backwards compatibility for procedureBody in createProcedureChange @StevenMassaro
- (#5617) fix: uses ThreadLocal to prevent concurrent modification on ScopeManager @filipelautert
- (#5446) Proposed fix for #5442 - command "unexpectedChangesets" always reports at least 1 unexpected changeset with initial tag in database @Tylorjg
- (#5506) fix: Parse all utf8 symbols @filipelautert
- (#5606) fix: treats potential nullpointer exception after a lock exception @filipelautert
- (#5581) Handle stored logic with parameters in the dependency graph DAT-15747 @wwillard7800
- (#5566) chunk long strings on insert for Oracle (DAT-16774) @StevenMassaro
- (#5522) MariaDB boolean: back to TINYINT(1) instead of TINYINT (MySQL) @famod
- (#5524) Don't execute CustomSqlChanges to generate logs @Alf-Melmac
- (#5498) Add missing OSGI settings @filipelautert
- (#5391) fix SQLFileChange.generateCheckSum() to calculate checksum without property substitution @jglass524
- (#5398) Fix issue #3516 addColumn ignores deleteCascade=true @andreiyusupau
- (#5479) do not skip over duplicate tags when doing rollback (DAT-16277) @StevenMassaro
- (#5484) Workaround failing test containers startup for mysql by falling back to previous version. @abrackx
- (#5397) Fix DatabaseFactory db loading when Database implementation is specified (fix for Issues 5371 \& 5396 ) @dhsmith1001
- (#5202) 4464 fix generated default column value using in PostgreSQL and Oracle for char/clob data types @LonwoLonwo
- (#5350) Fix getSerializableFieldValue when dealing with rollback object @MalloD12
- (#5414) Fix NPE in generateChangelog and diffChangelog DAT-16534 @wwillard7800
- (#5267) fix #5266: comma separated dbms-attribute for createProcedure-change triggers validation-check @jclohmann
- (#5304) Fix for DAT-15716 :: Include 'OR REPLACE' instruction for a view when generate-changelog/diff-changelog command are executed @MalloD12
## 🤖 Security, Driver and Other Updates
- (#5447) Bump org.slf4j:slf4j-jdk14 from 2.0.9 to 2.0.11 @dependabot
- Bump org.postgresql:postgresql from 42.7.1 to 42.7.2 by @dependabot in https://github.com/liquibase/liquibase/pull/5613
- Bump org.postgresql:postgresql from 42.7.1 to 42.7.2 in /liquibase-dist by @dependabot in https://github.com/liquibase/liquibase/pull/5612
- Bump org.apache.maven.plugins:maven-failsafe-plugin from 3.2.2 to 3.2.5 by @dependabot in https://github.com/liquibase/liquibase/pull/5449
- Bump maven-surefire-plugin.version from 3.2.2 to 3.2.5 by @dependabot in https://github.com/liquibase/liquibase/pull/5448
- Bump org.codehaus.mojo:flatten-maven-plugin from 1.5.0 to 1.6.0 by @dependabot in https://github.com/liquibase/liquibase/pull/5464
- chore(deps): Bump org.junit:junit-bom from 5.10.1 to 5.10.2 by @dependabot in https://github.com/liquibase/liquibase/pull/5556
- chore(deps-dev): Bump org.junit.jupiter:junit-jupiter from 5.10.1 to 5.10.2 by @dependabot in https://github.com/liquibase/liquibase/pull/5557
- Bump org.testcontainers:testcontainers-bom from 1.19.3 to 1.19.6 by @dependabot in https://github.com/liquibase/liquibase/pull/5621
- Bump actions/github-script from 6 to 7 by @dependabot in https://github.com/liquibase/liquibase/pull/5281
- Bump actions/setup-java from 3 to 4 by @dependabot in https://github.com/liquibase/liquibase/pull/5301
- Bump actions/checkout from 2 to 4 by @dependabot in https://github.com/liquibase/liquibase/pull/5324
- Bump github/codeql-action from 2 to 3 by @dependabot in https://github.com/liquibase/liquibase/pull/5380
- chore(deps-dev): Bump org.assertj:assertj-core from 3.25.1 to 3.25.3 by @dependabot in https://github.com/liquibase/liquibase/pull/5558
- chore(deps): Bump org.slf4j:slf4j-jdk14 from 2.0.11 to 2.0.12 by @dependabot in https://github.com/liquibase/liquibase/pull/5568
- Bump release-drafter/release-drafter from 5 to 6 by @dependabot in https://github.com/liquibase/liquibase/pull/5589
- Bump org.apache.maven.plugins:maven-shade-plugin from 3.5.1 to 3.5.2 by @dependabot in https://github.com/liquibase/liquibase/pull/5614
- bump version of setup-maven action by @StevenMassaro in https://github.com/liquibase/liquibase/pull/5643
- Bump com.oracle.database.jdbc:ojdbc8 from 19.21.0.0 to 19.22.0.0 by @dependabot in https://github.com/liquibase/liquibase/pull/5588
- Bump com.microsoft.sqlserver:mssql-jdbc from 12.4.1.jre8 to 12.6.1.jre8 by @dependabot in https://github.com/liquibase/liquibase/pull/5615
- Bump org.mariadb.jdbc:mariadb-java-client from 3.3.2 to 3.3.3 by @dependabot in https://github.com/liquibase/liquibase/pull/5616
- Bump whelk-io/maven-settings-xml-action from 20 to 22 by @dependabot in https://github.com/liquibase/liquibase/pull/5639
- Bump robinraju/release-downloader from 1.8 to 1.9 by @dependabot in https://github.com/liquibase/liquibase/pull/5640
- Bump actions/delete-package-versions from 3 to 5 by @dependabot in https://github.com/liquibase/liquibase/pull/5641
- Bump org.projectlombok:lombok from 1.18.30 to 1.18.32 by @dependabot in https://github.com/liquibase/liquibase/pull/5712
### Get Certified
Learn all the Liquibase fundamentals from free online courses by Liquibase experts and see how to apply them in the real world at https://learn.liquibase.com/.
### Read the Documentation
Please check out and contribute to the continually improving docs, now at https://docs.liquibase.com/.
### Meet the Community
Our community has built a lot. From extensions to integrations, you’ve helped make Liquibase the amazing open source project that it is today. Keep contributing to making it stronger:
[Contribute code](https://www.liquibase.org/development/contribute.html)
[Make doc updates](https://github.com/Datical/liquibase-docs)
[Help by asking and answering questions](https://forum.liquibase.org/)
[Set up a chat with the Product team](https://calendly.com/liquibase-outreach/product-feedback)
Thanks to everyone who helps make the Liquibase community strong!
Changes in version 4.26.0 (2024.02.06)
### Liquibase 4.26.0 is a major release
> [!IMPORTANT]
> Liquibase 4.26.0 contains several Notable Changes for Liquibase Pro users: Advanced IF conditionals, Simpler Regex-based pattern checks, and Checks Run Reports.
> [!NOTE]
> See the [Liquibase 4.26.0 Release Notes](https://docs.liquibase.com/start/release-notes/liquibase-4.26.0.html) for the complete set of release information.
## Notable Changes
### [PRO]
#### Liquibase Flow: Advanced IF conditionals
* In Liquibase flow files, use AND (&&), OR (||), and NOT (!) logic options, in single or grouped conditions, as well as substring matching and checking if a key or file exists.
* Learn more https://docs.liquibase.com/flow
#### Quality Checks: Simpler Regex-based pattern checks
* Check four advanced patterns without having to figure out the complicated regex needed to do it—just supply the patterns and Quality Checks will link and execute them.
* Learn more https://docs.liquibase.com/quality-checks
#### Observability: Checks Run Reports
* Understand and share the data on the execution of Quality Checks with a new Checks Run Report. Easily scan and understand your results with the summary section, Analyze your checks by viewing details by ChangeSet, by check, and by database. And collaborate with your team with shareable report.
* Learn more https://docs.liquibase.com/observability
#### Formatted SQL changelogs can use rollback scripts
* Previously, Formatted SQL ChangeLogs could only run in-line rollback commands. But, sometimes you need something more complex, like a full rollbackSqlFile. This functionality has been available for XML, JSON, and YAML formatted changelogs.
* Learn more https://docs.liquibase.com/concepts/changelogs/sql-format.html
### Liquibase Open Source and Liquibase Pro
#### Liquibase capability enhancements
* The `diffChangeLog` command has been updated only to create a changelog when changes are detected. This is a change from the previous behavior of creating an empty changelog.
* Adds two new `generateChangelog` options:
* `--run-on-change-types=createView,createProcedure` will set `runOnChange="true"` for each changeSet which contains solely `createView` and `createProcedure` changes. For backward compatibility, the default is an empty list.
* `--replace-if-exists=createView,createProcedure` will set `replaceIfExists="true"` for each `createView` and `createProcedure` changes. For backward compatibility, the default is an empty list.
* Fix a bug that previously included substituted properties in the checksum calculation for SQLFile change types
#### JDBC driver updates
* MariaDB JDBC driver updated from 3.2.0 to 3.3.2
* Snowflake JDBC driver updated from 3.14.3 to 3.14.4
* Firebird SQL JDBC driver updated from 5.0.2.java8 to 5.0.3.java8
* SQLite JDBC driver updated from 3.43.2.2 to 3.44.1.0
#### Database platform improvements
##### General
* Adds `create table if not exists` support for the following databases: CockroachDB, DB2 LUW, H2, HSQL, Informix, Ingres9, MariaDB, MySQL, Postgres, and SQLite.
* Fix the generated default column value in PostgreSQL and Oracle for char/clob data types.
##### Maria DB
* Adds Liquibase support for Maria DB 10.10.6 and later's new UUID data type.
* For boolean columns on MariaDB, revert the change made in Liquibase 4.25.1. It has been returned from TINYINT back to TINYINT(1).
##### DB2 z/OS
* Improves support for the empty table precondition.
#### Java API Changes
* AbstractJdbcDatabase now delegates the execution of Changes to the executor, which allows the executor more control over how Changes are executed. This gives executors access to Changes and ChangeSets which enables the management of transaction commits.
* Failure exceptions in ChangeSet.execute are now logged as a SEVERE level for easier access to a concise error message.
### [PRO] Changelog
* DAT-16531: Add labels, contexts, rollback-on-error to update reports runtime info by @abrackx in https://github.com/liquibase/liquibase-pro/pull/1499
* DAT-15455 Refactor ChangelogRewriters to follow general Factory approach by @vitaliimak in https://github.com/liquibase/liquibase-pro/pull/1195
* DAT-16675 add aliases for init copy and project in https://github.com/liquibase/liquibase-pro/pull/1488 by StevenMassaro
* DAT-16640 add rollbackSqlFile to formatted SQL changelog parsingin https://github.com/liquibase/liquibase-pro/pull/1501 by StevenMassaro
* DAT-16054 Implement filters for snapshot command in https://github.com/liquibase/liquibase-pro/pull/1440 by wwillard7800
* DAT-16282 Implement MVEL expression and added tests in https://github.com/liquibase/liquibase-pro/pull/1382 by wwillard7800
* DAT-16684 Checks run report tweaks, add check packages info in https://github.com/liquibase/liquibase-pro/pull/1491 by abrackx
* DAT-16273 Show fully qualified path in console when generating report in https://github.com/liquibase/liquibase-pro/pull/1483 by abrackx
* DAT-13042 Parse LDAP-style URL to create SQLPLUS connection string in https://github.com/liquibase/liquibase-pro/pull/1473 by wwillard7800
* DAT-16237 Styled checks run report in https://github.com/liquibase/liquibase-pro/pull/1481 by abrackx
* DAT-16349 Make sure diffChangelog respects drift arguments in https://github.com/liquibase/liquibase-pro/pull/1461 by wwillard7800
* DAT-16110 Implementation of regex helper checks in https://github.com/liquibase/liquibase-pro/pull/1330 by wwillard7800
* DAT-16500 do not clear a subset of MDC keys when scope exits in https://github.com/liquibase/liquibase-pro/pull/1447 by StevenMassaro
* DAT-16477 Append command name to default report name in https://github.com/liquibase/liquibase-pro/pull/1456 by abrackx
* DAT-16482 Correctly set logLevel on the Liquibase logger in https://github.com/liquibase/liquibase-pro/pull/1433 by wwillard7800
* DAT-16397 add changeset identifier to exceptions thrown from LiquibaseSqlParser in https://github.com/liquibase/liquibase-pro/pull/1443 by StevenMassaro
* DAT-16534 Fix issue with generateChangelog and diffChangelog in https://github.com/liquibase/liquibase-pro/pull/1446 by wwillard7800
* DAT-16330 Remove drift report mode parameter in https://github.com/liquibase/liquibase-pro/pull/1423 by wwillard7800
* DAT-13864 New pending changeset filter for checks run in https://github.com/liquibase/liquibase-pro/pull/1419 by wwillard7800
* DAT-16332 Add pending changes to update report in https://github.com/liquibase/liquibase-pro/pull/1438 by abrackx
## [PRO] Security, Driver and Other Updates
* Bump com.oracle.database.jdbc:ojdbc8 from 19.20.0.0 to 19.21.0.0 #1339 by dependabot bot
### [OSS] Changelog
## New Features
- (#5525) Add labels, context and rollback on error info to report (DAT-16531) @abrackx
- (#5490) DAT-16675: add support for command aliases @StevenMassaro
- (#5406) Allow snapshot control creation to be overridden for snapshot filters DAT-16054 @wwillard7800
- (#5256) Added exclusion for MVEL DAT-16282 @wwillard7800
- (#5336) add default constructor + setters to `RanChangeSet` \& related classes @rursprung
- (#5340) Fixes #2352 by adding support for loading embedded jar files @hayeskl
- (#5164) Write changelog only if changes exist @brachi-wernick
- (#5360) Introduce support for primitive types in new changes @fbiville
- (#5274) Use mariadb UUID when specify UUID type @mohamed-ahrrass-nw
- (#5413) add changeset identifier to exceptions thrown from LiquibaseSqlParser (DAT-16397) @StevenMassaro
- (#5402) Adds pending changesets to update report (DAT-16332) @abrackx
- (#3581) Support create table if not exists @taeyeon-Kim
- (#4635) generateChangelog optionally creates runOnChange=true and replaceIfExists=true for createView changes @mkarg
## Changes
- (#5329) Support runWith executors committing after the change set completes @dzeigler
- (#5452) Log the exception in case of failure in ChangeSet.execute @bignoncedric
- (#5043) Improve support for DB2[z] empty table precondition @MichaelKern-IVV
- (#5424) Moved saved\_state/compareGenerateSql.. directory from java source to resources bundle @MalloD12
- (#5462) map testcontainers to random available host port @StevenMassaro
- (#5457) prevent multiple databases in test classes @StevenMassaro
- (#5416) do not clear a subset of MDC keys when scope exits (DAT-16500) @StevenMassaro
- (#5417) switch integration tests to use h2 where possible (DAT-16015) @StevenMassaro
- (#5347) Added extra space for command help arguments display DAT-13864 @wwillard7800
## Bug Fixes
- (#5522) MariaDB boolean: back to TINYINT(1) instead of TINYINT (MySQL) @famod