Bugs item #2944504, was opened at 2010-02-02 10:33 Message generated for change (Tracker Item Submitted) made by vzzzbx You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2944504&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 "candidate" Status: Open Resolution: None Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) Assigned to: Niels Nes (nielsnes) Summary: SQL: "create table ... as select..." fails Initial Comment: On Feb2010 (yesterday's CVS checkout) it seems that CREATE TABLE .... AS SELECT doesn't work properly. See example below. I would have expected two columns as output for the second SELECT clause, preferably with the columnnames "a1" and "prob". sql>START TRANSACTION; auto commit mode: off sql>CREATE VIEW selectTerm_term_id AS SELECT docid as a1, prob as prob from docdict; operation successful sql>select * from selectTerm_term_id limit 10; +------+------------------------+ | a1 | prob | +======+========================+ | 0 | 1 | | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 1 | | 5 | 1 | | 6 | 1 | | 7 | 1 | | 8 | 1 | | 9 | 1 | +------+------------------------+ 10 tuples sql>CREATE TABLE selectTerm_term_id_top AS SELECT ALL a1, prob FROM selectTerm_term_id ORDER BY prob DESC LIMIT 26 WITH DATA; sql>SELECT * FROM selectTerm_term_id_top LIMIT 10; +------+ | v | +======+ | 0 | | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | +------+ 10 tuples sql> ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2944504&group_id=56967 ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
