Im using the following SQL:
MERGE INTO TEST_EXPORT KEY (ID) SELECT * FROM TEST WHERE TIME >
TEST.TIME AND ID = TEST.ID ;
It actually runs without complains, but don't updates the rows where the
time is greater..
Help is very appreciated.
Den torsdag 17 november 2016 kl. 16:38:25 UTC+1
Indexes normaly slow down inserts and speeds up selects(if indexes is
usable). Can you post more details? Like structure of table, number of
rows, select you performed?
Dne čtvrtek 17. listopadu 2016 16:04:39 UTC+1 Tommi Korhonen napsal(a):
>
> I did some testing and it seems my database is
those tables are related to LOB/CLOB/BLOB space management.
it's quite possible we have a leak somewhere in our handling of those,
particularly if you are generating temp tables with LOBs.
Unfortunately, without a test case, it is unlikely that we can fix it.
--
You received this message
follow the preparedstatement code down, to see how the parsing is different
from regular statement.
shouldn't be too hard to implement
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails
Hello,
we are using H2 version 1.4.192. Database URL is jdbc:h2:file:;CIPHER=AES;MV_STORE=false.
The size of the database file is growing dramatically in some environments
and we do not understand why. We checked our code for errors that prevented
committing of Hibernate transactions and the
Hello,
I have a problem with the following statement:
SELECT * FROM (SELECT ? FROM DUAL)
it gives this error with H2 1.4.191:
org.h2.jdbc.JdbcSQLException: Unknown data type: """?1"""; SQL statement:
SELECT * FROM (SELECT ? FROM DUAL) [50004-192]
at
Hi All!
H2 has a cool feature *EXPLAIN* for SQL statements.
Recently I found that statemtnts like "EXPLAIN Select * from Person where
ID = 1" - explained,
but "EXPLAIN Select * from Person where ID = ?" - failed.
It will be cool if EXPLAIN could process statements with "?".
It is possible? I
Hi im a new user of H2 database.
Im using the merge statement to insert data into the database.
Im looking for anysuggestion to do the following:
"Merge All data from Table1 into Table2 if Table1.ID = Table2.ID and
Table1.TIME > Table2.TIME"
--
You received this message because you are
I did some testing and it seems my database is much faster without indexes!
As I wrote, the database is in memory, not in file. It seems that indexes
only make memory searches slower. Maybe the query plan takes less time if
table scan is the only option.
--
You received this message because