Self relationship generate Error ORA-00904: "LARAVEL_RESERVED_0"

[ErDiabIo]

Hi

when query a model with whereDoesntHave on self relationship generete the following error

Error Code : 904 Error Message : ORA-00904: "CE_LARAVEL_RESERVED_0"."ID": invalid identifier Position : 103 Statement : select * from "CE_CATEGORIES" where not exists (select * from "CE_CATEGORIES" laravel_reserved_0 where "CE_LARAVEL_RESERVED_0"."ID" = "CE_CATEGORIES"."PARENT_CATEGORY")

For now i fix the problem by editing the following function wrapTable
inside src/Oci8/Query/Grammars/OracleGrammar.php
for use the prefix when concatenate $segments[0] with $segments[1]

  public function wrapTable($table)
  {
      if ($this->isExpression($table)) {
          return $this->getValue($table);
      }

      if (strpos(strtolower($table), ' as ') !== false) {
          $table = str_replace(' as ', ' ', strtolower($table));
      }

      $tableName = $this->wrap($this->tablePrefix.$table, true);
      $segments = explode(' ', $table);
      if (count($segments) > 1) {
          $tableName = $this->wrap($this->tablePrefix.$segments[0]).' '.$this->tablePrefix.$segments[1];
      }

      return $this->getSchemaPrefix().$tableName;
  }

Below an example code

Set the .env variable DB_PREFIX

Model

<?php

namespace App\Models\Category;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;

class Category extends Model
{
    use HasFactory;

    /**
     * @return BelongsTo<Category>
     */
    public function parent(): BelongsTo
    {
        return $this->belongsTo(Category::class, 'parent_category');
    }
}

Controller

$categories = Category::whereDoesntHave('parent')->get();

[yajra]

Thanks for reporting, wrapTable indeed needs several updates. Some fixes were implemented at #879.

Would you be able to check if #879 covers this issue? Will also check further when I got the chance.

[ErDiabIo]

Hi,

I’ve checked, and issue #879 doesn’t cover this case.
I can create a PR to fix this problem.

[yajra]

Yes please, PR is appreciated. Thanks!