Project

General

Profile

Actions
Copy link

Bug #14824

closed

dbal cannot handle LEFT JOIN correctly

Added by Christian Welzel over 19 years ago. Updated over 18 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Karsten Dambekalns
Category:
-
Target version:
-
Start date:
2005-06-17
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

then using left join in a query like this:
$table = 'tx_chcforum_thread LEFT JOIN tx_chcforum_post on tx_chcforum_post.thread_id = tx_chcforum_thread.uid';

dbal produces a query:
"tx_chcforum" "LEFT" JOIN "tx_chcforum_post" on "tx_chcforum_post.thread_id" = "tx_chcforum_thread.uid"

note that the "left" must not be quoted !

(issue imported from #M1205)

Actions
Copy link
 #1

Updated by Karsten Dambekalns almost 19 years ago

The LEFT was seen as an alias for the table name, thus it was quoted. This is fixed. But there is another bug in that query: "tx_chcforum_post.thread_id" must be quoted as "tx_chcforum_post"."thread_id"...

Actions
Copy link
 #2

Updated by Karsten Dambekalns almost 19 years ago

Bug has been fixed and the fix will find it's way into CVS ASAP.

Actions
Copy link

Also available in: Atom PDF