Re: [RDBO] math::bigint & pg
I'll second that, I've been making heavy use of the following bug fixes from the SVN trunk: - set boolean column to undef -> sets null in the DB - count interface improvements for a many-to-many when using Pg - Updating a lazy loading BYTEA column in Pg Needless to say they're all working great! Let me know if I can be of any help with test results, I have Fedora Core 4 and Redhat ES 4 machines. On 7/10/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > > On Jul 10, 2007, at 9:49 AM, John Siracusa wrote: > > > On 7/9/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > >> here's my testcase, reproduced on 3 machines (all running current > >> rose::db::object , not svn ) > > > > I see the bug when using 0.764 from CPAN, but I can't reproduce it > > with SVN, so I guess it's fixed :) > > Nice job!! > > Boy, that was fast!! > > When do you think a .765 release will come out ? There have been a > bunch of bug fixes in the past few days. Would be nice to see them > all 'live' > > and > what kind of testing needs to be done on it to make it happen? > i have osx 10.4, ubuntu , freebsd 6.1 and freebsd 6.2 boxes that i > can run tests on for you. > > > // Jonathan Vanasco > > | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > - - - - - - - - - - - - - - - - - - - > | CEO/Founder SyndiClick Networks > | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > - - - - - - - - - - - - - - - - - - - > | Founder/CTO/CVO > | FindMeOn.com - The cure for Multiple Web Personality Disorder > | Web Identity Management and 3D Social Networking > | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > - - - - - - - - - - - - - - - - - - - > | RoadSound.com - Tools For Bands, Stuff For Fans > | Collaborative Online Management And Syndication Tools > | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > - - - - - - - - - - - - - - - - - - - > > > > - > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > ___ > Rose-db-object mailing list > Rose-db-object@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/rose-db-object > - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
Re: [RDBO] math::bigint & pg
On Jul 10, 2007, at 9:49 AM, John Siracusa wrote: > On 7/9/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: >> here's my testcase, reproduced on 3 machines (all running current >> rose::db::object , not svn ) > > I see the bug when using 0.764 from CPAN, but I can't reproduce it > with SVN, so I guess it's fixed :) Nice job!! Boy, that was fast!! When do you think a .765 release will come out ? There have been a bunch of bug fixes in the past few days. Would be nice to see them all 'live' and what kind of testing needs to be done on it to make it happen? i have osx 10.4, ubuntu , freebsd 6.1 and freebsd 6.2 boxes that i can run tests on for you. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | CEO/Founder SyndiClick Networks | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | Founder/CTO/CVO | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | RoadSound.com - Tools For Bands, Stuff For Fans | Collaborative Online Management And Syndication Tools | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
Re: [RDBO] math::bigint & pg
On 7/9/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote: > here's my testcase, reproduced on 3 machines (all running current > rose::db::object , not svn ) I see the bug when using 0.764 from CPAN, but I can't reproduce it with SVN, so I guess it's fixed :) -John - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
Re: [RDBO] math::bigint & pg
On Jul 9, 2007, at 10:09 AM, John Siracusa wrote: > I added a test for this in SVN and can't reproduce it. My column > defs: here's my testcase, reproduced on 3 machines (all running current rose::db::object , not svn ) perhaps I'm setting something up wrong... http://dev.2xlp.com/svn/scratchpad/rosedb/issue_mathbigint/trunk/ svn co http://dev.2xlp.com/svn/scratchpad/rosedb/issue_mathbigint/ trunk/ the db info is in http://dev.2xlp.com/svn/scratchpad/rosedb/issue_mathbigint/trunk/ MyApp/RoseDB.pm the object has a $obj->__DUMP__(); convenience method, which will print the current state of the obj to STDERR. comes up as a 0 every time. looking at the pg table , it inserts a 0 as well, not an undef. i must be doing something blatantly wrong here -- and someone will notice it just looking at the class setup. i hope so. // Jonathan Vanasco | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | CEO/Founder SyndiClick Networks | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | Founder/CTO/CVO | FindMeOn.com - The cure for Multiple Web Personality Disorder | Web Identity Management and 3D Social Networking | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - | RoadSound.com - Tools For Bands, Stuff For Fans | Collaborative Online Management And Syndication Tools | - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
Re: [RDBO] math::bigint & pg
On 7/8/07, Jonathan Vanasco <[EMAIL PROTECTED]> wrote:
> I'm trying to pass a null value in for a bigint column.
>
> pg keeps complaining because its getting a 0. doing a data::dumper,
> I'm seeing the column with
> value=> [0]
> _a => undef
> _p=> undef
> sign=> '+'
>
> tailing the pg log, rose sends a 0
> I'm explicitly setting this col to undef, and it is not a 'not_null' col
I added a test for this in SVN and can't reproduce it. My column defs:
bint4 BIGINT,
bint4 => { type => 'bigint' },
The tests (edited):
$o = MyPgObject->new;
$o->bint4(555);
$o->save;
$o = MyPgObject->new(id => $o->id)->load;
is($o->bint4, 555, "bigint null 2 - $db_type");
$o->bint4(undef);
$o->save;
$o = MyPgObject->new(id => $o->id)->load;
is($o->bint4, undef, "bigint null 3 - $db_type");
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
___
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
[RDBO] math::bigint & pg
I'm trying to pass a null value in for a bigint column. pg keeps complaining because its getting a 0. doing a data::dumper, I'm seeing the column with value=> [0] _a => undef _p=> undef sign=> '+' tailing the pg log, rose sends a 0 I'm explicitly setting this col to undef, and it is not a 'not_null' col suggestions? - Jonathan Vanasco - findmeon.com / RoadSound.com Sent from my iPhone - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
