aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/oidint4-SunOS.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/oidint4-SunOS.out')
-rw-r--r--src/test/regress/expected/oidint4-SunOS.out66
1 files changed, 66 insertions, 0 deletions
diff --git a/src/test/regress/expected/oidint4-SunOS.out b/src/test/regress/expected/oidint4-SunOS.out
new file mode 100644
index 00000000000..dd3008c81be
--- /dev/null
+++ b/src/test/regress/expected/oidint4-SunOS.out
@@ -0,0 +1,66 @@
+QUERY: CREATE TABLE OIDINT4_TBL(f1 oidint4);
+QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('1234/9873');
+QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('1235/9873');
+QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('987/-1234');
+QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('123456');
+QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('123456/1234568901234567890');
+ERROR: pg_atoi: error reading "1234568901234567890": Result too large
+QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('');
+QUERY: INSERT INTO OIDINT4_TBL(f1) VALUES ('asdfasd');
+ERROR: pg_atoi: error in "asdfasd": can't parse "asdfasd"
+QUERY: SELECT '' AS five, OIDINT4_TBL.*;
+five|f1
+----+---------
+ |1234/9873
+ |1235/9873
+ |987/-1234
+ |123456/0
+ |0/0
+(5 rows)
+
+QUERY: SELECT '' AS one, o.* FROM OIDINT4_TBL o WHERE o.f1 = '1235/9873';
+one|f1
+---+---------
+ |1235/9873
+(1 row)
+
+QUERY: SELECT '' AS four, o.* FROM OIDINT4_TBL o WHERE o.f1 <> '1235/9873';
+four|f1
+----+---------
+ |1234/9873
+ |987/-1234
+ |123456/0
+ |0/0
+(4 rows)
+
+QUERY: SELECT '' AS four, o.* FROM OIDINT4_TBL o WHERE o.f1 <= '1235/9873';
+four|f1
+----+---------
+ |1234/9873
+ |1235/9873
+ |987/-1234
+ |0/0
+(4 rows)
+
+QUERY: SELECT '' AS three, o.* FROM OIDINT4_TBL o WHERE o.f1 < '1235/9873';
+three|f1
+-----+---------
+ |1234/9873
+ |987/-1234
+ |0/0
+(3 rows)
+
+QUERY: SELECT '' AS two, o.* FROM OIDINT4_TBL o WHERE o.f1 >= '1235/9873';
+two|f1
+---+---------
+ |1235/9873
+ |123456/0
+(2 rows)
+
+QUERY: SELECT '' AS one, o.* FROM OIDINT4_TBL o WHERE o.f1 > '1235/9873';
+one|f1
+---+--------
+ |123456/0
+(1 row)
+
+QUERY: DROP TABLE OIDINT4_TBL;