-
Notifications
You must be signed in to change notification settings - Fork 5
Description
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