GBASE 8M 内存数据库 错误码手册

类型与运算

Error Code SQLSTATE Message

12000 HY000 failed to initialize datatype layer

12001 HYC00 not implemented feature, in a function %s

12002 22001 byte length of data greater than column

length

12003 22001 character length of data greater than

column length

12004 22001 data converted with truncation of

fractional digits

12005 22001 conversion of data would result in loss

of whole digits

12006 22018 data value is not a numeric literal

12007 22003 data is outside the range of the data type

to which the number is being converted

12008 22001 data is greater than 0, less than 2, and

not equal to 1

12009 22003 data is less than 0 or greater than or

equal to 2

12010 22001 (byte length of data)/2 is greater than

column byte length

12011 22003 data value is not a hexadecimal value

12012 22008 data value is a valid timestamp literal;

time portion is nonzero

12013 22018 data value is not a valid date literal or

timestamp literal

12014 22008 data value is a valid timestamp literal;

fractional seconds portion is nonzero

12015 22018 data value is not a valid time literal or

timestamp literal

12016 22008 data value is a valid timestamp literal;

fractional seconds portion truncated

12017 22018 data value is not a valid date literal or

time literal or timestamp literal

GBASE 8M 错误码手册

南大通用数据技术股份有限公司 - 9 -

12018 22015 data value is a valid interval value; the

value in one of the fields is truncated

12019 22018 data value is not a valid interval

literal

12020 22001 number of digits greater than column byte

length

12021 22001 number of characters greater than column

byte length

12022 22003 data converted with truncation of whole

digits

12023 22003 data is outside the range of the data type

to which the number is being converted

12024 22001 data is greater than 0, less than 2, and

not equal to 1

12025 22003 data is less than 0 or greater than or

equal to 2

12026 22015 interval data truncated

12027 22001 byte length of data greater than column

length

12028 22001 character length of data greater than

column length

12029 22003 byte length of data not equal to SQL data

length

12030 22001 column byte length is less than %d

12031 22008 data value is not a valid date

12032 22007 data value is not a valid date format

12033 22001 column byte length is less than %d

12034 22018 data value is not a valid GUID

12035 22001 column byte length is less than %d

12036 22001 data value is not a valid time

12037 22007 data value is not a valid time format

12038 22001 column byte length is between %d and

character byte length

12039 22001 column byte length is less than %d

12040 22008 data value is not a valid timestamp

12041 22008 time fields are nonzero

GBASE 8M 错误码手册

• 10 - 南大通用数据技术股份有限公司

12042 22007 data value does not contain a valid date

12043 22008 fractional seconds fields are nonzero

12044 22007 data value does not contain a valid time

12045 22008 fractional seconds fields are truncated

12046 22007 data value does not contain a valid

timestamp

12047 22001 column byte length is less than character

byte length

12048 22015 data value is not a valid interval

literal

12049 22003 conversion resulted in truncation of

whole digits

12050 22015 one or more fields of data value were

truncated during conversion

12051 22001 column byte length is less than character

byte length

12052 22015 data value is not a valid interval

literal

12053 22003 conversion resulted in truncation of

whole digits

12054 22015 one or more fields of data value were

truncated during conversion

12055 01004 byte length of data greater equal than

buffer length

12056 01004 character length of data greater equal

than buffer length

12057 01S07 data converted with truncation of

fractional digits

12058 22003 conversion of data would result in loss

of whole digits

12059 22018 data is not numeric literal

12060 22003 data is outside the range of the data type

to which the number is being converted

12061 01S07 data is greater than 0, less than 2, and

not equal to 1

12062 22003 data is less than 0 or greater than or

GBASE 8M 错误码手册

南大通用数据技术股份有限公司 - 11 -

equal to 2

12063 01S07 data value is a valid timestamp-value;

time portion is nonzero

12064 22018 data value is not a valid date-value or

timestamp-value

12065 01S07 data value is a valid timestamp-value;

fractional seconds portion is nonzero

12066 22018 data value is not a valid time-value or

timestamp-value

12067 22018 data value is not a valid date-value or

time-value or timestamp-value

12068 01S07 data value is a valid interval

value;truncation of one or more trailing

fields

12069 22015 data value is a valid interval; leading

field significant precision is lost

12070 22018 data value is not a valid interval value

12071 01004 number of whole digits is less than

buffer length

12072 22003 number of whole digits is greater than

buffer length

12073 01S07 data converted with truncation of

fractional digits

12074 22003 conversion of data would result in loss

of whole digits

12075 22003 data is outside the range of the data type

to which the number is being converted

12076 01S07 data is greater than 0, less than 2, and

not equal to 1

12077 22003 data is less than 0 or greater than or

equal to 2

12078 22003 byte length of data is greater than

buffer length

12079 01S07 fractional seconds portion truncated

12080 22015 whole part of number truncated

12081 22003 buffer length is less equal than 1

GBASE 8M 错误码手册

• 12 - 南大通用数据技术股份有限公司

12082 22003 buffer length is less than 1

