You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/11/07 08:01:08 UTC
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
https://bz.apache.org/ooo/show_bug.cgi?id=126029
damjan@apache.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest|--- |4.2.0-dev
Confirmation on| |
OS|Windows XP |All
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
CC| |damjan@apache.org
--- Comment #14 from damjan@apache.org ---
Confirming even with latest SVN.
Open the database in comment 13. Queries -> Use Wizard to Create Query, choose
table 589, in step 3 "Search conditions" choose "yy" "is equal to" "2001",
click "Next" right up until the end. The query is created without that
condition.
When a second condition is entered, both conditions work correctly.
The following exception is logged on the console when "Next" is clicked:
Nov 07, 2015 8:26:30 AM com.sun.star.wizards.ui.FilterComponent
getFilterConditions
SEVERE: null
com.sun.star.sdbc.SQLException: Syntax error in SQL expression
java stack trace:
at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:171)
at com.sun.proxy.$Proxy59.setElementaryQuery(Unknown Source)
at
com.sun.star.wizards.ui.FilterComponent.getFilterConditions(FilterComponent.java:256)
at com.sun.star.wizards.query.QueryWizard.leaveStep(QueryWizard.java:341)
at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:359)
at
com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:677)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at
com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:90)
at
com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:86)
at
com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:45)
at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:171)
at com.sun.proxy.$Proxy57.execute(Unknown Source)
at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:730)
at com.sun.star.wizards.query.QueryWizard.start(QueryWizard.java:127)
at
com.sun.star.wizards.query.CallQueryWizard$QueryWizardImplementation.trigger(CallQueryWizard.java:92)
at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:171)
at com.sun.proxy.$Proxy59.setElementaryQuery(Unknown Source)
at
com.sun.star.wizards.ui.FilterComponent.getFilterConditions(FilterComponent.java:256)
at com.sun.star.wizards.query.QueryWizard.leaveStep(QueryWizard.java:341)
at com.sun.star.wizards.ui.WizardDialog.switchToStep(WizardDialog.java:359)
at
com.sun.star.wizards.ui.WizardDialog.gotoNextAvailableStep(WizardDialog.java:677)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at
com.sun.star.wizards.ui.event.MethodInvocation.invoke(MethodInvocation.java:90)
at
com.sun.star.wizards.ui.event.AbstractListener.invoke(AbstractListener.java:86)
at
com.sun.star.wizards.ui.event.CommonListener.actionPerformed(CommonListener.java:45)
at com.sun.star.bridges.jni_uno.JNI_proxy.dispatch_call(Native Method)
at com.sun.star.bridges.jni_uno.JNI_proxy.invoke(JNI_proxy.java:171)
at com.sun.proxy.$Proxy57.execute(Unknown Source)
at com.sun.star.wizards.ui.UnoDialog.executeDialog(UnoDialog.java:730)
at com.sun.star.wizards.query.QueryWizard.start(QueryWizard.java:127)
at
com.sun.star.wizards.query.CallQueryWizard$QueryWizardImplementation.trigger(CallQueryWizard.java:92)
--
You are receiving this mail because:
You are the assignee for the issue.