Error ORA-00918 - OracleGrammar::compileTableExpression does not work in Oracle 10g.

[adolfoabegg]

Summary of problem or feature request

Yajra\Oci8\Query\Grammars\OracleGrammar::compileTableExpression does not work with Oracle, it throws this error: Error Code : 918 Error Message : ORA-00918: column ambiguously defined

Code snippet of problem

See line 142 in this version https://github.com/yajra/laravel-oci8/blob/0fa820666796ad47de64a38fe054cff8ad4f7caf/src/Oci8/Query/Grammars/OracleGrammar.php

if ($query->limit > 1) {
            return "select t2.* from ( select rownum AS \"rn\", t1.* from ({$sql}) t1 ) t2 where t2.\"rn\" {$constraint}";
        }

System details

• OS: Linux Centos 7
• PHP Version: 7.1
• Laravel Version: 5.5
• Laravel-OCI8 Version: 5.5
• Oracle version: 10g

[yajra]

Can you please provide some snippets to reproduce the issue?

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity.

[github-actions[bot]]

This issue was closed because it has been inactive for 7 days since being marked as stale.