Unexpected Empty Reducer Folder

[bajinsheng]

@oraluben @ColinYoungTaro Great job for your reducer!

I am quite interested in it and have several questions when using it.

java -jar sqlancer-2.0.0.jar --num-threads 20 --use-reducer --reduce-ast --username root --password "" tidb --oracle WHERE

I run this command. Although I observed a crash, but no reduced log file was produced in the reduce folder.
Can you help look into this issue?

[oraluben]

Thanks for using and helping to test! I'll take a look at it.

[oraluben]

@bajinsheng Did you see EXPERIMENTAL: Trying to reduce queries using a simple reducer. in stdout?

[bajinsheng]

No relevant output.

[oraluben]

The reducer relies on Reproducer from TestOracle.check, which is currently null for most of the oracle implementations. At the moment only NOREC for sqlite3 implemented that. I'll find a way to reuse the oracle implementations and make that work for other DB/oracle.

[mrigger]

I assume the other DBMSs need to implement the Reproducer class (see

sqlancer/src/sqlancer/sqlite3/oracle/SQLite3NoRECOracle.java

Line 41 in 7804a3a

private class SQLite3NoRECReproducer implements Reproducer<SQLite3GlobalState> {

).