php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
32 - 23 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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: Thu Apr 18 22:01:28 2024 UTC