You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Thank you for the useful library.
I have encountered sql error when using Char '\NUL' in String.
Char '\NUL' is generated by (Test.QuickCheck.arbitrary :: Test.QuickCheck.Gen String) for example.
ENVIRONMENT
stack resolver: lts-13.12
extra-deps: HDBC-postgresql-2.3.2.6
db backend: postgresql 11.1
REPRODUCTION CODE
※conn is my local db Connection
ghci>str = ['a', '\NUL', 'b']
ghci>str
"a\NULb"
ghci>q = Database.Relational.relation . return . Database.Relational.value $ str
ghci>q
SELECT ALL 'ab' AS f0
ghci>show q
"SELECT ALL 'a\NULb' AS f0"
ghci>Database.HDBC.Record.Query.runQuery conn (Database.Relational.relationalQuery q) ()
*** Exception: SqlError {seState = "42601", seNativeError = 7, seErrorMsg = "execute: PGRES_FATAL_ERROR: ERROR: unterminated quoted string at or near \"'a\"\nLINE 1: SELECT ALL 'a\n ^\n"}
It seems like to fail escaping Char '\NUL'.
Excuse me for reporting only for now.
The text was updated successfully, but these errors were encountered:
Thank you for the useful library.
I have encountered sql error when using Char '\NUL' in String.
Char '\NUL' is generated by (Test.QuickCheck.arbitrary :: Test.QuickCheck.Gen String) for example.
ENVIRONMENT
REPRODUCTION CODE
※conn is my local db Connection
It seems like to fail escaping Char '\NUL'.
Excuse me for reporting only for now.
The text was updated successfully, but these errors were encountered: