source :join does not prepend 'join' in SQL query

activewarehouse / activewarehouse-etl-sample

A place where you will find a sample of use of ActiveWarehouse-ETL

40 stars 9 forks source link

Closed pcreux closed 12 years ago

pcreux commented 12 years ago

The following code:

source :in, {
 :type => :database,
 :target => :operational_database,
 :table => "users",
 :join => "contacts on users.ContactId = contacts.Id",
},

would generate the following SQL query:

SELECT * FROM users contacts on users.ContactId = contacts.Id;

The keyword join (or left outer join) is missing.

Work around:

 :join => "left outer join contacts on users.ContactId = contacts.Id"

pcreux commented 12 years ago

Wrong project. Sorry! :)