This happens when the application is running under Windows 7 on a Mac but not when running under windows 7 on a PC.
I realise I will be told that the error cannot be reproduced under the OS environments MyDac is designed for but if someone could tell me what is being asserted at line 592 that would be a start .
I'm using
MyDAC version 8.2.5 for Rad studio 2009
DBmonitor version 3.0.4
The table DLL and query SQL are below
Table DLL
Code: Select all
CREATE TABLE `member` (
`member_id` int(11) NOT NULL AUTO_INCREMENT,
`member_title` varchar(10) DEFAULT NULL,
`member_fn_1` varchar(50) DEFAULT NULL,
`member_sn` varchar(50) DEFAULT NULL,
`member_honours` varchar(30) DEFAULT NULL,
`member_dob` date DEFAULT NULL,
`member_current_class_id` int(11) DEFAULT NULL,
`member_date_elected_to_current_class` date DEFAULT NULL,
`member_address_id` int(11) DEFAULT NULL,
`member_email_id` int(11) DEFAULT NULL,
`member_home_phone` varchar(30) DEFAULT NULL,
`member_bmc_ref` varchar(15) DEFAULT NULL,
`member_mobile_phone` varchar(30) DEFAULT NULL,
`member_work_phone` varchar(30) DEFAULT NULL,
`member_comment` mediumtext,
`member_fn_2` varchar(50) DEFAULT NULL,
`member_fn_3` varchar(50) DEFAULT NULL,
`member_known_as` varchar(50) DEFAULT NULL,
`unused_member_status_id` int(11) DEFAULT NULL,
`member_show_email_in_handbook` tinyint(1) DEFAULT NULL,
`is_full_time_student` tinyint(1) DEFAULT '0',
`show_address_in_handbook` tinyint(1) DEFAULT '1',
`show_phone_in_handbook` tinyint(1) DEFAULT '1',
PRIMARY KEY (`member_id`),
KEY `FK_member_email_id` (`member_email_id`),
KEY `FK_member_address_id` (`member_address_id`),
KEY `KKmember_status_id` (`unused_member_status_id`),
CONSTRAINT `FK_member_address_id` FOREIGN KEY (`member_address_id`) REFERENCES `address` (`member_address_id`) ON UPDATE NO ACTION,
CONSTRAINT `FK_member_email_id` FOREIGN KEY (`member_email_id`) REFERENCES `member_email` (`email_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4451 DEFAULT CHARSET=utf8
Query SQL
Code: Select all
(
SELECT
member.member_id AS member_id,
IFNULL(member.member_title,'') AS member_title,
CASE
WHEN member.member_known_as IS NOT NULL THEN
CONCAT(member.member_fn_1, ' (',member.member_known_as,')')
ELSE
member.member_fn_1
END AS member_fn,
member.member_sn AS member_sn,
member_1.member_id AS joint_member_id,
IFNULL(member_1.member_title,'') AS joint_member_title,
CASE
WHEN member_1.member_known_as IS NOT NULL THEN
CONCAT(member_1.member_fn_1, ' (',member_1.member_known_as,')')
ELSE
member_1.member_fn_1
END AS joint_member_fn,
member_1.member_sn AS joint_member_sn,
CASE WHEN member.member_sn <> member_1.member_sn THEN '***' ELSE '' END AS surname_different
FROM
joint_member
INNER JOIN member
ON (joint_member.base_member_id = member.member_id)
INNER JOIN member AS member_1
ON (joint_member.partner_member_id = member_1.member_id)
ORDER BY member.member_sn
)
UNION ALL
(SELECT '','','','','','','','','' )
UNION ALL
(SELECT '----------','----------','----------','----------','----------','----------','----------','----------','----------' )
UNION ALL
(SELECT '','','','','','','','','' )
UNION ALL
(
SELECT
member_1.member_id AS member_id,
IFNULL(member_1.member_title,'') AS member_title,
CASE
WHEN member_1.member_known_as IS NOT NULL THEN
CONCAT(member_1.member_fn_1, ' (',member_1.member_known_as,')')
ELSE
member_1.member_fn_1
END AS member_fn,
member_1.member_sn AS member_sn,
member.member_id AS joint_member_id,
IFNULL(member.member_title,'') AS joint_member_title,
CASE
WHEN member.member_known_as IS NOT NULL THEN
CONCAT(member.member_fn_1, ' (',member.member_known_as,')')
ELSE
member.member_fn_1
END AS joint_member_fn,
member.member_sn AS joint_member_sn,
CASE WHEN member.member_sn <> member_1.member_sn THEN '***' ELSE '' END AS surname_different
FROM
joint_member
INNER JOIN member
ON (joint_member.base_member_id = member.member_id)
INNER JOIN member AS member_1
ON (joint_member.partner_member_id = member_1.member_id)
ORDER BY member.jointmember_sn
)