ClassCast exception when reading from specific sqlite db

[koperagen]

Firefox places db uses some weird column type that is not standard and not supported by xerial sqlite driver: LONGVARCHAR (https://sqlalchemy.narkive.com/DEL4O0EK/longvarchar). There's also a problem with driver being unable to tell if INTEGER column actually stores Long values
As a result, we have

1. DataColumn with type = BigDecimal?, and values are all String? values
2. DataColumn with type = Int?, and values are all Long? values
   Codegen in notebooks uses type to generate extension properties, and when you use them - you get ClassCast exception

class java.lang.String cannot be cast to class java.math.BigDecimal (java.lang.String and java.math.BigDecimal are in module java.base of loader 'bootstrap')

[Jolanrensen]

This is exactly what the debug mode can catch.
If you set kotlin.dataframe.debug=true in gradle.properties and make a test with the given data, you can see where the values come from and are converted. Runtime class cast exceptions should not occur if the code works with debug mode enabled.

That said, a more helpful exception message would be great :)

[koperagen]

I know