Zeoslib Portal

EgonHugeist , Nobody missed it be for I guess nobody missed that detection before because it doesn't affect resulting statement, so there is no need to make it optional (at least someone uses tokinizer directly). i'll start with the x''/0x'' for the other Drivers How do you think will be the best? ...

markus,

Fixed in Zeos7_branches_ testing rev.1652.

EgonHugeist,

I absolutely agree. E-modifier was just a 'must have' case, because if tokenized incorrectly - it broke the whole query processing.

It would be great to have methods for detecting such states.

EgonHugeist,

yes, it should be ttQuoted.
I just didn't know how to make it right (how to detect Emp as ttWord, but E'mp' as ttQuoted).

EgonHugeist,

Sorry, I didn't actually understand your question.

A quoted state is everything in '
'E' is a modifier.

Oh, this is great! Congratulations!!!

EgonHugeist , can you take a look at the following patch. What do you think about? It gets standard_conforming_strings value from Properties, but if not specified - takes it depending on protocol version (ON - for PG9+). This way user can specify SCS manually, or expect default behaviour for server...

EgonHugeist,

I don't know and didn't expect such a syntax...

It's not a problem, I can add this processing. It's gonna be very useful for DBMS developers etc.

Sure you understand what i mean.

I'm not sure I understand, I need to look deeper...

EgonHugeist , Other possibility is you create a ttWord childstate. "E" is a word state. If you check the next char for "\" or"'" then go on reading and change the result state(dependend on StandartConfirmingStrings). Yes, it's also a good algorythm. But it's only "...

EgonHugeist , and could you please insert some much more complicated tests, with accedend chars like 'üöäü'? that would be great! I'll do it. Do we need now GetServerSetting(), FStandartConfirmingStrings, function EncodeString and so on?? What do you think? Look at test I gave you earlier (procedur...

I made some tests of it on XE2 & UTF8. Seems to work fine. You only have to make Dest an out or var param.

EgonHugeist , No, actually. When standard_conforming_strings=off or E'syntax is used, then \' is parsed as ' But when standard_conforming_strings=on, \' is parsed as \' backslash_quote controls, whether postgres should allow usage of \' in SCS=off & E'syntax modes or it should raise exception. ...

EgonHugeist,

Yes, you're right. I was talking about IZPostgreSQLTokenizer interface.
I need it to set StandardConformingStrings behaviour.

EgonHugeist , I'm proceeding with modifying QuoteState tokenizer and I'm gonna need TZPostgreSQLTokenizer back (with a little change). This is a test I made that uses it. procedure TZTestPostgreSQLTokenizer.TestQuoteState; const TokenString1: string = '"a\""\''aa" ''c\'' ''c''''...

miab3,

Maybe you use some special compile settings (optimization=false etc.)