Re: [h2] Re: show hex value

Hello! There is a RAWTOHEX function, you can convert this integer number to a BINARY(4) data type and pass the result to this function: SELECT RAWTOHEX(CAST(1234567890 AS BINARY(4))); -- You received this message because you are subscribed

Re: [h2] index doesn't help

Hello! WHERE boolean and WHERE boolean = TRUE have no difference. The actual problem is usage of OR, H2 is unable to use indexes in such conditions. Take a look on execution plan produced by the EXPLAIN command: SELECT "SEQUENCE",

Re: [h2] Re: show hex value

Greetings. On Sat, 2023-01-21 at 09:21 -0800, mche...@gmail.com wrote: > hi , possible to show an integer in hex format? As far as I understand you can define your own Functions in H2, using Java language. This should do the trick. Cheers Andreas -- You received this message because you are

Re: [h2] index doesn't help

Greetings. On Sat, 2023-01-21 at 09:12 -0800, mche...@gmail.com wrote: > where mem or irqRequest <-- very slow I'd try  WHERE mem=true OR irqRequest=true It is possible that mem=irqRequest is not detected or considered (even when it resolved to the same meaning). It is also possible the OR

[h2] Re: show hex value

hi , possible to show an integer in hex format? On Wednesday, 4 January 2023 at 16:55:47 UTC+8 Evgenij Ryazanov wrote: > Hi! > > H2 Console already displays values of binary strings in hexadecimal > format, if you need a similar feature in other tool you should ask its > developers instead. >

[h2] index doesn't help

Hi all This query select sequence,mem,memaddr,memvalue, memRead from data where mem or irqRequest order by sequence where mem <-- fast where irqRequest <-- fast where mem or irqRequest <-- very slow create index mem on data(mem); create index irqRequest on data(irqRequest); create index