[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Tue Sep 2 23:22:38 + 2008 --- I just tried DEV300_m29 with CWS cloph11 with the flex that comes with Leopard/Xcode 3, and not a more recent one from Mac Ports, and the problem still occurs. When I try a select statement without a where clause, the parser tells me there is an error in SQL statement. The following works: select * from country where 1=1 The following don't: select * from country where 1 select * from country I am not sure that anything in OO.o DBA needs fixing, though. After all, the problem only seems to occurs with certain versions of flex, 2.5.4 and 2.5.35 work just fine. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Mon Sep 1 22:21:31 + 2008 --- I can't say. I am building with a more recent version of flex, 2.5.35, than comes with Leopard, 2.5.33. I don't have the problem any more, but I haven't build with an older flex. Guess, I could try that later this week (time permitting) and let you know. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 User clu changed the following: What|Old value |New value Keywords|oooqa |needmoreinfo, oooqa --- Additional comments from [EMAIL PROTECTED] Mon Sep 1 14:07:40 + 2008 --- does this problem still occure in a current version? - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Thu Mar 27 06:35:10 + 2008 --- I know this is reported to the Mac developers, though not yet in their bug tracking system, but via other channels. Just yesterday I asked our side of the contact to check the status of this issue. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Wed Mar 26 21:57:26 + 2008 --- Confirmed. If I use flex 2.5.35 out of MacPorts the tables are accesable. I only rebuild connectivity and will do a clean build with the same flex once I have the time to do so. @fs: Yes. m2 was build using Tiger. So you're right that the bug is caused by Leopards flex. Is there a chance to get this fixed for the Leopard flex? - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Wed Mar 26 18:08:19 + 2008 --- I did a complete rebuild from a fresh checkout with flex 2.5.35 installed from MacPorts. The problem has vanished. Base is working for me. I'll have to make a note about flex versions on my Leopard Build page. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Wed Mar 26 13:18:34 + 2008 --- (the interesting project for the diff would be connectivity, not dbaccess) 2.5.4 is known to work, so I assume "downgrading" to it would solve the problem. Note that an out-of-the-box 2.5.33 is also known to work (meanwhile, it formerly didn't, this was the first problem I mentioned above, but it is fixed now on OOo side). What causes the problem is the 2.5.33 shipped with Leopoard. When you change your flex version, you need to rebuild connectivity/source/parse and connectivity/source/dbtools. (touching sqlflex.l should suffice, but to be on the safe side you could do a complete rebuild.) - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Wed Mar 26 12:34:23 + 2008 --- Yes, in my case, the m4 build was done on my Leopard machine. Tiger has flex version 2.5.4 and Leopard has 2.5.33. I can install 2.5.35 and see if that makes a difference. If not, then I could manually install 2.5.4 on Leopard and make sure it is my path before /usr/bin/flex when building. I'll try changing flex versions and report the results. Oh, and I diffed m2 and m4 last night, and there were no significant changes in dbaccess, just some string resource files changed. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 User fs changed the following: What|Old value |New value CC|'maveric,mechtilde' |'fs,maveric,mechtilde,oj' --- Additional comments from [EMAIL PROTECTED] Wed Mar 26 11:01:05 + 2008 --- I know two issues which could cause this: First, we once had a problem that our syntax file, when compiled with a recent flex version, produced nonsense, but didn't when compiled with an older version. This was fixed quite a while ago, and I doubt it re-appeared in our source (there was no significant change between m2 and m4, not even in sb83). Second, the flex coming with Leopard has a problem: When fed with our input file, it produces code which is, in exactly one line, different from the code produced by an flex downloaded from the project page. Unfortunately, this one line makes our parser to fail. Both of the reasons mentioned above are known to cause the problem described here. I would assume that the m4 build we talk about was produced in a different environment than the m2 build, the latter using a flex from Tiger, the former using a flex from Leopard. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 17:45:26 + 2008 --- Ok. If it's working in m2 and not working in m4? What changed? sb83? - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 17:25:04 + 2008 --- select * from people Works in mahos DEV300m2 (OOo_3.0.0_080314_MacOSXIntel_install_de) with your testdb.odb (four entries, right?) and an own one HSQLDB too - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 13:37:04 + 2008 --- I added the database that I created to test this yesterday. However, with any database that you open with Base from DEV300_m4 on a Mac running Leopard, you get this problem. I can't say whether or not it affects other platforms or OS releases, as this is the only one where I've used m4. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 13:34:32 + 2008 --- Created an attachment (id=52285) Test DB to show issue - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 12:42:21 + 2008 --- can you attach an example database with this problem. so I can try to reproduse it on my machine? - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 12:37:25 + 2008 --- Yes, it occurs without quote marks. All you have to do is double-click on a table in the Tables sheet to view its data. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 User mechtilde changed the following: What|Old value |New value CC|'maveric' |'maveric,mechtilde' Keywords| |oooqa --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 10:24:11 + 2008 --- Does it also occurs without quoting marks? - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 User maveric changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 07:27:23 + 2008 --- Confirming the issue using DEV300_m4 under Mac OS X 10.5.2 on Mac Intel. Following the given steps the issue is reproducible. - 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]
[dba-issues] [Issue 87398] Syntax error in SQL Expres sion when no where clause
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87398 Issue #|87398 Summary|Syntax error in SQL Expression when no where clause Component|Database access Version|DEV300m4 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|dyrcona --- Additional comments from [EMAIL PROTECTED] Tue Mar 25 02:19:54 + 2008 --- Whenever you try to access a table with a method that has an underlying SQL representation of "select * from tablename" you get an error dialog which says: "The data content could not be loaded. Syntax error in SQL expression." Clicking the "More" button in the error dialogs leads through the following: SQL Status: HY000 Error Code: 1000 Syntax error in SQL expression select * from "people" syntax error, unexpected INVALIDSYMBOL, expecting $end, Invalid symbol NOTE: people was the name of a table I created in a database to test this. The error occurs reproducibly under a number of circumstances. The easiest way to cause it to happen is to open an existing database, going to the table editor, and then double-clicking on any given table to see/edit the data. It happens with forms or queries that load an entire table, i.e. that have no where clause. If you edit a query in SQL view, you can see the error with select * from tablename. However, if you type select * from tablename where 1=1, you get the results that you expected for the previous query. This error occurs for me in an existing hsqldb, a brand new hsqldb created just to test this, and a MySQL database accessed via JDBC and mysql-connector 5.0. - 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]