12083 01004 (byte length of data)/2 is greater equal

than buffer length

12084 01004 (character length of data)/2 is greater

equal than buffer length

12085 01004 byte length of data is greater than

buffer length

12086 01004 buffer length is between %d and character

byte length

12087 22003 buffer length is less than %d

12088 22003 byte length of data is greater than

buffer length

12089 22003 buffer length is less than %d

12090 22003 byte length of data is greater than

buffer length

12091 01004 buffer length is between %d and character

byte length

12092 22003 buffer length is less than %d

12093 22003 byte length of data is greater than

buffer length

12094 01004 buffer length is between %d and character

byte length

12095 22003 buffer length is less than %d

12096 01004 buffer length is between %d and character

length

12097 22003 byte length of data is greater than

buffer length

12098 01S07 time portion of timestamp is nonzero

12099 01S07 fractional seconds portion of timestamp

is nonzero

12100 01S07 fractional seconds portion of timestamp

is truncated

12101 01S07 trailing fields portion truncated

12102 22015 leading precision of target is not big

enough to hold data from source

12103 22003 interval precision was a single field and

GBASE 8M 错误码手册

南大通用数据技术股份有限公司 - 13 -

truncated whole

12104 22015 interval precision was not a sigle field

12105 22003 byte length of data is greater than

buffer length

12106 01004 number of whole digits is less than

buffer length

12107 22003 number of whole digits is greater equal

than buffer length

12108 01S07 trailing fields portion truncated

12109 22015 leading precision of target is not big

enough to hold data from source

12110 01S07 interval precision was a single field and

truncated fractional

12111 22003 interval precision was a single field and

truncated whole

12112 07006 interval precision was not a sigle field

12113 22003 byte length of data is greater than

buffer length

12114 01004 number of whole digits is less than

buffer length

12115 22003 number of whole digits is greater equal

than buffer length

12116 22009 invalid time zone displacement value

12117 42000 invalid number of arguments

12118 42000 inconsistent datatype of function

parameters: %s

12119 42000 comparison is not applicable: %s and %s

12120 42000 conversion is not applicable: from %s

to %s

12121 22021 invalid character value in characterset

repertoire

12122 22012 divisor is equal to zero

12123 22018 data is not boolean literal

12124 HY000 invalid argument for factorial function

12125 22027 trim set should have only one character

12126 22008 datetime field overflow

GBASE 8M 错误码手册

• 14 - 南大通用数据技术股份有限公司

12127 HY000 invalid ROWID

12128 22019 invalid escape character

12129 HY000 invalid character set identifier

12130 HY000 invalid extract field for extract source

12131 42000 inconsistent datatypes: argument[%d]

expected %s

12132 HY000 date format value exceeds maximum length

(%d)

12133 HY000 date format not recognized

12134 HY000 format code appears twice

12135 HY000 %s conflicts with %s

12136 HY000 literal does not match format string

12137 HY000 input value not long enough for date

format

12138 HY000 date format picture ends before

converting entire input string

12139 HY000 year must be between %s and %s, and not

be 0

12140 2200C missing or illegal character following

the escape character

12141 HY000 not a valid month

12142 HY000 a non-numeric character was found where

a numeric was expected

12143 HY000 day of month must be between 1 and last

day of month

12144 HY000 not a valid day of the week

12145 HY000 day of year must be between 1 and 365 (366

for leap year)

12146 HY000 format code cannot appear in date input

format

12147 HY000 BC/B.C. or AD/A.D. required

12148 HY000 julian date must be between 0 and 5373484

12149 HY000 %s may only be specified once

12150 HY000 Julian date precludes use of day of year

12151 HY000 Not enough format info buffer

12152 HY000 hour must be between %d and %d

GBASE 8M 错误码手册

南大通用数据技术股份有限公司 - 15 -

12153 HY000 minute must be between 0 and 59

12154 HY000 second must be between 0 and 59

12155 HY000 the fractional seconds must be between 0

and 999999

12156 HY000 time zone hour must be between -14 and 14

12157 HY000 time zone minute must be between 0 and 59

12158 HY000 seconds in day must be between 0 and 86399

12159 HY000 AM/A.M. or PM/P.M. required

12160 HY000 HH24 precludes use of meridian indicator

12161 HY000 %s conflicts with use of %s

12162 HY000 invalid XID string

12163 HY000 date not valid for month specified

12164 HY000 signed year precludes use of BC/AD

12165 HY000 number format value exceeds maximum

length (%d)

12166 HY000 invalid number format model

12167 HY000 cannot use %s twice

12168 HY000 cannot use %s and %s together

12169 22001 string data, right truncation

12170 HY000 argument '%d' is out of range

12171 HY000 invalid datepart for data type %s

12172 42000 maximum number of arguments exceeded

12173 42000 invalid char length units(%s): use

OCTETS or CHARACTERS

12174 22023 The argument of %s function is invalid

12175 22023 The argument [%d] of %s function is

invalid

Table 2-1 类型与运算相关错误