[ 
https://issues.apache.org/jira/browse/TORQUE-305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Michael Wagner updated TORQUE-305:
----------------------------------

    Description: 
It would be nice if the torque criteria api would support inserts with a given 
sub query like the following:

INSERT INTO table_a (column_a, column_b, column_c)
  SELECT
    /* Literal number values with column aliases */
    value_a AS column_a,
    value_b AS column_b,
    column_x
  FROM table_b 
  WHERE ...;

  was:
It would be nice if the torque criteria api would support inserts with a given 
sub query like the following:

INSERT INTO table_a (column_a, column_b, column_c)
  SELECT
    /* Literal number values with column aliases */
    value_a AS column_a,
    value_b AS column_b,
    column_c
  FROM table_b 
  WHERE ...;


> Do insert with a select subquery
> --------------------------------
>
>                 Key: TORQUE-305
>                 URL: https://issues.apache.org/jira/browse/TORQUE-305
>             Project: Torque
>          Issue Type: Improvement
>    Affects Versions: 4.0
>            Reporter: Michael Wagner
>
> It would be nice if the torque criteria api would support inserts with a 
> given sub query like the following:
> INSERT INTO table_a (column_a, column_b, column_c)
>   SELECT
>     /* Literal number values with column aliases */
>     value_a AS column_a,
>     value_b AS column_b,
>     column_x
>   FROM table_b 
>   WHERE ...;



--
This message was sent by Atlassian JIRA
(v6.1#6144)

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscr...@db.apache.org
For additional commands, e-mail: torque-dev-h...@db.apache.org

Reply via email to