chop-dbhi / dataexpress

[NOT MAINTAINED] DataExpress is a simple, Scala-based cross database ETL toolkit supporting Postgres, MySql, Oracle, SQLServer, and Sqlite
http://dataexpress.research.chop.edu
BSD 2-Clause "Simplified" License
72 stars 9 forks source link

Handle ambiguous precision/scale on NUMERIC output #11

Open mitalia opened 12 years ago

mitalia commented 12 years ago

With some databases, numeric output can come out of the database without precision and scale assigned. Currently, this causes table creation and inserts to fail. We should fall back to a plain NUMERIC data type with no precision or scale when this happens (if supported by the target database). There is an Oracle example we can use as a starting point.