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 ". -- D. Richard Hipp drh at sqlite.org
