On 2018/08/01 4:50 PM, Bart Smissaert wrote:
I think you might be right there, but for my practical purpose I need the result to be invalid. I just wonder if a Halt at row 2 and no further rows produced is good way to determine this.
Such a hard question to answer. It's like asking if a Robo-suitcase is a good idea for your fishing tackle... It /might/ be, but since none of us use it that way, it's hard to answer definitively.
That said, David Raymond already did a good job of checking some of the pragmas for you and at least proved that false positives exist for the simple rule you expressed.
May I ask about your use-case and what specifically is needed? Perhaps a simpler way exists to get to it. The "let's feed it to the engine and see if it cries" method of error detection is dangerous to my mind, especially for pragmas that alter the DB, but it might be perfectly o.k. in your use-case.
Cheers, Ryan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
