[
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: [email protected]
For additional commands, e-mail: [email protected]
