SQLite3Result::fetchArray Doesn't Handle Join Statement Properly

[loay-ali]

When i tried using ( join ) statement for fetching data , sqlite3 tend to overwrite the column name if it appears in the other table

• eg:

table-a

ID	Name	Foreign_id
1	bar	2

table-b

ID	Name
2	foo

When i try to join them

SELECT * FROM table-a a JOIN table-b b ON(a.foreign_id=b.id)

i get the result as follows

[
  array(
  'ID' => 2,
  'name' => 'foo',
  'foreign_id' => 2
  )
]

i suggest prefixing the columns names with the table aliases name to clarify and avoid overwriting

So the result would be like this

[
 array(
  'a.ID' => 1,
  'a.name' => 'bar',
  'a.Foreign_id' => 2,
  'b.ID' => 2,
  'b.name' => 'foo'
 )
]

thanks in advance

From manual page: https://php.net/sqlite3result.fetcharray

[devnexen]

Hi @loay-ali what is the table-b alias again ? can't see it.

[loay-ali]

Hi @loay-ali what is the table-b alias again ? can't see it.

It's (b)

[devnexen]

I do not know that well the sqlite3 extension, but it seems doable at first glance to get a table name for a given column (not 100 % sure we can get the alias rather than the real table name though) ; but then how to "assess" when it is useful to do so is where I have more difficulty to foresee the feasibility (e.g. just checking the keyword ?). But we ll see..

[loay-ali]

I could use fetchArray With SQLITE3_NUM argument to get columns from both tables , but it's not functional in the long run ( e.g. inserting a new column in the table -> this will miss the order ) ,by the way - assigning the table name instead of aliases have a problem if we (SELF JOIN)