From fa6bce3e7815c9f4e97497626af9e4ce9bceab5c Mon Sep 17 00:00:00 2001 From: Ben Pfaff Date: Wed, 31 May 2023 14:31:09 -0700 Subject: [PATCH] tests: Fix PostgreSQL test. --- tests/language/commands/get-data-psql.at | 40 ++++++++++++------------ 1 file changed, 20 insertions(+), 20 deletions(-) diff --git a/tests/language/commands/get-data-psql.at b/tests/language/commands/get-data-psql.at index 6e5b1a0a26..12e1f0998b 100644 --- a/tests/language/commands/get-data-psql.at +++ b/tests/language/commands/get-data-psql.at @@ -164,28 +164,28 @@ AT_CHECK([pspp -o pspp.csv ordinary-query.sps]) AT_CHECK([cat pspp.csv], [0], [dnl Table: Variables Name,Position,Measurement Level,Role,Width,Alignment,Print Format,Write Format -bool,1,Scale,Input,8,Right,F8.2,F8.2 +bool,1,Unknown,Input,8,Right,F8.2,F8.2 bytea,2,Nominal,Input,1,Left,AHEX2,AHEX2 char,3,Nominal,Input,8,Left,A8,A8 -int8,4,Scale,Input,8,Right,F8.2,F8.2 -int2,5,Scale,Input,8,Right,F8.2,F8.2 -int4,6,Scale,Input,8,Right,F8.2,F8.2 -numeric,7,Scale,Input,8,Right,E40.6,E40.6 +int8,4,Unknown,Input,8,Right,F8.2,F8.2 +int2,5,Unknown,Input,8,Right,F8.2,F8.2 +int4,6,Unknown,Input,8,Right,F8.2,F8.2 +numeric,7,Unknown,Input,8,Right,E40.6,E40.6 text,8,Nominal,Input,16,Left,A16,A16 -oid,9,Scale,Input,8,Right,F8.2,F8.2 -float4,10,Scale,Input,8,Right,F8.2,F8.2 -float8,11,Scale,Input,8,Right,F8.2,F8.2 -money,12,Scale,Input,8,Right,DOLLAR8.2,DOLLAR8.2 +oid,9,Unknown,Input,8,Right,F8.2,F8.2 +float4,10,Unknown,Input,8,Right,F8.2,F8.2 +float8,11,Unknown,Input,8,Right,F8.2,F8.2 +money,12,Unknown,Input,8,Right,DOLLAR8.2,DOLLAR8.2 pbchar,13,Nominal,Input,8,Left,A8,A8 varchar,14,Nominal,Input,8,Left,A8,A8 -date,15,Scale,Input,8,Right,DATE11,DATE11 -time,16,Scale,Input,8,Right,TIME11.0,TIME11.0 -timestamp,17,Scale,Input,8,Right,DATETIME22.0,DATETIME22.0 -timestamptz,18,Scale,Input,8,Right,DATETIME22.0,DATETIME22.0 -interval,19,Scale,Input,8,Right,DTIME13.0,DTIME13.0 -interval_months,20,Scale,Input,8,Right,F3.0,F3.0 -timetz,21,Scale,Input,8,Right,TIME11.0,TIME11.0 -timetz_zone,22,Scale,Input,8,Right,F8.2,F8.2 +date,15,Unknown,Input,8,Right,DATE11,DATE11 +time,16,Unknown,Input,8,Right,TIME11.0,TIME11.0 +timestamp,17,Unknown,Input,8,Right,DATETIME22.0,DATETIME22.0 +timestamptz,18,Unknown,Input,8,Right,DATETIME22.0,DATETIME22.0 +interval,19,Unknown,Input,8,Right,DTIME13.0,DTIME13.0 +interval_months,20,Unknown,Input,8,Right,F3.0,F3.0 +timetz,21,Unknown,Input,8,Right,TIME11.0,TIME11.0 +timetz_zone,22,Unknown,Input,8,Right,F8.2,F8.2 Table: Data List bool,bytea,char,int8,int2,int4,numeric,text,oid,float4,float8,money,pbchar,varchar,date,time,timestamp,timestamptz,interval,interval_months,timetz,timetz_zone @@ -210,9 +210,9 @@ AT_CHECK([pspp -o pspp.csv empty-result.sps]) AT_CHECK([cat pspp.csv], [0], [dnl Table: Variables Name,Position,Measurement Level,Role,Width,Alignment,Print Format,Write Format -a,1,Scale,Input,8,Right,F8.2,F8.2 -b,2,Scale,Input,8,Right,DATE11,DATE11 -c,3,Scale,Input,8,Right,E40.2,E40.2 +a,1,Unknown,Input,8,Right,F8.2,F8.2 +b,2,Unknown,Input,8,Right,DATE11,DATE11 +c,3,Unknown,Input,8,Right,E40.2,E40.2 ]) dnl Test query with large result set. -- 2.30.2