Bugs item #2830905, was opened at 2009-08-01 20:13 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2830905&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL "stable" >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Fabian (mr-meltdown) Assigned to: Niels Nes (nielsnes) Summary: SQL: unexpected '*' in: "select '' as two, * Initial Comment: CREATE TABLE CHAR_TBL(f1 char); SELECT '' AS seven, CHAR_TBL.*; !Column expression Table 'char_tbl' unknown Might be that MonetDB doesn't do this because we want CHAR_TBL in a WHERE-clause, in that case we better just fix the test. pg_regress/char ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-08-03 21:02 Message: fixed parser to handle '*' any were in the selection ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-08-03 09:09 Message: ok, the first issue (select from table without table in FROM-clause) is fixed in the tests (we don't suppor this), so this bug is about the remaining issue SELECT '' AS two, * FROM TEXT_TBL; not working. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-08-01 20:27 Message: related and perhaps more of an issue is the following query: QUERY = SELECT '' AS two, * FROM TEXT_TBL; ERROR = !syntax error, unexpected '*' in: "select '' as two, *" aparently MonetDB expects text_tbl.* here pg_regress/text ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2830905&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
