If you can reduce this to a standalone SQL script, I can take a look at it.
Why would you need to have local modifications to h2? On Saturday, 22 June 2013, wrote: > 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] <javascript:_e({}, > 'cvml', 'h2-database%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[email protected]');> > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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.
