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 km...@apache.org on 2005/01/12 20:40:18 UTC
svn commit: r124983 - /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMetaDataJdbc30.out
Author: kmarsden
Date: Wed Jan 12 11:40:17 2005
New Revision: 124983
URL: http://svn.apache.org/viewcvs?view=rev&rev=124983
Log:
add missing master file - patch by myrna@golux.com
Added:
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMetaDataJdbc30.out (contents, props changed)
Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMetaDataJdbc30.out
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMetaDataJdbc30.out?view=auto&rev=124983
==============================================================================
--- (empty file)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMetaDataJdbc30.out Wed Jan 12 11:40:17 2005
@@ -0,0 +1,444 @@
+Test parameterMetaDataJdbc30 starting
+parameters count for callable statement is 4
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_OUT
+Parameter number : 4
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+Bug 4450 - generate metadata for return parameter
+param count is: 2
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 31
+parameter getScale 0
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_OUT
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+parameters count for prepared statement is 5
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 5
+parameter getScale 0
+parameter getParameterType 1
+parameter getParameterTypeName CHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 4
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 5
+parameter getScale 0
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 5
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 91
+parameter getParameterTypeName DATE
+parameter getParameterClassName java.sql.Date
+parameter getParameterMode PARAMETER_MODE_IN
+Bug 4533 - hide associated parameters
+parameters count for prepared statement is 2
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 128
+parameter getScale 0
+parameter getParameterType 12
+parameter getParameterTypeName VARCHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 36
+parameter getScale 0
+parameter getParameterType 1
+parameter getParameterTypeName CHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
+variation 1, testing jira 44
+parameters count for prepared statement is 2
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 128
+parameter getScale 0
+parameter getParameterType 12
+parameter getParameterTypeName VARCHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 128
+parameter getScale 0
+parameter getParameterType 12
+parameter getParameterTypeName VARCHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
+parameters count for prepared statement is 0
+Bug 4654 - fill in where clause parameter type info
+parameters count for prepared statement is 1
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+PASS -- expected exception
+SQLSTATE(XCL13): SQL Exception: The parameter position '-1' is out of range. The number of parameters for this prepared statement is '1'.
+PASS -- expected exception
+SQLSTATE(XCL13): SQL Exception: The parameter position '0' is out of range. The number of parameters for this prepared statement is '1'.
+PASS -- expected exception
+SQLSTATE(XCL13): SQL Exception: The parameter position '2' is out of range. The number of parameters for this prepared statement is '1'.
+test: no parameter for the statement and then do getParameterMetaData()
+parameters count for prepared statement is 0
+test: the scale returned should be the one set by registerOutParameter
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 30
+parameter getScale 15
+parameter getParameterType 2
+parameter getParameterTypeName NUMERIC
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_OUT
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 30
+parameter getScale 15
+parameter getParameterType 2
+parameter getParameterTypeName NUMERIC
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_OUT
+Behaviour of meta data and out params after re-compile
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_OUT
+Parameter number : 4
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+DUMMYINT alias returned 11111
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_OUT
+Parameter number : 4
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+DUMMYINT alias returned 6
+DUMMYINT alias returned 22222
+ParameterMetaData for Java procedures with INTEGER parameters
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+Parameter number : 4
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 4
+parameter getParameterTypeName INTEGER
+parameter getParameterClassName java.lang.Integer
+parameter getParameterMode PARAMETER_MODE_OUT
+ParameterMetaData for Java procedures with CHAR parameters
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 10
+parameter getScale 0
+parameter getParameterType 1
+parameter getParameterTypeName CHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 25
+parameter getScale 0
+parameter getParameterType 12
+parameter getParameterTypeName VARCHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 19
+parameter getScale 0
+parameter getParameterType 1
+parameter getParameterTypeName CHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+Parameter number : 4
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned false
+parameter getPrecision 32
+parameter getScale 0
+parameter getParameterType 12
+parameter getParameterTypeName VARCHAR
+parameter getParameterClassName java.lang.String
+parameter getParameterMode PARAMETER_MODE_OUT
+ParameterMetaData for Java procedures with DECIMAL parameters
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 5
+parameter getScale 3
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 4
+parameter getScale 2
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 9
+parameter getScale 0
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+Parameter number : 4
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 2
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_OUT
+ParameterMetaData for Java procedures with some literal parameters
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 4
+parameter getScale 2
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 9
+parameter getScale 0
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 2
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_OUT
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 9
+parameter getScale 0
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 2
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_OUT
+Parameter number : 1
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 5
+parameter getScale 3
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN
+Parameter number : 2
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 9
+parameter getScale 0
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_IN_OUT
+Parameter number : 3
+parameter isNullable PARAMETER_NULLABLE
+parameter isSigned true
+parameter getPrecision 10
+parameter getScale 2
+parameter getParameterType 3
+parameter getParameterTypeName DECIMAL
+parameter getParameterClassName java.math.BigDecimal
+parameter getParameterMode PARAMETER_MODE_OUT
+Test parameterMetaDataJdbc30 finished