search

frictionlessdata / tableschema-sql-py

Generate SQL tables, load and extract data, based on JSON Table Schema descriptors.
MIT License
60 stars 19 forks source link

Pattern check uses 'like' which is not RE compatible #84

Closed akariv closed 4 years ago

akariv commented 4 years ago

Overview

In version 1.3.0, constraint checks were added.

The pattern constraint, though, was implemented using a like sql operator which is not POSIX RE compatible:

https://github.com/frictionlessdata/tableschema-sql-py/commit/11b41b27a991a347b9117ae312f2e1dd0ccb4fca#diff-06244424627478397c4e73620b8d452fR72

From the postgresql documentation, the correct operator should probably have been ~.

Please preserve this line to notify @roll (lead of this repository)