Update of /cvsroot/monetdb/sql/src/test/BugTracker-2010/Tests
In directory 
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv21522/src/test/BugTracker-2010/Tests

Added Files:
        tableDataLimit.SF-2944504.sql 
Log Message:
propagated changes of Friday Feb 05 2010 - Sunday Feb 07 2010
from the Feb2010 branch to the development trunk

  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  2010/02/05 - vzzzbx:
          src/test/BugTracker-2010/Tests/tableDataLimit.SF-2944504.sql,1.1.2.1
  adding test for bug SF-2944504 (including stable output, bug seems fixed)
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


--- NEW FILE: tableDataLimit.SF-2944504.sql ---
START TRANSACTION;

CREATE TABLE aap (x int, y int);
INSERT INTO aap VALUES (5,7), (6,9), (11,13), (15,17);

CREATE TABLE test AS SELECT ALL x, y FROM aap ORDER BY x DESC LIMIT 3 WITH DATA;

SELECT * FROM test;

ROLLBACK;


------------------------------------------------------------------------------
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-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

Reply via email to