📄 resultset.out

📁 derby database source code.good for you.
💻 OUT
📖 第 1 页 / 共 5 页
字号:
getLong(10): 10getLong(dc): 10getObject(10): 10.10getObject(dc): 10.10getShort(10): 10getShort(dc): 10getString(10): 10.10getString(dc): 10.10getTime(10) got exception Data Conversion SQLExceptiongetTime(dc) got exception Data Conversion SQLExceptiongetTimestamp(10) got exception Data Conversion SQLExceptiongetTimestamp(dc) got exception Data Conversion SQLExceptiongetBigDecimal(11,1): 11beetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)getBigDecimal(bi,1): 11getBoolean(11): truegetBoolean(bi): truegetByte(11): 11getByte(bi): 11getBytes(11) got exception Data Conversion SQLExceptiongetBytes(bi) got exception Data Conversion SQLExceptiongetDate(11) got exception Data Conversion SQLExceptiongetDate(bi) got exception Data Conversion SQLExceptiongetDouble(11): 11.0getDouble(bi): 11.0getFloat(11): 11.0getFloat(bi): 11.0getInt(11): 11getInt(bi): 11getLong(11): 11getLong(bi): 11getObject(11): 11getObject(bi): 11getShort(11): 11getShort(bi): 11getString(11): 11getString(bi): 11getTime(11) got exception Data Conversion SQLExceptiongetTime(bi) got exception Data Conversion SQLExceptiongetTimestamp(11) got exception Data Conversion SQLExceptiongetTimestamp(bi) got exception Data Conversion SQLExceptiongetBigDecimal(12,1) got exception Data Conversion SQLExceptionbeetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)getBigDecimal(cbd,1) got exception Data Conversion SQLExceptiongetBoolean(12) got exception Data Conversion SQLExceptiongetBoolean(cbd) got exception Data Conversion SQLExceptiongetByte(12) got exception Data Conversion SQLExceptiongetByte(cbd) got exception Data Conversion SQLExceptiongetBytes(12): 0x007400770065006C0076getBytes(cbd): 0x007400770065006C0076getDate(12) got exception Data Conversion SQLExceptiongetDate(cbd) got exception Data Conversion SQLExceptiongetDouble(12) got exception Data Conversion SQLExceptiongetDouble(cbd) got exception Data Conversion SQLExceptiongetFloat(12) got exception Data Conversion SQLExceptiongetFloat(cbd) got exception Data Conversion SQLExceptiongetInt(12) got exception Data Conversion SQLExceptiongetInt(cbd) got exception Data Conversion SQLExceptiongetLong(12) got exception Data Conversion SQLExceptiongetLong(cbd) got exception Data Conversion SQLExceptiongetObject(12) is okgetObject(cbd) is ok getShort(12) got exception Data Conversion SQLExceptiongetShort(cbd) got exception Data Conversion SQLExceptiongetString(12): 007400770065006c0076getString(cbd): 007400770065006c0076getTime(12) got exception Data Conversion SQLExceptiongetTime(cbd) got exception Data Conversion SQLExceptiongetTimestamp(12) got exception Data Conversion SQLExceptiongetTimestamp(cbd) got exception Data Conversion SQLExceptiongetBigDecimal(13,1) got exception Data Conversion SQLExceptionbeetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)getBigDecimal(vbd,1) got exception Data Conversion SQLExceptiongetBoolean(13) got exception Data Conversion SQLExceptiongetBoolean(vbd) got exception Data Conversion SQLExceptiongetByte(13) got exception Data Conversion SQLExceptiongetByte(vbd) got exception Data Conversion SQLExceptiongetBytes(13): 0x0033007400650065006EgetBytes(vbd): 0x0033007400650065006EgetDate(13) got exception Data Conversion SQLExceptiongetDate(vbd) got exception Data Conversion SQLExceptiongetDouble(13) got exception Data Conversion SQLExceptiongetDouble(vbd) got exception Data Conversion SQLExceptiongetFloat(13) got exception Data Conversion SQLExceptiongetFloat(vbd) got exception Data Conversion SQLExceptiongetInt(13) got exception Data Conversion SQLExceptiongetInt(vbd) got exception Data Conversion SQLExceptiongetLong(13) got exception Data Conversion SQLExceptiongetLong(vbd) got exception Data Conversion SQLExceptiongetObject(13) is okgetObject(vbd) is ok getShort(13) got exception Data Conversion SQLExceptiongetShort(vbd) got exception Data Conversion SQLExceptiongetString(13): 0033007400650065006egetString(vbd): 0033007400650065006egetTime(13) got exception Data Conversion SQLExceptiongetTime(vbd) got exception Data Conversion SQLExceptiongetTimestamp(13) got exception Data Conversion SQLExceptiongetTimestamp(vbd) got exception Data Conversion SQLExceptiongetBigDecimal(14,1) got exception Data Conversion SQLExceptionbeetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)getBigDecimal(lvbd,1) got exception Data Conversion SQLExceptiongetBoolean(14) got exception Data Conversion SQLExceptiongetBoolean(lvbd) got exception Data Conversion SQLExceptiongetByte(14) got exception Data Conversion SQLExceptiongetByte(lvbd) got exception Data Conversion SQLExceptiongetBytes(14): 0x0034007400650065006EgetBytes(lvbd): 0x0034007400650065006EgetDate(14) got exception Data Conversion SQLExceptiongetDate(lvbd) got exception Data Conversion SQLExceptiongetDouble(14) got exception Data Conversion SQLExceptiongetDouble(lvbd) got exception Data Conversion SQLExceptiongetFloat(14) got exception Data Conversion SQLExceptiongetFloat(lvbd) got exception Data Conversion SQLExceptiongetInt(14) got exception Data Conversion SQLExceptiongetInt(lvbd) got exception Data Conversion SQLExceptiongetLong(14) got exception Data Conversion SQLExceptiongetLong(lvbd) got exception Data Conversion SQLExceptiongetObject(14) is okgetObject(lvbd) is ok getShort(14) got exception Data Conversion SQLExceptiongetShort(lvbd) got exception Data Conversion SQLExceptiongetString(14): 0034007400650065006egetString(lvbd): 0034007400650065006egetTime(14) got exception Data Conversion SQLExceptiongetTime(lvbd) got exception Data Conversion SQLExceptiongetTimestamp(14) got exception Data Conversion SQLExceptiongetTimestamp(lvbd) got exception Data Conversion SQLExceptiongetBigDecimal(15,1): nullbeetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)getBigDecimal(cl,1): nullgetBoolean(15): falsegetBoolean(cl): falsegetByte(15): 0getByte(cl): 0getBytes(15): nullgetBytes(cl): nullgetDate(15): nullgetDate(cl): nullgetDouble(15): 0.0getDouble(cl): 0.0getFloat(15): 0.0getFloat(cl): 0.0getInt(15): 0getInt(cl): 0getLong(15): 0getLong(cl): 0getObject(15) is okgetObject(cl) is ok getShort(15): 0getShort(cl): 0getString(15): nullgetString(cl): nullgetTime(15): nullgetTime(cl): nullgetTimestamp(15): nullgetTimestamp(cl): nullgetBigDecimal(16,1): nullbeetle 5328 - JCC returns incorrect scale for getBigDecimal(String,int)getBigDecimal(bl,1): nullgetBoolean(16): falsegetBoolean(bl): falsegetByte(16): 0getByte(bl): 0getBytes(16): nullgetBytes(bl): nullgetDate(16): nullgetDate(bl): nullgetDouble(16): 0.0getDouble(bl): 0.0getFloat(16): 0.0getFloat(bl): 0.0getInt(16): 0getInt(bl): 0getLong(16): 0getLong(bl): 0getObject(16) is okgetObject(bl) is ok getShort(16): 0getShort(bl): 0getString(16): nullgetString(bl): nullgetTime(16): nullgetTime(bl): nullgetTimestamp(16): nullgetTimestamp(bl): nullrs.next() on closed result set got exception Result Set Closed Exceptionjust auto commit  bug4810 1, 1  bug4810 1, 2  LOCK TABLELocks are held  bug4810 1, 3  LOCK TABLELocks are held  LOCK TABLEcommit with auto commit  bug4810 1, 1  bug4810 1, 2commit  LOCK TABLEResult Set Closed Exception  LOCK TABLE  LOCK TABLErollback with auto commit  bug4810 1, 1  bug4810 1, 2rollback  LOCK TABLEResult Set Closed Exception  LOCK TABLE  LOCK TABLESTART testMutableValuesCHECKING on getXXX()ROW 1ROW 2ROW 3OK EQUALITY OBJECT RETURNED column 4 existing 1OK EQUALITY OBJECT RETURNED column 5 existing 1OK EQUALITY OBJECT RETURNED column 6 existing 1CHECKING on getObject()ROW 1ROW 2ROW 3OK EQUALITY OBJECT RETURNED column 4 existing 1OK EQUALITY OBJECT RETURNED column 5 existing 1OK EQUALITY OBJECT RETURNED column 6 existing 1COMPLETE testMutableValuesRun select * from s ss (f, e, d, c, b, a) where f = 0 and then try getTableName and getSchemaName on columnsgetTableName(1): SgetSchemaName(1): APPRun select * from (select * from s) a and then try getTableName and getSchemaName on columnsgetTableName(1): SgetSchemaName(1): APPRun select * from s1.t1 as abc and then try getTableName and getSchemaName on columnsTable name of first column is T1Schema name of first column is S1Table name of second column is T1Schema name of second column is S1Run select abc.c11 from s1.t1 as abc and then try getTableName and getSchemaName on columnsTable name of first column is T1Schema name of first column is S1Run select bcd.a, abc.c11 from s1.t1 as abc, s as bcd and then try getTableName and getSchemaName on columnsTable name of first column is SSchema name of first column is APPTable name of second column is T1Schema name of second column is S1Run select app1.t1.c11, app2.t1.c11 from app1.t1, app2.t1 and then try getTableName and getSchemaName on columnsTable name of first column is T1Schema name of first column is APP1Table name of second column is T1Schema name of second column is APP2Tests to check metadata information of nullif columnSet up by creating table for testing all datatypes combinationscreate table AllDataTypesTable (SMALLINTCOL SMALLINT,INTEGERCOL INTEGER,BIGINTCOL BIGINT,DECIMALCOL DECIMAL(10,5),REALCOL REAL,DOUBLECOL DOUBLE,CHARCOL CHAR(60),VARCHARCOL VARCHAR(60),LONGVARCHARCOL LONG VARCHAR,CHARFORBITCOL CHAR(60) FOR BIT DATA,VARCHARFORBITCOL VARCHAR(60) FOR BIT DATA,LVARCHARFORBITCOL LONG VARCHAR FOR BIT DATA,CLOBCOL CLOB(1k),DATECOL DATE,TIMECOL TIME,TIMESTAMPCOL TIMESTAMP,BLOBCOL BLOB(1k))insert into AllDataTypesTable values(NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)insert into AllDataTypesTable values(0,0,0,0.0,0.0,0.0,'0','0','0',X'10aa',X'10aa',X'10aa','13','2000-01-01','15:30:20','xxxxxxFILTERED-TIMESTAMPxxxxx,NULL)insert into AllDataTypesTable values(1,1,1,1.0,1.0,1.0,'aa','aa','aa',NULL,NULL,NULL,'14','2000-01-01','15:30:20','xxxxxxFILTERED-TIMESTAMPxxxxx,NULL)insert into AllDataTypesTable values(2,21,22,23.0,24.0,25.0,'2.0','15:30:20','xxxxxxFILTERED-TIMESTAMPxxxxx,X'10aaaa',X'10aaba',X'10aaca',NULL,NULL,'15:30:20','xxxxxxFILTERED-TIMESTAMPxxxxx,NULL)Start testing all datatypes combinations in NULLIF functionSELECT NULLIF(SMALLINTCOL,SMALLINTCOL) from AllDataTypesTable	 COL1(datatype : SMALLINT, precision : 5, scale : 0)	 ---------------------------------------------------	{null}	{null}	{null}	{null}SELECT NULLIF(SMALLINTCOL,INTEGERCOL) from AllDataTypesTable	 COL1(datatype : SMALLINT, precision : 5, scale : 0)	 ---------------------------------------------------	{null}	{null}	{null}	{2}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -