marsupilami wrote: ↑09.01.2021, 15:50
Hello leus,
you should be able to send and receive private messages now. Regarding MySQLs tableticket304: I just added a patch to trunk to have it there too. I wonder why this change never made it there...
Regarding the other errors on MySQL: They don't fail on the test system, I will have to look into this at another time.
Regarding the fails on sqlite:
TestInsertFailAndCorrectCachedUpdates fails on the test system too.
TestDbcBCDValues doesn't fail. I assume that there is a problem with the test rather than with Zeos itself there.
Best regards,
Jan
Okay. I still see errors on my side. The MySQL errors are probably because of my local version (I'm using MySQL 8 with the appropriate libmysql.dll).
Code: Select all
C:\delphi\zeoslib\packages\DelphiXE10.3\build>ZTestAll.exe -b
Config File Name: C:\delphi\zeoslib\database\test.properties
Executing C:\delphi\zeoslib\database\drop_mysql.sql
Executing C:\delphi\zeoslib\database\drop_mysql_bugreport.sql
Executing C:\delphi\zeoslib\database\create_mysql.sql
Executing C:\delphi\zeoslib\database\populate_any.sql
Executing C:\delphi\zeoslib\database\populate_mysql.sql
Executing C:\delphi\zeoslib\database\create_mysql_bugreport.sql
DUnit / Testing
..........................................................................................................................................................................................................................................................................................................E......................................................................................................................................................................................F...........................................F..............................................................
Time: 0:00:16.383
FAILURES!!!
Test Results:
Run: 484
Failures: 2
Errors: 1
There was 1 error:
1) TestTicket304: EZSQLException
at
"SQL Error: Table 'zeos.tableticket304' doesn't exist
Code: 1146 SQL: delete from TableTicket304
"
There were 2 failures:
1) TestInsertFailAndCorrectCachedUpdates: ETestFailure
at
"mysql5/mysql: the constraint should forbit inserting the row, expected: <False> but was: <True>"
2) TestSelectTwoQueriesGetMoreResults: ETestFailure
at
"mysql5/mysql: Final update count, expected: <0> but was: <3>"
C:\delphi\zeoslib\packages\DelphiXE10.3\build>
The
TestTicket304 test expects a table that's not present (I assume it should be in create_mysql_bugreport.sql but it is not).
The
TestInsertFailAndCorrectCachedUpdates test I don't understand well the intention of that test is. Is it trying to check some constraint? (because the table doesn't have any in the
c_dep_id column):
Code: Select all
-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Server version: 8.0.21 - MySQL Community Server - GPL
-- Server OS: Win64
-- HeidiSQL Version: 11.1.0.6116
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-- Dumping database structure for zeos
CREATE DATABASE IF NOT EXISTS `zeos` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `zeos`;
-- Dumping structure for table zeos.cargo
CREATE TABLE IF NOT EXISTS `cargo` (
`c_id` bigint NOT NULL AUTO_INCREMENT,
`c_dep_id` smallint DEFAULT NULL,
`c_name` char(10) DEFAULT NULL,
`c_seal` tinyint(1) DEFAULT NULL,
`c_date_came` datetime DEFAULT NULL,
`c_date_out` datetime DEFAULT NULL,
`c_weight` float DEFAULT NULL,
`c_width` int DEFAULT NULL,
`c_height` int DEFAULT NULL,
`c_cost` float(12,4) DEFAULT NULL,
`c_attributes` blob,
PRIMARY KEY (`c_id`),
KEY `cargo_FK` (`c_dep_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32771 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
-- Dumping data for table zeos.cargo: ~7 rows (approximately)
/*!40000 ALTER TABLE `cargo` DISABLE KEYS */;
REPLACE INTO `cargo` (`c_id`, `c_dep_id`, `c_name`, `c_seal`, `c_date_came`, `c_date_out`, `c_weight`, `c_width`, `c_height`, `c_cost`, `c_attributes`) VALUES
(1, 2, 'Grain', 1, '2002-12-20 02:00:00', '2002-12-20 02:00:00', 5000, NULL, NULL, 1769.4301, NULL),
(2, 1, 'Paper', 2, '2002-12-19 14:00:00', '2002-12-23 00:00:00', 1000, 10, 10, 986.4700, NULL),
(3, 1, 'Wool', 0, '2002-12-20 18:00:00', NULL, 400, 7, 4, 643.1100, NULL),
(4, 2, 'Suagr', 1, '2002-12-21 10:20:00', '2002-12-26 00:00:00', 2034, NULL, NULL, 1964.8700, NULL);
/*!40000 ALTER TABLE `cargo` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
The
TestSelectTwoQueriesGetMoreResults I haven't checked yet, but I understand after the last GetMoreResults() call, GetUpdateCount() should return 0. Will do some debugging tomorrow.
