Provide ability to return all columns using RETURNING (eg RETURNING *)
----------------------------------------------------------------------
Key: CORE-3808
URL: http://tracker.firebirdsql.org/browse/CORE-3808
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Mark Rotteveel
Priority: Minor
Currently when using INSERT ... RETURNING, UPDATE ... RETURNING, DELETE ...
RETURNING one needs to explicitly specify the columns to be returned. It would
be great if this could be extended to return all columns, eg by specifying
RETURNING * (similar to what PostgreSQL has:
http://www.postgresql.org/docs/current/static/sql-insert.html ).
Rationale for this:
The JDBC specification provides for functionality to automatically retrieve
generated keys for statements (see
http://docs.oracle.com/javase/6/docs/api/java/sql/Statement.html#executeUpdate(java.lang.String,%20int)
). As it is impossible to find out which column(s) are auto-generated in
Firebird, Jaybird 2.2 will simply return all columns of a table. However, to be
able to do that I need to query the table metadata which adds additional
overhead (eg server roundtrips).
Being able to simply specify RETURNING * would cut out that overhead and would
simplify the driver side.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
