You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Michael Wagner (JIRA)" <ji...@apache.org> on 2013/11/13 10:45:24 UTC

[jira] [Created] (TORQUE-305) Insert with a Select Subquery

Michael Wagner created TORQUE-305:
-------------------------------------

             Summary: 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_value, column_b_value, column_c_value)
  SELECT
    /* Literal number values with column aliases */
    1 AS column_a_value,
    2 AS column_b_value,
    column_c_value
  FROM table_b 
  WHERE ...;



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

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