Skip to content

Commit 17428ae

Browse files
OreoYangOreoYang
committed
fix oracle-check failed
1 parent e371807 commit 17428ae

File tree

5 files changed

+620
-577
lines changed

5 files changed

+620
-577
lines changed

‎contrib/ivorysql_ora/expected/ora_datetime.out‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -280,7 +280,7 @@ CREATE INDEX TEST_DATE_BRIN ON TEST_DATE USING BRIN (A);
280280
-- Build tables and test 'NLS_TIMESTAMP_FORMAT' parameter, don't do the validity check.
281281
CREATE TABLE TEST_TIMESTAMP(a TIMESTAMP);
282282
SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SS.FF9';
283-
-- effective number of fractional seconds is 6,the part of excess is 0
283+
-- effective number of fractional seconds is 6, the part of excess is 0
284284
INSERT INTO TEST_TIMESTAMP VALUES('1990-1-19 11:11:11.123456789');
285285
INSERT INTO TEST_TIMESTAMP VALUES('1990-2-19'); -- hour、minute、second、fractional second is zero.
286286
INSERT INTO TEST_TIMESTAMP VALUES('1990-2-19 11:11:11');
@@ -550,7 +550,7 @@ CREATE INDEX TEST_TIMESTAMP_BRIN ON TEST_TIMESTAMP USING BRIN (A);
550550
-- Build tables and test 'NLS_TIMESTAMP_TZ_FORMAT' parameter, don't do the validity check.
551551
CREATE TABLE TEST_TIMESTAMPTZ(a TIMESTAMP WITH TIME ZONE);
552552
SET NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH24:MI:SS.FF9';
553-
-- effective number of fractional seconds is 6,the part of excess is 0
553+
-- effective number of fractional seconds is 6, the part of excess is 0
554554
INSERT INTO TEST_TIMESTAMPTZ VALUES('1990-1-19 11:11:11.123456789');
555555
INSERT INTO TEST_TIMESTAMPTZ VALUES('1990-2-19'); -- hour、minute、second、fractional second is zero.
556556
INSERT INTO TEST_TIMESTAMPTZ VALUES('1990-2-19 11:11:11');

‎contrib/ivorysql_ora/expected/ora_datetime_datatype_functions.out‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1739,10 +1739,10 @@ select * from timestpwtz_tb;
17391739
drop table timestpwtz_tb;
17401740
alter session set NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH.MI.SS.FF5 AM';
17411741
CREATE TABLE timestp_tb(timestp_clo timestamp(7));
1742-
WARNING: TIMESTAMP(7) effective number of fractional seconds is 6,the part of excess is 0
1742+
WARNING: TIMESTAMP(7) effective number of fractional seconds is 6, the part of excess is 0
17431743
LINE 1: CREATE TABLE timestp_tb(timestp_clo timestamp(7));
17441744
^
1745-
WARNING: TIMESTAMP(7) effective number of fractional seconds is 6,the part of excess is 0
1745+
WARNING: TIMESTAMP(7) effective number of fractional seconds is 6, the part of excess is 0
17461746
insert into timestp_tb values ('2022-08-19 03.37.05 PM');
17471747
select * from timestp_tb;
17481748
timestp_clo

‎contrib/ivorysql_ora/sql/ora_datetime.sql‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -143,7 +143,7 @@ CREATE TABLE TEST_TIMESTAMP(a TIMESTAMP);
143143

144144
SET NLS_TIMESTAMP_FORMAT='YYYY-MM-DD HH24:MI:SS.FF9';
145145

146-
-- effective number of fractional seconds is 6,the part of excess is 0
146+
-- effective number of fractional seconds is 6, the part of excess is 0
147147
INSERT INTO TEST_TIMESTAMP VALUES('1990-1-19 11:11:11.123456789');
148148

149149
INSERT INTO TEST_TIMESTAMP VALUES('1990-2-19'); -- hour、minute、second、fractional second is zero.
@@ -276,7 +276,7 @@ CREATE TABLE TEST_TIMESTAMPTZ(a TIMESTAMP WITH TIME ZONE);
276276
SET NLS_TIMESTAMP_TZ_FORMAT='YYYY-MM-DD HH24:MI:SS.FF9';
277277

278278

279-
-- effective number of fractional seconds is 6,the part of excess is 0
279+
-- effective number of fractional seconds is 6, the part of excess is 0
280280
INSERT INTO TEST_TIMESTAMPTZ VALUES('1990-1-19 11:11:11.123456789');
281281

282282
INSERT INTO TEST_TIMESTAMPTZ VALUES('1990-2-19'); -- hour、minute、second、fractional second is zero.

0 commit comments

Comments
 (0)