db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Wagner (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (TORQUE-305) Do insert with a select subquery
Date Wed, 13 Nov 2013 09:47:20 GMT

     [ 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 */
    1 AS column_a,
    2 AS column_b,
    column_c
  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_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 ...;


> 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 */
>     1 AS column_a,
>     2 AS column_b,
>     column_c
>   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


Mime
View raw message