PSPP-BUG: Incorrect STATISTICS group by on string.

[Jeremy Parente]

Hello,

when running the following source on both 0.6.1 (DEBIAN 0.6.1-4) or 0.6.2 (compiled from GNU archive), I got strange results:

##############################################################
DATA LIST LIST /status (a12) flag (f2) type (a16) delta (f8).

BEGIN DATA.
OPEN 0 'open' 0
DEFLATE 0 'deflate/html' 100
DEFLATE 0 'deflate/txt' 50
DONE 1 'image/jpeg' 50
DONE 1 'image/png' 151
DONE 1 'image/jpeg' 70
FAILED 1 'image/jpeg' 0
DONE 1 'image/jpeg' 56
DONE 1 'image/png' 150
DONE 1 'image/png' 148
DEFLATE 0 'deflate/html' 97
DEFLATE 0 'deflate/txt' 56
DONE 1 'image/gif' 56
DEFLATE 0 'deflate/css' 63
DONE 1 'image/gif' 150
END DATA.

TEMPORARY.
SELECT IF (status NE 'OPEN' AND status NE 'FAILED')
FREQUENCIES
 /variables=type
 /statistics=ALL.
##############################################################
1.1 DATA LIST.  Reading free-form data from INLINE.
+--------+------+
|Variable|Format|
#========#======#
|status  |A12   |
|flag    |F2.0  |
|type    |A16   |
|delta   |F8.0  |
+--------+------+

2.1 FREQUENCIES.  type
+-----------+----------------+---------+--------+--------+--------+
|           |                |         |        |  Valid |   Cum  |
|Value Label|      Value     |Frequency| Percent| Percent| Percent|
#===========#================#=========#========#========#========#
|           |deflate/html    |        5|   38.46|   38.46|   38.46|
|           |image/gif       |        2|   15.38|   15.38|   53.85|
|           |image/jpeg      |        3|   23.08|   23.08|   76.92|
|           |image/png       |        3|   23.08|   23.08|  100.00|
#===========#================#=========#========#========#========#
|                       Total|       13|   100.0|   100.0|        |
+----------------------------+---------+--------+--------+--------+
##############################################################

Note that all "deflate/*" types are grouped under "deflate/html".

When I remove "deflate/" part from the dataset, I got the result I expected:

##############################################################
DATA LIST LIST /status (a12) flag (f2) type (a16) delta (f8).

BEGIN DATA.
OPEN 0 'open' 0
DEFLATE 0 'html' 100
DEFLATE 0 'txt' 50
DONE 1 'image/jpeg' 50
DONE 1 'image/png' 151
DONE 1 'image/jpeg' 70
FAILED 1 'image/jpeg' 0
DONE 1 'image/jpeg' 56
DONE 1 'image/png' 150
DONE 1 'image/png' 148
DEFLATE 0 'html' 97
DEFLATE 0 'txt' 56
DONE 1 'image/gif' 56
DEFLATE 0 'css' 63
DONE 1 'image/gif' 150
END DATA.

TEMPORARY.
SELECT IF (status NE 'OPEN' AND status NE 'FAILED')
FREQUENCIES
 /variables=type
 /statistics=ALL.
##############################################################
3.1 DATA LIST.  Reading free-form data from INLINE.
+--------+------+
|Variable|Format|
#========#======#
|status  |A12   |
|flag    |F2.0  |
|type    |A16   |
|delta   |F8.0  |
+--------+------+

4.1 FREQUENCIES.  type
+-----------+----------------+---------+--------+--------+--------+
|           |                |         |        |  Valid |   Cum  |
|Value Label|      Value     |Frequency| Percent| Percent| Percent|
#===========#================#=========#========#========#========#
|           |css             |        1|    7.69|    7.69|    7.69|
|           |html            |        2|   15.38|   15.38|   23.08|
|           |image/gif       |        2|   15.38|   15.38|   38.46|
|           |image/jpeg      |        3|   23.08|   23.08|   61.54|
|           |image/png       |        3|   23.08|   23.08|   84.62|
|           |txt             |        2|   15.38|   15.38|  100.00|
#===========#================#=========#========#========#========#
|                       Total|       13|   100.0|   100.0|        |
+----------------------------+---------+--------+--------+--------+
##############################################################

Best regards.

--

---

Jeremy PARENTE
Ingénieur R&D
Tel : +33 (0)493 001 641
Fax : +33 (0)493 001 661
UDcast, 2455 Route des Dolines, BP 355,
F-06906 Sophia Antipolis, France 

http://www.UDcast.com

Confidentiality: This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Access to this message by anyone else is unauthorised. If you have received this e-mail in error please notify the sender immediately and delete this message from your computer without further action. Any disclosure, dissemination, distribution or copying of this message or any files transmitted with it by an unauthorised recipient is strictly prohibited and may be unlawful.

---