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/01/12 16:44:47 UTC
[Issue 126029] New: don't accept query on SQL AND return error
message in sql mode
https://issues.apache.org/ooo/show_bug.cgi?id=126029
Issue ID: 126029
Issue Type: DEFECT
Summary: don't accept query on SQL AND return error message in
sql mode
Product: Base
Version: 4.0.0
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: code
Assignee: issues@openoffice.apache.org
Reporter: win22@pochta.ru
hi.
when i type query in sql mode and run it, i get an error message.
QUERY purpose:select all children, who was born in 2001 year.
[code]
select * from 589 where yy='2001';
[/code]
*I checked the syntax, it works perfect on demo base on tutorial site.
**when i try make query in design view, it return me just unsorted table, with
all records from 1997 till 2008.
Thank you
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #6 from antonio1 <wi...@pochta.ru> ---
Created attachment 84411
--> https://issues.apache.org/ooo/attachment.cgi?id=84411&action=edit
here the step by step query
here is making query by query wisard.
i set condition yy=2001 but in result this condition not settled on 2a picture.
on 3 pic. see - result all records are choose, not 2001 only.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #2 from antonio1 <wi...@pochta.ru> ---
Created attachment 84407
--> https://issues.apache.org/ooo/attachment.cgi?id=84407&action=edit
1
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #7 from antonio1 <wi...@pochta.ru> ---
Created attachment 84412
--> https://issues.apache.org/ooo/attachment.cgi?id=84412&action=edit
sql query
direct sql doesn't accepted conditions
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #9 from oooforum <oo...@free.fr> ---
Please read more attentively my comment 1.
Screenshots are fine but an ODB is better to reproduce.
Save our time and provide informations required.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #3 from antonio1 <wi...@pochta.ru> ---
Created attachment 84408
--> https://issues.apache.org/ooo/attachment.cgi?id=84408&action=edit
2
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
oooforum <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |oooforum@free.fr
Resolution|--- |NOT_AN_ISSUE
--- Comment #1 from oooforum <oo...@free.fr> ---
Your bug report is being closed as NOT_AN_ISSUE due to a lack of information
which is needed in order to accurately reproduce and confirm the problem. We
encourage you to retest your bug against the latest release. If the issue is
still present in the latest stable release, we need the following information:
a) Provide a step-by-step procedure to reproduce (the simpler will be the
better)
b) Provide any test case(s) which will help us confirm the problem (like a
sample document)
c) Provide screenshots of the problem if you think it might help
Once all of this is done, please set the bug back to UNCONFIRMED and we will
attempt to reproduce the issue.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
antonio1 <wi...@pochta.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |UNCONFIRMED
Resolution|NOT_AN_ISSUE |---
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #4 from antonio1 <wi...@pochta.ru> ---
Created attachment 84409
--> https://issues.apache.org/ooo/attachment.cgi?id=84409&action=edit
3
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #5 from antonio1 <wi...@pochta.ru> ---
Created attachment 84410
--> https://issues.apache.org/ooo/attachment.cgi?id=84410&action=edit
2a
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #10 from antonio1 <wi...@pochta.ru> ---
of coarce,sir, i can send odb, but to your private mail, because it has some
pers data,i'm in doubt to expose it public.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #12 from antonio1 <wi...@pochta.ru> ---
Created attachment 84413
--> https://issues.apache.org/ooo/attachment.cgi?id=84413&action=edit
syntax errors
base even truncated is 1.3 mb(20 records)
is it bug or normal
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #13 from antonio1 <wi...@pochta.ru> ---
http://www.mediafire.com/download/9nm2dd304v6h3ix/589_bASE_tested.zip
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #8 from antonio1 <wi...@pochta.ru> ---
i just find, that this bug was when only one conditions choosed.
when 2 conditions choosed, the query created.
is it bug or special feature?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 126029] don't accept query on SQL AND return error message in
sql mode
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=126029
--- Comment #11 from oooforum <oo...@free.fr> ---
This is a public bug tracking system, so if you attach a file, it does not
contain confidential data.
See this tutorial:
https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=8289 to know how do
it.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.