|
|
|
|
|
|
|
|
|
|
|
Version 11
Die SQL Engine gibt spezifische Fehler zurück, die nachfolgend aufgelistet sind. Diese Fehler lassen sich mit einer Fehlerverwaltungsmethode abfangen, die über den Befehl ON ERR CALL eingerichtet wird und über den Befehl GET LAST SQL ERROR analysieren.
Generische Fehler
| 1001 | INVALID ARGUMENT |
| 1002 | INVALID INTERNAL STATE |
| 1003 | NOT RUNNING |
Semantische Fehler
| 1101 | TABLE DOES NOT EXIST |
| 1102 | COLUMN DOES NOT EXIST |
| 1103 | TABLE NOT DECLARED IN FROM CLAUSE |
| 1104 | AMBIGUOUS COLUMN NAME |
| 1105 | TABLE ALIAS SAME AS TABLE NAME |
| 1106 | DUPLICATE TABLE ALIAS |
| 1107 | DUPLICATE TABLE IN FROM CLAUSE |
| 1108 | INCOMPATIBLE TYPES |
| 1109 | INVALID ORDER BY INDEX |
| 1110 | WRONG AMOUNT OF PARAMETERS |
| 1111 | INCOMPATIBLE PARAMETER Typ |
| 1112 | UNKNOWN FUNCTION |
| 1113 | DIVISION BY ZERO |
| 1114 | ORDER BY INDEX NOT ALLOWED |
| 1115 | DISTINCT NOT ALLOWED |
| 1116 | NESTED COLUMN FUNCTIONS NOT ALLOWED |
| 1117 | COLUMN FUNCTIONS NOT ALLOWED |
| 1118 | CAN NOT MIX COLUMN AND SCALAR OPERATIONS |
| 1119 | INVALID GROUP BY INDEX |
| 1120 | GROUP BY INDEX NOT ALLOWED |
| 1121 | GROUP BY NOT ALLOWED WITH SELECT ALL |
| 1122 | NOT A COLUMN EXPRESSION |
| 1123 | NOT A GROUPING COLUMN IN AGGREGATE ORDER BY |
| 1124 | MIXED LITERAL TYPES IN PREDICATE |
| 1125 | LIKE ESCAPE IS NOT ONE CHAR |
| 1126 | BAD LIKE ESCAPE CHAR |
| 1127 | UNKNOWN ESCAPE SEQUENCE IN LIKE |
| 1128 | COLUMNS FROM MORE THAN ONE QUERY IN COLUMN FUNCTION |
| 1129 | SCALAR EXPRESSION WITH GROUP BY |
| 1130 | SUBQUERY HAS MORE THAN ONE COLUMN |
| 1131 | SUBQUERY MUST HAVE ONE ROW |
| 1132 | INSERT Wert COUNT DOES NOT MATCH COLUMN COUNT |
| 1133 | DUPLICATE COLUMN IN INSERT |
| 1134 | COLUMN DOES NOT ALLOW NULLS |
| 1135 | DUPLICATE COLUMN IN UPDATE |
| 1136 | TABLE ALREADY EXISTS |
| 1137 | DUPLICATE COLUMN IN CREATE TABLE |
| 1138 | DUPLICATE COLUMN IN COLUMN LIST |
| 1139 | MORE THAN ONE PRIMARY KEY NOT ALLOWED |
| 1140 | AMBIGUOUS FOREIGN KEY NAME |
| 1141 | COLUMN COUNT MISMATCH IN FOREIGN KEY |
| 1142 | COLUMN TYPE MISMATCH IN FOREIGN KEY |
| 1143 | FAILED TO FIND MATCHING PRIMARY COLUMN |
| 1144 | UPDATE AND DELETE CONSTRAINTS MUST BE THE SAME |
| 1145 | FOREIGN KEY DOES NOT EXIST |
| 1146 | INVALID LIMIT VALUE IN SELECT |
| 1147 | INVALID OFFSET VALUE IN SELECT |
| 1148 | PRIMARY KEY DOES NOT EXIST |
| 1149 | FAILED TO CREATE FOREIGN KEY |
| 1150 | FIELD IS NOT IN PRIMARY KEY |
| 1151 | FIELD IS NOT UPDATEABLE |
Implementation
| 1203 | FUNCTIONALITY IS NOT IMPLEMENTED |
| 1204 | FAILED TO CREATE NEW RECORD |
| 1205 | FAILED TO UPDATE FIELD |
| 1206 | FAILED TO DELETE RECORD |
| 1207 | NO MORE JOIN SEEDS POSSIBLE |
| 1208 | FAILED TO CREATE TABLE |
| 1209 | FAILED TO DROP TABLE |
| 1210 | CANT BUILD BTREE FOR ZERO RECORDS |
| 1211 | COMMANDE COUNT GREATER THAN ALLOWED |
| 1212 | FAILED TO CREATE DATABASE |
| 1213 | FAILED TO DROP COLUMN |
| 1214 | Wert IS OUT OF BOUNDS |
| 1215 | FAILED TO STOP SQL_SERVER |
| 1216 | FAILED TO LOCALIZE |
Analysefehler
1301 PARSING FAILED
Zugriff auf Runtime language
| 1401 | COMMAND NOT SPECIFIED |
| 1402 | ALREADY LOGGED IN |
| 1403 | SESSION DOES NOT EXIST |
| 1404 | UNKNOWN BIND ENTITY |
| 1405 | INCOMPATIBLE BIND ENTITIES |
| 1406 | REQUEST RESULT NOT AVAILABLE |
| 1407 | BINDING LOAD FAILED |
| 1408 | COULD NOT RECOVER FROM PREVIOUS ERRORS |
| 1409 | NO OPEN STATEMENT |
| 1410 | RESULT EOF |
| 1411 | BOUND VALUE IS NULL |
| 1412 | STATEMENT ALREADY OPENED |
| 1413 | FAILED TO GET PARAMETER VALUE |
| 1414 | INCOMPATIBLE PARAMETER ENTITIES |
| 1415 | PARAMETER VALUE NOT SPECIFIED |
| 1416 | COLUMN REFERENCE PARAMETERS FROM DIFFERENT TABLES |
| 1417 | EMPTY STATEMENT |
| 1418 | FAILED TO UPDATE VARIABLE |
| 1419 | FAILED TO GET TABLE REFERENCE |
| 1420 | FAILED TO GET TABLE CONTEXT |
| 1421 | COLUMNS NOT ALLOWED |
| 1422 | INVALID COMMAND COUNT |
| 1423 | INTO CLAUSE NOT ALLOWED |
| 1424 | EXECUTE IMMEDIATE NOT ALLOWED |
| 1425 | ARRAY NOT ALLOWED IN EXECUTE IMMEDIATE |
| 1426 | COLUMN NOT ALLOWED IN EXECUTE IMMEDIATE |
| 1427 | NESTED BEGIN END SQL NOT ALLOWED |
| 1428 | RESULT IS NOT A SELECTION |
Datumsanalyse
| 1501 | SEPARATOR_EXPECTED |
| 1502 | FAILED TO PARSE DAY OF MONTH |
| 1503 | FAILED TO PARSE MONTH |
| 1504 | FAILED TO PARSE YEAR |
| 1505 | FAILED TO PARSE HOUR |
| 1506 | FAILED TO PARSE MINUTE |
| 1507 | FAILED TO PARSE SECOND |
| 1508 | FAILED TO PARSE MILLISECOND |
| 1509 | INVALID AM PM USAGE |
| 1510 | FAILED TO PARSE TIME ZONE |
| 1511 | UNEXPECTED CHARACTER |
| 1512 | FAILED TO PARSE TIMESTAMP |
| 1513 | FAILED TO PARSE DURATION |
Datumsformatierung
1551 FAILED
Lexer Fehler
| 1601 | NULL INPUT STRING |
| 1602 | NON TERMINATED STRING |
| 1603 | NON TERMINATED COMMENT |
| 1604 | INVALID NUMBER |
| 1605 | UNKNOWN START OF TOKEN |
| 1606 | NON TERMINATED NAME |
| 1607 | NO VALID TOKENS |
Zwischenspeicherung
| 2000 | CACHEABLE NOT INITIALIZED |
| 2001 | VALUE ALREADY CACHED |
| 2002 | CACHED VALUE NOT FOUND |
Protokollfehler
| 3000 | HEADER NOT FOUND |
| 3001 | UNKNOWN COMMAND |
| 3002 | ALREADY LOGGED IN |
| 3003 | NOT LOGGED IN |
| 3004 | UNKNOWN OUTPUT MODE |
| 3005 | INVALID STATEMENT ID |
| 3006 | UNKNOWN DATA Typ |
| 3007 | STILL LOGGED IN |
| 3008 | SOCKET READ ERROR |
| 3009 | SOCKET WRITE ERROR |
|
|
|
|
|
|
|
|
|
|
|