Support optional error string

[neverchanje]

statement error string::interval: context-dependent operators are not allowed in computed column\nHINT: STRING to INTERVAL casts depend on session IntervalStyle; use parse_interval\(string\) instead
CREATE TABLE invalid_table (
  invalid_col interval AS ('1 hour'::string::interval) STORED
)

Statement error is also a part of the testing. In some circumstances, we may expect the system to produce errors as expected.

[skyzh]

We already have

query error pgcode 42601
select count(sum(v3)) from t

Does this work for you?

[neverchanje]

Am I using the wrong version?

sqllogictest --version
sqllogictest 0.5.4

My sqllogictest encountered the following failure:

query error pgcode 22000
select -1.702823466e+308 -1.702823466e+308

sqllogictest -p 4566 -d dev -u root 'test.slt'
[FAILED]

failed to parse sqllogictest file

Caused by:
    ParseError { kind: InvalidSortMode("pgcode"), loc: Location { file: "test.slt", line: 1 } }

Error: some test case failed:
[
    "test.slt",
]

[skyzh]

Oh, then it might not be well-supported. I'll take a look...

[xxchan]

Currently we only have statement error support.

Duplicate with: #30

[xxchan]

close as duplicate