Replace REGEXP with LIKE for sql queries in renameForFuse
File names and folder names can include special characters. For such
file names SQL REGEXP might misinterpret actual char in file name as
regex metacharacter. This misinterpretation leads to SQL query failures
or mismatching different db rows than expected. To resolve this, we
should escape all metacharacters in file name. Since the same SQL query
can be achieved using SQL LIKE, we can replace REGEXP with SQL LIKE.
Changed rename methods getWritableFilesForRenameDirectory and
getAllFilesForRenameDirectory to use SQL LIKE instead of SQL REGEXP.
Bug: 160438494
Bug: 160441534
Test: atest android.scopedstorage.cts.host.ScopedStorageHostTest#testRenameWithSpecialChars
Change-Id: I67f966ccdc28d4ce403d45b34eda65bcb20dd718
(cherry picked from commit ad3c0c8eaccd0019c997d0b209163a9d662b6f24)
(cherry picked from commit ab4fd9add6ee54cc6f039e72378c6756be2cb366)
1 file changed