| 1 | This is the change log for the perl extension PApp::SQL. |
1 | This is the change log for the perl extension PApp::SQL. |
| 2 | |
2 | |
|
|
3 | 2.002 Mon Mar 4 07:24:49 CET 2019 |
|
|
4 | - support DBD::MAriaDB is sql_insertid. |
|
|
5 | - use DBI's last_insert_id method as fallback, with |
|
|
6 | all undef parameters. |
|
|
7 | |
|
|
8 | 2.001 Sat Oct 7 17:52:36 CEST 2017 |
|
|
9 | - protip: avoid postgres, it's an inefficient pile of garbage code. |
|
|
10 | - work around DBD::Pg (and only DBD::Pg) unnecessarily modifying |
|
|
11 | the first argument of bind_param, likely due to some misguided |
|
|
12 | implementation of some unneccessary extensions requiring |
|
|
13 | non-standard syntax for bind_param. bleah. |
|
|
14 | - minor av_fetch optimisation. |
|
|
15 | |
|
|
16 | 2.0 Sat Jul 28 15:50:52 CEST 2012 |
|
|
17 | - work around some bugs in DBD drivers (SQLite...) instead of |
|
|
18 | crashing. |
| 3 | - use SvOKp to decide whether we should upgrade to utf-8. |
19 | - use SvOKp to decide whether we should upgrade to utf-8. |
| 4 | - since DBD::mysql keeps changing their number detection code |
20 | - since DBD::mysql keeps changing their number detection code |
| 5 | and therefore keeps corrupting our data, call bind_param |
21 | and therefore keeps corrupting our data, call bind_param |
| 6 | with "correctly" deduced types on first first execution |
22 | with "correctly" deduced types on first first execution |
| 7 | of an sql statement. |
23 | of an sql statement. |
| … | |
… | |
| 11 | - switch to FNV-1a hash and actually _do_ hash more than the |
27 | - switch to FNV-1a hash and actually _do_ hash more than the |
| 12 | first character of the sql statement. |
28 | first character of the sql statement. |
| 13 | - check the length of the sql string when deciding whether it is |
29 | - check the length of the sql string when deciding whether it is |
| 14 | too long for caching, do not use the size of the allocated |
30 | too long for caching, do not use the size of the allocated |
| 15 | memory area, which is less useful. |
31 | memory area, which is less useful. |
|
|
32 | - use less mind-boggling but safer method to pass return values to perl. |
| 16 | |
33 | |
| 17 | 1.05 Sun Jun 21 07:13:25 CEST 2009 |
34 | 1.05 Sun Jun 21 07:13:25 CEST 2009 |
| 18 | - check statement handles for active state, to avoid using |
35 | - check statement handles for active state, to avoid using |
| 19 | a cached statement handle that is currently active |
36 | a cached statement handle that is currently active |
| 20 | (good for recursive invocations, and threads). |
37 | (good for recursive invocations, and threads). |
