[TYPO3-core] RFC #11022: DBAL does not support SQL from (new?) session management

[Xavier Perseguers]

Hi,

>> Solution:
>> 1) The parser already supports the "&" as calc operator. Extend it to
>> allow the "+".
> 
> Too bad & is the only operator NOT supported by Oracle [I think it has
> only a BITAND function] ;) Anyway, while you're at it you can add the
> usual operators:
> 
> +, -, *, /, %

Those arithmetic operators are added in v3.

>> , <, <=, >=, =, <>, !=
> &, |, ~, <<, >>
> AND, OR, NOT

& already supported
NOT too

I'm not sure there is a real need to add other logical operators. What 
do you think? I know that adding those operators now would be quite easy 
but OTOH I fear it will slow down the review process as nobody uses 
them. Anyway, I changed the code in v3 to be able to easily accomodate 
more "calc" operators.

> FYI - Bitwise XOR: ^ (Mysql), # (PostgreSQL)

Meaning we should be able to read ^ but output # when backend is PostgreSQL.

@Ries: which driver is used when using a PostgreSQL DB?

>> 2) Remove pretty but unneeded extra parentheses around the calculated
>> statement "(crdate + lifetime)" as it bugs the SQL parser.
> 
> Well, yes. Really a shame the SQL parser isn't that great.

Regards

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 11022_v3.diff
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20090503/adc1b9b7/attachment-0001.txt