Re: [sqlite] Patch to fix pragma short_column_names in sqlite 3.0.0

2004-06-19 Thread John LeSueur
D. Richard Hipp wrote: The intend is to fix SQLite 3.0 so that it generates column names the same way as other database engines. Hence it will (in theory) be compatible and no "AS" aliases will be required. If somebody can supply me with a consise list of rules for generating column names, that wo

Re: [sqlite] Patch to fix pragma short_column_names in sqlite 3.0.0

2004-06-19 Thread D. Richard Hipp
John LeSueur wrote: > The reason [the short_column_names] pragma is important to me is for > compatibility with existing codebases. I have a couple large applications > that run on postgres, that I am porting to a desktop application that will > use sqlite as the backend. I would rather not add as

[sqlite] Patch to fix pragma short_column_names in sqlite 3.0.0

2004-06-19 Thread John LeSueur
There seems to be a bug with pragma short_column_names that if it is set, column names are blank. Attached is a patch to fix this. To be honest, I'm not very familiar with sqlite's codebase, so the P3_STATIC is kind of a guess, but it compiled and ran just fine. The reason this pragma is importan