To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=93165
Issue #|93165
Summary|oooqa
Component|Database access
Version|OOO300m3
Platform|All
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P4
Subcomponent|none
Assigned to|oj
Reported by|clu
------- Additional comments from [EMAIL PROTECTED] Wed Aug 27 09:56:21 +0000
2008 -------
from a discription of simonaw:
I am running PostgreSQL 8.3.1 w/ postgresql-8.3-603.jdbc4.jar
I created this table:
mco=# \d btest
Table "public.btest"
Column | Type | Modifiers
----------+---------+-----------
id | integer | not null
billable | boolean |
Indexes:
"btest_pkey" PRIMARY KEY, btree (id)
with the following sample data:
mco=# select * from btest;
id | billable
----+----------
0 | t
1 | f
2 | f
3 | t
(4 rows)
- I connect via JDBC
- open the table btest
- I put the cursor in the "billable" column and press the "AutoFilter" and get
the following:
"Syntax error in SQL expression" with the statement:
SELECT * FROM "public"."btest" WHERE "public"."btest"."billable" = 1 = 1
The "= 1 = 1" is one thing but it doesn't work with "= 1" either.
clu: i can repro that
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
