Oracle limit() bug |
[eluser]inari[/eluser]
Code: $this->db->join('contacts','contacts.co_id=activities.co_id','left'); Produces data from oracle: Code: Array These fields with strange names are some weird response from oracle when using same column names in many tables. I guess that this Oracle handle to prevent fields with the same name, but they only comes when using limit. Without limit: Code: $this->db->join('contacts','contacts.co_id=activities.co_id','left'); produces: Code: Array Any help how to use limit and to keep original column names is welcome.
[eluser]Derek Allard[/eluser]
The driver is for OCI8. I know they are similar, but not identical. I don't have an Oracle db to test against unfortunately, so any additional guidance you could provide would be appreciated.
[eluser]inari[/eluser]
Query that produces that weird column names is: Code: SELECT * FROM (select inner_query.*, rownum rnum FROM What is this inner_query? I can't even google it out. I don't see what is wrong? Please tell me what may I try to change in this query to make it work? Any ideas? |
Welcome Guest, Not a member yet? Register Sign In |