> Le 2 mars 2016 ? 13:26, Richard Hipp <drh at sqlite.org> a ?crit : > > On 3/2/16, Olivier Mascia <om at integral.be> wrote: >> Hello, >> >> This is really not important, nor a bug, but since I started with SQLite I >> have been puzzled about its habit to convert to upper case the beginning of >> each schema statement (CREATE TABLE, CREATE INDEX). It looks like it stores >> and keeps the remaining intact, but convert the "create table ..." to >> "CREATE TABLE ...". >> >> Is there a functional reason to do this? >> > > Formats like: "create temp table fuzzy(...." and "create table > aux.fuzzy(..." need to have the "temp" and "aux." tokens stripped out. > That is most easily accomplished by just replacing everything up > through the start of the name of the table with "CREATE TABLE ".
Thanks. It explains it. :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om
