Import SQLite 3.8.7.4.

third_party/sqlite/src/test/transitive1.test

 # 2013 April 17
 #
 # The author disclaims copyright to this source code.  In place of
 # a legal notice, here is a blessing:
 #
 #    May you do good and not evil.
 #    May you find forgiveness for yourself and forgive others.
 #    May you share freely, never taking more than you give.
 #
 #*************************************************************************
@@ skipping 264 matching lines @@
                        AND seasons.season = episodeview.c12)
       JOIN files ON files.idFile = episodeview.idFile
       JOIN tvshowlinkpath ON tvshowlinkpath.idShow = tvshowview.idShow
       JOIN path ON path.idPath = tvshowlinkpath.idPath
   WHERE tvshowview.idShow = 1
   GROUP BY episodeview.c12;
 } {1 /tmp/tvshows/The.Big.Bang.Theory/ {The Big Bang Theory} {Leonard Hofstadter and Sheldon Cooper are brilliant physicists, the kind of "beautiful minds" that understand how the universe works. But none of that genius helps them interact with people, especially women. All this begins to change when a free-spirited beauty named Penny moves in next door. Sheldon, Leonard's roommate, is quite content spending his nights playing Klingon Boggle with their socially dysfunctional friends, fellow CalTech scientists Howard Wolowitz and Raj Koothrappali. However, Leonard sees in Penny a whole new universe of possibilities... including love.} 2007-09-24 Comedy CBS TV-PG 3 1 0}
 
 
 finish_test