Commita8a487d

committed

Fix pg_index statistics query to join proper relation.

1 parentf107174 commita8a487dCopy full SHA for a8a487d

File tree

-2

lines changed

src/interfaces/jdbc/org/postgresql
- jdbc1
  - DatabaseMetaData.java
- jdbc2
  - DatabaseMetaData.java

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2658,7 +2658,7 @@ public java.sql.ResultSet getIndexInfo(String catalog, String schema, String tab`
`2658`	`2658`	`"WHERE ((c.relname = '" +tableName.toLowerCase() +"') " +`
`2659`	`2659`	`" AND (c.oid = x.indrelid) " +`
`2660`	`2660`	`" AND (i.oid = x.indexrelid) " +`
`2661`		`-" AND (c.relam = a.oid)) " +`
	`2661`	`+" AND (i.relam = a.oid)) " +`
`2662`	`2662`	`"ORDER BY x.indisunique DESC, " +`
`2663`	`2663`	`" x.indisclustered, a.amname, i.relname");`
`2664`	`2664`	`while (r.next()) {`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2656,7 +2656,7 @@ public java.sql.ResultSet getIndexInfo(String catalog, String schema, String tab`
`2656`	`2656`	`"WHERE ((c.relname = '" +tableName.toLowerCase() +"') " +`
`2657`	`2657`	`" AND (c.oid = x.indrelid) " +`
`2658`	`2658`	`" AND (i.oid = x.indexrelid) " +`
`2659`		`-" AND (c.relam = a.oid)) " +`
	`2659`	`+" AND (i.relam = a.oid)) " +`
`2660`	`2660`	`"ORDER BY x.indisunique DESC, " +`
`2661`	`2661`	`" x.indisclustered, a.amname, i.relname");`
`2662`	`2662`	`while (r.next()) {`

Comments

(0)