https://bugs.documentfoundation.org/show_bug.cgi?id=83454
--- Comment #19 from eremmel <[email protected]> --- Tested LO 5.1.2.2 Windows on W7 with negative results: Bug is still there. Regression: I reported before that bug does not happen with LO 4.2.8.2 (See comment 16). Additional information: It looks like that something is wrong with the parser in Base when database type is MSAccess. The reported error with 5.1.2.2 is: Syntax error (missing operator) in query expression '`A`.`f` `F`' A modification to the queries listed in comment 16 result in accepting the aliases: 1: Adding on the first field/expression an add empty string. OK: SELECT '' + `A`.`f` AS "F" FROM `A` OK: SELECT `A`.`f` + '' AS "F" FROM `A` 2: Adding selection of all columns with * OK: SELECT *, `A`.`f` AS "F" FROM `A` BUT: column ordering is "F", <other columns> iso <other columns>, "F" OK: SELECT *, `f` AS "F" FROM `A` BUT: column ordering is "F", <other columns> iso <other columns>, "F" OK: SELECT `A`.`f` AS "F", * FROM `A` FAIL: SELECT `A`.*, `A`.`f` AS "F" FROM `A` OK: SELECT `A`.*, ''+`A`.`f` AS "F" FROM `A` Note: This bug prevent every user that needs MSAccess from going to LO 5.x. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
