You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by bp...@apache.org on 2016/06/01 16:59:08 UTC
svn commit: r1746487 -
/db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties
Author: bpendleton
Date: Wed Jun 1 16:59:08 2016
New Revision: 1746487
URL: http://svn.apache.org/viewvc?rev=1746487&view=rev
Log:
DERBY-3181: DatabaseMetaData.getBestRowIdentifier behavior with invalid scope
This patch was contributed by Danoja Dias (danojadias at gmail dot com)
This change is a follow-on to revision 1745414, and removes the
getBestRowIdentifierEmpty query definition from the queries in
metadata.properties.
Modified:
db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties
Modified: db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties?rev=1746487&r1=1746486&r2=1746487&view=diff
==============================================================================
--- db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties (original)
+++ db/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/metadata.properties Wed Jun 1 16:59:08 2016
@@ -884,29 +884,6 @@ getIndexInfo=\
#
############################################
-# getBestRowIdentifierEmpty
-#
-# Used when bad params passed into
-# getBestRowIdentifier(); return empty result set
-# of the right shape
-#
-getBestRowIdentifierEmpty=\
- SELECT SCOPE, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, \
- BUFFER_LENGTH, DECIMAL_DIGITS, PSEUDO_COLUMN \
- FROM (VALUES \
- (CAST (2 AS SMALLINT), \
- CAST ('' AS VARCHAR(128)), \
- 0, \
- CAST ('INT' AS VARCHAR(128)), \
- 0, \
- 0, \
- CAST (0 AS SMALLINT), \
- CAST (0 AS SMALLINT)) \
- ) AS BESTROWIDENTIFIER( \
- SCOPE, COLUMN_NAME, DATA_TYPE, TYPE_NAME, COLUMN_SIZE, BUFFER_LENGTH, \
- DECIMAL_DIGITS, PSEUDO_COLUMN) \
- WHERE (1=0)
-
# getBestRowIdentifierPrimaryKey
#
# Find a primary key on the given table