# Cascading eager loading patch not working in oracle

**URL:** <https://www.ruby-forum.com/t/cascading-eager-loading-patch-not-working-in-oracle/54798>\
**Category:** Rails\
**Created:** [March 14, 2006, 11:45am UTC](https://www.ruby-forum.com/t/cascading-eager-loading-patch-not-working-in-oracle/54798 "2006-03-14T11:45:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![guest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/8dc957/32.png) [@guest](https://www.ruby-forum.com/u/guest)\
**Post date:** [March 14, 2006, 11:45am UTC](https://www.ruby-forum.com/t/cascading-eager-loading-patch-not-working-in-oracle/54798/1 "2006-03-14T11:45:06Z")

</div>

Notice the “AS” keyword appears many times. Oracle does not support this  
keyword:

ActiveRecord::StatementInvalid: OCIError: ORA-00905: missing keyword:  
SELECT tim  
esheets.id AS t0\_r0, timesheets.start\_date AS t0\_r1, timesheets.status  
AS t0\_r2,  
timesheets.cost AS t0\_r3, timesheets.charge AS t0\_r4,  
timesheets.employee AS t0  
_r5, employees.id AS t1\_r0, employees.name AS t1\_r1,  
employees.start\_date AS t1_  
r2, employees.cost AS t1\_r3, employees.charge AS t1\_r4,  
employees.username AS t1…

I have just installed edge rails.

---

<div class="post-metadata">

**Author:** ![guest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/8dc957/32.png) [@guest](https://www.ruby-forum.com/u/guest)\
**Post date:** [March 14, 2006, 11:49am UTC](https://www.ruby-forum.com/t/cascading-eager-loading-patch-not-working-in-oracle/54798/2 "2006-03-14T11:49:53Z")

</div>

Will be fixed with [http://dev.rubyonrails.org/ticket/4231](http://dev.rubyonrails.org/ticket/4231)

-Jonathan.

---

<div class="post-metadata">

**Author:** ![guest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/8dc957/32.png) [@guest](https://www.ruby-forum.com/u/guest)\
**Post date:** [March 14, 2006, 12:02pm UTC](https://www.ruby-forum.com/t/cascading-eager-loading-patch-not-working-in-oracle/54798/3 "2006-03-14T12:02:09Z")

</div>

Thanks Jonathan,

how do i apply the patch assoc\_alias.patch provided from  
[http://dev.rubyonrails.org/ticket/4231](http://dev.rubyonrails.org/ticket/4231)?? I am using windows.

It’s quite urgent so your help is really appreciated!  
Thanks,  
Chris

---

<div class="post-metadata">

**Author:** ![guest](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/8dc957/32.png) [@guest](https://www.ruby-forum.com/u/guest)\
**Post date:** [March 14, 2006, 12:08pm UTC](https://www.ruby-forum.com/t/cascading-eager-loading-patch-not-working-in-oracle/54798/4 "2006-03-14T12:08:33Z")

</div>

- Grab [http://unxutils.sourceforge.net/](http://unxutils.sourceforge.net/) to get a Windows version of the  
patch utility.
- Do a rake freeze\_edge
- Download the assoc\_alias.patch into the vendor/rails directory
- Use the patch utility, something like ‘patch -p0 \< assoc\_alias.patch’  
from  
inside vendor/rails should do it.

-Jonathan.