Debian Codegraph @

CHANGES

raw
1 Release 1.26
2 Fix missing conditional statements for "new" datatypes introduced with
3 ASE 15.x
4
5 Release 1.25
6 Fix issue in bigtime/bigdatetime ISO conversion.
7 Allow ability to set configuration options via environment
8 variables (see README)
9
10 Release 1.24
11 Added support for asymmetric password encryption.
12 Fix issue with milliseconds not being returned for bigdatetime in ISO mode.
13
14 Release 1.23
15
16 Fix failing binding of integer values to unsigned int columns
17 when using placeholders.
18
19 Release 1.22
20
21 Map prepare_cached as prepare to avoid various issues with
22 transactions.
23
24 Release 1.20
25
26 Fix issue with locale variable incorrectly set on AIX.
27 Allow passwords > 32 characters.
28
29 Release 1.19
30
31 Fix compilation issue when CS_BIG_TIME is not defined.
32
33 Release 1.18
34
35 Fix further issues with FreeTDS.
36 Improved error handling for numeric/decimal values.
37 Fix logic error in the finish() call when syb_flush_finish is enabled.
38
39 Release 1.17
40
41 Fix various longstanding build issues with FreeTDS and/or MS-SQL
42 Update CPAN metadata to reflect github repo
43
44 Release 1.16
45
46 Fix buffer overflow with ASE 16.x
47
48 Release 1.15
49
50 Minor fixes to allow building on Windows.
51 Fixed syntax error at compile time for some compilers
52 Allow database names with special chars in the name.
53 Change to ct_data_info() to flag an error in case the CS_IODESC returned
54 doesn't include a valid text pointer - this happens if the text/image column
55 is nullable and has not been initialized in the database.
56
57 Release 1.14
58
59 Fix bad size handling for unicode data.
60 Remove default charset setting to utf8 (this had been done in 1.11 as part of
61 improved utf8 handling, but has negative side-effects. If unicode handling is needed
62 then set "charset=utf8" as part of the connection string.
63 Enforce the fact that utf8/unicode handling only works with OpenClient 15.x or later.
64
65 Release 1.13
66
67 Fix for incorrect UTF8 handling when retrieving UNICODE data (Jean-Pierre Rupp).
68
69 Release 1.12
70
71 Bug/Typo/Compatibility fixes with various versions of OpenClient.
72 Experimental: Handle in/out parameters (Merijn Broeren)
73
74 Release 1.11
75
76 Remove reliance on PERL_POLLUTE.
77 Add better support for utf8 (Dave Rolsky)
78
79 Release 1.10
80
81 Handle 15.x datatypes correctly.
82 Add LONGMS date format symbol to handle microseconds for bigdatetime.
83 Add support for CS_LONGCHAR_TYPE (Mark Aufflick)
84 Document syb_isdead().
85 Handle 64bit builds with FreeTDS (Ian Grant/Hans Kristian Rosbach)
86 Add foreign_key_info & statistics_info (Jim Radford)
87 Change behavior of large fixed precision numeric types (money, bigint)
88 to be converted to a string internally and returned as such to the caller
89 (behavior similar to numeric/decimal). This can be reverted to the old behavior
90 by defining SYB_NATIVE_NUM.
91
92 Release 1.09
93
94 Behavior change: A new connection level attribute (syb_disconnect_in_child)
95 has been added to allow automatical handling of InactiveDestroy across
96 forks. By default in 1.09 a connection will NOT get closed if the process
97 ID of the process that is exiting is not the same as the PID of the
98 process that created the connection.
99 Detect ASE error 5702 (The server is terminating this process) as a fatal
100 error for the connection.
101
102 Bug Fixes
103
104 645 - Spurious COMMIT calls sent to the dataserver during the login/connect calls.
105 628 - Increase size of Kerberos Principal string buffer
106 627 - Spurious sigset_t declaration.
107
108 Release 1.08
109
110 Detect missing libblk.a library, and disable the BLK api calls
111 if necessary.
112 Added code to force dlopen() to use RTLD_GLOBAL.
113 Corrected ct_option() functionality detection.
114 Fixed incorrect handling of bind_params() (Thanks to Tim Bunce).
115 Added serverType DSN parameter.
116 Added tds_keepalive DSN parameter.
117 Fixed incorrect handling of multiple result sets with DBI
118 1.53 and later.
119 Re-wrote $dbh->ping() in C, it's now four times faster.
120 Allow automated build without prompts.
121 Improved nsql().
122 Added corrected handling of DATE and TIME values (ASE 12.5.2 and later).
123 Added handling of UNSIGNED INT and BIGINT (ASE 15 and later).
124 Added PERL_NO_GET_CONTEXT #define.
125
126 Bug Fixes
127
128 624 - Empty strings incorrectly passed as NULL.
129 616 - Spurious error message when the login request times out.
130 614 - Documentation improvement for syb_xxx methods.
131 610 - Segfault when using signals with the threaded libraries and
132 perl >= 5.8.
133
134
135 Release 1.07
136
137 Changed the t/xblk.t test to lookup the charset used by the
138 server and specify this in the connect() string. This should
139 avoid failures when the client and server uses charsets of
140 different sizes (utf8 vs. iso_1, for example).
141 Better error reporting when the connection data is incorrect
142 for the test scripts.
143 Modified $dbh->ping() slightly.
144
145 Bug Fixes
146
147 604 - Add missing mode parameter to mkdir in t/xblob.t
148 606 - Memory leak in the BLK API.
149
150 Release 1.06
151
152 Fix off-by-one error for ISO date format.
153 Clear error/warning when connecting to a Replication Server.
154 Fix AutoCommit "off" behavior when CHAINED mode is turned off.
155 Fix $dbh->begin_work() behavior.
156
157 Note: This version fails 4 tests in t/xblk.t when building
158 against the 15.0 Beta OCS libraries.
159
160 Bug Fixes
161
162 582 - ISO date formatting off by one for months.
163 591 - NUM_OF_PARAMS isn't handled properly
164 593 - Connection can become unusable due a bug in
165 get_server_version().
166 597 - Prepared stored procs with placeholders return
167 corrupted recordset on second fetch.
168 599 - The call to "prepare" also executes the statement.
169 600 - $sth->finish sometimes fails to properly clean up the
170 handle.
171
172 Release 1.05
173
174 BEHAVIOR CHANGE - $dbh->{LongReadLen} must now be called
175 before $dbh->prepare(). Previously you could call this after
176 the $dbh->prepare() but before the $sth->execute().
177
178 Install private statement handle methods for TEXT/IMAGE handling
179 to avoid $h->func() calls, and update documentation.
180 Implement experimental BLK API via prepare/execute loop.
181 Change default "AutoCommit" off mode from explicit transactions
182 to using the "chained" mode if it is available.
183 Add $sth->syb_describe() call, taken from Sybase::CTlib's
184 ct_describe().
185 Add ISO8601 date/time format for output.
186 Fix $sth->finish() behavior when syb_flush_finish is turned on.
187 Changed do { } while($sth->{syb_more_results}); idiom to use
188 redo instead.
189 Better/more consistent handling of multiple sth on a single dbh,
190 and new test file.
191
192 Bugs Fixed:
193
194 580 - Binding binary/varbinary values to placeholders sometimes
195 fails.
196 575 - Fails three tests under Tru-64.
197 577 - perl Makefile.PL fails if umask is 0.
198 578 - Better warning for calling $dbh->{LongReadLen} if $dbh is busy.
199 572 - Minor documentation update for bind_param().
200
201 Release 1.04
202
203 Bugs Fixed:
204
205 566 - $sth->{NAME} fails right after prepare().
206
207 Release 1.03
208
209 Added linking of threaded Sybase libs if perl is built with
210 threading turned on.
211 Added CLONE() method.
212 Minor changes to dbdimp.c to be thread-safe.
213 Added t/thread.t test script.
214 Changes to Makefile.PL to make configuration easier.
215 Add support for Kerberos-based network login.
216 Handle new library names (libsybct vs. libct).
217 Make sure that cached statement handle attributes (NAME_lc, etc)
218 are cleared when multiple result sets are processed.
219 Add host and port connection properties, to allow connections
220 to ASE servers that are not defined in the interfaces file
221 (requires OCS 12.5.1)
222 Add ability to dynamically increase the maximum number of
223 connections (thanks to Ed Avis).
224 Add ability to ignore stored proc return status in nsql() (thanks
225 to Merijn Broeren)
226 Fix Makefile.PL umask() issue on Win32 (thanks to Darin Delegal).
227
228 Bugs Fixed:
229
230 541 - $sth->{NAME} fails right after prepare().
231 551 - Tests fail when using perl 5.6.1.
232 556 - Add support for user-supplied SSL certificate file.
233 557 - type_info_all broken with ASE 11.0.x
234 562 - syb_flush_finish doesn't work during the connect() phase.
235 563 - Memory leak when syb_binary_images is set.
236
237
238 Release 1.02
239
240 Added syb_server_version attribute. This is filled in at connect()
241 time with the numeric version number (11.0.3.3, 12.5.1, etc) of the
242 server that you are connected to.
243
244 Bugs Fixed:
245
246 520 - t/exec.t fails on Win32.
247 533 - logic error in deadlock retry in nsql().
248 532 - t/xblob.t test provides false positive for win32.
249 534 - Placeholder prepare() fails with ASE 11.0.x
250
251 Release 1.01
252
253 Automatically finish() statement handles if they are re-executed
254 before all the rows have been fetched.
255 Added support for new tables() syntax, thanks to Stephen Wilcoxon.
256 Added support for DATE and TIME datatypes (available in the
257 ASE 12.5.1 release, currently undergoing beta testing).
258 Allow user to specify a database to use for the tests instead of
259 using "tempdb" (useful if user does not have SA privileges).
260
261 Bugs Fixed:
262
263 517 - getpwnam() isn't portable.
264 493 - Second execute on a prepared handle fails.
265 487 - Add connection information to error messages.
266 407 - Second+ statement does not use db from "use database".
267
268 Release 1.00
269
270 Added data_sources().
271 Allow "SQL_BINARY" placeholder parameters to be passed either
272 as a hex string (with or without leading 0x), or as raw binary
273 data.
274
275 Bugs Fixed:
276
277 477 - segfault when servermsg_cb is called with a null connection
278 480 - Makefile.PL searches system dirs before PERL5LIB dirs when
279 looking for DBI installation.
280 485 - Incorrect handling of large varbinary columns on fetches.
281 489 - (same as 497, see below).
282 492 - Can't compile on Win2k.
283 494 - Do not try to use the ocs.cfg file if it exists.
284 495 - Incorrect handling of parameters when using placeholders &
285 stored procs.
286 497 - implicit type conversions with prepared statements often fail
287 503 - Binary placeholders with stored procedures.
288 506 - Default scriptName/hostname connect() params.
289 508 - DBD::Sybase doesn't build under Win2k.
290
291 Release 0.95
292
293 Support for building DBD::Sybase in 64 bit mode with the
294 64 bit version of OpenClient on Solaris, HP-UX, AIX, etc.
295 (note that perl itself must also be built in 64 bit
296 mode for this to work!)
297
298 Added column_info() method.
299
300 Added G_EVAL flag to syb_err_handler calls.
301 Improved syb_err_handler handling (thanks to Matthew Persico)
302 Fixed memory leak when opening additional connections for multiple
303 statement handles on a single database handle (thanks to Stefan
304 Harbeck)
305 Applied minor patch by Alex Fridman to get to build on WinNT.
306 Force a ct_cancel() if, due to syb_do_proc_status, we force a
307 failure on a request that could have more results pending (Blaise
308 Lepeuple)
309 Added syb_cancel_request_on_error attribute (see bug 471).
310 Warning - the default value for this attribute changes the behavior
311 of $sth->execute() when there is a failure that is detected in
312 multi-statement requests.
313 Added syb_bind_empty_string_as_null attribute (see bug 446) to
314 allow user configurable empty string binding semantics (convert
315 to single space [default] or to NULL).
316
317 Bugs Fixed:
318
319 431 - fetchrow_hashref() has incorrect keys when retrieving
320 multiple result sets.
321 437 - imp_sth->numRows in st_next_result not always set.
322 444 - Incorrect example for ct_get_data(). ct_get_data() SEGV
323 if passed a non-reference for $image.
324 394 - $sth->{CursorName} fails hard.
325 449 - ct_get_data() limited to 32k
326 450 - Fix incorrect NULLABLE handling.
327 452 - Incorrect $sth->finish() handling in syb_flush_finish mode
328 (thanks to Steve Willer).
329 443 - $sth->fetch produces error if called after $sth->execute on
330 statement that doesn't return any rows.
331 411 - statement handle attributes do not change between result sets.
332 430 - $dbh->prepare can return undef without triggering RaiseError.
333 436 - Problems with make test generating errors creating
334 Makefile.aperl.
335 441 - amadmin who,sqm fails while in a transaction.
336 446 - Empty string converts to a space (fixed by making this
337 configurable).
338 448 - define strncasecmp as strnicmp for Win32 systems.
339 454 - syb_err_handler won't catch connect-time error.
340 456 - ping still fails if connection is dead.
341 461 - Memory leak if NOT using placeholders in selects and
342 calling execute() multiple times.
343 464 - Binding an empty string for a date field causes "1/1/1900"
344 to be inserted (instead of NULL).
345 469 - nsql error handling bug.
346 447 - syb_db_disconnect(): ct_con_drop() failed.
347 471 - Certain class of errors isn't detected by DBD::Sybase.
348
349
350 Documentation changes to explain why
351 ... WHERE (product_code = ? OR (? IS NULL AND product_code IS NULL))
352 doesn't work with Sybase.
353
354
355
356 Release 0.94
357
358 Added optional SQL buffer argument to syb_err_handler.
359 Interactive setting of user/server/pwd entries in PWD
360 for "make test".
361 Add syb_failed_db_fatal and syb_no_child_con attributes.
362
363 Bugs Fixed:
364
365 408 - Add the YYYYMMDD format to _date_fmt().
366 414 - Binding '' is interpreted as NULL.
367 415 - Fix buffer overlow in syb_db_login().
368 418 - Fix incorrect handing of CS_CANCELED return code in
369 st_next_result().
370 421 - ActiveState patches.
371
372 Release 0.93
373
374 Added password encryption option to connect() request (contributed
375 by Tin Martone)
376 Added initial nsql().
377 Added ct_get_data(), ct_send_data() and friends func().
378 Added ?-style placeholder support for exec proc statements.
379 Changed getExtraLibs() in Makefile.PL to *not* link with -linsck
380 or -ltli (this avoids problems if the $SYBASE/config/libtcl.cfg
381 file has been set to load the threaded version of these
382 libraries.)
383 Added support for primary_key_info().
384 (release 0.92 was never publicly released for various reasons)
385
386 Bugs Fixed:
387 366 ping() fails if connection has been marked dead
388 364 t/fail.t bug.
389
390
391 Release 0.91
392
393 Removed artificial 1024 byte limit on char/varchar datatypes in
394 result sets.
395
396 Bug Fixes:
397
398 213: BLOBs are returned in HEX, not binary.
399
400 Release 0.90
401
402 Release number sequence change: I'm dropping the "alpha" qualifier
403 and I expect to release 1.00 fairly soon.
404
405 Small Makefile.PL fix for Sybase 12.0 installation directory
406 changes.
407 Applied patch from Tim Ayers to allow 0x type formatting for
408 binary data fetches (similar to what Sybase::CTlib and
409 Sybase::DBlib allow).
410 Fixed some t/ scripts to not fail when run against MS-SQL.
411 Corrected the handling of timeout events in the client
412 callback.
413
414 Bug Fixes:
415
416 349: CS_NUMERIC bindings for ?-style placeholders fails for large
417 values.
418 345: Dynamic statement ids get re-used.
419 351: prepared statements with placeholders cause handle to become
420 unusable if *first* execute fails.
421 352: ping() doesn't work right in Apache::DBI (thanks to
422 Kiriakos Georgiou)
423 353: syb_quoted_identifier doesn't work.
424 354: Calling fetch() after prepare() but no execute() fails with
425 internal DBI error. This should also fix bug # 278 and 288.
426 297: type_info() returns incorrect or no data.
427 344: timeout doesn't work correctly.
428
429
430 Release 0.23
431
432 Bug Fixes:
433
434 331: ? marks in comments are parsed as placeholders.
435 343: Errors in stored procs cause data rows from proc to be
436 thrown away.
437 255: $dbh->execute does not fail it executing proc without
438 permissions.
439
440 Release 0.22
441
442 Bug Fixes:
443
444 271: execute() does not restart a transaction after a rollback
445 or commit when running multiple execute() calls for the
446 same statement handle.
447 294: SEGV on executing a prepared statement with undef values.
448 295: SEGV due to printf w/ null pointer
449 299: Missing dTHR in syb_st_prepare().
450
451
452 Release 0.21
453
454 Added constant() function, so that if DBD::Sybase is use'd you
455 can access some CS_xxx_RESULT constants.
456 Added $sth->func('syb_output_params') to allow for easier
457 retrieval of stored proc OUTPUT parameters.
458 Added syb_do_proc_status database attribute to allow $sth->execute
459 to handle stored procedure return status directly, and to fail if
460 the stored proc has a non-0 return status. This should also fix
461 bug 255.
462 Errors with severity 10 or below are not stored in $DBI::err
463 anymore. Use $dbh->{syb_err_handler} to get at those warning
464 messages.
465 Added t/fail.t test script to better test failure modes.
466 Setting AutoCommit on a $dbh with active statement handles is now
467 a fatal error.
468
469 Bug Fixes:
470
471 255: Memory leak for prepared statements that are not executed.
472 264: make test fails when building DBD::Sybase against
473 OpenClient 10.x.
474 266: make test fails when building DBD::Sybase with perl 5.004_04
475 or earlier.
476 268: $sth->execute(x,y,z) (ie executing a prepare'd statment that
477 has ?-style placeholders) does not return undef if a
478 constraint violation occurs on the insert/update/delete.
479
480
481 Release 0.20
482
483 Fix code to allow prepare, execute, execute, execute... on
484 statements that don't include ?-style placeholders.
485 Fix LENGTH/PRECISION/SCALE $sth attributes to be closer to the
486 DBI spec.
487 Fix core dump problem when binding undef values and having
488 trace >= 2.
489 Add syb_quoted_identifier connection/database handle attribute.
490 Add syb_oc_version read-only database handle attribute, returns the
491 Sybase library version that this binary is currently using.
492 Added the syb_rowcount $dbh attribute.
493 Added $sth->cancel().
494 Call the syb_err_handler (if one is defined) for client-side
495 errors.
496
497 Release 0.19
498
499 Setting chained/non-chained mode was still broken. <sigh>
500 syb_flush_finish mode didn't quite work right either.
501 Added more verbose traces.
502
503 Release 0.18
504
505 Add $h->{syb_chained_txn} attribute to switch between CHAINED
506 transactions and explicit named transactions for AutoCommit=0
507 mode. The default is for syb_chained_txn to be off (ie 0.13 behaviour).
508 Fixed typo in syb_db_commit() to actually commit instead of doing
509 a rollback.
510 Added an autocommit.t test (which still needs some work).
511 Disable opening new connection for secondary $sth handles off of a
512 single $dbh handle when AutoCommit == 0.
513
514 Release 0.17
515
516 Fix AutoCommit = 0 problems introduced with 0.15 for MS-SQL or older
517 Sybase server (ie TDS 4.x protocol connections).
518 Add syb_dynamic_supported $dbh attribute to check whether the
519 connection supports ?-style placeholders.
520
521 Release 0.16
522
523 Added code to define PL_xxx symbols for pre 5.005 perls.
524 New syb_flush_finish attribute (contributed by Steve Miller).
525 Patch to Makefile.PL for VMS systems.
526 Better library detection code in Makefile.PL.
527
528 Release 0.15
529
530 Added an error handler callback which can intercept error messages
531 and provide ad-hoc handling of error situations.
532 In AutoCommit == 0 mode, use CS_OPT_CHAINXACTS mode on the
533 server instead of issuing explicit transactions.
534 $dbh->LongReadLen and LongTruncOK now work.
535 First cut at the type_info() and type_info_all() methods.
536 perl Makefile.PL now attempts to discover the libraries directly
537 based on what it finds in $SYBASE/lib.
538
539 Release 0.14
540
541 Added a 'timeout' connection attribute (contributed by Tom May)
542 to handle timeout errors during normal processing.
543 SQL PRINT statements are now handled by a warn() call (instead
544 a printf() call) so that they can be caught by a __WARN__ handler.
545 Make sure $dbh->do() returns immediately when an error is encountered.
546 Include dbd-sybase.pod (Tim Bunce's Driver Summary for DBD::Sybase).
547
548 Release 0.13
549
550 Bug fix release - binding undef (NULL) variables when using
551 ? style placeholders didn't work.
552 Incorrect login didn't get flagged properly (this bug was
553 introduced in 0.11.)
554 Added database attribute to the connect() call.
555
556 Release 0.12
557
558 Bug fix release - recent versions of DBI make an array that
559 DBD::Sybase uses read-only, causing errors when multiple
560 result sets are retrieved where the second result set is wider
561 (has more columns) than the first one.
562
563 Release 0.11
564
565 Adds support for multiple $sth for a single $dbh (this is done
566 by openeing a new connection in prepare() if the previously
567 prepared statement is still active.
568 Add support for date formatting via $dbh->func($fmt,
569 '_date_fmt').
570 Added two new connect attributes: scriptName and
571 hostname. Setting these can help identify processes in the
572 Sybase sysprocesses table.
573
574 Release 0.10
575
576 Fixes stupid Makefile.PL bug.
577 Fixes incorrect freeing of memory when mixing prepare()
578 statements with ? placeholders and prepare() statements
579 without them.
580
581 Release 0.09
582
583 Features:
584
585 Added $sth->{syb_result_type} which returns the numerical
586 value of the current result set. The values are defined
587 in $SYBASE/include/cspublic.h.
588 Made $sth->{TYPE} compatible with generic DBI values, and
589 added $sth->{syb_types} to get the native Sybase types.
590 Added $dbh->tables and $dbh->table_info.
591
592 Finally got rid of the "Use of uninitialized value" message
593 in connect() (thanks to Tom May for this)
594
595 Fixed at least some of the memory leaks (thanks to Bryan Mawhinney)
596
597 Added Sybase specific do() sub that will handle multiple result
598 sets.
599
600 Added $dbh->{syb_show_sql} and $dbh->{syb_show_eed} to add more
601 control to error reporting.
602
603 Implemented $dbh->ping() method (first cut - may need improvement!)
604
605 Bug Fixes:
606
607 244: fetch gets infinite loop on sproc error
608 246: extended error messages go to STDOUT.
609
610 Release 0.08
611
612 Features:
613
614 Added ? placeholder processing. This is done by calling ct_dynamic()
615 and friends if the statement being executed includes ? type
616 placeholders.
617
618 Bug Fixes:
619
620 210: print statements are lost
621 231: error messages are lost
622 238: reformat error messages
623 241: remove the necessity for users to call $sth->finish
624
625 Release 0.07
626
627 Bug fixes:
628
629 204: One form of DBI->connect() fails when specifying the server name.
630 211: $dbh->do("use database") fails with RaiseError is true.
631 230: fetch() does not return correct results for certain stored
632 procs situations.
633
634 Release 0.06
635
636 Added ability to specify interfaces file in the connect()
637 call.
638 Added eg/dbschema.pl (ported from Sybase::DBlib).
639 Fixed incorrect handling of AutoCommit and PrintError
640 attributes to connect().
641
642 Bugs fixed:
643
644 203: Executing sp_helprotect fails.
645
646 Release 0.05
647
648 Added explicit assignement of LDDLFLAGS and LDFLAGS in
649 Makefile.PL to make sure that -L$SYBASE/lib comes first
650 in the list of -L flags.
651 Added documentation.
652 Added ability to specify character set, language, packet size
653 in the connect() call.
654 Small Win32 portability patch to Makefile.PL from Matt Herbert.
655
656 Bugs fixed:
657
658 198: connect failure does not return undef
659 199: DBD::Sybase interaction with Apache::DBI 0.74
660
661 Release 0.04
662
663 Fixed counting of active statement handles.
664 Add implicit rollback of open transactions on disconnect.
665 Add implicit commit when changing AutoCommit from off to on.
666
667 Release 0.03
668
669 First ALPHA release of native DBD::Sybase implementation.
670
671 Release 0.02
672
673 Some fixes to the emulation layer.
674
675 Release 0.01
676
677 Proof of concept release - built as an emulation layer on top
678 of Sybase::CTlib (part of sybperl 2.x).