Hi, I wanted to insert values by using a subquery with some constants (INTEGER and VARCHAR):
INSERT INTO MONITOR_SCHEMA.MAP_SLA_TRANS (TA_TYPE_ID, SLA_NAME, CREATOR, CREATE_DATETIME, CATALOG) VALUES ( SELECT 1 as TA_TYPE_ID,SLA_NAME,'TEST' as CREATOR, CURRENT_TIMESTAMP() AS CREATE_DATETIME,'TPCC30' AS CATALOG FROM MONITOR_SCHEMA.SLA WHERE ALL_TRANSACTIONS = 'TRUE' AND SLA_NAME != 'TENANT1_ONLYTWOTAS') The subquery itself can be executed without any problems. But integrated in the INSERT statement I got the following error message (I also tried it without alias names in the subquery): COLUMN_COUNT_DOES_NOT_MATCH = 21002 I used version 1.3.170 with a lot of modifications, but they should be not responsible for the problem Thanks, Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
