Getting fields for a table in another schema

[softarius]

0004-getTableColumns-for-another-schema.txt

Steps to reproduce the issue

• install Joomla with PostgreSQl driver.
• create a new schema (for example 'test')
• create a new table in this schema

CREATE TABLE test.customer (
  id SERIAL,
  name VARCHAR(100),
  PRIMARY KEY(id)
) 
WITH (oids = false);

• in code call getTableColumns for this table

$db = JFactory::getDBO();
$custfields=$db->getTableColumns('test.customer'); 

Expected result

Array with fields of table

Actual result

Empty array

System information (as much as possible)

PostgreSQL Joomla driver using (important!)
Any operation system (Windows or Linux for me)
Joomla 3.9.6 (or staging)
PostgreSQL 10 (or other)

Additional comments

A fixed this bag (see attached patch)

[ghost]

Please "System information (as much as possible)"

[softarius]

System information (as much as possible)

• PostgreSQL Joomla driver using (important!)
• Any operation system (Windows or Linux for me)
• Joomla 3.9.6 (or staging)
• PostgreSQL 10 (or other)

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24998.}

[alikon]

you have already the solution so then
please submit a pr is easy: https://docs.joomla.org/Using_the_Github_UI_to_Make_Pull_Requests

[softarius]

Yes. Done.
PR #24999

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24998.}

[richard67]

Then you can close this issue because there is a PR.

[joomla-cms-bot]

Set to "closed" on behalf of @alikon by The JTracker Application at issues.joomla.org/joomla-cms/24998

[alikon]

closing as we have a pr for testing #24999

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/24998.}