output: Introduce pivot tables.

[pspp] / tests / language / stats / flip.at

diff --git a/tests/language/stats/flip.at b/tests/language/stats/flip.at
index 22058f23bf8d5f1cb227036baf3385ea8610958a..f6d665e1fef5cb111fca5df06a638c124a3ff075 100644 (file)
--- a/tests/language/stats/flip.at
+++ b/tests/language/stats/flip.at
@@ -1,3 +1,19 @@
+dnl PSPP - a program for statistical analysis.
+dnl Copyright (C) 2017 Free Software Foundation, Inc.
+dnl 
+dnl This program is free software: you can redistribute it and/or modify
+dnl it under the terms of the GNU General Public License as published by
+dnl the Free Software Foundation, either version 3 of the License, or
+dnl (at your option) any later version.
+dnl 
+dnl This program is distributed in the hope that it will be useful,
+dnl but WITHOUT ANY WARRANTY; without even the implied warranty of
+dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+dnl GNU General Public License for more details.
+dnl 
+dnl You should have received a copy of the GNU General Public License
+dnl along with this program.  If not, see <http://www.gnu.org/licenses/>.
+dnl
 AT_BANNER([FLIP command])
 
 AT_SETUP([FLIP with NEWNAMES])
@@ -31,19 +47,19 @@ flip.sps:12: warning: FLIP: FLIP ignores TEMPORARY.  Temporary transformations w
 
 Table: Data List
 CASE_LBL,v,w,x,y,z
-a       ,1.00,6.00,11.00,16.00,21.00
-b       ,2.00,7.00,12.00,17.00,22.00
-c       ,3.00,8.00,13.00,18.00,23.00
-d       ,4.00,9.00,14.00,19.00,24.00
-e       ,1.00,6.00,11.00,16.00,21.00
+a,1.00,6.00,11.00,16.00,21.00
+b,2.00,7.00,12.00,17.00,22.00
+c,3.00,8.00,13.00,18.00,23.00
+d,4.00,9.00,14.00,19.00,24.00
+e,1.00,6.00,11.00,16.00,21.00
 
 Table: Data List
 CASE_LBL,a,b,c,d,e
-v       ,1.00,2.00,3.00,4.00,1.00
-w       ,6.00,7.00,8.00,9.00,6.00
-x       ,11.00,12.00,13.00,14.00,11.00
-y       ,16.00,17.00,18.00,19.00,16.00
-z       ,21.00,22.00,23.00,24.00,21.00
+v,1.00,2.00,3.00,4.00,1.00
+w,6.00,7.00,8.00,9.00,6.00
+x,11.00,12.00,13.00,14.00,11.00
+y,16.00,17.00,18.00,19.00,16.00
+z,21.00,22.00,23.00,24.00,21.00
 ])
 AT_CLEANUP
 
@@ -69,16 +85,16 @@ v1,v2,v3,v4,v5,v6,v7,v8,v9,v10
 
 Table: Data List
 CASE_LBL,VAR000,VAR001
-v1      ,1.00,4.00
-v2      ,2.00,5.00
-v3      ,3.00,6.00
-v4      ,4.00,7.00
-v5      ,5.00,8.00
-v6      ,6.00,9.00
-v7      ,7.00,10.00
-v8      ,8.00,11.00
-v9      ,9.00,12.00
-v10     ,10.00,13.00
+v1,1.00,4.00
+v2,2.00,5.00
+v3,3.00,6.00
+v4,4.00,7.00
+v5,5.00,8.00
+v6,6.00,9.00
+v7,7.00,10.00
+v8,8.00,11.00
+v9,9.00,12.00
+v10,10.00,13.00
 ])
 AT_CLEANUP
 
@@ -98,3 +114,30 @@ flip.
 AT_CHECK([pspp -O format=csv flip.sps], [1], [ignore])
 
 AT_CLEANUP
+
+
+
+AT_SETUP([FLIP with invalid variable names])
+
+AT_DATA([flip.sps], [dnl
+data list notable list /N (a3) a b c d *.
+begin data.
+""   1  2  3  4
+BY   1  2  3  4
+end data.
+
+flip newnames=n.
+
+list.
+])
+
+AT_CHECK([pspp -O format=csv flip.sps], [0], [dnl
+Table: Data List
+CASE_LBL,v,BY1
+a,1.00,1.00
+b,2.00,2.00
+c,3.00,3.00
+d,4.00,4.00
+])
+
+AT_CLEANUP