/
releaseNotes.html
4228 lines (4040 loc) · 187 KB
/
releaseNotes.html
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
---
layout: documentation
menu: releaseNotes
subtitle: Release Notes
---
<h1>Release Notes</h1>
<p>Thank you all for reporting all these issues and contributing fixes!</p>
<div class="release">
<h2 id="5.1.4">Flyway 5.1.4 (Unreleased)</h2>
<h3>New features</h3>
<ul>
{% include issue.html id="2054" title="Additional SQL*Plus SET commands support (ESCAPE, FLAGGER, HEADING)" pro=true %}
{% include issue.html id="2059" title="Warn about MariaDB driver usage when connection to MySQL 5.5+" %}
</ul>
<h3>Bug fixes</h3>
<ul>
{% include issue.html id="2051" title="PostgreSQL: clean fails when trying to drop aggregates added by extensions" %}
{% include issue.html id="2052" title="Regression Issue: Checksums invalid for blank migrations applied in v5.0.7 and below" %}
{% include issue.html id="2053" title="Repeatable migrations produce invalid SQL during dry-run" %}
</ul>
<p>
Thanks to CatalinaMoisuc, Craig Davidson and Paul Chown for reporting these issues fixes.
</p>
</div>
<div class="release">
<h2 id="5.1.3">Flyway 5.1.3 (2018-06-20)</h2>
<h3>Bug fixes</h3>
<ul>
{% include issue.html id="2028" title="Unable to clean schema that contains a user-defined function with schemabinding in SQL Server" %}
{% include issue.html id="2031" title="Warning: Input stream has been finalized or forced closed without being explicitly closed" %}
{% include issue.html id="2037" title="Upgrade Maven plugins to protect against Zip Slip" pr="2037" %}
{% include issue.html id="2041" title="Sybase 15.7: Incorrect syntax near 'GO'" %}
{% include issue.html id="2042" title="Workaround a bug in windows cmd" pr="2042" %}
{% include issue.html id="2045" title="Info: Synthetic migrations (like SCHEMA) should not show up as repeatable" %}
{% include issue.html id="2046" title="ErrorOverrides fail to override warning into error" %}
{% include issue.html id="2047" title="Batching sometimes executes statements twice" %}
</ul>
<p>
Thanks to Dar Brett, Esteban Marin, Piotrek Żygieło, seneiran and sullis for reporting these issues and contributing fixes.
</p>
</div>
<div class="release">
<h2 id="5.1.2">Flyway 5.1.2 (Skipped due to build process failure)</h2>
</div>
<div class="release">
<h2 id="5.1.1">Flyway 5.1.1 (2018-05-28)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1803">Issue 1803</a>
Postgres "ERROR: must be superuser to create a base type" during clean of DOMAIN
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2026">Issue 2026</a>
ErrorOverrides should also work with negative error codes
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2027">Issue 2027</a>
Getting 'ERROR: Validate failed' after upgrading from 5.0.7 to 5.1.0
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2029">Issue 2029</a>
Regression in 5.1.0 regarding non-transactional migrations including comments
</li>
</ul>
<p>
Thanks to Patrick Kohan, Peter Matseykanets and Simon Kissane for reporting these issues.
</p>
</div>
<div>
<h2 id="5.1.0">Flyway 5.1.0 (2018-05-24)</h2>
<p><strong>DO NOT USE: This release contains an important checksum validation <a href="https://github.com/flyway/flyway/issues/2027">regression</a> which has been fixed in 5.1.1.</strong></p>
<h3>New features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/94">Issue 94</a>
Batch updates for SQL statements {% include pro.html %}
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/104">Issue 104</a>
Informix support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/615">Issue 615</a>
Stream parser for SQL migrations {% include pro.html %}
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1315">Issue 1315</a>
SQL Callbacks - more than one .sql file per event
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1392">Issue 1392</a>
Callbacks for errors
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1675">Issue 1675</a>
ErrorOverrides: override errors into warnings and warnings into errors {% include pro.html %}
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1738">Issue 1738</a>
Allow extending classpath in gradle task config
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1738"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1865">Issue 1865</a>
New option to allow for 'Ignored' migrations in 'validate' command: `ignoreIgnoredMigrations`
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1866"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1877">Issue 1877</a>
Maven: Add a workingDirectory parameter to support relative filesystem locations in conf files
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1883">Issue 1883</a>
SQL*Plus variable substitution support {% include pro.html %}
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1928">Issue 1928</a>
Fluent configuration using API
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1936">Issue 1936</a>
Environment variable configuration using API
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1970">Issue 1970</a>
CockroachDB 2.0 support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1980">Issue 1980</a>
Provide a default implementation of `Configuration` as part of the API
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2003">Issue 2003</a>
MySQL 8.0 support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2019">Issue 2019</a>
Java 10 support
</li>
</ul>
<h3>Incompatible Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1707">Issue 1707</a>
<code>FlywayConfiguration.getCallbacks()</code> now returns <code>Callback[]</code> instead of <code>FlywayCallback[]</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1707">Issue 1707</a>
<code>Flyway.getCallbacks()</code> now returns <code>Callback[]</code> instead of <code>FlywayCallback[]</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1865">Issue 1865</a>
'Ignored' migrations now trigger an error by default. The old more lenient behavior can be restored by setting `ignoreIgnoredMigrations` to `true`
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1883">Issue 1883</a>
SQL*Plus support is now disabled by default and must be explicitly activated using the new <code>oracle.sqlplus</code> flag
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1928">Issue 1928</a>
<code>Flyway</code> now implements <code>Configuration</code> instead of <code>FlywayConfiguration</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1928">Issue 1928</a>
<code>FlywayConfiguration.getLocations()</code> now returns <code>Location[]</code> instead of <code>String[]</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1928">Issue 1928</a>
<code>Flyway.getLocations()</code> now returns <code>Location[]</code> instead of <code>String[]</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1928">Issue 1928</a>
<code>Flyway.getSchemas()</code> now returns an empty array (instead of the connection's default schema) if no schemas were set using <code>setSchemas()</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1946">Issue 1946</a>
<code>FlywayConfiguration.getEncoding()</code> now returns <code>Charset</code> instead of <code>String</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1946">Issue 1946</a>
<code>Flyway.getEncoding()</code> now returns <code>Charset</code> instead of <code>String</code>
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1707">Issue 1707</a>
<code>FlywayCallback</code> and <code>BaseFlywayCallback</code> have been deprecated in favor of <code>Callback</code>.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1928">Issue 1928</a>
<code>FlywayConfiguration</code> has been deprecated in favor of <code>Configuration</code>.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1989">Issue 1989</a>
Flyway Command-line now ships with H2 1.4.197
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2007">Issue 2007</a>
Flyway Command-line now ships with MariaDB JDBC driver 2.2.4
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2013">Issue 2013</a>
Flyway Command-line now ships with Derby 10.14
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2014">Issue 2014</a>
Flyway Command-line now ships with JRE 8u172
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2015">Issue 2015</a>
Flyway Command-line now ships with SQL Server JDBC driver 6.4.0
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2016">Issue 2016</a>
Flyway Command-line now ships with PostgreSQL JDBC driver 42.2.2
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/100">Issue 100</a>
Clean tries to drop a function from an extension and fails
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1362">Issue 1362</a>
Header comment on stored procedure
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1420">Issue 1420</a>
Line break settings are not respected (Windows)
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1707">Issue 1707</a>
Non-transactional SQL callbacks failing after upgrade to 4.2.0
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1876">Issue 1876</a>
Postgres COPY FROM STDIN fails on data containing string delimiters
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1892">Issue 1892</a>
Allow executing info while a migration is running
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1917">Issue 1917</a>
CommandLine Help / Usage for Community Editions shows PRO commands and options
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1918">Issue 1918</a>
UNC path support for filesystem locations
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1922">Issue 1922</a>
LogFactory should use same classloader for feature detection and loading the correct logcreator
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1923">Issue 1923</a>
Flyway Maven Plugin can't find JDBC driver if the driver is a dependency with scope provided
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1924">Issue 1924</a>
Too much memory allocations
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1926">Issue 1926</a>
PostgreSQL: Flyway uses "public" schema instead of current_schema when search_path starts with $user
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1927">Issue 1927</a>
Flyway 5 regression when line in multi line string starts with single line comment
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1932">Issue 1932</a>
Do not delete types that extensions depend on when cleaning PostgreSql
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1932"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1940">Issue 1940</a>
PostgreSQL: Ignore objects created by extensions when checking whether a schema is empty
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1943">Issue 1943</a>
Flyway schema creation issue on Oracle 12.2 DB with password policy enabled
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1945">Issue 1945</a>
COPY ... FROM stdin throws "missing data for column" error
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1948">Issue 1948</a>
On PostgreSql the alternate quote string literal is not detected if it is not followed by a space
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1950">Issue 1950</a>
Repair dry-run: java.lang.IndexOutOfBoundsException
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1955">Issue 1955</a>
Redshift: Unable to create uppercase schema history table
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1959">Issue 1959</a>
PostgreSQL search path not restored properly after migrations when auto-comit == false
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1968">Issue 1968</a>
JDBC Migration failures not entered into schema_version table
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1979">Issue 1979</a>
Support for tnsnames.ora if TNS_ADMIN is set (issue #1806) does not work correctly
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1983">Issue 1983</a>
Failure on creation of a schema history table on an empty database when autoCommit is false
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1989">Issue 1989</a>
Clean cannot drop schema with H2 1.4.197 and newer
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1992">Issue 1992</a>
CREATE SUBSCRIPTION PostgreSQL statement not detected as non-transactional
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2011">Issue 2011</a>
SQL Server parsing issue when string literal is followed by as keyword without a space in between
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/2025">Issue 2025</a>
Baseline migration is always updated when repairing
</li>
</ul>
<p>
Thanks to aebaugh, AndrasJanurik,
andrey-poltavskiy, Bartosz Kamiński, Ben Manes, bigslack, Brett Randall, Brian O'Halloran,
brodgers-oreilly, Chuck May, cmcmurtrie, Craig Davidson, Daniel Huss, Dmitrii Apanasevich,
Jens Doose, jezovuk, jMediaConverter, Kevin Sheedy, Konrad Botor, Leo Breuss,
luengnat, Manikanta G, nireno, nkbysani, Oleg Artenii, Peter Wippermann, Punnapulusu, Razvan,
Sandra Parsick, Simon Gamma, TimoTHa, umapathy08, Wim Deblauwe and Yannik Hampe for reporting these issues.
</p>
</div>
<div class="release">
<h2 id="5.0.7">Flyway 5.0.7 (2018-01-30)</h2>
<h3>Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1912">Issue 1912</a>
Flyway now requires the Java 9 compiler to build. Java runtime compatibility is unchanged.
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1901">Issue 1901</a>
DB2 parsing issue when END IF is split across lines
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1906">Issue 1906</a>
CLI flyway specified drivers directory via jarDirs not applied
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1907">Issue 1907</a>
Off-by-one error for installed_rank in dry run scripts
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1911">Issue 1911</a>
Make it clearer that a Dry Run does not modify the database
</li>
</ul>
<p>
Thanks to buuren and David Atkinson for reporting these issues.
</p>
</div>
<div class="release">
<h2 id="5.0.6">Flyway 5.0.6 (2018-01-16)</h2>
<h3>New features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1897">Issue 1897</a>
Info should also print the current schema version
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1878">Issue 1878</a>
DB2 Stored procedure scripts which run in 4.1.2 fail to execute in 5.0.2
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1890">Issue 1890</a>
MigrationInfoImpl (still) violates compareTo contract
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1893">Issue 1893</a>
flyway schema version table creation fails after SQL callback execution
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1894">Issue 1894</a>
Missing semi colon in the dryrun SQL to insert into the flyway_schema_history table
</li>
</ul>
<p>
Thanks to aebaugh, David Atkinson, Lyor Goldstein and Rob34 for reporting these issues and contributing fixes.
</p>
</div>
<div class="release">
<h2 id="5.0.5">Flyway 5.0.5 (2018-01-04)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1882">Issue 1882</a>
Add Maven artifact install and deploy scripts
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1884">Issue 1884</a>
Undo command does not respect the expected order when used with target
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1885">Issue 1885</a>
Location that only contains repeatable Migrations leads to ArrayIndexOutOfBounds
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1886">Issue 1886</a>
Incorrect WARNING: Ignoring unsupported SQL*Plus statement when "column" text appears on a new line
</li>
</ul>
<p>
Thanks to David Atkinson, David J. M. Karlsen, ImmanuelRhesa and quentinbricard
for reporting these issues and contributing fixes.
</p>
</div>
<div class="release">
<h2 id="5.0.4">Flyway 5.0.4 (2018-01-02)</h2>
<h3>New features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1882">Issue 1882</a>
Add Maven artifact install and deploy scripts
</li>
</ul>
<h3>Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1881">Issue 1881</a>
Update copyright to 2018
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1498">Issue 1498</a>
Cannot load migration SQL scripts from the root of the classpath in a jarfile
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1875">Issue 1875</a>
SAPHANATable.doDrop() should drop with CASCADE
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1879">Issue 1879</a>
Support for Redshift statements which cannot be run inside a transaction
</li>
</ul>
<p>
Thanks to Gareth Rogers, Jonathan Bregler and Matyas Albert Nagy
for reporting these issues and contributing fixes.
</p>
</div>
<div class="release">
<h2 id="5.0.3">Flyway 5.0.3 (2017-12-20)</h2>
<h3>New features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1872">Issue 1872</a>
SQL*Plus: Add SHOW EDITION support
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/502">Issue 502</a>
sp_MSForeachtable statement hangs
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1250">Issue 1250</a>
One connection is used for all migrations causes an issue with session params redefined
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1508">Issue 1508</a>
Support for cleaning SQL Server Rule and Default objects
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1633">Issue 1633</a>
Implementing MigrationInfoProvider.getDescription() returning String longer than 200 characters
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1676">Issue 1676</a>
SQL Server USE statements within migration cause Flyway to fail
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1838">Issue 1838</a>
SQL Server migration batch terminator as first statement gives empty query error
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1861">Issue 1861</a>
SET SERVEROUTPUT ON Not working in 5.0.1 trial
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1869">Issue 1869</a>
Unknown configuration property: flyway.skip when property set to false or null
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1873">Issue 1873</a>
Support for cleaning SQL Server DATABASE triggers
</li>
</ul>
<p>
Thanks to Ayrat Natfullin, Catchwa, gscht,
mahidbdw, mpapetti, Patrik Duditš and vencoreguy for reporting these issues and contributing fixes.
</p>
</div>
<div class="release">
<h2 id="5.0.2">Flyway 5.0.2 (2017-12-08)</h2>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/1859">Issue 1859</a>
Validation error with schema_version table name
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1862">Issue 1862</a>
Gradle plugin not published successfully
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1863">Issue 1863</a>
flyway -dryRunOutput causes a migrate when a colon is used instead of =
</li>
</ul>
<p>
Thanks to David Atkinson, Marceau Dewilde and Tommy Odom for reporting these issues and contributing fixes.
</p>
</div>
<div class="release">
<h2 id="5.0.1">Flyway 5.0.1 (2017-12-07)</h2>
<p>This release is identical to Flyway 5.0.0. It only adds the platform specific distribution of Flyway Command-line
which were missing in Flyway 5.0.0.</p>
</div>
<div class="release">
<h2 id="5.0.0">Flyway 5.0.0 (2017-12-07)</h2>
<p><strong>Important note for users upgrading from Flyway 3.x:</strong> This release no longer supports a schema history
table upgrade from Flyway 3.x. You must upgrade to Flyway 4.2.0 first before upgrading to Flyway 5.0.0.</p>
<p><strong>Important note for EnterpriseDB, Vertica, SolidDB, Phoenix and Greenplum:</strong>
Support for these databases has been kept back and will be integrated later in the Flyway 5.0 series.
You can keep using Flyway 4.2.0 until then.</p>
<h3>New features</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/87">Issue 87</a>
Output to sql file instead of committing against the DB
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/109">Issue 109</a>
Undo migrations
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/797">Issue 797</a>
Official Flyway Dockerfile
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/809">Issue 809</a>
Promote internal logging wrapper to external API
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/944">Issue 944</a>
Allow to use paths relative to flyway.conf location
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1562">Issue 1562</a>
Add flyway.configFiles support to Gradle plugin
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1624">Issue 1624</a>
Multiple configuration files
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1663">Issue 1663</a>
Support TestContainers JDBC connection string
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1693">Issue 1693</a>
Command-line: Add -D support to define JVM system properties
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1699">Issue 1699</a>
Command-line: allow setting system properties in config file
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1727">Issue 1727</a>
Command-line: JAVA_ARGS environment variable support
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1728">Issue 1728</a>
Command-line: Use Windows CLASSPATH environment variable
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1733">Issue 1733</a>
Redshift JDBC 4.2 driver support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1742">Issue 1742</a>
Allow Multiple Suffixes/File Extensions
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1754">Issue 1754</a>
Allow injecting a complete Configuration
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1760">Issue 1760</a>
CockroachDB support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1777">Issue 1777</a>
Sybase ASE jConnect JDBC driver support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1804">Issue 1804</a>
Repair: also correct migration type
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1806">Issue 1806</a>
Oracle: Automatically enable support TNSNames aliases if TNS_ADMIN is set
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1819">Issue 1819</a>
Flyway Command-line now ships with the official Microsoft JDBC driver for SQL Server
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1845">Issue 1845</a>
Oracle SQL*Plus commands support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1849">Issue 1849</a>
Show output from select statements in console
</li>
</ul>
<h3>Incompatible changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/109">Issue 109</a>
The <code>FlywayCallback</code> interface has 4 new methods:
<code>beforeUndo</code>, <code>beforeEachUndo</code>, <code>afterEachUndo</code> and <code>afterUndo</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/109">Issue 109</a>
The <code>MigrationInfoProvider</code> interface has 1 new method: <code>isUndo</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/109">Issue 109</a>
The <code>MigrationState</code> enum has 2 new elements: <code>AVAILABLE</code> and <code>UNDONE</code>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1402">Issue 1402</a>
Maven 3 is now the new minimum supported version
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1429">Issue 1429</a>
Gradle 3.0 is now the new minimum supported version
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1577">Issue 1577</a>
Flyway now fails on incorrect parameter instead of showing a warning
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1692">Issue 1692</a>
Java 8 is now the new minimum supported version
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1818">Issue 1818</a>
Sybase ASE 15.7 is now the new minimum supported version
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1820">Issue 1820</a>
DB2 z/OS support has been discontinued
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1827">Issue 1827</a>
Redshift users must now connect using the Redshift driver. Connections with the PostgreSQL driver are no longer supported.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1841">Issue 1841</a>
MigrationState.SUPERSEEDED has now been renamed to SUPERSEDED
</li>
<li>Oracle 12.1 is now the new minimum supported by Flyway Community Edition</li>
<li>SQL Server 2014 is now the new minimum supported by Flyway Community Edition</li>
<li>DB2 10.5 is now the new minimum supported by Flyway Community Edition</li>
<li>MySQL 5.5 is now the new minimum supported by Flyway Community Edition</li>
<li>MariaDB 5.5 is now the new minimum supported by Flyway Community Edition</li>
<li>PostgreSQL 9.3 is now the new minimum supported by Flyway Community Edition</li>
<li>SAP HANA 2.0 is now the new minimum supported by Flyway Community Edition</li>
<li>HSQLDB 2.0 is now the new minimum supported by Flyway Community Edition</li>
<li>Derby 10.11 is now the new minimum supported by Flyway</li>
</ul>
<h3>Changes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/pull/1752">Issue 1752</a>
Flyway Command-line now ships with MariaDB JDBC driver 2.2.0
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1752"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1756">Issue 1756</a>
Flyway Command-line now ships with PostgreSQL JDBC driver 42.1.4
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1822">Issue 1822</a>
Flyway Command-line now ships with H2 1.4.196
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1823">Issue 1823</a>
Flyway Command-line now ships with HSQLDB 2.4.0
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1824">Issue 1824</a>
Flyway Command-line now ships with SQLite 3.20.1
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1848">Issue 1848</a>
The default for flyway.table has been changed from schema_version to flyway_schema_history
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1850">Issue 1850</a>
The Flyway Command-line platform-specific archives now ship with JRE 8u152
</li>
</ul>
<h3>Bug fixes</h3>
<ul>
<li>
<a href="https://github.com/flyway/flyway/issues/183">Issue 183</a>
Multiline RULE declarations are not parsed correctly
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1167">Issue 1167</a>
Clean on DB2 functions or procedures fails when two procedures have the same name
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1750"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1305">Issue 1305</a>
Maven warning when using Flyway plugin with parallel builds
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1336">Issue 1336</a>
State column contents truncated in Info command
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1361">Issue 1361</a>
Clean fails to DROP AGGREGATE in SQL Server
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1426">Issue 1426</a>
SQL Server: ALTER DATABASE ... SET SINGLE_USER not supported
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1550">Issue 1550</a>
Numerous flaws in Clean implementation for Oracle DB
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1601"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1554">Issue 1554</a>
validate does not respect target
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1575">Issue 1575</a>
Command info: Comparison method violates its general contract
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1601">Issue 1601</a>
Clean improvements for Oracle pt.2
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1601"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1620">Issue 1620</a>
Flyway logs passwords at INFO level
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1625">Issue 1625</a>
Callbacks are added and executed multiple times
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1627">Issue 1627</a>
Appengine & ClassPathScanner : throw AccessControlException since 4.1.0
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1634">Issue 1634</a>
DB2 inserting of triggers fails, depending on the format of the statement
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1636">Issue 1636</a>
Metadata table creation error is not reported
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1642">Issue 1642</a>
Java error when running flyway from bash shell of Git for Windows
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1643"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1649">Issue 1649</a>
flyway:clean fails on db2 when trying to drop versioning on tables which is accessed by a MQT
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1650"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1654">Issue 1654</a>
Deadlock produced in Postgres when running migrations in parallel with a migration task containing CREATE INDEX CONCURRENTLY
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1656"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1678">Issue 1678</a>
ignoreMissingMigrations default not specified
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1686">Issue 1686</a>
Gradle plugin warning after migrating to Gradle 4.0
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1853"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1690">Issue 1690</a>
Support for labels preceding DB2 SQL PL BEGIN ... END block
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1691">Issue 1691</a>
DB2 stored procedure nested block support
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1694">Issue 1694</a>
Can't use Use MSDB in SQL server
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1701">Issue 1701</a>
Table.exists() very slow in Postgres Environments with a lot of objects
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1702"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1711">Issue 1711</a>
SQL Server BACKUP and RESTORE statements broken
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1713">Issue 1713</a>
Suppress redundant "SQLite does not support setting the schema..." messages
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1723">Issue 1723</a>
Anonymous block in SAP HANA is not working
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1726">Issue 1726</a>
outOfOrder parameter value not validated
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1729">Issue 1729</a>
Resource leak detected enabling Strict Mode on Android platform
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1730"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1732">Issue 1732</a>
Cannot create metadata table in DB2 when default table organization is set to column
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1757">Issue 1757</a>
Warn on incompatible class change
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1764">Issue 1764</a>
USE sql command leaks to subsequent migration files
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1782">Issue 1782</a>
First character in script column of schema_version table removed if double back slashes in location.
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1802">Issue 1802</a>
Clean fails when Postgres DOMAIN depends on SEQUENCE
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1813">Issue 1813</a>
Checksum mismatch error not helpful
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1817">Issue 1817</a>
DB2 truncate statement fails under Flyway 4.2.0
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1831">Issue 1831</a>
Incorrect Redshift search_path parsing
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1842">Issue 1842</a>
Oracle: Ignore lone /
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1846">Issue 1846</a>
Oracle statement fails when it contains DATE'11/29/2017' and no space in between
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1847">Issue 1847</a>
Documentation is not clear about the definition of missing and future migration
</li>
<li>
<a href="https://github.com/flyway/flyway/issues/1851">Issue 1851</a>
CockroachDb invalid default database name
<span class="label label-info"><a href="https://github.com/flyway/flyway/pull/1852"><i
class="fa fa-mail-reply"></i> Pull Request</a></span>
</li>
<li>
<a href="https://github.com/flyway/flyway/pull/1854">Issue 1854</a>
Adding comment surrounding usage of Oracle TNS Connection string
</li>
</ul>
<p>
Thanks to Alexei Osipov, andrey-poltavskiy, aoksys, Carl Taylor, Christopher Smith, Craig Davidson, czyzby,
Dennis Hoer, djohnsonmach, FlakM, Francesco Proietti, George Thomas, Gili Tzabari,
hmtelbi, Igor Nikolaev, J0s3f, Jason Hinch, Jasper Brekelmans, Jasper van Wanrooy, jcoulehan,
Jeffrey Li, Jens Doose, Jidehem, John McCall, Joshy Austin, jsross, Julien Coupez, Kevin Bloch,
masc3d, Mattias Sällström, Mihir Mehta, mstarita, nvartolomei,
o2dac, pswrdf, rbatllet, Renat Sabitov, Rob34, RobertRad, Roger Qiu,
Sabine Heimsath, sandman24, sasivarnans,
Simon Kissane, Stefano Teodorani,
Stephan Pauxberger, Tibor Baksa, ToBeReplaced, Victor Osolovskiy, vojbarzz,
wanglin0413, xindu and Yogi2803 for reporting these issues and contributing fixes.
</p>
<h2 id="4.2.0">Flyway 4.2.0 (2017-04-27)</h2>
<h3>New features</h3>
<ul>
<li>