Skip to content

Sql Column Presence is not validating correctly #7

@lusabo

Description

@lusabo

Describe the bug
Sql Column Presence is not validating correctly

To Reproduce

Go to page: https://hub.guardrailsai.com/validator/numbersstation/sql_column_presence

Query example: SELECT title, description, responsible FROM task
Cols: title
Actual behavior: Failure
Expected behavior: Success

Query example: SELECT 'title', 'description', 'responsible' FROM task
Cols: title
Actual behavior: Success
Expected behavior: Success

Query example: SELECT 'title', 'description', 'responsible' FROM task
Cols: 'title'
Actual behavior: Success
Expected behavior: Success

Query example: SELECT 'title', 'description', 'responsible' FROM task
Cols: 'titles'
Actual behavior: Success
Expected behavior: Failure

Query example: SELECT 'title', 'description', 'responsible' FROM task
Cols: 'titles'
Actual behavior: Success
Expected behavior: Failure

Query example: SELECT 'title', 'description', 'responsible' FROM task
Cols: 'abcd'
Actual behavior: Success
Expected behavior: Failure

Query example: INSERT INTO task ('title', 'description', 'responsible') VALUES ('A','B','C')
Cols: 'abcd'
Actual behavior: Success
Expected behavior: Failure

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions