forked from DBD-SQLite/DBD-SQLite
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathChanges
1382 lines (1154 loc) · 51.9 KB
/
Changes
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
Changes for Perl extension DBD-SQLite
1.76 2024-10-19
- Switched to a production version
1.75_01 2024-09-17
- Upgraded SQLite to 3.46.1
- Fix for Windows quadmath builds (GH#115, sisyphus++)
- Omit load_extension if static build
1.74 2023-09-20
- Switched to a production version
1.73_01 2023-07-09
- Upgraded SQLite to 3.42.0
- Add missing possible table_type values to POD (GH#105, dboehmer++)
1.72 2022-11-04
- Switched to a production version
1.71_07 2022-10-26
- Upgraded SQLite to 3.39.4
1.71_06 2022-03-12
- Set UTF8CACHE to avoid slowdown with -DDEBUGGING (andk, Leont, FGasper)
1.71_05 2022-02-26
- Fix another test failure on perl built with -DDEBUGGING
- Lowercase datatype in table column metadata for backcompat
1.71_04 2022-02-26
- Fix test failure on perl built with -DDEBUGGING (andk++)
1.71_03 2022-02-23
- Upgraded SQLite to 3.38.0
- Expose sqlite_error_offset introduced in 3.38.0
1.71_02 2022-01-07
- Upgraded SQLite to 3.37.2
- Improve sqlite_load_extension doc (GH#94, Derek Lamb++)
1.71_01 2021-12-02
- Upgraded SQLite to 3.37.0
- Add a feature to unregister a created function
- Fix accented characters in POD (GH#90, HaraldJoerg++)
1.70 2021-08-01
- Switched to a production version
1.69_02 2021-07-30
- Fix doc to use the correct attribute with sqlite_ (GH#86, eekboek++)
- Modify the fix to silence the sqlite_unicode warning not to check
the attribute twice
- Fix an encoding issue of naive (GH#83, HaraldJoerg++)
1.69_01 2021-07-30
- Typo (GH#85, grr++)
- Silenced deprecation warning of sqlite_unicode not to break
tests of existing applications
1.68 2021-07-22
- Switched to a production version
1.67_07 2021-06-19
- Upgraded SQLite to 3.36.0
1.67_06 2021-06-14
- Experiment with another quadmath patch to see if it works
with an older version of FreeBSD
1.67_05 2021-06-13
- Made DBD_SQLITE_STRING_MODE constants exportable
1.67_04 2021-05-31
- Upgraded SQLite to 3.35.5
- Stop setting THREADSAFE=0 if perl has pthread (ie. 5.20+)
(Bjoern Hoehrmann++, GH#69, #72)
- Fixed a memory leak in ::VirtualTable
- Introduced "string_mode" handle attribute (Felipe Gasper++)
to fix long-standing issues of sqlite_unicode (GH#78, #68)
- Added a dependency from dbdimp.o to the *.inc files included
into dbdimp.c (Laurent Dami++, GH#74)
- Fixed an offset issue of VirtualTable (Laurent Dami++, GH#75)
1.67_03 2021-03-31
- Upgraded SQLite to 3.35.3
- Enabled math functions introduced in SQLite 3.35
- Fix quadmath issues (Tux++, leont++)
1.67_02 2020-12-06
- Upgraded SQLite to 3.34.0
- Added a few new constants
- Added sqlite_txn_state method to see internal state
of the backend
1.67_01 2020-11-24
- Switched to XSLoader (GH#63; toddr++)
- Use quadmath_snprintf if USE_QUADMATH is defined
- Use av_fetch instead of av_shift (norimy++)
1.66 2020-08-30
- Switched to a production version
1.65_03 2020-07-27
- Upgraded SQLite to 3.32.3
1.65_02 2020-02-08
- Upgraded SQLite to 3.31.1
1.65_01 2020-01-18
- Upgraded SQLite to 3.30.1
- Added several SQL_ types as alias (pali++)
- Fixed two initialization issues (ppisar++)
- Allowed create_function to return an array reference
to specify the type of the value
1.64 2019-08-12
- Switched to a production version
1.63_05 2019-07-12
- Upgraded SQLite to 3.29.0
- Added sqlite_get_autocommit private method (GH#52)
- Addded new db_config constants, notably to prohibit
double-quoted string literals
1.63_04 2019-05-25
- Upgraded SQLite to 3.28.0
- Modified doc for sqlite_db_filename which actually returns undef
or an empty string (GH#50)
- Fixed ->quote($blob, SQL_BLOB) to quote correctly (GH#51, pali++)
1.63_03 2019-02-15
- Applied a patch to fix segmentation fault on 32-bit big-endian
platforms by Niko Tyni (GH#45)
1.63_02 2019-02-14
- Upgraded SQLite to 3.27.1
- Let a URI filename test skip if SQLite is compiled with URI filename
support (GH#47)
1.63_01 2019-01-26
- Made sure an internal hv is initialized (GH#45)
- Fixed a number of tests to skip
- Bumped up Test::More requirement
- Replaced bundled Test::NoWarnings with Test::FailWarnings
- Handle 'unknown' op in DBD::SQLite::VirtualTable::PerlData (Corion++)
1.62 2018-12-29
- Switched to a production version
1.61_04 2018-12-22
- Added sqlite_db_config method and new constants for it
- Added sqlite_defensive option to disallow dangerous SQLite features
- Exposed some of the hidden extended result codes
1.61_03 2018-12-19
- Upgraded SQLite to 3.26.0, which reportedly has a security fix
1.61_02 2018-12-01
- Added sqlite_backup_from_dbh/sqlite_backup_to_dbh methods
- Introduced sqlite_prefer_numeric_type database handle attribute
that changes the value of TYPE statement handle attribute
from an array of string to an array of integer, as an experimental
feature. Setting this may break your applications.
- Changed preferred bugtracker
1.61_01 2018-12-01
- Added ability to configure SQLITE_MAX_LENGT with environmental
variable (Roy Storey)
- Added sqlite_limit database handle method to change run-time limits
- Upgraded SQLite to 3.25.3
- Updated constants
1.60 2018-12-01
- Switched to a production version
1.59_03 2018-11-03
- Added a note on the long standing bug on TYPE statement
handle attribute
- Applied a doc patch on Virtual::PerlData by Björn Höhrmann
(GH-31)
1.59_02 2018-09-30
- Upgraded SQLite to 3.25.2
1.59_01 2018-09-17
- Upgraded SQLite to 3.25.0, with ALTER TABLE ... RENAME COLUMN
and UPSERT among others
- Added ::GetInfo (GH#32, Brendan Byrd)
- Fix to use a PV value as a virtual table column value
where appropriate (RT-124941)
- Add deferrability to foreign_key_info (mohawk2)
1.58 2018-03-28
- Switched to a production version.
1.57_01 2018-03-21
- Made it an error to fetch attributes from a statement
handle whose database handle is inactive (ribasushi++)
1.56 2018-02-28
- Switched to a production version.
1.55_07 2018-01-27
- This is a developer release to help testing DBIx::Class
- Upgraded SQLite to 3.22.0
- Disabled two STAT compile time options (tentatively),
which fixes RT-124227 anyway
1.55_06 2018-01-27
- This is a developer release to help testing DBIx::Class
- Downgraded SQLite to 3.19.3 because of a SQLite regression
(RT-124227, ribasushi++)
- Fixed some tests to adapt to a change in error format
introduced by the latest DBI
- Remove no warnings test from t/43_fts.t which failed under
some environments
1.55_05 2017-12-16
- Implemented ParamValues statement handle attribute (RT-123886)
1.55_04 2017-11-22
- Updated SQLite to 3.21.0
- Resolved #122581: statistics_info() doesn't work correctly
(John Deighan)
- Fixed typo (GH#26, ReneNyffenegger)
- Silenced some warnings (GH#25, Jacques Germishuys)
- Fixed no dot in @INC issue (GH#24, ribasushi)
- Fixed zero-length BLOB value is retrieved as undef
(GH#23, SATO Kentaro)
- Fixed VirtualTable::PerlData to use new ops added in SQLite 3.21.0
(GH#28, fschlich)
- noted on sqlite_extended_result_codes handle attribute
1.55_03 2017-02-14
- Updated SQLite to 3.17.0
1.55_02 2017-01-08
- Updated SQLite to 3.16.2
- Fixed statistics_info when only unique indexes were requested (Dave
Rolsky++). GitHub #21
1.55_01 2017-01-04
- Updated SQLite to 3.16.0
1.54 2016-12-24
- Switched to a production version.
- Resolved RT#119219: Trivial documentation bug in DBL::SQLite 1.52
1.53_01 2016-11-26
- Re-enabled perl tokenizer by calling sqlite_db_config
if SQLite >= 3.12
1.52 2016-11-15
- Switched to a production version.
1.51_07 2016-10-16
- Downgraded SQLite to 3.13.0 (RT#118395)
1.51_06 2016-10-15
- Updated SQLite to 3.15.0
1.51_05 2016-06-23
- Updated SQLite to 3.13.0
- Resolved #115465: column_info doesn't parse sizes with spaces
(ilmari++)
- Added two missing function declarations (rurban++)
1.51_04 2016-03-07
- Updated SQLite to 3.11.1, which fixed an FTS5 index
corruption issue
1.51_03 2016-02-20
- No code change
- Resolved #112220: t/62_regexp_multibyte_char_class.t fails
for perl >= 5.22.0 and non-utf8 locale (SREZIC++)
1.51_02 2016-02-20
- No code change; fixed a newly added test that only passed
under recent perls (>= 5.18)
1.51_01 2016-02-20
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Updated to SQLite 3.11.0.
As upstream disabled two-arg fts3_tokenizer() for security concern,
DBD::SQLite also stopped enabling it by default. If you do need
perl tokenizer, compile/install with SQLITE_ENABLE_FTS3_TOKENIZER
environmental variable.
- Applied a doc patch by Salvatore Bonaccorso
- Enabled (experimental) FTS5
- Fixed REGEXP function to work under sqlite_unicode correctly
(András Farkas++)
1.50 2016-02-11
- Switched to a production version.
1.49_08 2016-01-30
- no significant code changes
- Resolved RT#111558: Virtual table tests depend on enhanced
query syntax availability (vlmarek++)
- Ingore FTS tests if FTS is not available
1.49_07 2016-01-21
- Updated to SQLite 3.10.2, which fixed a case-folding bug
in the LIKE operator introduced in SQLite 3.10.0.
1.49_06 2016-01-15
- Updated to SQLite 3.10.1, which fixed an old bug that could
generate incorrect results when a scalar subquery attempts
to use the block sorting optimization.
1.49_05 2016-01-11
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Updated to SQLite 3.10.0.
Because of the addition of LIKE/GLOB/REGEXP support on
virtual tables, previous ::PerlData virtual table got broken.
This is hopefully fixed by adding strlike/strglob functions
to DBD::SQLite but if you use this virtual table, please
test it carefully.
- Now you can make a database connection read-only if you
turn on the ReadOnly attribute when you connect. (RT #110439)
If you set it after you connect to a database, DBD::SQLite
warns because the database doesn't actually become read-only.
- Improved ::Constants
- to load DBD::SQLite by itself
- to expose SQLITE_VERSION_NUMBER
- introduced a few new (shorter) tags
1.49_04 2015-11-24
- Updated ::Constants
- Fixed a sqlite version number in a test (GH-14; NANIS++)
1.49_03 2015-11-05
- Updated to SQLite 3.9.2, with JSON support
1.49_02 2015-10-10
- Added a workaround to resolve #106950 Extra warnings
with savepoints (hopefully)
- Not to run tests for table_column_metadata unless
ENABLE_COLUMN_METADATA is set
1.49_01 2015-08-04
- Updated to SQLite 3.8.11.1
- Resolved #106151 SAVEPOINT bug
- Made sure to keep what's left in unprepared_statements when
allow_multiple_statements is set. (GH #11)
1.48 2015-06-12
- Switched to a production version. (ISHIGAKI)
1.47_05 2015-05-08
- Updated to SQLite 3.8.10
1.47_04 2015-05-02
- Used MY_CXT instead of a global variable
1.47_03 2015-04-16
- Added :all to EXPORT_TAGS in ::Constants
1.47_02 2015-04-16
- Updated to SQLite 3.8.9
- Added DBD::SQLite::Constants, from which you can import any
"useful" constants into your applications.
- Removed previous Cygwin hack as SQLite 3.8.9 compiles well again
- Now create_function/aggregate accepts an extra bit
(SQLITE_DETERMINISTIC) for better performance.
1.47_01 2015-02-17
*** (EXPERIMENTAL) CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Commented OPTIMIZE out of WriteMakefile (RT #94207).
If your perl is not compiled with -O2, your DBD::SQLite may
possibly behave differently under some circumstances.
(This release is to find notable examples from CPAN Testers).
- Set THREADSAFE to 0 under Cygwin to cope with an upstream
regression since 3.8.7 (GH #7).
- Updated to SQLite 3.8.8.2
- Resolved #35449: Fast DBH->do (ptushnik, ISHIGAKI)
1.46 2014-12-10
- Switched to a production version. (ISHIGAKI)
1.45_06 2014-11-26
- Silenced a compile-time warning (Unescaped left brace
in regex is deprecated) in PerlData virtual table
under bleadperl
1.45_05 2014-11-25
- Updated to SQLite 3.8.7.2
- Restored regexp support in PerlData virtual table
by secure reimplementation using closure (DAMI++)
1.45_04 2014-10-28
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Changed to apply quotemeta() to parameters while building
a query for a virtual table using PerlData for security.
(RIBASUSHI++ and MAUKE++) (DAMI, ISHIGAKI)
1.45_03 2014-10-25
- Fixed regression of 0 as integer (ISHIGAKI)
1.45_02 2014-10-23
- Improved int overflow handling under 32bit strawberry perl
(ISHIGAKI)
1.45_01 2014-10-22
- Updated to SQLite 3.8.7 (ISHIGAKI)
- Resolved #76395 (hopefully): int values over 32 bit in length
produce an error "datatype mismatch" (ISHIGAKI)
1.44 2014-10-22
- Switched to a production version. (ISHIGAKI)
1.43_09 2014-10-20
- Resolved #99583: Legacy DOS 8.3 filename support incompatible
with SQLITE WAL journal mode (spotted by Pat Horton) (ISHIGAKI)
- 1.43_07/08 were not VC6 compatible (ISHIGAKI)
1.43_08 2014-08-21
- Updated to SQLite 3.8.6, which should fix a unique index
issue: see http://www.sqlite.org/src/info/9a6daf340df99ba93c
for details (ISHIGAKI)
1.43_07 2014-07-30
- Resolved #97598: Crash on disconnect with virtual tables (FTS4)
(patch and test code by Rob++) (ISHIGAKI)
1.43_06 2014-07-22
- Fixed compile error/warning for older perls (reported by ribasushi)
(ISHIGAKI)
1.43_05 2014-07-21
- No significant code changes; removed unnecessary dependencies.
1.43_04 2014-07-21
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Resolved #96877: sql statements should be converted to utf8 (DAMI)
If you set sqlite_unicode to true, SQL statements will be upgraded
to avoid inconsistency between embedded params and bind params.
- Resolved #96494: [PATCH] add SYSTEM TABLE to table_info() type
list (MJP)
- Supported virtual tables in Perl, and added two sample tables
(DAMI++)
1.43_03 2014-06-12
- Updated to SQLite 3.8.5, which should fix query planner's
issues in SQLite (ISHIGAKI)
- Fixed busy_timeout to accept 0 to disable (reported by zdm)
(ISHIGAKI)
- Resolved #95511: primary_key_info fails to return names for
named primary keys (Kenneth Kroenlein)
- Resolved #96050: Segfault in disconnected sqlite_db_filename
(reported by Alex Vandiver) (ISHIGAKI)
1.43_02 2014-03-26
- Limited -std=gnu99 to solaris gcc only, though it may be
harmless in many cases (mattp++) (ISHIGAKI)
1.43_01 2014-03-26
- Added -std=gnu99 for solaris gcc users (reported by mattp++)
(ISHIGAKI)
1.42 2014-03-20
- Switched to a production version. (ISHIGAKI)
1.41_07 2014-03-13
- Updated to SQLite 3.8.4.1, which fixed several obscure bugs on
"ORDER BY" or "DISTINCT". (ISHIGAKI)
1.41_06 2014-02-12
- Updated to SQLite 3.8.3.1, which fixed a SQLite bug in 3.8.2
(bundled in DBD::SQLite 1.41_04/5) that could cause queries to
omit valid out rows. (ISHIGAKI)
1.41_05 2014-01-22
- Resolved #92322: Failure under heavily parallelized tests
(ISHIGAKI)
- Disabled Test::NoWarnings in a test
1.41_04 2014-01-12
- Updated to SQLite 3.8.2 (ISHIGAKI)
- Resolved #90211: Error in documentation (Felix Li)
- Resolved #89351: DBD-SQLite won't compile on Cygwin 64 bit
(Warren Young++) (ISHIGAKI)
- Tweaked sqlite_see_if_its_a_number not to guess data types of
bind values with explicit type specification (via bind_param()
etc) (mje++, ilmari++) (ISHIGAKI)
1.41_03 2013-09-05
- Updated to SQLite 3.8.0.2 (ISHIGAKI)
1.41_02 2013-08-30
- Updated to SQLite 3.8.0.1 to resolve #88228 (RIBASUSHI++)
(ISHIGAKI)
1.41_01 2013-08-27
*** NOTICE ON NEXT GENERATION QUERY PLANNER ***
- As of SQLite 3.8.0, SQLite's query planner has been rewritten.
According to the author, the new query planner should give
exactly the same result (though perhaps with a little less CPU
time spent planning) for simple queries, and for complex
queries, it can in many cases provide a much faster answer.
See http://www.sqlite.org/queryplanner-ng.html for details.
*** NOTICE ON PARTIAL INDICES ***
- Database files created by SQLite 3.8.0 are still readable and
writable by prior versions, but if you use partial indices
introduced in SQLite 3.8.0, those files become unreadable and
unwritable by older versions of (DBD::)SQLite. They'll be
readable/writable again by dropping partial indices.
- Resolved #87435: PATCH: statistics_info perldoc (DDICK)
- Resolved #87297: URI filenames in DBD::SQLite (ISHIGAKI)
1.40 2013-07-28
- NetBSD also doesn't like the _XOPEN_SOURCE hack (ISHIGAKI)
- Resolved #86080: PATCH: statistics_info support (DDICK)
1.39 2013-05-31
- Production release, no changes from 1.38_05
1.38_05 2013-05-31
- OpenBSD doesn't like the previous _XOPEN_SOURCE hack (ISHIGAKI)
- Disabled a unicode-related test for older perls (ISHIGAKI)
1.38_04 2013-05-29
- Tentatively defined _XOPEN_SOURCE under *BSD systems to see
if it solves a compilation issue for threaded perls (ISHIGAKI)
1.38_03 2013-05-20
*** NOTICE ON QUERY OPTIMIZER ENHANCEMENT ***
- As of SQLite 3.7.15, SQLite's query optimizer was enhanced
and the result order of a SELECT statement without an ORDER
BY clause may be different from the one of the previous
versions. If your applications or tests mistakenly depend
on the arbitrary output order, they may be broken with this
enhancement.
- Updated to SQLite 3.7.17 (ISHIGAKI)
- Fixed tests that mistakenly made invalid assumptions about
the result order (ISHIGAKI)
- Added a brief note on useful pragmata. (ISHIGAKI)
- Resolved #85302: type fixes (ISHIGAKI)
1.38_02 2013-04-04
- Updated to SQLite 3.7.16.1 (ISHIGAKI)
- Removed two obsolete pragma calls at login time (ISHIGAKI)
- Resolved #80344: Set SQLITE_DISABLE_DIRSYNC on AIX (suggested
by Steve Barnsley) (ISHIGAKI)
- Resolved #81536: primary_key_info returns the wrong KEY_SEQ
(VLYON)
- Resolved #84027: Finalizer() not called in (D. Richard Hipp)
- Resolved #84372: -Wpointer-sign warnings with utf8_hop
(RURBAN)
- Resolved #84373: Add test for RT #26775 "name)" key with
DISTINCT (RURBAN/ISHIGAKI)
- Resolved #70815: DBD::SQLite 1.33 build is broken under
Solaris using Sun C (RURBAN)
- Resolved #84380: Fix WINLIKE for mingw/msys (RURBAN)
- Added a note on DBD::SQLite and File::Temp (suggested by
TOKUHIROM) (ISHIGAKI)
1.38_01 2012-09-24
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Resolved #56444: immediate transaction should be on by
default, and the doc be updated.
If you really need the deferred transaction (which had long
been the default), set sqlite_use_immediate_transaction
to false explicitly. (ISHIGAKI)
- Updated to SQLite 3.7.14 (ISHIGAKI)
- Added support for foreign_key_info (DAMI/ISHIGAKI)
- Added several methods to retrieve internal information such as
table_column_metadata/db_filename/*_status (ISHIGAKI/VOVKASM)
- Added sqlite_load_extension so that extensions can add
functions internally (ISHIGAKI)
- Resolved #77617: atoll () sometimes just is atol () (GAAS)
- Resolved #48084: improper "require utf8" in tests (ISHIGAKI)
- Resolved #77724: bug in primary_key_info with regard to column
names containing whitespace (ISHIGAKI)
- Resolved #79364: variance example of the doc (ISHIGAKI)
- Resolved #78833: utf8 flag for column names (JAMADAM)
(This hopefully resolved #72418 as well)
- Resolved #64177: ping() wipes out the errstr (ISHIGAKI)
- Resolved #79576: (patch) bind_param don't work with PADTMP
scalars (VOVKASM)
- Refactored primary_key_info to support attached databases
(ISHIGAKI)
1.37 2012-06-12
- Updated to SQLite 3.7.12.1 (ISHIGAKI)
1.36_04 2012-05-19
- Final developer release
- Updated to SQLite 3.7.12 (ISHIGAKI)
- Tweaked Makefile.PL to behave better during the Bsymbolic
check (HMBRAND)
- Added SQLITE_WITHOUT_ZONEMALLOC for older MacOS X (ISHIGAKI)
1.36_03 2012-05-07
- Updated to SQLite 3.7.11 (ISHIGAKI)
- Fix >32bit integer truncation and other sqlite_set_result
condition issue (Yuriy Kaminskiy)
- Fix integer overflow in passing argument to perl function
(Yuriy Kaminskiy)
- Convert unsigned -> int64 when possible (Yuriy Kaminskiy)
- Turned datatype mismatch error (introduced in 1.34_02) into
a warning (you can disable this warning by setting PrintWarn
attribute to false). (ISHIGAKI)
- Refactored sqlite_is_number to fix various corner cases
(ISHIGAKI)
1.36_02 2012-02-23
- Downgraded SQLite to 3.7.9, as 3.7.10 turned out to be
broken on the latest MacOS X (due to a missing symbol),
and broke other modules that typically use temporary tables
under a few environments too. As of this writing, would-be
3.7.11 seems fine, but it would take another month to be
released. (ISHIGAKI)
1.36_01 2012-01-19
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Updated to SQLite 3.7.10 (ISHIGAKI)
Note that this release changed the default schema format
number, that means newly created database files will be
unreadable by SQLite version prior to 3.3.0 (2006-01-10)
(or DBD::SQLite prior to 1.12) unless you explicitly issue
"PRAGMA legacy_file_format=ON".
- Enabled SQLITE_ENABLE_FTS4
- Enabled SQLITE_ENABLE_STAT3
- Resolved #73159: FTS tokenizer segfault (ISHIGAKI)
- Resolved #73787: sqlite_see_if_its_a_number causes a buffer
overflow (ISHIGAKI)
- Resolved #73314 for DBD-SQLite: binding of 64bit integers fail
on 1.34_02 (ISHIGAKI)
- Implemented sqlite_trace and sqlite_profile methods for simpler
tracing/profiling; use DBI_TRACE/DBI_PROFILE for more
complicated cases (ISHIGAKI)
1.35 2011-11-29
- Updated to SQLite 3.7.9 (ISHIGAKI)
- One small potential break case if you are using FTS4 and ^
1.34_03 2011-11-01
- Adding an explicit dynamic_config => 1 (ADAMK)
- bind_param SQL_INTEGER error now actually dies with RaiseError.
(ISHIGAKI)
1.34_02 2011-10-21
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Resolved #67581: bind_param SQL_INTEGER numifies value;
Now DBD::SQLite croaks if you explicitly specify datatype
(with bind_param) and datatype mismatch happens (ISHIGAKI)
- Datatype set in the bind_param(_array) becomes sticky now
(as per DBI spec). This potentially affects code depending on
current undocumented and broken behavior. (Yuriy Kaminskiy)
- Resolved #71311: binding output columns as SQL_BLOB returns
nothing (ISHIGAKI)
- Bsymbolic flag was not portable enough and was not silently
ignored under MacOSX. Needs to check harder to see if the
linker supports the option. (ISHIGAKI)
- Fixed binding named parameters. (Yuriy Kaminskiy)
- Moved check for bind_ph/is_inout so it always error-out.
(Yuriy Kaminskiy)
- Don't set imp_sth->stmt to NULL on error path (Yuriy Kaminskiy)
- Explained an issue of rollback with unfinished statements.
(ISHIGAKI)
1.34_01 2011-09-22
- Updated to SQLite 3.7.8 (ISHIGAKI)
- Made util/getsqlite.pl work properly for SQLite 3.7.5+ (ISHIGAKI)
- Cookbook: don't use globals (Yuriy Kaminskiy)
- Resolved #70135 and hopefully other mod_perl/CentOS issues like
#63873 and #47983, with a patch by MDOOTSON++ (ISHIGAKI)
1.33 2011-05-20
- Production release, no changes from 1.32_04
1.32_04 2011-05-20
- Updated to SQLite 3.7.6.3 (ISHIGAKI)
- Made util/getsqlite.pl state that it needs fixing to work for
SQLite 3.7.5+ when it dies at the last step, and outline what the
user needs to do manually instead, until getsqlite is fixed (DUNCAND)
1.32_03 2011-05-12
- Updated to SQLite 3.7.6.2 (ISHIGAKI)
- Resolved #67843 for DBD-SQLite: savepoint rollback alters AC
state (ISHIGAKI)
1.32_02 2011-03-07
- Updated to SQLite 3.7.5 (ISHIGAKI)
- Resolved #65267 for DBD-SQLite: Add RTree support option;
skip fts3/metadata tests if those features are disabled
(ISHIGAKI)
- Resolved #65267: Add RTree support option (CJFIELDS)
- Added sqlite_see_if_its_a_number database handle attribute
to deal with issues caused by (quoted) bind values against
numbers such as return values from a function etc. (ISHIGAKI)
1.32_01 2010-12-10
- Made util/getsqlite.pl work with the amalg distro filename changes
introd by SQLite 3.7.4, and still with older ones also (DUNCAND)
- Updated to SQLite 3.7.4 (DUNCAND)
- Resolved #61355: Fails testing in parallel (ISHIGAKI)
- Resolved #61361: Problems building 1.31 with system SQLite (ISHIGAKI)
- Resolved #61117: Supporting database as an alias for dbname in
DSN (ISHIGAKI)
- Resolved #62370: Segfaults during operations on disconnected
handles (ISHIGAKI)
- Resolved #61958: REGEXP should return NULL when one of its
arguments is NULL (ISHIGAKI)
- Removed PrintWarn tweak introduced in 1.19_09 (Tim Bunce's
advice) (ISHIGAKI)
1.31 2010-09-15
- Production release, identical to 1.30_06
1.30_06 2010-09-09
- Resolved # 60860: Slow but steady memory leak on
last_insert_id calls (ISHIGAKI)
- Moved DBD::SQLite::FTS3Transitional into a dedicated dist (DAMI)
- Updated bundled Test::NoWarnings to 1.02 (ADAMK)
- Slightly bumped Test::More and added Test::Builder dependencies,
because they are inherited from the bundled Test::NoWarnings (ADAMK)
- Upgraded ppport.h to the latest version (ADAMK)
1.30_05 2010-08-27
- Test::NoWarnings bundled in the "inc" directory was ignored
in a new test. (ISHIGAKI)
1.30_04 2010-08-25
- Updated to SQLite 3.7.2 (DUNCAND)
- Resolved #60698: "Test failures with SQLite 3.7", using included
patch by Niko Tyni ([email protected]) of t/lib/Test.pm (DUNCAND)
- Added support for FTS3 tokenizers written in Perl. Added tests
and documentation on how to use FTS3. Changed compilation flag
to use the recommanded -DSQLITE_ENABLE_FTS3_PARENTHESIS
*** MAY POSSIBLY BREAK OLD APPLICATIONS THAT ALREADY USED FTS3 ***
(DAMI)
- Fixed various backward compatibility issues back to SQLite 3.6.1
(ISHIGAKI)
- Resolved #58332: Documentation error for preventing fsync
(ISHIGAKI)
1.30_03 2010-05-21
- Updated to SQLite 3.6.23.1 (ISHIGAKI)
- Resolved #56693: [PATCH] Fix spelling errors (patch by
Ansgar Burchardt) (ISHIGAKI)
- Added compile_options() to get compile options (ISHIGAKI)
- Fixed punctuation; suggested by Father Chrysostomos (ISHIGAKI)
- Ignore unknown collations, as they may be installed without
using DBD::SQLite's api. This should help ICU plugin. (ISHIGAKI)
1.30_02 2010-03-30
- Implemented sqlite_use_immediate_transaction database handle
attribute to avoid deadlocks easily (ISHIGAKI)
- Resolved #55466: Problem with names in DB that using square
bracers (ISHIGAKI)
- Added SQLITE_ENABLE_LOCKING_STYLE=0 for Mac OSX to avoid
compile error (ISHIGAKI)
1.30_01 2010-03-10
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Resolved #54271: Inserting a string with utf-8 flag on
corrupts BLOB data; now BLOB data is always stored as bytes
(without the utf-8 flag) even if it has the flag set (ISHIGAKI)
- Updated to SQLite 3.6.23 (DUNCAND)
- Implemented NUM_OF_PARAMS statement handle attribute (ISHIGAKI)
- Added experimental "sqlite_allow_multiple_statements"
database handle attribute, and "sqlite_unprepared_statements"
statement handle attribute, to allow processing a SQL dump.
(ISHIGAKI)
- Resolved #53579: Added a note and a test of placeholders.
(ISHIGAKI)
- Resolved #45113, which was actually an issue of dequoting
primary key column names (ISHIGAKI)
- You can now retrieve some of the statement handle attributes
before you execute. (ISHIGAKI)
- Added preamble to copy sqlite3.[hc] files into a share
directory (where you can access via File::ShareDir) to allow
extension authors to use the same C source/header as they
used to build DBD::SQLite itself. (ISHIGAKI)
1.29 2010-01-08
- Updated to SQLite 3.6.22 (DUNCAND)
1.28_02 2010-01-03
- Now empty (or comment only) statements won't cause segv
or "not an error" errors. Spotted by TOKUHIROM. (ISHIGAKI)
- Resolved #52573: previous fix always turned on the AutoCommit
flag; it goes along with the behavior of the internal library
but broke compat. (ISHIGAKI)
- Removed the SQLITE_CORE and SQLITE_PRT_SZ flags at the recommendation
of the SQLite mailing list. (ADAMK)
1.28_01 2009-12-22
- Updated to SQLite 3.6.21 (ISHIGAKI)
- Silence warnings on HP-UX (HMBRAND)
- Resolved #52573: Manual Transaction handling seems to be
broken (hopefully) (ISHIGAKI)
1.27 2009-11-23
- Switching to a production version
1.26_07 2009-11-15
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Foreign keys support is once again disabled by default.
It seems to have a greater impact than we expected and
it actually broke things. This feature probably will be
enabled by default by the sqlite team in the future, and
eventually you'll need to cope with it, but right now we
agreed with some discussion to give you more time to be
prepared. If you use referential stuff in your schema
(which sqlite ignores now) should do extensive testing
to ensure that they will work when you issue "PRAGMA
foreign_keys = ON". (ISHIGAKI)
- Updated to SQLite 3.6.20 (DUNCAND)
- Resolved #50935: there remained old "unicode" attribute usage
in the pod, spotted by ASHLEY. (ISHIGAKI)
1.26_06 2009-10-28
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Removed undocumented (and most probably unused) reset method
from a statement handle (which was only accessible via func().)
Simply use "$sth->finish" instead. (ISHIGAKI)
- Now DBD::SQLite supports foreign key constraints by default.
Long-ignored foreign keys (typically written for other DB
engines) will start working. If you don't want this feature,
issue a pragma to disable foreign keys. (ISHIGAKI)
- Renamed "unicode" attribute to "sqlite_unicode" for integrity.
Old "unicode" attribute is still accessible but will be
deprecated in the near future. (ISHIGAKI)
- You can see file/line info while tracing even if you compile
with a non-gcc compiler. (ISHIGAKI)
- Major code refactoring. (ISHIGAKI)
- Pod reorganized, and some of the missing bits (including
pragma) are added. (ISHIGAKI)
1.26_05 2009-10-15
- Updated to SQLite 3.6.19 (ISHIGAKI)
1.26_04 2009-10-06
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Resolved #49716: Fixed $dbh->column_info to work according to
the spec in DBI and added support for attached databases. (VLYON)
- Fixed $sth->primary_key_info to work according to the spec in DBI
and changed the tests in t/27_metadata.t to reflect this. (VLYON)
- Tweaked not to hide a real error by a "not an error" issued
by another sqlite3 function between the failed sqlite3 function
and the sqlite_error to report. Note that this change makes
some failures issue two relevant errors at a time. (ISHIGAKI)
- Updated to SQLite 3.6.18 (DUNCAND)
- Resolved #48393: previous effort was not enough; BegunWork
should also be handled properly (ISHIGAKI)
- Replaced last DBILOGFP with DBIc_LOGPIO(imp_xxh) (ISHIGAKI)
- Tweaked t/08_busy.t not to fail just because it is tested
under a very, very slow (virtual) machine. (ISHIGAKI)
- Added a code to look for a compiler from Module::Install::Can.
(ISHIGAKI)
- Added documentation and an 'Escape' attribute for $sth->table_info.
(VLYON)
1.26_03 2009-08-12
- Updated to SQLite 3.6.17 (ISHIGAKI)
- Switched to use :memory: for most of the tests (ISHIGAKI)
- Fixed a memory leak when prepare should fail (ISHIGAKI)
- Added support for commit/rollback/update hooks (DAMI)
- Added support for set_authorizer (DAMI)
- Added support for collation_needed(), and reorganised driver API
for user-defined collations (DAMI)
- Exported constants from sqlite3.h into DBD::SQLite namespace (DAMI)
- Added support in t/lib/Test.pm for checking both versions of
driver-private methods ("func" / "sqlite_*") (DAMI)
- Removed unused and obsolete "list_tables" from SQLite.xs (DAMI)
- Added a default implementation for the REGEXP infix operator (DAMI)
- Renamed several internal sqlite3_ functions to sqlite_
for clarity (ISHIGAKI)
- Accept empty filename at connect (sqlite will open a tempfile) (DAMI)
- Documented the connect() method (DAMI)
- Replaced imp_dbh->in_tran with sqlite3_get_autocommit(), hoping
this would fix the annoying rollback issues, including #48393
(ISHIGAKI)
- META.yml requires is now generated instead of being derived from the
(incorrect) PREREQ_PM values by ExtUtils::MakeMaker (ADAMK)
1.26_02 2009-06-19
*** CHANGES THAT MAY POSSIBLY BREAK YOUR OLD APPLICATIONS ***
- Resolved #46831: table_info schema is incorrect and doesn't
work with attached databases (VLYON/ISHIGAKI)
- Updated to SQLite 3.6.15 (DUNCAND)
- Resolved #44882: Use of $h->func() should be deprecated and
replaced with calls to driver-private 'installed methods'
(ISHIGAKI)
- Added access to Online Backup functionality. (TJC)
- Added enable_load_extension pod (ISHIGAKI)
- Now private methods/functions return true after successful
calls (#44871) (ISHIGAKI)
- Removed all of the "croak"s (#44871) (ISHIGAKI)
1.26_01 2009-05-05
- Added ORDINAL_POSITION support for $dbh->column_info (ADAMK)
- Applied several fixes from GFUJI to clean up code (#45578)
(ISHIGAKI)
- Skipped some of the unicode path tests under cygwin (#45166)
(JDHEDDEN)
- Added some explanation and workarounds for a SQL that
compares a return value of a function with a numeric bind
value (ISHIGAKI)
1.25 2009-04-23
- Amalgamation conversion turned out to be quicker than expected.
- Changing to a production release. (ADAMK)
1.24_02 2009-04-22
- Merging various externally-contributed annotations from
annocpan.org (ADAMK)
- Created the beginnings of a DBD::SQLite::Cookbook (ADAMK)
1.24_01 2009-04-22
- Moved getsqlite.pl into util (ADAMK)
- Switching to the RT queue instead of the RT report page that
does nothing and just refers you to email (ADAMK)
- Now DBD::SQLite also uses amalgamated source recommended at sqlite.org (ISHIGAKI)
- Resolved #45166: better unicode path handling under cygwin (ISHIGAKI)
- Resolved #45171: test failure on CentOS 4.6 (ISHIGAKI)
1.23 2009-04-19
- No changes from 1.22_08, just switched to production release (ADAMK)
1.22_08 2009-04-17
- Completed the migration of all tests and deleted lib.pl (ADAMK)
- Prevented a double "commit is innefective" warning (ADAMK)
- Adding a version for the Win32.pm dependency (ADAMK)
1.22_07 2009-04-16
- Improved non-latin unicode filename support/test
on Windows (SZABGAB/ISHIGAKI)
- Removed the table name generator from t/lib.pl,
getting us closer to removing t/lib.pl entirely (ADAMK)
- Increased use of Test::NoWarnings (ADAMK)
- Converted half the remaining lib.pl tests to t::lib::Test (ADAMK)
- Require Win32.pm on Windows (CHORNY)
1.22_06 2009-04-15
- Simplifying various miscellaneous code (ADAMK)
- Adding support for non-latin unicode filenames on Windows (ADAMK)
1.22_05 2009-04-15
- Hopefully the last dev release before the next production release.
- Updated to SQLite 3.6.13 (DUNCAND)
- Setting svn:eol-style to native to prevent EOL issues (ADAMK)
- Resolved #44861: tweaked Makefile.PL to support older HP-UX (ISHIGAKI)
1.22_04 2009-04-11
- Adding support parsing attributes out of the DSN (ADAMK)
- Inserted pTHX_/aTHX_ for better efficiency (suggested in #44884 by TIMB) (ISHIGAKI)
- Dropping support for uncode before 5.8.5 to simplify support and
to prevent people hurting themselves on platforms that don't
properly support Unicode anyway (ADAMK)
- Stopped guessing if a bind param looks like a number or not
(suggested by GUIDO). This reopens #29058 and #29629, but
there are two workarounds for them. 1) Use "bind_param"
explicitly (rather than plain "execute", as you do for BLOB).
2) Add "+0" to the appropriate part(s) of your SQL to let
sqlite convert them into a number. (ISHIGAKI)
1.22_03 2009-04-10
- Resolved #44876: Patch to fix includes in the SQLITE_LOCATION case by janus (ISHIGAKI)
- Added PERL_NO_GET_CONTEXT for efficiency (suggested in #44884 by TIMB) (ISHIGAKI)
- Refactored error handling (suggested in #44884, #44871 by TIMB) (ISHIGAKI)
1.22_02 2009-04-09
- Added missing documentation bits for 'create_collation'
and 'progress_handler' (DAMI)
- Resolved RT#25924 (Arguments to user-defined functions do not
respect unicode setting) (DAMI)
- Added comments on the return values on error, and fixed another
wrong return value in execute (ISHIGAKI)
- Added SQL_NULLABLE_UNKNOWN; still wonders if the error above
should be ignored or not (ISHIGAKI)
1.22_01 2009-04-09
- Resolved #25371: Calls sv_utf8_upgrade on strings going into
the database to make sure latin-1 strings are not saved as
Malformed UTF-8 character in the SQLite TEXT column (MIYAGAWA)
1.21 2009-04-09
- Fixed the issue that execute on inactive handles returned
0 instead of undef, which made a DBIC test broken (ISHIGAKI)
1.20 2009-04-07