Noel Grandin comments

Results 137 comments of


                                            Noel Grandin

Support UNSIGNED data types

unsigned arithmentic is weird https://stackoverflow.com/questions/430346/why-doesnt-java-support-unsigned-ints/15053268#15053268

Merge and update on a table with a composite primary key extremely slow.

do you have a self-contained test case?

Backport H2 to java8

I would be ok with just keeping this on a separate branch, and then you can merge/etc new stuff to that branch.

Data Races org.h2.jdbc.JdbcConnection

Hmmm. In most other methods in JdbcConnection, we appear to be trying to make this class thread-safe via calls to lock() and unlock(), so it seems reasonable to me that...

Data Races org.h2.jdbc.JdbcConnection

> IJust wonder, how big that can of worms To my mind, the only promise we can reasonably make is that multiple threads can call JdbcConnection and those calls are...

H2 selects less selective index in query plan

Would you like to try improving the selectivity calculation? The relevant code is in Analyze#analyzeTable and Index#getCostRangeIndex

H2 selects less selective index in query plan

Very nice analysis! > > > `analyzeTable` currently samples the first `N` rows (presumably based on the order they were written to disk?). > It samples the first N rows....