bung87 / amysql Goto Github PK

mysql works well, but

5.5.5-10.4.14-MariaDB-1:10.4.14+maria~xenial

mariadb-10.5.5.high_sierra

not supported , insert as null and return as null

Documentation is sparse and examples do not exist; tests are not commented and such are not suitable as examples. This makes it very difficult to use this library.

env:
linux mysql8

MYSQL_TYPE_JSON is not allowed as Item_param lacks a proper implementation for val_json.

https://github.com/mysql/mysql-server/blob/124c7ab1d6f914637521fd4463a993aa73403513/sql/sql_prepare.cc#L636-L639

in buffered branch I change protocol.receivePacket body's socket.recv to socket.recvInto with flags = {}

during handshake phrase , sent auth data to server, tcpdump shows it actually sent, when I receive server response I got
Connection reset by peer

https://github.com/bung87/amysql/tree/zstd
run sudo tcpdump -i pktap,lo0 port 3306 -n -q -tttt -s 0 -A on mac shows:
=h..=h..........test
but select * from mysql.general_log shows mysql server didn't get that packet when sending init db command with test.

also it's not clear to me what's the protocol-compression-algorithms value set on server side that support uncompress and zstd
https://dev.mysql.com/worklog/task/?id=12475#New_system_variables:

initial complete in devel branch, some code may need better performance care.

Running into the protocol error on retrieving larger (not really that large tbh) data sets. The compression does help but still hits a wall when trying to retrieve more than a 100 or so rows.

The failure results when the conn.bufLen is less than the payload length.

Edit: Using Chronos