Can't cast a text field to integer, even though the data should allow it.

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Upload the attached .csv file to the ORDS
2. In the Schema designer, try changing the 'Age' field from text to Integer.
3. Receive error message 'ERROR: default for column "Age" cannot be cast to 
type integer'

What is the expected output? What do you see instead?
It should cast to integer without any problems.

Please use labels and text to provide additional information.
Chrome staging 1.0.8 - 4125 + Chrome App 1.0.7

Original issue reported on code.google.com by jajwil...@gmail.com on 2 Mar 2015 at 4:45

[GoogleCodeExporter]

Hmm. I'm finding that I can no longer cast the 'latitude' field from text to 
Decimal in the usual Mondial db either. This DEFINITELY worked in the past, so 
this is a bug that has crept into the schema designer relatively recently. This 
is an Access import - so it's not just .csv imports being affected. 
Upping priority.

Original comment by jajwil...@gmail.com on 2 Mar 2015 at 5:03

• Changed title: Can't cast a text field to integer, even though the data should allow it.
• Added labels: Priority-Critical
• Removed labels: Priority-High

[GoogleCodeExporter]

Seems I forgot to add the file where I couldn't cast text to int. Here it is!

Original comment by jajwil...@gmail.com on 13 Mar 2015 at 2:16

Attachments:

• colourstest2.csv