Differences between SQLi and Incorta SQL capabilities

RADSr — Wed, 31 May 2023 17:37:52 GMT

I have a SQL statement with a long and convoluted backstory ( tl/dr - bug making me chase workaround ) and I've come across a potential solution using cast ( <column> as numeric )

See the animated GIF at the end of this post for the perplexing problem!

It works wonderfully in DBeaver connecting to Incorta via SQLi

It does not work wonderfully - nor at all - using a derived table w/ Incorta SQL. It 1) asks for precision and scale and 2) excitedly tells me that decimals aren't supported when I give it precision and scale:

Currently decimal type is not supported!

note the serial punctuation.

As well I've found a potential workaround using round(<COLUMN>, 2 ) but again doesn't work in the UI as round() will only take one input and the workaround doesn't work around with only one input.

I hadn't expected that there would be functionality when using an external tool that isn't available internally - should I ? Is there documentation somewhere of what functionality is available where?

topic Differences between SQLi and Incorta SQL capabilities in Administrative Discussions

Differences between SQLi and Incorta SQL capabilities