Zeoslib Portal

Hi All! I'm fairly new to PostgreSQL and I noticed that using the Zeoslib PostgreSQL protocol querying CURRENT_TIMESTAMP always gives an unadjusted value (it seems to return UTC time which is what PostgreSQL stores for TimestampTz types.) I think that's incorrect (or perhaps I'm doing something wron...

Hi All! Is there something weird about Zeoslib's handling of PostgreSQL's current_timestamp? (or possibly with PostgreSQL's timezone support in general.) I'm just doing a standard: select current_timestamp; And I always seem to get UTC time back instead of my current timezone's time. The timezone is...

Looks good, thanks! Again, I really like what you did with that whole thing. As you mentioned previously, the ability to separate out the format settings code also made it a lot easier to test in a standalone manner. One very minor thing is that I notice that the classes in ZFormatSettings require a...

There's an issue with the foRightZerosTrimmed option in that leading zeros aren't preserved when it does the math to remove the trailing zeros. Basically it sets the scale to the number of digits left, but if the NanoFractions was 010000000 (.01 second) it gets reduced to 1 with a scale of 1 and so ...

I put a modified version of EscapeFractionFormat into the User Patches forum. I think it fixes the #2, #3 and #4 issues that I mentioned in the last message.

-Mark

This version has some changes related to handling formats with AM/PM and a few other minor fixes. I'm still testing but I'll report back if I find anything wrong. Updated to include fix for leading zero removal when foRightZerosTrimmed is on. -Mark procedure TZAbstractSecondFractionFormatSettings.Es...

I really like what you've done with the ZFormatSettings stuff! It's very flexible. There are a few things I've found: #1: In InternalGetFromFormatSettings you're scanning for 'm' and replacing with 'n', which messes up any AMPM or AM/PM formats. I've fixed it by just checking the preceding character...

What I've seen so far looks very good, nice job!

-Mark

Hi Folks, This may have already been fixed but it looks like the commit labeled "fix DateTime representation after Marks updates" has an issue with time formats containing am/pm (basically the m part is being replaced with n causing some bugs. I'm assuming that the "Mark" in the ...

Hi All! For some reason my other post seems to give an error when I go to it. I found out the issue, my code sets ZQuery.Readonly := True; After that sorting it using IndexFieldNames or SortedFields causes a huge performance issue, but seemingly only for MySQL datasets. I've verified this on a simpl...

I'll have to see if I can find that dll. I don't see it as a separate download from MySQL, it must be part of the bigger install set. I just tested a version of my exe from a few months ago and that one sorts instantaneously, so I suspect that it's a recent (within the last 3 months or so) change of...

I've tested on a clean repos of 8.0.0-015f7868 with the same results. A bit stumped but I'll keep looking.

I've tested with: Both 32bit and 64bit with similar results and using both of these clients: libmysql.dll: ver 6.1.11 (I can't use this one against my MySQL 8 server, so this one is just with 5.7) mariadb.dll: ver 10.5.5 (Server versions 5.7 and 8.0) My sampling profiler shows that 98% of the execut...

Hi All! I'm using a TZQuery that contains a single column recordset of 10,000 bigints (just the numbers 1 to 10,000). Using ZQuery.IndexFieldNames := 'MYIDFIELD ASC'; Seems to take longer than I'd expect (about 4 seconds on my machine.) Tests of other sorting also seems to be slow where I don't expe...

Note that handling mixed case on MySQL is part of my previous pull request fixes. I've also made a matrix of the various "Stores" properties for each protocol and it looks like SQLLite sets both StoresLowerCaseIdentifiers and StoresUpperCaseIdentifiers to true (I don't use SQLLite but it s...