Re: [sqlite] Bind Parameters Documentation

[Filipe Oliveira]

On 08/12/2013 08:26 PM, Filipe Oliveira wrote:

Hi,

In parameters section of this page 
http://www.sqlite.org/lang_expr.html says that


"A dollar-sign followed by an identifier name also holds a spot for a 
named parameter with the name $. The identifier name in this case 
can include one or more occurrences of "::" ...".


It gave me the impression (because of "in this case") that only 
parameters started with '$' can have occurrences of "::" but the 
tokenizer is accepting them for parameters started with ":" and "@".


Am I misunderstanding the documentation?

Thanks,

Filipe Oliveira

Hi,

For what I can see from the code it is possible to have parameters 
started by '#', '$', '@', and ':' that are succeeded by an identifier. 
This identifier can contain not only occurrences of "::" but also a 
suffix enclosed in "(...)".


tokenize.c - line 316
  /* Fall through into the next case if the '#' is not followed by
  ** a digit. Try to match # where  is a parameter name. */
}
#ifndef SQLITE_OMIT_TCL_VARIABLE
case '$':
#endif
case '@':  /* For compatibility with MS SQL Server */
case ':': {
...

From my point of view the documentation isn't according to the 
implementation. Can anyone clarify?


Thanks,

Filipe Oliveira

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bind Parameters Documentation

[Filipe Oliveira]

Hi,

In parameters section of this page http://www.sqlite.org/lang_expr.html 
says that


"A dollar-sign followed by an identifier name also holds a spot for a 
named parameter with the name $. The identifier name in this case 
can include one or more occurrences of "::" ...".


It gave me the impression (because of "in this case") that only 
parameters started with '$' can have occurrences of "::" but the 
tokenizer is accepting them for parameters started with ":" and "@".


Am I misunderstanding the documentation?

Thanks,

Filipe Oliveira
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Possible duplicate grammar rule for expression (in documentation)

[Filipe Oliveira]

Hello,

The grammar rules for an expression 
(http://www.sqlite.org/lang_expr.html) indicate that a binary expression 
can have the operators IS and IS NOT, but there is also one rule above 
the BETWEEN expression that indicates the same.
I was trying to understand if these two rules have different meanings or 
not.


Best regards,

Filipe Oliveira
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users