simcop2387/DBD-SQLite-SQLcipher
1
0
Fork 0
mirror of https://github.com/DBD-SQLite/DBD-SQLite synced 2025-06-07 06:08:38 -04:00
Code Issues Releases Wiki Activity
DBD-SQLite-SQLcipher/lib/DBD/SQLite/VirtualTable
History
Exact
Max Maischein 1fd1a0d15f Handle 'unknown' op in DBD::SQLite::VirtualTable::PerlData 
This patch adds code and a test when SQLite generates an 'unknown'
op for a table join in the BEST_INDEX() callback. The Perl code crashed
when such an op was generated for a JOIN criterion by the SQLite engine.

The SQLite engine creates an 'unknown' op on the following SQL
for example:

                select r.nodepath
                  from temp.scan_results r
                       left join temp.scan_results m
                             on r.nodepath = m.nodepath+1
                 where m.nodepath is null

The important part is that the right side of the left join must be
checked for IS NULL.
2019-01-25 19:05:07 +01:00
..
FileContent.pm oops, overlooked unnecessary non-core deps 2014-07-21 14:16:52 +09:00
PerlData.pm Handle 'unknown' op in DBD::SQLite::VirtualTable::PerlData 2019-01-25 19:05:07 +01:00