[h2] Re: [h2database/h2database] propagate trace settings to ephemeral databases (#2214)

2019-10-31 Thread Steven Parkes
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

[h2] Re: Trailing whitespaces are removed from varchar

2019-10-31 Thread Evgenij Ryazanov
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

[h2] Re: A negative scale value produces incorrect precision and scale values

2019-10-31 Thread Thomas Maurer
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

[h2] Re: Trailing whitespaces are removed from varchar

2019-10-31 Thread Evgenij Ryazanov
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 =

[h2] Re: Trailing whitespaces are removed from varchar

2019-10-31 Thread Rikard Swahn
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,

[h2] Re: row_number() over (order by (select null))

2019-10-31 Thread Evgenij Ryazanov
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))

[h2] Re: Trailing whitespaces are removed from varchar

2019-10-31 Thread Evgenij Ryazanov
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

[h2] Trailing whitespaces are removed from varchar

2019-10-31 Thread Rikard Swahn
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

[h2] Re: row_number() over (order by (select null))

2019-10-31 Thread Evgenij Ryazanov
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

[h2] row_number() over (order by (select null))

2019-10-31 Thread Wouter Zelle
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

[h2] Re: A negative scale value produces incorrect precision and scale values

2019-10-31 Thread Evgenij Ryazanov
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

[h2] Re: A negative scale value produces incorrect precision and scale values

2019-10-31 Thread Thomas Maurer
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.