Zeoslib Portal

The bug I mentioned above in StrToBoolEx() exists in two of the overloads and affects both the 'yes' check and the 'true' check I mentioned above (due to the buffer position not being incremented properly beyond +1) So the two overloads affected are: function StrToBoolEx(Buf, PEnd: PAnsiChar; const ...

Note that if we just fix the bug in StrToBoolEx without fixing the logic of the GetIndexes call then the NONUNIQUE value will be reversed, so it's important to do both.

-Mark

That's odd. I've tested it quite a bit. What do you get if you put this code in that function (at that same line)? Note that the dataset's type for IndexInfoColNonUniqueIndex is a boolean and the existing code tries to set it as a string (and I think the logic of it is incorrect regardless.) Result....

In unit ZDbcMySqlMetadata, function TZMySQLDatabaseMetadata.UncachedGetIndexInfo replace the line: Result.UpdateString(IndexInfoColNonUniqueIndex, LowerCase(BoolStrs[GetInt(ColumnIndexes[2]) = 0])); with Result.UpdateBoolean(IndexInfoColNonUniqueIndex, (GetInt(ColumnIndexes[2]) = 1)); -Mark

It looks like the MySQL metadata calls: UncachedGetImportedKeys UncachedGetExportedKeys UncachedGetCrossReference All currently don't work on MySQL 5.7 and MySQL 8.0 (those are the only two versions I have access to.) They all seem to rely on the command: SHOW TABLE STATUS FROM %s LIKE ''%s'' which ...

I'm no expert on MySQL or TLS however I was able to get an SSL connection (or at least connect) by using the database property: MYSQL_SSL=TRUE It also seemed that I had to use the mariadb client as the mysql one that I tried didn't appear to support ssl. More info: https://zeoslib.sourceforge.io/vie...

I'm not sure setting catalog works for Pg. Pg's "current schema" handling is a bit different than other databases. I just run

set search_path = MySchema

after login.

-Mark

I wonder wether it makes sense to just tell people to use text mode result sets if one wants to use arrays. Otherwise we will have to document which array types we support and which array types we don't support. Rearding writing of arrays: I seem to remember that Egonhugeist told me PostgreSQL alwa...

Good points by all and it's definitely a shame that pglib doesn't support mixed mode. I don't personally use the more esoteric types of the various databases (varray in Oracle is another one off the top of my head.) Note that I believe you can reset the pg driver to string mode using "BinaryWir...

My proposal would be to keep the datatype used for arrays as an stStream and not use stArray for this. Doing so requires two changes: #1: if ColumnType is a stream in TZPostgreSQLResultSet.Open set its precision to zero. It will only be non-zero in cases where the array element is a varchar(#)[] typ...

I wonder if this is an effect of changing the Pg driver mode to binary. In string mode, I believe it would return a csv-like representation of the array data. I have not tested that; it's just based on my reading up on the issue. In binary mode you'd have to construct that string using the structure...

Using FB3 server and running a cartesian product join on two large tables (just to have something lengthy to abort.) Calling ZConn.AbortOperation closes the connection and leaves it in a state where it seems that a reconnect doesn't work. Exiting the program is the only solution as far as I can tell...

[Redacted thing I posted when I thought this was for MySQL and not SQLServer! Apologies!]

-Mark

Safe wishes sent!

-Mark

Thanks!

-Mark