Re: [h2database/h2database] propagate trace settings to ephemeral databases
(#2214)
I wrote the code, it's mine, and I'm contributing it to H2 for distribution
multiple-licensed under the MPL 2.0, and the EPL 1.0
(https://h2database.com/html/license.html).
Thanks for the project and thanks to
Issue with H2 Console was fixed.
https://github.com/h2database/h2database
https://h2database.com/html/build.html#building
--
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
Thank you very much!
--
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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
This is the same issue. H2 Console reads the formatted value with
JavaScript where spaces were already removed by the browser; you can
add white-space: pre style to cells (if your browser has development tools)
as a workaround.
The database is not affected.
try (Connection c =
No, it seems like they are removed. If I edit the value, the input box also
is missing the space.
If I insert with two trailing spaces, it is persisted: INSERT INTO TEST
VALUES(2, 'Hello2 ');
This is a real issue I have in a groovy application, where I use jdbc.
On Thursday, October 31,
If you want to assign row numbers to a some column, you can use the
following command in both SQL Server and H2:
CREATE TABLE TEST(ID INT PRIMARY KEY, NUMBER INT);
INSERT INTO TEST(ID) VALUES (1), (2), (5), (6), (7), (10);
WITH T(ID, RN) AS (SELECT ID, ROW_NUMBER() OVER(ORDER BY (SELECT 1))
Hello.
They aren't removed by H2. Web browser ignores them when it displays a
table.
Perhaps H2 Console should use some style such as white-space: pre to make
them visible.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from
Hello,
Trailing spaces seem to be removed by H2 on varchar columns.
Example, run this in dbconsole:
CREATE TABLE TEST(ID INT PRIMARY KEY,
NAME VARCHAR(255));
INSERT INTO TEST VALUES(1, 'Hello ');
SELECT * FROM TEST;
name is then returned as 'Hello'
Tested on H2 1.4.200 (2019-10-14)
Is
Hello.
I tried to execute such command in SQL Server 2012, 2017, and 2019 on
db<>fiddle and I must say that it leads to undefined results in this
database system. It can set column to 1 in all rows, in can set column to 1
in some rows and to some other number in other rows depending on content
Hi,
I have a query that works in SQL Server, but not in H2 1.4.200:
update table set field = sub.rownumber from
(select row_number() over (order by (select null)) as rownumber from table)
sub
The error message claims that there is a syntax error after the first
'from.' Is there a way to do
It was already fixed, you can build H2 from its current sources available
on GitHub, if you wish.
https://github.com/h2database/h2database
https://h2database.com/html/build.html#building
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To
Hi Evgenij
Oracle supports scale values from -84 to 127
https://www.oracletutorial.com/oracle-basics/oracle-number-data-type/. Do
you intend to fix the problem to maintain oracle compatibility?
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
12 matches
Mail list logo