Bug 478075 - MIGRATED_FROM_JIRA: Penrose removes duplicate entries because of join column primary key requirement
Summary: MIGRATED_FROM_JIRA: Penrose removes duplicate entries because of join column ...
Keywords:
Status: CLOSED EOL
Alias: None
Product: penrose
Classification: Retired
Component: Engine
Version: 2.0
Hardware: All
OS: Linux
low
low
Target Milestone: ---
Assignee: Endi Sukma Dewata
QA Contact: Ben Levenson
URL:
Whiteboard:
Depends On:
Blocks: 471500
TreeView+ depends on / blocked
 
Reported: 2008-12-27 07:56 UTC by Chandrasekar Kannan
Modified: 2020-03-27 19:38 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2020-03-27 19:38:58 UTC
Embargoed:


Attachments (Terms of Use)

Description Chandrasekar Kannan 2008-12-27 07:56:46 UTC
Non-unique column values that had to be marked as primary keys because they are join columns disappear when Penrose serves them up as ldap ? it incorrectly discards the ?duplicates?. 

Additional Comments From endisd dated Mon Sep 12 13:02:51 CDT 2005 
Penrose now allows to use any keys (not just primary keys) to be used for join. Penrose 0.9.5 includes a new sample database with various mapping configurations which demonstrates this ability. Please reopen this issue if your mapping configuration still doesn't work.


=========================================================
Issue dump from jira
$VAR1 = {
          'priority' => '3',
          'customFieldValues' => [],
          'project' => 'PENROSE',
          'status' => '5',
          'components' => [
                            {
                              'name' => 'Engine',
                              'id' => '10009'
                            }
                          ],
          'key' => 'PENROSE-79',
          'assignee' => 'endisd',
          'summary' => 'Penrose removes duplicate entries because of join column primary key requirement',
          'id' => '10268',
          'updated' => '2005-09-12 13:02:51.0',
          'votes' => '0',
          'fixVersions' => [
                           {
                             'releaseDate' => '2005-09-15 00:00:00.0',
                             'sequence' => '5',
                             'name' => 'Penrose-0.9.5',
                             'released' => 'true',
                             'id' => '10022',
                             'archived' => 'false'
                           }
                         ],
          'affectsVersions' => [
                               {
                                 'releaseDate' => '2005-07-26 00:00:00.0',
                                 'sequence' => '3',
                                 'name' => 'Penrose-0.9.3',
                                 'released' => 'true',
                                 'id' => '10020',
                                 'archived' => 'false'
                               }
                             ],
          'description' => 'Non-unique column values that had to be marked as primary keys because they are join columns disappear when Penrose serves them up as ldap ? it incorrectly discards the ?duplicates?. 
',
          'created' => '2005-09-01 22:08:05.0',
          'environment' => 'Linux',
          'resolution' => '1',
          'type' => '1'
        };


=========================================================

Comment 1 Chandrasekar Kannan 2008-12-27 07:56:48 UTC
Marking bug as MODIFIED as it was already resolved in Jira - PENROSE-79


Note You need to log in before you can comment on or make changes to this bug.