Skip Menu |

This queue is for tickets about the CGI-Uploader CPAN distribution.

Report information
The Basics
Id: 40909
Status: rejected
Priority: 0/
Queue: CGI-Uploader
People
Owner: MARKSTOS [...] cpan.org
Requestors: RSAVAGE [...] cpan.org
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 2.15
Fixed in: (no value)

History Show all quoted text
  Thu Nov 13 18:44:46 2008 RSAVAGE [...] cpan.org - Ticket created
Subject: Column gen_from_id forced to accept nulls
The hash returned by sub extract_meta() is missing the key/value pair gen_from_id => 0. This means it is not passed in to sub store_meta(), which means it is not part of the generated SQL. So, if the column is declared by the caller to be gen_from_id integer not null the SQL execute dies because that column is not populated. I call the column parent_id, so I get this error: null value in column "parent_id" violates not-null constraint.
  Thu Apr 02 11:27:11 2009 MARKSTOS [...] cpan.org - Taken
  Thu Apr 02 11:28:01 2009 MARKSTOS [...] cpan.org - Correspondence added
On Thu Nov 13 18:44:46 2008, RSAVAGE wrote: Show quoted text
> The hash returned by sub extract_meta() is missing the key/value pair > gen_from_id => 0. > > This means it is not passed in to sub store_meta(), which means it is > not part of the generated SQL. > > So, if the column is declared by the caller to be > gen_from_id integer not null > the SQL execute dies because that column is not populated. > > I call the column parent_id, so I get this error: > null value in column "parent_id" violates not-null constraint.
I think I disagree about this behavior. I think a parent should have "gen_from_id" set to NULL to correctly represent that it is not generated from anything. Am I missing something? Mark
  Thu Apr 02 11:28:02 2009 The RT System itself - Status changed from 'new' to 'open'
  Thu Apr 02 11:28:03 2009 MARKSTOS [...] cpan.org - Status changed from 'open' to 'stalled'
  Tue Apr 14 20:40:45 2009 MARKSTOS [...] cpan.org - Reference to ticket #40910 added
  Tue Apr 14 20:41:40 2009 MARKSTOS [...] cpan.org - Correspondence added
Marking as resolved, See "RT#40910" for context.
  Tue Apr 14 20:41:41 2009 The RT System itself - Status changed from 'stalled' to 'open'
  Tue Apr 14 20:41:41 2009 MARKSTOS [...] cpan.org - Status changed from 'open' to 'rejected'