⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 resultset.out

📁 derby database source code.good for you.
💻 OUT
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
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 function
SELECT 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}
SELECT NULLIF(SMALLINTCOL,BIGINTCOL) from AllDataTypesTable
	 COL1(datatype : SMALLINT, precision : 5, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{2}
SELECT NULLIF(SMALLINTCOL,DECIMALCOL) from AllDataTypesTable
	 COL1(datatype : SMALLINT, precision : 5, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{2}
SELECT NULLIF(SMALLINTCOL,REALCOL) from AllDataTypesTable
	 COL1(datatype : SMALLINT, precision : 5, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{2}
SELECT NULLIF(SMALLINTCOL,DOUBLECOL) from AllDataTypesTable
	 COL1(datatype : SMALLINT, precision : 5, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{2}
SELECT NULLIF(SMALLINTCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR' are not supported.
SELECT NULLIF(SMALLINTCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'VARCHAR' are not supported.
SELECT NULLIF(SMALLINTCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(SMALLINTCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(SMALLINTCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(SMALLINTCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(SMALLINTCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'CLOB' are not supported.
SELECT NULLIF(SMALLINTCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'DATE' are not supported.
SELECT NULLIF(SMALLINTCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'TIME' are not supported.
SELECT NULLIF(SMALLINTCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'TIMESTAMP' are not supported.
SELECT NULLIF(SMALLINTCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'SMALLINT' and 'BLOB' are not supported.
SELECT NULLIF(INTEGERCOL,SMALLINTCOL) from AllDataTypesTable
	 COL1(datatype : INTEGER, precision : 10, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{21}
SELECT NULLIF(INTEGERCOL,INTEGERCOL) from AllDataTypesTable
	 COL1(datatype : INTEGER, precision : 10, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(INTEGERCOL,BIGINTCOL) from AllDataTypesTable
	 COL1(datatype : INTEGER, precision : 10, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{21}
SELECT NULLIF(INTEGERCOL,DECIMALCOL) from AllDataTypesTable
	 COL1(datatype : INTEGER, precision : 10, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{21}
SELECT NULLIF(INTEGERCOL,REALCOL) from AllDataTypesTable
	 COL1(datatype : INTEGER, precision : 10, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{21}
SELECT NULLIF(INTEGERCOL,DOUBLECOL) from AllDataTypesTable
	 COL1(datatype : INTEGER, precision : 10, scale : 0)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{21}
SELECT NULLIF(INTEGERCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR' are not supported.
SELECT NULLIF(INTEGERCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'VARCHAR' are not supported.
SELECT NULLIF(INTEGERCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(INTEGERCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(INTEGERCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(INTEGERCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(INTEGERCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'CLOB' are not supported.
SELECT NULLIF(INTEGERCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'DATE' are not supported.
SELECT NULLIF(INTEGERCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'TIME' are not supported.
SELECT NULLIF(INTEGERCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'TIMESTAMP' are not supported.
SELECT NULLIF(INTEGERCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'INTEGER' and 'BLOB' are not supported.
SELECT NULLIF(BIGINTCOL,SMALLINTCOL) from AllDataTypesTable
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{22}
SELECT NULLIF(BIGINTCOL,INTEGERCOL) from AllDataTypesTable
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{22}
SELECT NULLIF(BIGINTCOL,BIGINTCOL) from AllDataTypesTable
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(BIGINTCOL,DECIMALCOL) from AllDataTypesTable
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{22}
SELECT NULLIF(BIGINTCOL,REALCOL) from AllDataTypesTable
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{22}
SELECT NULLIF(BIGINTCOL,DOUBLECOL) from AllDataTypesTable
	 COL1(datatype : BIGINT, precision : 19, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{22}
SELECT NULLIF(BIGINTCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR' are not supported.
SELECT NULLIF(BIGINTCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'VARCHAR' are not supported.
SELECT NULLIF(BIGINTCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(BIGINTCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(BIGINTCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(BIGINTCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(BIGINTCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'CLOB' are not supported.
SELECT NULLIF(BIGINTCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'DATE' are not supported.
SELECT NULLIF(BIGINTCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'TIME' are not supported.
SELECT NULLIF(BIGINTCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'TIMESTAMP' are not supported.
SELECT NULLIF(BIGINTCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'BIGINT' and 'BLOB' are not supported.
SELECT NULLIF(DECIMALCOL,SMALLINTCOL) from AllDataTypesTable
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{23.00000}
SELECT NULLIF(DECIMALCOL,INTEGERCOL) from AllDataTypesTable
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{23.00000}
SELECT NULLIF(DECIMALCOL,BIGINTCOL) from AllDataTypesTable
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{23.00000}
SELECT NULLIF(DECIMALCOL,DECIMALCOL) from AllDataTypesTable
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(DECIMALCOL,REALCOL) from AllDataTypesTable
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{23.00000}
SELECT NULLIF(DECIMALCOL,DOUBLECOL) from AllDataTypesTable
	 COL1(datatype : DECIMAL, precision : 10, scale : 5)
	 ---------------------------------------------------
	{null}
	{null}
	{null}
	{23.00000}
SELECT NULLIF(DECIMALCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'CHAR' are not supported.
SELECT NULLIF(DECIMALCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'VARCHAR' are not supported.
SELECT NULLIF(DECIMALCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(DECIMALCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(DECIMALCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(DECIMALCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(DECIMALCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'CLOB' are not supported.
SELECT NULLIF(DECIMALCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'DATE' are not supported.
SELECT NULLIF(DECIMALCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'TIME' are not supported.
SELECT NULLIF(DECIMALCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'TIMESTAMP' are not supported.
SELECT NULLIF(DECIMALCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'DECIMAL' and 'BLOB' are not supported.
SELECT NULLIF(REALCOL,SMALLINTCOL) from AllDataTypesTable
	 COL1(datatype : REAL, precision : 7, scale : 0)
	 -----------------------------------------------
	{null}
	{null}
	{null}
	{24.0}
SELECT NULLIF(REALCOL,INTEGERCOL) from AllDataTypesTable
	 COL1(datatype : REAL, precision : 7, scale : 0)
	 -----------------------------------------------
	{null}
	{null}
	{null}
	{24.0}
SELECT NULLIF(REALCOL,BIGINTCOL) from AllDataTypesTable
	 COL1(datatype : REAL, precision : 7, scale : 0)
	 -----------------------------------------------
	{null}
	{null}
	{null}
	{24.0}
SELECT NULLIF(REALCOL,DECIMALCOL) from AllDataTypesTable
	 COL1(datatype : REAL, precision : 7, scale : 0)
	 -----------------------------------------------
	{null}
	{null}
	{null}
	{24.0}
SELECT NULLIF(REALCOL,REALCOL) from AllDataTypesTable
	 COL1(datatype : REAL, precision : 7, scale : 0)
	 -----------------------------------------------
	{null}
	{null}
	{null}
	{null}
SELECT NULLIF(REALCOL,DOUBLECOL) from AllDataTypesTable
	 COL1(datatype : REAL, precision : 7, scale : 0)
	 -----------------------------------------------
	{null}
	{null}
	{null}
	{24.0}
SELECT NULLIF(REALCOL,CHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'CHAR' are not supported.
SELECT NULLIF(REALCOL,VARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'VARCHAR' are not supported.
SELECT NULLIF(REALCOL,LONGVARCHARCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'LONG VARCHAR' are not supported.
SELECT NULLIF(REALCOL,CHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'CHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(REALCOL,VARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'VARCHAR () FOR BIT DATA' are not supported.
SELECT NULLIF(REALCOL,LVARCHARFORBITCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'LONG VARCHAR FOR BIT DATA' are not supported.
SELECT NULLIF(REALCOL,CLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'CLOB' are not supported.
SELECT NULLIF(REALCOL,DATECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'DATE' are not supported.
SELECT NULLIF(REALCOL,TIMECOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'TIME' are not supported.
SELECT NULLIF(REALCOL,TIMESTAMPCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'TIMESTAMP' are not supported.
SELECT NULLIF(REALCOL,BLOBCOL) from AllDataTypesTable
ERROR 42818: Comparisons between 'REAL' and 'BLOB' are not supported.
SELECT NULLIF(DOUBLECOL,SMALLINTCOL) from AllDataTypesTable
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{25.0}
SELECT NULLIF(DOUBLECOL,INTEGERCOL) from AllDataTypesTable
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{25.0}
SELECT NULLIF(DOUBLECOL,BIGINTCOL) from AllDataTypesTable
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
	 --------------------------------------------------
	{null}
	{null}
	{null}
	{25.0}
SELECT NULLIF(DOUBLECOL,DECIMALCOL) from AllDataTypesTable
	 COL1(datatype : DOUBLE, precision : 15, scale : 0)
12345

⌨️ 快捷键说明

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