Re: [sqlite] Comments loss in sqlite_master table

The parallel usage would be a bonus if sqlite with threads could in the future be instructed to use more available cores on the system. On Thu, May 29, 2014 at 10:46 AM, big stone wrote: > Hi Domingo, > > Oracle is doing also this sort of things with there / * parallel */

Re: [sqlite] Comments loss in sqlite_master table

Hi Domingo, Oracle is doing also this sort of things with there / * parallel */ comment keyword. For example : http://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm#i1006328 ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Comments loss in sqlite_master table

Hi Dan, You're right : situation is much better than what I thought. I ddid a more complete check, switching from sqlite.exe 3.8.3 to sqlite.dll 3.8.4.3 create /*this */ -- really table /* is */ toty( -- for /* truly */ x --educative ) /*purpose */ -- and comment hunting ; select sql from

Re: [sqlite] Comments loss in sqlite_master table

Here is a link to a document describing the "COMMENT" syntax http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_4009.htm#i2119719 On Thu, May 29, 2014 at 10:34 AM, Domingo Alvarez Duarte wrote: > Hello all ! > > Now that we are talking about comments in sql

Re: [sqlite] Comments loss in sqlite_master table

Hello all ! Now that we are talking about comments in sql statements why not extend sqlite to accept the "COMMENTS" keyword for fields and tables and then we will have a standard way to store extra information about our sql schema. Cheers ! On Thu, May 29, 2014 at 10:10 AM, Luuk

Re: [sqlite] Comments loss in sqlite_master table

On 29-5-2014 11:00, Dan Kennedy wrote: On 05/29/2014 03:42 PM, big stone wrote: Hello, I miss the functionnality of some other sql motors that keep the comments inside an object definition, like a table. This sounds quite illogical, as : - Newlines and spaces are kept, (if not around

Re: [sqlite] Comments loss in sqlite_master table

On 05/29/2014 03:42 PM, big stone wrote: Hello, I miss the functionnality of some other sql motors that keep the comments inside an object definition, like a table. Example : (with sqlite.exe 3.8.3) create table /* This table has an educative purpose */ toto(x); create table /* This table has

Re: [sqlite] Comments loss in sqlite_master table

On Thu, May 29, 2014 at 10:48 AM, Luuk wrote: > According to this: > http://www.sqlite.org/lang_createtable.html > > The comment is not part of the 'full statement'. According to the grammar charts, comments can't appear at all. Comments being allowed to appear is

Re: [sqlite] Comments loss in sqlite_master table

Hi Luuk, You're right : there is also a problem of consistency with documentation . Neither the spaces around 'x' in 'toty( x )' are in the documentation,but SQLite kept those useless spaces anyway. ___ sqlite-users mailing list

Re: [sqlite] Comments loss in sqlite_master table

On 29-5-2014 10:42, big stone wrote: Hello, I miss the functionnality of some other sql motors that keep the comments inside an object definition, like a table. Example : (with sqlite.exe 3.8.3) create table /* This table has an educative purpose */ toto(x); create table /* This table has an

[sqlite] Comments loss in sqlite_master table

Hello, I miss the functionnality of some other sql motors that keep the comments inside an object definition, like a table. Example : (with sqlite.exe 3.8.3) create table /* This table has an educative purpose */ toto(x); create table /* This table has an educative purpose */