Base: trying to set limits in queries gives an 'unexpected token' error

[mattebuntu]

When I'm trying to set a limit in a query about how many records it should display I get an 'unexpected token' error, whether I input the value manually or choose it from the dropdown menu.

ProblemType: Bug
DistroRelease: Ubuntu 16.04
Package: libreoffice-core 1:5.1.4-0ubuntu1
ProcVersionSignature: Ubuntu 4.4.0-36.55-generic 4.4.16
Uname: Linux 4.4.0-36-generic x86_64
ApportVersion: 2.20.1-0ubuntu2.1
Architecture: amd64
CurrentDesktop: Unity
Date: Tue Sep 13 17:40:45 2016
ExecutablePath: /usr/lib/libreoffice/program/soffice.bin
InstallationDate: Installed on 2016-06-14 (91 days ago)
InstallationMedia: Ubuntu 16.04 LTS "Xenial Xerus" - Release amd64 (20160420.1)
SourcePackage: libreoffice
UpgradeStatus: No upgrade log present (probably fresh install)

[penalvch (penalvch)]

Matteo Paolini, thank you for reporting this and helping make Ubuntu better.

1) Could you please provide an example Base file?
2) Could you please provide a keyboard click-for-click of how to reproduce?
3) Could you please provide a screenshot of the error?

[mattebuntu (mattebuntu-deactivatedaccount-deactivatedaccount)]

To reproduce the bug:

1) Create a new query in design mode and add a table

2) add either all or some fields to the query by double clicking on the
list of fields that has appeared

3) set a limit to how many records should be displayed, either by
entering a value manually in the box at the top that says "All" or by
selecting a suggested value from the dropdown menu beside said box

4) run the query by pressing f5

normally it should display the records from the selected table equal to
the value that I set previously, but instead I get an "unexpected token"
error.

On 15/09/16 06:13, Christopher M. Penalver wrote:
> Matteo Paolini, thank you for reporting this and helping make Ubuntu
> better.
>
> 1) Could you please provide an example Base file?
> 2) Could you please provide a keyboard click-for-click of how to reproduce?
> 3) Could you please provide a screenshot of the error?
>
> ** Changed in: libreoffice (Ubuntu)
> Importance: Undecided => Low
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>

[penalvch (penalvch)]

Matteo Paolini:
1) Was this an issue in a prior LibreOffice version?
2) Would testing the latest version of LO provide a WORKAROUND via https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-5-2 ?

[mattebuntu (mattebuntu-deactivatedaccount-deactivatedaccount)]

1) I don't know unfortunately, the only Libreoffice version I've used is 5.1

2) even after upgrading the bug still remains.

On 15/09/16 22:41, Christopher M. Penalver wrote:
> Matteo Paolini:
> 1) Was this an issue in a prior LibreOffice version?
> 2) Would testing the latest version of LO provide a WORKAROUND via https://launchpad.net/~libreoffice/+archive/ubuntu/libreoffice-5-2 ?
>
> ** Changed in: libreoffice (Ubuntu)
> Importance: Low => Medium
>