Skip to content

Set default value of parse_float_as_decimal to true #14612

@andygrove

Description

@andygrove

Is your feature request related to a problem or challenge?

According to the ANSI SQL specification, floating point numbers in SQL should be interpreted as decimals. We currently interpret them as floats:

    pub struct SqlParserOptions {
        /// When set to true, SQL parser will parse float as decimal type
        pub parse_float_as_decimal: bool, default = false

Describe the solution you'd like

Set default to true and fix regressions in test suite. This will likely involve fixing some bugs in type coercion such as #14272

Describe alternatives you've considered

No response

Additional context

No response

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions