Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit6c96188

Browse files
committed
Remove the 'not in' operator (!!=). This was a hangover from Berkeley
days that was obsolete the moment we had IN (SELECT ...) capability.It's arguably a security hole since it applied no permissions check tothe table it searched, and since it was never documented anywhere,removing it seems more appropriate than fixing it.
1 parenta41e46b commit6c96188

File tree

6 files changed

+7
-141
lines changed

6 files changed

+7
-141
lines changed

‎src/backend/utils/adt/Makefile

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
#
22
# Makefile for utils/adt
33
#
4-
# $PostgreSQL: pgsql/src/backend/utils/adt/Makefile,v 1.65 2007/08/21 01:11:18 tgl Exp $
4+
# $PostgreSQL: pgsql/src/backend/utils/adt/Makefile,v 1.66 2007/08/27 01:39:24 tgl Exp $
55
#
66

77
subdir = src/backend/utils/adt
@@ -19,7 +19,7 @@ OBJS = acl.o arrayfuncs.o array_userfuncs.o arrayutils.o bool.o \
1919
cash.o char.o date.o datetime.o datum.o domains.o\
2020
enum.o float.o format_type.o\
2121
geo_ops.o geo_selfuncs.o int.o int8.o like.o lockfuncs.o\
22-
misc.o nabstime.o name.onot_in.onumeric.o numutils.o\
22+
misc.o nabstime.o name.o numeric.o numutils.o\
2323
oid.o oracle_compat.o pseudotypes.o rowtypes.o\
2424
regexp.o regproc.o ruleutils.o selfuncs.o\
2525
tid.o timestamp.o varbit.o varchar.o varlena.o version.o xid.o\

‎src/backend/utils/adt/not_in.c

Lines changed: 0 additions & 124 deletions
This file was deleted.

‎src/include/catalog/catversion.h

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -37,7 +37,7 @@
3737
* Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
3838
* Portions Copyright (c) 1994, Regents of the University of California
3939
*
40-
* $PostgreSQL: pgsql/src/include/catalog/catversion.h,v 1.418 2007/08/25 01:06:25 tgl Exp $
40+
* $PostgreSQL: pgsql/src/include/catalog/catversion.h,v 1.419 2007/08/27 01:39:24 tgl Exp $
4141
*
4242
*-------------------------------------------------------------------------
4343
*/
@@ -53,6 +53,6 @@
5353
*/
5454

5555
/*yyyymmddN */
56-
#defineCATALOG_VERSION_NO200708241
56+
#defineCATALOG_VERSION_NO200708261
5757

5858
#endif

‎src/include/catalog/pg_operator.h

Lines changed: 1 addition & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
* Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
99
* Portions Copyright (c) 1994, Regents of the University of California
1010
*
11-
* $PostgreSQL: pgsql/src/include/catalog/pg_operator.h,v 1.154 2007/08/21 01:11:25 tgl Exp $
11+
* $PostgreSQL: pgsql/src/include/catalog/pg_operator.h,v 1.155 2007/08/27 01:39:24 tgl Exp $
1212
*
1313
* NOTES
1414
* the genbki.sh script reads this file and generates .bki
@@ -290,8 +290,6 @@ DATA(insert OID = 622 ( "<" PGNSP PGUID b f f700 70016 623 625 float4lt s
290290
DATA(insertOID=623 (">"PGNSPPGUIDbff70070016622624float4gtscalargtselscalargtjoinsel ));
291291
DATA(insertOID=624 ("<="PGNSPPGUIDbff70070016625623float4lescalarltselscalarltjoinsel ));
292292
DATA(insertOID=625 (">="PGNSPPGUIDbff70070016624622float4gescalargtselscalargtjoinsel ));
293-
DATA(insertOID=626 ("!!="PGNSPPGUIDbff23251600int4notin-- ));
294-
DATA(insertOID=627 ("!!="PGNSPPGUIDbff26251600oidnotin-- ));
295293
DATA(insertOID=630 ("<>"PGNSPPGUIDbff18181663092charneneqselneqjoinsel ));
296294

297295
DATA(insertOID=631 ("<"PGNSPPGUIDbff181816633634charltscalarltselscalarltjoinsel ));

‎src/include/catalog/pg_proc.h

Lines changed: 1 addition & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
10-
* $PostgreSQL: pgsql/src/include/catalog/pg_proc.h,v 1.464 2007/08/22 01:39:45 tgl Exp $
10+
* $PostgreSQL: pgsql/src/include/catalog/pg_proc.h,v 1.465 2007/08/27 01:39:24 tgl Exp $
1111
*
1212
* NOTES
1313
* The script catalog/genbki.sh reads this file and generates .bki
@@ -902,10 +902,6 @@ DESCR("convert int8 to int2");
902902
DATA(insertOID=754 (int8PGNSPPGUID1210fftfi120"21"_null__null__null_int28-_null_ ));
903903
DESCR("convert int2 to int8");
904904

905-
DATA(insertOID=1285 (int4notinPGNSPPGUID1210fftfs216"23 25"_null__null__null_int4notin-_null_ ));
906-
DESCR("not in");
907-
DATA(insertOID=1286 (oidnotinPGNSPPGUID1210fftfs216"26 25"_null__null__null_oidnotin-_null_ ));
908-
DESCR("not in");
909905
DATA(insertOID=655 (nameltPGNSPPGUID1210fftfi216"19 19"_null__null__null_namelt-_null_ ));
910906
DESCR("less-than");
911907
DATA(insertOID=656 (namelePGNSPPGUID1210fftfi216"19 19"_null__null__null_namele-_null_ ));

‎src/include/utils/builtins.h

Lines changed: 1 addition & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
* Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group
88
* Portions Copyright (c) 1994, Regents of the University of California
99
*
10-
* $PostgreSQL: pgsql/src/include/utils/builtins.h,v 1.300 2007/08/21 01:11:30 tgl Exp $
10+
* $PostgreSQL: pgsql/src/include/utils/builtins.h,v 1.301 2007/08/27 01:39:25 tgl Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -418,10 +418,6 @@ extern Datum pg_tablespace_databases(PG_FUNCTION_ARGS);
418418
externDatumpg_rotate_logfile(PG_FUNCTION_ARGS);
419419
externDatumpg_sleep(PG_FUNCTION_ARGS);
420420

421-
/* not_in.c */
422-
externDatumint4notin(PG_FUNCTION_ARGS);
423-
externDatumoidnotin(PG_FUNCTION_ARGS);
424-
425421
/* oid.c */
426422
externDatumoidin(PG_FUNCTION_ARGS);
427423
externDatumoidout(PG_FUNCTION_ARGS);

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp