Hi all, we are running into an issue with H2's behaviour around fixed length character types as described in https://groups.google.com/forum/#!topic/h2-database/oB3Wrv0obEQ
The situation we have is that we are writing tests for an abstraction layer on top of JD Edwards, which uses CHAR fields heavily. To test our abstractions we would like to simulate the DB2 behaviour with H2, but the difference with the trimming of CHAR fields makes that difficult. I looked at how I could possibly fix this. The relevant code seems to be the first line in org.h2.value.ValueStringFixed#get(String). I could probably add another field in org.h2.engine.SysProperties to toggle the behaviour (obviously defaulting to the current one), but in many ways it seems appropriate to have it as a toggle on org.h2.engine.Mode. The first problem I have is that I don't know how to get to the mode from the code in ValueStringFixed. There doesn't seem to be an obvious path for that data to flow through. But that might well be just me not having really understood the code yet. I also don't know if that would be an acceptable change given that it will affect existing behaviour - if someone has worked around the H2 behaviour in the modes of engines that do not trim, then changing the behaviour for the mode could break things. It seems extremely unlikely to cause real grief, but technically it would be a breaking change. Would such a change be acceptable? Cheers, Peter -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
