Prepared Plan Cache support limit ?

[dbsid]

Enhancement

Currently plan cache does not support query including limit ? clause, just in case small or large numbers should not shared the sample execution plan.

For real-world core-banking application, the number for limit ? is consistent. This kind of query ranks top executions, it makes sense to to cache plan and reduce the compilation cost.

An example query select * from account where sub_acct_no = ? and sign_status = ? limit ?

I'll suggest to add a config to lift this limitation.

[qw4990]

Duplicated with #38491