php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #57479 Relational DAS is failing when one parent and two children
Submitted: 2007-01-15 13:15 UTC Modified: 2007-01-15 13:19 UTC
From: mfp@php.net Assigned:
Status: Closed Package: SCA_SDO (PECL)
PHP Version: 5.1.6 OS: WinXP
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: mfp@php.net
New email:
PHP Version: OS:

 

 [2007-01-15 13:15 UTC] mfp@php.net
Description:
------------
The following problem was reported to us by Alex <aslomov89@pacbell.net>

>>Hi Matthew,
>>
>>I got a problem using SDO Relational.
>>
>>When I do Select with SDO Rel. from 3 tables:
>>Tab1, Tab2, Tab3
>>where
>>Tab2 has a Foreig Key pointing to Tab1;
>>Tab 3 has a FK pointing to Tab2
>>everything works just fine.
>>
>>Now I have a situation when I have another 3 tables:
>>t1, t2, t3
>>where
>>t2 has a FK pointing to t1;
>>t3 has a FK pointing to t1
>>No constraints between t2 and t3.
>>Then SDO Relation does not work. I always get the exception:
>>SDO_PropertyNotFoundException: Cannot find property:t2


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2007-01-15 13:19 UTC] mfp@php.net
This bug has been fixed in CVS.

In case this was a documentation problem, the fix will show up at the
end of next Sunday (CET) on pecl.php.net.

In case this was a pecl.php.net website problem, the change will show
up on the website in short time.
 
Thank you for the report, and for helping us make PECL better.

A fairly elementary failure I am afraid. When building the new objects, we were going to the most recently created object and calling createDataObject on it. That worked with company department employee but not when there are two different tables at the same level. Fixed by making sure we find the parent object to call createDataObject on.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 27 11:01:30 2024 UTC