Stability seems good to me. I sometimes get MS SQL and MySQL database
corruptions either from power outages or OOM. I think you've done an
insanely awesome job putting H2 together Thomas. Other more "Mainstream"
products seem to get more hype and attention, but I don't think that
makes them bet
Hi,
Not sure about version 1.3.153, but with a current version of H2, I get,
depending on autocommit enabled or not:
Autocommit enabled:
rollback to savepoint test_savepoint;
Savepoint is invalid: "TEST_SAVEPOINT"; SQL statement:
rollback to savepoint test_savepoint [90063-192] 90063/90063
Autoc
Hi,
What I could do is make H2 version 1.4.192 "non-beta" now. I didn't want to
do that because for some use cases (according to Steve McLeod), performance
was not great with versions up to and including 1.4.191, and I didn't know
about 1.4.192. But now I have confirmation from Steve McLeod that
p
Ooops, so easy using escape. Sorry.
select csvwrite('C:\temp\test.txt', 'select * from v1', 'charset=UTF-8
fieldDelimiter= escape= writeColumnHeader=false') as "written";Enter code
here...
On Wednesday, June 8, 2016 at 4:45:36 PM UTC+2, t603 wrote:
>
> Hello,
>
> I have a quite simple questi
Hello,
I have a quite simple question about CSVWRITE in H2 1.4.191. My code is:
create or replace view v1 as select '"a"';
select * from v1;
select csvwrite('C:\temp\test.txt', 'select * from v1', 'charset=UTF-8
fieldDelimiter= writeColumnHeader=false') as "written";
And I got:
""a""
But I
Am trying to do execute a CreateCluster operation. I have two databases on
different machines started by:
java -cp c:\h2\bin\h2-1.4.192.jar org.h2.tools.Server -tcp -tcpPort 9101
-tcpAllowOthers -baseDir c:\Users\scottvm9
java -cp c:\H2\bin\h2-1.4.192.jar org.h2.tools.Server -tcp -tcpPort 9101
