SQLエンジンエラー (1001 -> 3018)

4D - Documentation   French   English   German   Spanish   日本語   4D v11 SQLコマンドテーマリスト   4D v11 SQLインデックス   4D v11 SQL定数テーマリスト   戻る   前   次

version 11


4DのSQLエンジンは以下にリストするようなエラーを返します。これらのエラーはON ERR CALLでインストールされるエラー処理メソッドでとらえることができ、GET LAST ERROR STACKコマンドで検証できます。

一般的なエラー

1001INVALID ARGUMENT
1002INVALID INTERNAL STATE
1003NOT RUNNING

セマンティックエラー

1101TABLE DOES NOT EXIST
1102COLUMN DOES NOT EXIST
1103TABLE NOT DECLARED IN FROM CLAUSE
1104AMBIGUOUS COLUMN NAME
1105TABLE ALIAS SAME AS TABLE NAME
1106DUPLICATE TABLE ALIAS
1107DUPLICATE TABLE IN FROM CLAUSE
1108INCOMPATIBLE TYPES
1109INVALID ORDER BY INDEX
1110WRONG AMOUNT OF PARAMETERS
1111INCOMPATIBLE PARAMETER TYPE
1112UNKNOWN FUNCTION
1113DIVISION BY ZERO
1114ORDER BY INDEX NOT ALLOWED
1115DISTINCT NOT ALLOWED
1116NESTED COLUMN FUNCTIONS NOT ALLOWED
1117COLUMN FUNCTIONS NOT ALLOWED
1118CAN NOT MIX COLUMN AND SCALAR OPERATIONS
1119INVALID GROUP BY INDEX
1120GROUP BY INDEX NOT ALLOWED
1121GROUP BY NOT ALLOWED WITH SELECT ALL
1122NOT A COLUMN EXPRESSION
1123NOT A GROUPING COLUMN IN AGGREGATE ORDER BY
1124MIXED LITERAL TYPES IN PREDICATE
1125LIKE ESCAPE IS NOT ONE CHAR
1126BAD LIKE ESCAPE CHAR
1127UNKNOWN ESCAPE SEQUENCE IN LIKE
1128COLUMNS FROM MORE THAN ONE QUERY IN COLUMN FUNCTION
1129SCALAR EXPRESSION WITH GROUP BY
1130SUBQUERY HAS MORE THAN ONE COLUMN
1131SUBQUERY MUST HAVE ONE ROW
1132INSERT VALUE COUNT DOES NOT MATCH COLUMN COUNT
1133DUPLICATE COLUMN IN INSERT
1134COLUMN DOES NOT ALLOW NULLS
1135DUPLICATE COLUMN IN UPDATE
1136TABLE ALREADY EXISTS
1137DUPLICATE COLUMN IN CREATE TABLE
1138DUPLICATE COLUMN IN COLUMN LIST
1139MORE THAN ONE PRIMARY KEY NOT ALLOWED
1140AMBIGUOUS FOREIGN KEY NAME
1141COLUMN COUNT MISMATCH IN FOREIGN KEY
1142COLUMN TYPE MISMATCH IN FOREIGN KEY
1143FAILED TO FIND MATCHING PRIMARY COLUMN
1144UPDATE AND DELETE CONSTRAINTS MUST BE THE SAME
1145FOREIGN KEY DOES NOT EXIST
1146INVALID LIMIT VALUE IN SELECT
1147INVALID OFFSET VALUE IN SELECT
1148PRIMARY KEY DOES NOT EXIST
1149FAILED TO CREATE FOREIGN KEY
1150FIELD IS NOT IN PRIMARY KEY
1151FIELD IS NOT UPDATEABLE

実装エラー

1203FUNCTIONALITY IS NOT IMPLEMENTED
1204FAILED TO CREATE NEW RECORD
1205FAILED TO UPDATE FIELD
1206FAILED TO DELETE RECORD
1207NO MORE JOIN SEEDS POSSIBLE
1208FAILED TO CREATE TABLE
1209FAILED TO DROP TABLE
1210CANT BUILD BTREE FOR ZERO RECORDS
1211COMMAND COUNT GREATER THAN ALLOWED
1212FAILED TO CREATE DATABASE
1213FAILED TO DROP COLUMN
1214VALUE IS OUT OF BOUNDS
1215FAILED TO STOP SQL_SERVER
1216FAILED TO LOCALIZE

解析エラー

1301 PARSING FAILED

ランタイムランゲージアクセスエラー

1401COMMAND NOT SPECIFIED
1402ALREADY LOGGED IN
1403SESSION DOES NOT EXIST
1404UNKNOWN BIND ENTITY
1405INCOMPATIBLE BIND ENTITIES
1406REQUEST RESULT NOT AVAILABLE
1407BINDING LOAD FAILED
1408COULD NOT RECOVER FROM PREVIOUS ERRORS
1409NO OPEN STATEMENT
1410RESULT EOF
1411BOUND VALUE IS NULL
1412STATEMENT ALREADY OPENED
1413FAILED TO GET PARAMETER VALUE
1414INCOMPATIBLE PARAMETER ENTITIES
1415PARAMETER VALUE NOT SPECIFIED
1416COLUMN REFERENCE PARAMETERS FROM DIFFERENT TABLES
1417EMPTY STATEMENT
1418FAILED TO UPDATE VARIABLE
1419FAILED TO GET TABLE REFERENCE
1420FAILED TO GET TABLE CONTEXT
1421COLUMNS NOT ALLOWED
1422INVALID COMMAND COUNT
1423INTO CLAUSE NOT ALLOWED
1424EXECUTE IMMEDIATE NOT ALLOWED
1425ARRAY NOT ALLOWED IN EXECUTE IMMEDIATE
1426COLUMN NOT ALLOWED IN EXECUTE IMMEDIATE
1427NESTED BEGIN END SQL NOT ALLOWED
1428RESULT IS NOT A SELECTION

日付解析エラー

1501SEPARATOR_EXPECTED
1502FAILED TO PARSE DAY OF MONTH
1503FAILED TO PARSE MONTH
1504FAILED TO PARSE YEAR
1505FAILED TO PARSE HOUR
1506FAILED TO PARSE MINUTE
1507FAILED TO PARSE SECOND
1508FAILED TO PARSE MILLISECOND
1509INVALID AM PM USAGE
1510FAILED TO PARSE TIME ZONE
1511UNEXPECTED CHARACTER
1512FAILED TO PARSE TIMESTAMP
1513FAILED TO PARSE DURATION

日付フォーマットエラー

1551 FAILED

Lexer エラー

1601NULL INPUT STRING
1602NON TERMINATED STRING
1603NON TERMINATED COMMENT
1604INVALID NUMBER
1605UNKNOWN START OF TOKEN
1606NON TERMINATED NAME
1607NO VALID TOKENS

キャッシュエラー

2000CACHEABLE NOT INITIALIZED
2001VALUE ALREADY CACHED
2002CACHED VALUE NOT FOUND

プロトコルエラー

3000HEADER NOT FOUND
3001UNKNOWN COMMAND
3002ALREADY LOGGED IN
3003NOT LOGGED IN
3004UNKNOWN OUTPUT MODE
3005INVALID STATEMENT ID
3006UNKNOWN DATA TYPE
3007STILL LOGGED IN
3008SOCKET READ ERROR
3009SOCKET WRITE ERROR


4D - Documentation   French   English   German   Spanish   日本語   4D v11 SQLコマンドテーマリスト   4D v11 SQLインデックス   4D v11 SQL定数テーマリスト   戻る   前   次