Proposal: support syntax "SET DEFAULT [GLOBAL] $SortMode"

[MrCroxx]

In distributed environment, the order of query result set is uncertain, which is also not required in SQL without "ORDER BY".

To simplify the test script, we can support syntax like SET DEFAULT [GLOBAL] $SortMode to set the default sort mode required by query statement in the current file or all files, instead of specify sort mode after each. query statement.

[fuyufjh]

Can we add an option to compare the result set without ordering?

[fuyufjh]

BTW, it's bad to use a SET DEFAULT... syntax because SET command is usually a command for database.

[MrCroxx]

Can we add an option to compare the result set without ordering?

We already have. But it's not the default config.

https://github.com/singularity-data/sqllogictest-rs/blob/77f0ae315a4d5056ab3a6d817683bbc3ef1cf835/src/parser.rs#L98-L109

[MrCroxx]

@fuyufjh Do you prefer set RowSort as default or keep the current config and introduce a syntax to set the sort mode, 0.0 .

[fuyufjh]

@fuyufjh Do you prefer set RowSort as default or keep the current config and introduce a syntax to set the sort mode, 0.0 .

Both are okay for me. But if we want others to use our sqllogictest-rs, Prefer the later one ("introduce a syntax to set the sort mode")

[skyzh]

Yes, I would prefer to use some control statement. Currently, we have:

statement ok
xxxx

... and we can have

+control default rowsort