https://bugs.freedesktop.org/show_bug.cgi?id=62645
Priority: medium
Bug ID: 62645
Assignee: [email protected]
Summary: VIEWING - Libmariadb connector fails to display data
in mysql server registered VIEW
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.0.0.alpha0+ Master
Component: Database
Product: LibreOffice
Tested Version 4.1.0.0.alpha0+ (Build ID:
edf57013463eff6d3b40d8d5d933577f0e6cf8e)
After having gotten the new libmariadb connector to build on OSX, I am seeing
the following error when browsing my table list :
The data content could not be loaded.
allocate_buffer_for_field: invalid rbind data type
The SQL command leading to this error is:
SELECT * FROM "ipdatabase"."natpha_ddl"
natpha_ddl is a server registered view
It is built in the following way :
DROP VIEW IF EXISTS `natpha_ddl`;
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`alex`@`%` SQL SECURITY DEFINER
VIEW `natpha_ddl` AS select `oldfmpro`.`File_Num` AS
`file_num`,`oldfmpro`.`Owner1` AS `Owner1`,`oldfmpro`.`Filing_Num` AS
`filing_num`,`oldfmpro`.`Filing_Date1` AS
`filing_date1`,`oldfmpro`.`Prio_FF_Date1` AS
`Prio_FF_Date1`,if(((`oldfmpro`.`Prio_FF_Date1` + interval 30 month) is not
null),(`oldfmpro`.`Prio_FF_Date1` + interval 30
month),(`oldfmpro`.`Filing_Date1` + interval 30 month)) AS `NATPHA` from
`oldfmpro` where ((`oldfmpro`.`Filing_Num` is not null) and
(`oldfmpro`.`Ctry_Short` = 'WO') and (`oldfmpro`.`IngJur` like '%ajt%') and
(`oldfmpro`.`Filing_Date1` >= (curdate() + interval -(30) month))) order by
if(((`oldfmpro`.`Prio_FF_Date1` + interval 30 month) is not
null),(`oldfmpro`.`Prio_FF_Date1` + interval 30
month),(`oldfmpro`.`Filing_Date1` + interval 30 month));
The display of the data in this view used to function flawlessly with the
previous mysql connector, so there must be some difference in the libmariadb
and mysql connector code which is causing this to happen.
The view functions normally in other software (MySQLWorkench, MySQLQuery
Browser).
Alex
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
