Skip to content

Crash when using string_length with sqlite #199

@spicychickensauce

Description

@spicychickensauce

Code of Conduct

  • I agree to follow this project's Code of Conduct

AI Policy

  • I agree to follow this project's AI Policy, or I agree that AI was not used while creating this issue.

Versions

ash_sql: "0.3.16"

Operating system

Current Behavior

In a calculation, I have expr(string_length(field)).
When using sqlite, this leads to the error:

Unknown Error
* ** (Exqlite.Error) no such function: normalize

The sql fragment seems to be generated here.

sqlite doesn't have a normalize function.

I can easily work around the issue by using fragment("LENGTH(?)", field) instead.

Reproduction

No response

Expected Behavior

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions