DBD-Sprite
view release on metacpan or search on metacpan
DBDSprite.htm view on Meta::CPAN
by Perl for sorting purposes and the rest as strings. This is seen
when sorting, ie NUMERIC types sort as 1,5,10,40,200, whereas
STRING types sort these as 1,10,200,40,5. CHAR fields are right-
padded with spaces when stored. LONG-type fields are subject to
truncation by the "LongReadLen" attribute value. BLOB-type
fields have their data stored on separate files created by Sprite.
</PRE>
<P>
<PRE> DBD::Sprite works with the tieDBI module, if "Sprite => 1" lines are added
to the "%CAN_BIND" and "%CAN_BINDSELECT" hashes. This should not be
necessary, and I will investigate when I have time.
Data field names must NOT be the same as any of Perl's string operators
(eq lt le ge gt, etc) or boolean operators (and or not)!
</PRE>
<H1><A NAME="CHANGES">LATEST CHANGES</A></H1>
Revision history for Perl extension DBD::Sprite.
<UL>
<LI>0.01 Fri Feb 25 13:00:55, 2000
<BR>- original version; created by h2xs 1.18
<LI>0.02 Fri Mar 03, 2000
<BR>- Fixed single-quote handling on bound parameters.
<LI>0.07 Fri Apr 14, 2000
<BR>- Refixed test-14 failure (CHAR datatype). Also create and alter
table commands should now work properly (save your table 1st! ;)
<LI>0.08 Wed May 03, 2000
<BR>- Fix Windows glob problem for Perl2EXE
<BR>- Added missing file "OraSpriteFns.pl" to build
<LI>0.09 Fri Jun 09, 2000
<BR>- Fix bug in DELETE which occassionally caused infinite loop.
<LI>0.10 Wed Aug 16, 2000
<BR>- Fix bug involving "like" and field values containing regex-
special characters, ie. ".".
<LI>0.11 Thu Aug 31, 2000
<BR>- Fix regex bug in Sprite.pm and add error-checking for SQL
<BR>- commands wo/space after table-name, ie "update table-name\n...".
<LI>0.12 Tue Sep 05, 2000
<BR>- Show the size fields are truncated to in "-519" error message.
<LI>0.13 Tue Oct 10, 2000
<BR>- Fix CaseTableNames attribute to "sprite_CaseTableNames.
<BR>- Minor docs fix.
<LI>0.14 Thu Oct 12, 2000
<BR>- Added Oracle TO_DATE and CONCAT functions. Fixed bug now
allowing more than 1 argument for functions, and minor bug
which stripped wild-card chars from function results in "LIKE"
expressions.
<LI>0.15 Thu Nov 02, 2000
<BR>- Fix bug that caused question marks in bound parameter values to be
treated as additional parameters.
<LI>0.16 Thu Dec 21, 2000
<BR>- Fixed bug which would not allow lower-case versions of the "AND" and
"OR" operators. Also made field-names used as right-values return
the appropriate value they represent rather than just a literal
string of the field name, ie. "update table set FIELD1 = FIELD2"
should now work properly instead of setting FIELD1 to "FIELD2" in
every record of "table".
<LI>0.17 Fri Mar 09, 2001
<BR>- Fixed bug where types not returned for cursor after update,
Fixed bug where table names not returned if space appeared after
"table_name"?
<BR>- Fixed bug in "makesdb.pl" -<BR>- was encrypting wrong argument.
<LI>0.18 Wed Mar 13, 2001
<BR>- Changed comparisens of literal data with "CHAR" fields to first
pad the literal with appropriate spaces so that eqality tests would
pass (to work like Oracle and the way DBIx-Recordset expects).
Also added new option "sprite_StrictCharComp" to force the old behavior.
<BR>- Fixed bug that occasionally inserted a "0" instead of "" in numeric
fields when inserting NULL. To get the proper "old" behavior,
specify a default of zero for each numeric field, ie.
"NUMFIELD=NUMBER=0" in the top line of your Sprite table files.
<BR>- Added some code to check syntax of "where" clauses. (for DBIx-
Recordset.
<BR>- Fixed a couple of other small bugs that DBIx-Recordset tests found.
<LI>0.19 Wed Mar 21, 2001
<BR>- Fixed problem seeing all Windows file-names due to case-insensitivity
in Windows.
<LI>0.20 Fri Aug 15, 2001
<BR>- Fixed bug involving autocommit on statements containing "select" in data.
Caught by Simon Elliott, Thanks! Also fixed several other minor glitches.
<BR>- Fixed bug forbidding sequence files in mixed-case directories unless
CaseTableNames was set (CaseTableNames only applies to the file-name).
Also added code to display "$@" and "$?" in the error details message on
-511 errors (could not [over]write file).
<LI>0.21 Wed Sep 12, 2001
<BR>- Fixed AutoCommit to actually work. Caught by Jojo Kamote Escubil, Thanks,
Jojo! Also fixed another bug affecting quoted value strings containing
question marks (Caught by me!)
<LI>0.22 Mon Sep 17, 2001
<BR>- Removed regex optimization (s///o) which caused record and field separators
to not work right when one opened a database, closed that database, then
opened a second database with different record and or field separators.
Caught by Larry Yudelson, Thanks!
<LI>0.23 Thu Oct 23, 2001
<BR>- Added new regex feature to allow one to capture regex matches and update
field values, ie:
update MYTABLE set FIELD1 = '$1' where FIELD2 =~ '(\d+)'
This will set FIELD1 to the 1st number found in FIELD2 in the same
record. Up to 2 matches for each "where" expression containing "=~" or
"!~" may be captured. $1 .. $n correspond to each set of unescaped
parenthesis from left to right in the "where" clause.
<BR>- Added TO_CHAR function for converting Perl "time" values to printable
formats. Has most date and numeric functions in the two-argument
form of the Oracle "TO_CHAR" function, which it is designed to emulate.
<BR>- Added some optimization for mass-updates.
<BR>- Added many other new Oracle functions (TO_NUMBER, USER, ABS, COS, EXP,
FLOOR, MOD, POWER, ROUND, SIGN, SIN, TRUNC, CHR, INITCAP, LTRIM,
REPLACE, RTRIM, TRANSLATE, ASCII, LENGTH, SYSDATE. All should now
work when selected from "DUAL".
<BR>- Selecting from "DUAL" should now work as expected.
<LI>0.26 Mon Oct 29, 2001
<BR>- Fixed bug introduced in 0.24 where tests failed not finding "makesdb.pl".
<BR>- Fixed test failure on Windows platforms (I think).
<BR>- Added still more Oraclish functions (CEIL, EXP, INSTR, INSTRB, LAST_DAY,
LPAD, NVL, RPAD, LAST_DAY, and SQRT. Fixed FLOOR.
It should be noted that these functions do almost no error-checking.
<BR>- Added date-handling capability to TRUNC.
<BR>- Added "AUTONUMBER" datatype to allow autonumbering without sequences.
This emulates the way M$-Access(ODBC) does things.
( run in 1.785 second using v1.01-cache-2.11-cpan-39bf76dae61 )