Quantifier node could utilize Used Identifier List to improve its execution efficiency

albertZhangTJ / sqlancer-lancerfuzz

Detecting Logic Bugs in DBMS

http://www.sqlancer.com/

MIT License

1 stars 0 forks source link

Quantifier node could utilize Used Identifier List to improve its execution efficiency #7

Closed albertZhangTJ closed 6 months ago

albertZhangTJ commented 7 months ago

Instead of querying target DBMS for available identifiers in every iteration of the quantifier node, we can cache the list alongside Used Identifier List. This should help improve the efficiency drastically.

albertZhangTJ commented 6 months ago

Tried, doesn't work with forward only ResultSets. Translating the result set to another data structure is doable yet might not worth it since the cache reuse rate is expected to be low. Will close for now.