[sqlite] Crash when running complex FT5 queries

[Gergely Lukacsy (glukacsy)]

Hi,



We run into a reproducible crash on FTS5 search when searching something 
complex such as:



"(word1* word2* word3*) OR word1* OR word2* OR word3*"



It might be that we are doing something wrong, but any insight is appreciated. 
The actual crashing call is a sqlite3_step/1 call:



while (SQLITE_ROW == stepResult)

  {

                stepResult = sqlite3_step(statement); // BOOM



                if (stepResult == SQLITE_ROW)

                {

                           ...

                }

}



Regards,

Gergely



              0000000000000000()    Unknown

             SparkWindows.exe!sqlite3_column_name16?()    C

             SparkWindows.exe!sqlite3_column_name16?()    C

             SparkWindows.exe!sqlite3_column_name16?()    C

             SparkWindows.exe!sqlite3_column_name16?()    C

             SparkWindows.exe!sqlite3_create_function16?() C

             SparkWindows.exe!sqlite3CodecGetKey?()            C

             SparkWindows.exe!sqlite3CodecGetKey?()            C

             SparkWindows.exe!sqlite3_step?()           C

             SparkWindows.exe!sqlite3_column_name16?()    C

             SparkWindows.exe!sqlite3_column_name16?()    C

             SparkWindows.exe!sqlite3_result_subtype?()       C

             SparkWindows.exe!sqlite3CodecGetKey?()            C

             SparkWindows.exe!sqlite3CodecGetKey?()            C

             SparkWindows.exe!sqlite3_step?()           C

>              
> SparkWindows.exe!DatabaseWrapper::DBWrapper::_fetchFromDatabase(const 
> std::basic_string<char,std::char_traits<char>,std::allocator<char> > & 
> tableName, const 
> std::basic_string<char,std::char_traits<char>,std::allocator<char> > & 
> select, const 
> std::vector<std::tuple<std::basic_string<char,std::char_traits<char>,std::allocator<char>
>  >,DatabaseWrapper::DBType,enum 
> DatabaseWrapper::DBOperatorType>,std::allocator<std::tuple<std::basic_string<char,std::char_traits<char>,std::allocator<char>
>  >,DatabaseWrapper::DBType,enum DatabaseWrapper::DBOperatorType> > > & 
> arguments, unsigned __int64 limit, const 
> std::basic_string<char,std::char_traits<char>,std::allocator<char> > & 
> orderByColumnName, const bool orderByDescending) Line 504             C++

              
SparkWindows.exe!DatabaseWrapper::DBWrapper::_fetchFromDatabase(const 
std::basic_string<char,std::char_traits<char>,std::allocator<char> > & 
tableName, const 
std::vector<std::basic_string<char,std::char_traits<char>,std::allocator<char> 
>,std::allocator<std::basic_string<char,std::char_traits<char>,std::allocator<char>
 > > > & columns, const 
std::vector<std::tuple<std::basic_string<char,std::char_traits<char>,std::allocator<char>
 >,DatabaseWrapper::DBType,enum 
DatabaseWrapper::DBOperatorType>,std::allocator<std::tuple<std::basic_string<char,std::char_traits<char>,std::allocator<char>
 >,DatabaseWrapper::DBType,enum DatabaseWrapper::DBOperatorType> > > & 
arguments, unsigned __int64 limit, const 
std::basic_string<char,std::char_traits<char>,std::allocator<char> > & 
orderByColumnName, const bool orderByDescending) Line 435             C++