Select error column lists do not match - Исправление ошибок и поиск оптимальных решений проблем

I found the problem with the DW, and its not in the SQL or the pull of the DW itself its the use of the MODIFY function to change the SQL behind the scenes.
But the initial problem remains, as the solution I devised did not work.

Before calling the Modify function I changed the single quotes (‘) to double («) around certain items (listed below), and this actually got past the column error that is a result of a bad Modify call. The problem that arose from this change is that though the MODIFY function now modifies correctly, the DW gets an invalid Column error with Double «‘s.

Catch 22. Change the SQL to use the modify function, but then the DW wont retrieve properly.

Columns Changing:
Select < Various Coumns>,
To_Number( To_Char(FAST.account_request.requested_date, «mm») ),
To_Number( To_Char(FAST.account_request.requested_date, «dd») ),
To_Number( To_Char(FAST.account_request.requested_date, «yy») ),
InStr(FAST.account_request.status, «xndaper»)

SQL comes from here:
is_orgselect = dw_list.Describe(«DataWindow.Table.Select»)

Changes are here:
is_orgselect = replace(is_orgselect, pos(is_orgselect, «‘mm'»), 4, «~»mm~»»)
is_orgselect = replace(is_orgselect, pos(is_orgselect, «‘dd'»), 4, «~»dd~»»)
is_orgselect = replace(is_orgselect, pos(is_orgselect, «‘yy'»), 4, «~»yy~»»)
is_orgselect = replace(is_orgselect, pos(is_orgselect, «‘xndaper'»), 9, «~»xndaper~»»)

t_modstrg = «DataWindow.Table.Select='» &
+ is_orgselect + t_where + «‘»

The entire SQL of the DW becomes what is below:

SELECT FAST.ACCOUNT_REQUEST.~»SSO_LOGIN_ID~» , ~»FAST~».~»ACCOUNT_REQUEST~».~»CONNECT_ID~» , ~»FAST~».~»ACCOUNT_REQUEST~».~»REQUESTED_DATE~» , To_Number( To_Char(FAST.account_request.requested_date, «mm») ), To_Number( To_Char(FAST.account_request.requested_date, «dd») ), To_Number( To_Char(FAST.account_request.requested_date, «yy») ), ~»FAST~».~»ACCOUNT_REQUEST~».~»STATUS~» , ~»FAST~».~»ACCOUNT_REQUEST~».~»REQUESTOR_LOGIN_ID~» , ~»FAST~».~»SSO_USER~».~»LAST_NAME~» , ~»FAST~».~»SSO_USER~».~»FIRST_NAME~» , ~»FAST~».~»SSO_USER~».~»MIDDLE_NAME~» , ~»FAST~».~»SSO_USER~».~»FIN_DEPT_ID~» , ~»FAST~».~»ACCOUNT_REQUEST~».~»APPROVER_LOGIN_ID~» , ~»FAST~».~»SSO_USER~».~»SU_ID~» , ~»FAST~».~»ACCOUNT_REQUEST~».~»STATUS_DATE~» , ~»FAST~».~»DEPARTMENT~».~»DEPT_NAME~» , ~»FAST~».~»CONNECTION~».~»SHORT_DESC~» , InStr(FAST.account_request.status,»xndaper») FROM ~»FAST~».~»ACCOUNT_REQUEST~» , ~»FAST~».~»SSO_USER~» , ~»FAST~».~»CONNECTION~» , ~»FAST~».~»DEPARTMENT~» WHERE ( ~»FAST~».~»SSO_USER~».~»FIN_DEPT_ID~» = ~»FAST~».~»DEPARTMENT~».~»DEPT_NUMBER~» (+)) and ( ~»FAST~».~»ACCOUNT_REQUEST~».~»SSO_LOGIN_ID~» = ~»FAST~».~»SSO_USER~».~»SSO_LOGIN_ID~» ) and ( ~»FAST~».~»ACCOUNT_REQUEST~».~»CONNECT_ID~» = ~»FAST~».~»CONNECTION~».~»CONNECT_ID~» ) and (FAST.account_request.status in («r», «e»))’

Источник

~~Спрашивающий~~

Заблокирован

Ошибка компиляции процедуры

21.11.2013, 20:53. Показов 5616. Ответов 11

Метки нет (Все метки)

Добрый день! У меня возник вопрос. Есть код процедуры:

SQL

BEGIN
 
FOR
    SELECT ID, NAME
    FROM TEST
    WHERE NAME LIKE '%' + :NAME + '%'
    INTO 
    :ID,
    :NAME
DO
  SUSPEND;
END

Код работает, но если пытаюсь убрать поле ID

SQL

BEGIN
 
FOR
    SELECT *
    FROM TEST
    WHERE NAME LIKE '%' + :NAME + '%'
    INTO 
    :NAME
DO
  SUSPEND;
END

Происходит ошибка.

Dynamic SQL Error.
SQL error code = -313.
Count of column list and variable list do not match.

Удаляю так же поле ID см. картинку. Оставляю только NAME.

Миниатюры

__________________
Помощь в написании контрольных, курсовых и дипломных работ, диссертаций здесь

arni

912 / 877 / 62

Регистрация: 06.01.2010

Сообщений: 2,367

Записей в блоге: 6

21.11.2013, 21:19

Count of column list and variable list do not match

перевожу с английского:

Количество колонок не совпадает с количестовом переменных.

Поразмышляйте, как сервер должен запихнуть неопределенное кол-во столбцов

SQL

SELECT *

в одну переменную

SQL

1	INTO :NAME

Добавлено через 1 минуту
p.s. вот это

SQL

1	WHERE NAME LIKE '%' + :NAME + '%'

лучше записать так

SQL

1	WHERE NAME containing :NAME

~~Спрашивающий~~

Заблокирован

21.11.2013, 21:28

[ТС]

arni, Спс я с английским в ладах, помогите тогда как должно выглядеть правильное решение?

arni

912 / 877 / 62

Регистрация: 06.01.2010

Сообщений: 2,367

Записей в блоге: 6

21.11.2013, 21:34

Спрашивающий, предложу более полезное действо для вас:
когда вы этот код

SQL

1
2
3

SELECT ID, NAME
..
INTO :ID, :NAME

превратили в этот

SQL

1
2
3

SELECT *
...
INTO :NAME

вы действительно сделали лишь

убрать поле ID

? Или же ваши действия затронули куда большее?

~~Спрашивающий~~

Заблокирован

22.11.2013, 07:04

[ТС]

Помогите пожалуйста привести в нормальный вид. Отобразив все столбцы, но ввод параметра в условие WHERE оставив только поле NAME.

912 / 877 / 62

Регистрация: 06.01.2010

Сообщений: 2,367

Записей в блоге: 6

22.11.2013, 08:57

Я готов вам помочь, если вы будете прикладывать собственные усилия к обучению.
Если же вам нужно не обучение, а детский сад «сделайте это за меня», тогда я умываю руки. Возможно найдутся более отзывчивые люди.

Подсказка: если вам нужны «все столбцы», то вы должны перечислить их поименно в SELECT, и для каждого предусмотреть переменную-параметр в INTO

~~Спрашивающий~~

Заблокирован

22.11.2013, 15:23

[ТС]

arni, Спасибо огромное за желание мне помочь, я приложу все усилия. И так, я сделал вот так:

SQL

BEGIN
 
FOR
    SELECT ID, NAME
    FROM TEST
    WHERE NAME LIKE '%' + :NAME + '%'
    INTO 
    :ID,
    :NAME
DO
  SUSPEND;
END

Теперь из MS Excel с помощью ADODB делаю подключение к базе данных:

Visual Basic

Public conn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public cmd As New ADODB.Command
 
Sub Main()
    OpenDB
End Sub
 
Sub OpenDB()
On Error GoTo er:
    Set conn = Nothing
    Set conn = New ADODB.Connection
    conn = "DRIVER=Firebird/InterBase(r) driver;User=SYSDBA;Password=masterkey;Database=D:DATABASE_.GDB;DataSource=HOMEPC;Port=3050;Dialect=3;Charset=NONE;Role=Administrator;Connection lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=50;Packet Size=8192;ServerType=0;"
    conn.Open
        If conn.State = 1 Then
            MsgBox "Ñîåäèíåíèå óñòàíîâëåíî"
            Form1.Show
        Else
            MsgBox "Îøèáêà": End
        End If
Exit Sub
er:     MsgBox Err.Description, vbCritical, "": Exit Sub
End Sub

И СОБСТВЕННО ОБРАЩЕНИЕ:

Visual Basic

Sub SQL()
    Set cmd = New ADODB.Command
    cmd.ActiveConnection = conn
    cmd.CommandType = adCmdStoredProc
    cmd.CommandText = "SELECT_"
    cmd.Parameters.Append cmd.CreateParameter("NAME", adBSTR, adParamInput, 250, Text3.Text)
    
    Set rs = New ADODB.Recordset
    rs.CursorLocation = adUseClient
    rs.Open cmd
    Set VSFlexGrid1.DataSource = rs
End Sub

Передавая параметр поиска:

Visual Basic

1	cmd.Parameters.Append cmd.CreateParameter("NAME", adBSTR, adParamInput, 250, Text3.Text)

NAME значение из Text3.Text

Но не работает, сообщение об ошибке:

912 / 877 / 62

Регистрация: 06.01.2010

Сообщений: 2,367

Записей в блоге: 6

22.11.2013, 16:03

Но не работает, сообщение об ошибке:

вы остановились на самом интересном

~~Спрашивающий~~

Заблокирован

22.11.2013, 16:43

[ТС]

Вот ошибка, хотя к примеру триггер на MS SQL SERVER с помощью VBA прекрасно работает.

Миниатюры

912 / 877 / 62

Регистрация: 06.01.2010

Сообщений: 2,367

Записей в блоге: 6

22.11.2013, 17:35

Полный текст процедуры не помешает.

~~Спрашивающий~~

Заблокирован

22.11.2013, 17:38

[ТС]

SQL

BEGIN
 
FOR
    SELECT ID, NAME
    FROM TEST
    WHERE NAME LIKE '%' + :NAME + '%'
    INTO
    :ID,
    :NAME
DO
  SUSPEND;
END

Миниатюры

912 / 877 / 62

Регистрация: 06.01.2010

Сообщений: 2,367

Записей в блоге: 6

22.11.2013, 17:46

Вы показали тело процедуры. Заголовочная часть обрезана.
На скриншоте видно, что якобы ID и NAME — это входные параметры, а не выходные.
Неясно, что у вас на закладке «Output», но похоже, что заголовок процедуры некорректен.
Хотелось бы посмотреть его полностью в текстовом формате, без интерпретации SQL Manager.
Сразу оговорюсь, что этот инструмент мне не знаком, поэтому как убрать хидер и посмотреть исходный SQL в нём, я без понятия.

Источник

501

335544802

dialect_reset_warning

Database dialect being changed from 3 to 1

301

335544808

dtype_renamed

DATE data type is now called TIMESTAMP

301

336003076

dsql_dialect_warning_expr

Use of @1 expression that returns different results in dialect 1 and dialect 3

301

336003080

dsql_warning_number_ambiguous

WARNING: Numeric literal @1 is interpreted as a floating-point

301

336003081

dsql_warning_number_ambiguous1

value in SQL dialect 1, but as an exact numeric value in SQL dialect 3.

301

336003082

dsql_warn_precision_ambiguous

WARNING: NUMERIC and DECIMAL fields with precision 10 or greater are stored

301

336003083

dsql_warn_precision_ambiguous1

as approximate floating-point values in SQL dialect 1, but as 64-bit

301

336003084

dsql_warn_precision_ambiguous2

integers in SQL dialect 3.

300

335544807

sqlwarn

SQL warning code = @1

106

336068855

dyn_miss_priv_warning

Warning: @1 on @2 is not granted to @3.

101

335544366

segment

segment buffer length shorter than expected

100

335544338

from_no_match

no match for first value expression

100

335544354

no_record

invalid database key

100

335544367

segstr_eof

attempted retrieval of more segments than exist

335544875

bad_debug_format

Bad debug info format

335544931

montabexh

Monitoring table space exhausted

-84

335544554

nonsql_security_rel

object has non-SQL security class defined

-84

335544555

nonsql_security_fld

column has non-SQL security class defined

-84

335544668

dsql_procedure_use_err

procedure @1 does not return any values

-85

335544747

usrname_too_long

The username entered is too long. Maximum length is 31 bytes.

-85

335544748

password_too_long

The password specified is too long. Maximum length is 8 bytes.

-85

335544749

usrname_required

A username is required for this operation.

-85

335544750

password_required

A password is required for this operation

-85

335544751

bad_protocol

The network protocol specified is invalid

-85

335544752

dup_usrname_found

A duplicate user name was found in the security database

-85

335544753

usrname_not_found

The user name specified was not found in the security database

-85

335544754

error_adding_sec_record

An error occurred while attempting to add the user.

-85

335544755

error_modifying_sec_record

An error occurred while attempting to modify the user record.

-85

335544756

error_deleting_sec_record

An error occurred while attempting to delete the user record.

-85

335544757

error_updating_sec_db

An error occurred while updating the security database.

-103

335544571

dsql_constant_err

Data type for constant unknown

-104

335544343

invalid_blr

invalid request BLR at offset @1

-104

335544390

syntaxerr

BLR syntax error: expected @1 at offset @2, encountered @3

-104

335544425

ctxinuse

context already in use (BLR error)

-104

335544426

ctxnotdef

context not defined (BLR error)

-104

335544429

badparnum

undefined parameter number

-104

335544440

bad_msg_vec

-104

335544456

invalid_sdl

invalid slice description language at offset @1

-104

335544570

dsql_command_err

Invalid command

-104

335544579

dsql_internal_err

Internal error

-104

335544590

dsql_dup_option

Option specified more than once

-104

335544591

dsql_tran_err

Unknown transaction option

-104

335544592

dsql_invalid_array

Invalid array reference

-104

335544608

command_end_err

Unexpected end of command

-104

335544612

token_err

Token unknown

-104

335544634

dsql_token_unk_err

Token unknown — line @1, column @2

-104

335544709

dsql_agg_ref_err

Invalid aggregate reference

-104

335544714

invalid_array_id

invalid blob id

-104

335544730

cse_not_supported

Client/Server Express not supported in this release

-104

335544743

token_too_long

token size exceeds limit

-104

335544763

invalid_string_constant

a string constant is delimited by double quotes

-104

335544764

transitional_date

DATE must be changed to TIMESTAMP

-104

335544796

sql_dialect_datatype_unsupport

Client SQL dialect @1 does not support reference to @2 datatype

-104

335544798

depend_on_uncommitted_rel

You created an indirect dependency on uncommitted metadata. You must roll back the current transaction.

-104

335544821

dsql_column_pos_err

Invalid column position used in the @1 clause

-104

335544822

dsql_agg_where_err

Cannot use an aggregate or window function in a WHERE clause, use HAVING (for aggregate only) instead

-104

335544823

dsql_agg_group_err

Cannot use an aggregate or window function in a GROUP BY clause

-104

335544824

dsql_agg_column_err

Invalid expression in the @1 (not contained in either an aggregate function or the GROUP BY clause)

-104

335544825

dsql_agg_having_err

Invalid expression in the @1 (neither an aggregate function nor a part of the GROUP BY clause)

-104

335544826

dsql_agg_nested_err

Nested aggregate and window functions are not allowed

-104

335544849

malformed_string

Malformed string

-104

335544851

command_end_err2

Unexpected end of command — line @1, column @2

-104

335544930

too_big_blr

BLR stream length @1 exceeds implementation limit @2

-104

335544980

internal_rejected_params

Incorrect parameters provided to internal function @1

-104

335545022

cannot_copy_stmt

Cannot copy statement @1

-104

335545023

invalid_boolean_usage

Invalid usage of boolean expression

-104

335545035

svc_no_stdin

No isc_info_svc_stdin in user request, but service thread requested stdin data

-104

335545037

svc_no_switches

All services except for getting server log require switches

-104

335545038

svc_bad_size

Size of stdin data is more than was requested from client

-104

335545039

no_crypt_plugin

Crypt plugin @1 failed to load

-104

335545040

cp_name_too_long

Length of crypt plugin name should not exceed @1 bytes

-104

335545045

null_spb

NULL data with non-zero SPB length

-104

336003075

dsql_transitional_numeric

Precision 10 to 18 changed from DOUBLE PRECISION in SQL dialect 1 to 64-bit scaled integer in SQL dialect 3

-104

336003077

sql_db_dialect_dtype_unsupport

Database SQL dialect @1 does not support reference to @2 datatype

-104

336003087

dsql_invalid_label

Label @1 @2 in the current scope

-104

336003088

dsql_datatypes_not_comparable

Datatypes @1are not comparable in expression @2

-104

336397215

dsql_max_sort_items

cannot sort on more than 255 items

-104

336397216

dsql_max_group_items

cannot group on more than 255 items

-104

336397217

dsql_conflicting_sort_field

Cannot include the same field (@[email protected]) twice in the ORDER BY clause with conflicting sorting options

-104

336397218

dsql_derived_table_more_columns

column list from derived table @1 has more columns than the number of items in its SELECT statement

-104

336397219

dsql_derived_table_less_columns

column list from derived table @1 has less columns than the number of items in its SELECT statement

-104

336397220

dsql_derived_field_unnamed

no column name specified for column number @1 in derived table @2

-104

336397221

dsql_derived_field_dup_name

column @1 was specified multiple times for derived table @2

-104

336397222

dsql_derived_alias_select

Internal dsql error: alias type expected by pass1_expand_select_node

-104

336397223

dsql_derived_alias_field

Internal dsql error: alias type expected by pass1_field

-104

336397224

dsql_auto_field_bad_pos

Internal dsql error: column position out of range in pass1_union_auto_cast

-104

336397225

dsql_cte_wrong_reference

Recursive CTE member (@1) can refer itself only in FROM clause

-104

336397226

dsql_cte_cycle

CTE ‘@1’ has cyclic dependencies

-104

336397227

dsql_cte_outer_join

Recursive member of CTE can’t be member of an outer join

-104

336397228

dsql_cte_mult_references

Recursive member of CTE can’t reference itself more than once

-104

336397229

dsql_cte_not_a_union

Recursive CTE (@1) must be an UNION

-104

336397230

dsql_cte_nonrecurs_after_recurs

CTE ‘@1’ defined non-recursive member after recursive

-104

336397231

dsql_cte_wrong_clause

Recursive member of CTE ‘@1’ has @2 clause

-104

336397232

dsql_cte_union_all

Recursive members of CTE (@1) must be linked with another members via UNION ALL

-104

336397233

dsql_cte_miss_nonrecursive

Non-recursive member is missing in CTE ‘@1’

-104

336397234

dsql_cte_nested_with

WITH clause can’t be nested

-104

336397235

dsql_col_more_than_once_using

column @1 appears more than once in USING clause

-104

336397237

dsql_cte_not_used

CTE «@1» is not used in query

-104

336397238

dsql_col_more_than_once_view

column @1 appears more than once in ALTER VIEW

-104

336397257

dsql_max_distinct_items

Cannot have more than 255 items in DISTINCT list

-104

336397321

dsql_cte_recursive_aggregate

Recursive member of CTE cannot use aggregate or window function

-104

336397326

dsql_wlock_simple

WITH LOCK can be used only with a single physical table

-104

336397327

dsql_firstskip_rows

FIRST/SKIP cannot be used with OFFSET/FETCH or ROWS

-104

336397328

dsql_wlock_aggregates

WITH LOCK cannot be used with aggregates

-104

336397329

dsql_wlock_conflict

WITH LOCK cannot be used with @1

-105

335544702

escape_invalid

Invalid ESCAPE sequence

-105

335544789

extract_input_mismatch

Specified EXTRACT part does not exist in input datatype

-105

335544884

invalid_similar_pattern

Invalid SIMILAR TO pattern

-150

335544360

read_only_rel

attempted update of read-only table

-150

335544362

read_only_view

cannot update read-only view @1

-150

335544446

non_updatable

not updatable

-150

335544546

constaint_on_view

Cannot define constraints on views

-151

335544359

read_only_field

attempted update of read-only column

-155

335544658

dsql_base_table

@1 is not a valid base table of the specified view

-157

335544598

specify_field_err

must specify column name for view select expression

-158

335544599

num_field_err

number of columns does not match select list

-162

335544685

no_dbkey

dbkey not available for multi-table views

-170

335544512

prcmismat

Input parameter mismatch for procedure @1

-170

335544619

extern_func_err

External functions cannot have more than 10 parameters

-170

335544850

prc_out_param_mismatch

Output parameter mismatch for procedure @1

-170

335545101

fun_param_mismatch

Input parameter mismatch for function @1

-171

335544439

funmismat

function @1 could not be matched

-171

335544458

invalid_dimension

column not array or invalid dimensions (expected @1, encountered @2)

-171

335544618

return_mode_err

Return mode by value not allowed for this data type

-171

335544873

array_max_dimensions

Array data type can use up to @1 dimensions

-172

335544438

funnotdef

function @1 is not defined

-172

335544932

modnotfound

module name or entrypoint could not be found

-203

335544708

dyn_fld_ambiguous

Ambiguous column reference.

-204

335544463

gennotdef

generator @1 is not defined

-204

335544502

stream_not_defined

reference to invalid stream number

-204

335544509

charset_not_found

CHARACTER SET @1 is not defined

-204

335544511

prcnotdef

procedure @1 is not defined

-204

335544515

codnotdef

status code @1 unknown

-204

335544516

xcpnotdef

exception @1 not defined

-204

335544532

ref_cnstrnt_notfound

Name of Referential Constraint not defined in constraints table.

-204

335544551

grant_obj_notfound

could not find object for GRANT

-204

335544568

text_subtype

Implementation of text subtype @1 not located.

-204

335544573

dsql_datatype_err

Data type unknown

-204

335544580

dsql_relation_err

Table unknown

-204

335544581

dsql_procedure_err

Procedure unknown

-204

335544588

collation_not_found

COLLATION @1 for CHARACTER SET @2 is not defined

-204

335544589

collation_not_for_charset

COLLATION @1 is not valid for specified CHARACTER SET

-204

335544595

dsql_trigger_err

Trigger unknown

-204

335544620

alias_conflict_err

alias @1 conflicts with an alias in the same statement

-204

335544621

procedure_conflict_error

alias @1 conflicts with a procedure in the same statement

-204

335544622

relation_conflict_err

alias @1 conflicts with a table in the same statement

-204

335544635

dsql_no_relation_alias

there is no alias or table named @1 at this scope level

-204

335544636

indexname

there is no index @1 for table @2

-204

335544640

collation_requires_text

Invalid use of CHARACTER SET or COLLATE

-204

335544662

dsql_blob_type_unknown

BLOB SUB_TYPE @1 is not defined

-204

335544759

bad_default_value

can not define a not null column with NULL as default value

-204

335544760

invalid_clause

invalid clause — ‘@1’

-204

335544800

too_many_contexts

Too many Contexts of Relation/Procedure/Views. Maximum allowed is 256

-204

335544817

bad_limit_param

Invalid parameter to FETCH or FIRST. Only integers >= 0 are allowed.

-204

335544818

bad_skip_param

Invalid parameter to OFFSET or SKIP. Only integers >= 0 are allowed.

-204

335544837

bad_substring_offset

Invalid offset parameter @1 to SUBSTRING. Only positive integers are allowed.

-204

335544853

bad_substring_length

Invalid length parameter @1 to SUBSTRING. Negative integers are not allowed.

-204

335544854

charset_not_installed

CHARACTER SET @1 is not installed

-204

335544855

collation_not_installed

COLLATION @1 for CHARACTER SET @2 is not installed

-204

335544867

subtype_for_internal_use

Blob sub_types bigger than 1 (text) are for internal use only

-204

335545104

invalid_attachment_charset

CHARACTER SET @1 cannot be used as a attachment character set

-204

336003085

dsql_ambiguous_field_name

Ambiguous field name between @1 and @2

-205

335544396

fldnotdef

column @1 is not defined in table @2

-205

335544552

grant_fld_notfound

could not find column for GRANT

-205

335544883

fldnotdef2

column @1 is not defined in procedure @2

-206

335544578

dsql_field_err

Column unknown

-206

335544587

dsql_blob_err

Column is not a BLOB

-206

335544596

dsql_subselect_err

Subselect illegal in this context

-206

336397208

dsql_line_col_error

At line @1, column @2

-206

336397209

dsql_unknown_pos

At unknown line and column

-206

336397210

dsql_no_dup_name

Column @1 cannot be repeated in @2 statement

-208

335544617

order_by_err

invalid ORDER BY clause

-219

335544395

relnotdef

table @1 is not defined

-219

335544872

domnotdef

domain @1 is not defined

-230

335544487

walw_err

WAL Writer error

-231

335544488

logh_small

Log file header of @1 too small

-232

335544489

logh_inv_version

Invalid version of log file @1

-233

335544490

logh_open_flag

Log file @1 not latest in the chain but open flag still set

-234

335544491

logh_open_flag2

Log file @1 not closed properly; database recovery may be required

-235

335544492

logh_diff_dbname

Database name in the log file @1 is different

-236

335544493

logf_unexpected_eof

Unexpected end of log file @1 at offset @2

-237

335544494

logr_incomplete

Incomplete log record at offset @1 in log file @2

-238

335544495

logr_header_small

Log record header too small at offset @1 in log file @2

-239

335544496

logb_small

Log block too small at offset @1 in log file @2

-239

335544691

cache_too_small

Insufficient memory to allocate page buffer cache

-239

335544693

log_too_small

Log size too small

-239

335544694

partition_too_small

Log partition size too small

-240

335544497

wal_illegal_attach

Illegal attempt to attach to an uninitialized WAL segment for @1

-241

335544498

wal_invalid_wpb

Invalid WAL parameter block option @1

-242

335544499

wal_err_rollover

Cannot roll over to the next log file @1

-243

335544500

no_wal

database does not use Write-ahead Log

-244

335544503

wal_subsys_error

WAL subsystem encountered error

-245

335544504

wal_subsys_corrupt

WAL subsystem corrupted

-246

335544513

wal_bugcheck

Database @1: WAL subsystem bug for pid @2
@3

-247

335544514

wal_cant_expand

Could not expand the WAL segment for database @1

-248

335544521

wal_err_rollover2

Unable to roll over please see Firebird log.

-249

335544522

wal_err_logwrite

WAL I/O error. Please see Firebird log.

-250

335544523

wal_err_jrn_comm

WAL writer — Journal server communication error. Please see Firebird log.

-251

335544524

wal_err_expansion

WAL buffers cannot be increased. Please see Firebird log.

-252

335544525

wal_err_setup

WAL setup error. Please see Firebird log.

-253

335544526

wal_err_ww_sync

obsolete

-254

335544527

wal_err_ww_start

Cannot start WAL writer for the database @1

-255

335544556

wal_cache_err

Write-ahead Log without shared cache configuration not allowed

-257

335544566

start_cm_for_wal

WAL defined; Cache Manager must be started first

-258

335544567

wal_ovflow_log_required

Overflow log specification required for round-robin log

-259

335544629

wal_shadow_err

Write-ahead Log with shadowing configuration not allowed

-260

335544690

cache_redef

Cache redefined

-260

335544692

log_redef

Log redefined

-261

335544695

partition_not_supp

Partitions not supported in series of log file specification

-261

335544696

log_length_spec

Total length of a partitioned log must be specified

-281

335544637

no_stream_plan

table @1 is not referenced in plan

-282

335544638

stream_twice

table @1 is referenced more than once in plan; use aliases to distinguish

-282

335544643

dsql_self_join

the table @1 is referenced twice; use aliases to differentiate

-282

335544659

duplicate_base_table

table @1 is referenced twice in view; use an alias to distinguish

-282

335544660

view_alias

view @1 has more than one base table; use aliases to distinguish

-282

335544710

complex_view

navigational stream @1 references a view with more than one base table

-283

335544639

stream_not_found

table @1 is referenced in the plan but not the from list

-284

335544642

index_unused

index @1 cannot be used in the specified plan

-291

335544531

primary_key_notnull

Column used in a PRIMARY constraint must be NOT NULL.

-291

335545103

domain_primary_key_notnull

Domain used in the PRIMARY KEY constraint of table @1 must be NOT NULL

-292

335544534

ref_cnstrnt_update

Cannot update constraints (RDB$REF_CONSTRAINTS).

-293

335544535

check_cnstrnt_update

Cannot update constraints (RDB$CHECK_CONSTRAINTS).

-294

335544536

check_cnstrnt_del

Cannot delete CHECK constraint entry (RDB$CHECK_CONSTRAINTS)

-295

335544545

rel_cnstrnt_update

Cannot update constraints (RDB$RELATION_CONSTRAINTS).

-296

335544547

invld_cnstrnt_type

internal Firebird consistency check (invalid RDB$CONSTRAINT_TYPE)

-297

335544558

check_constraint

Operation violates CHECK constraint @1 on view or table @2

-313

335544669

dsql_count_mismatch

count of column list and variable list do not match

-313

336003099

upd_ins_doesnt_match_pk

UPDATE OR INSERT field list does not match primary key of table @1

-313

336003100

upd_ins_doesnt_match_matching

UPDATE OR INSERT field list does not match MATCHING clause

-313

336003111

dsql_wrong_param_num

Wrong number of parameters (expected @1, got @2)

-314

335544565

transliteration_failed

Cannot transliterate character between character sets

-315

336068815

dyn_dtype_invalid

Cannot change datatype for column @1. Changing datatype is not supported for BLOB or ARRAY columns.

-383

336068814

dyn_dependency_exists

Column @1 from table @2 is referenced in @3

-401

335544647

invalid_operator

invalid comparison operator for find operation

-402

335544368

segstr_no_op

attempted invalid operation on a BLOB

-402

335544414

blobnotsup

BLOB and array data types are not supported for @1 operation

-402

335544427

datnotsup

data operation not supported

-406

335544457

out_of_bounds

subscript out of bounds

-406

335545028

ss_out_of_bounds

Subscript @1 out of bounds [@2, @3]

-407

335544435

nullsegkey

null segment of UNIQUE KEY

-413

335544334

convert_error

conversion error from string «@1»

-413

335544454

nofilter

filter not found to convert type @1 to type @2

-413

335544860

blob_convert_error

Unsupported conversion to target type BLOB (subtype @1)

-413

335544861

array_convert_error

Unsupported conversion to target type ARRAY

-501

335544577

dsql_cursor_close_err

Attempt to reclose a closed cursor

-502

335544574

dsql_decl_err

Invalid cursor declaration

-502

335544576

dsql_cursor_open_err

Attempt to reopen an open cursor

-502

336003090

dsql_cursor_redefined

Statement already has a cursor @1 assigned

-502

336003091

dsql_cursor_not_found

Cursor @1 is not found in the current context

-502

336003092

dsql_cursor_exists

Cursor @1 already exists in the current context

-502

336003093

dsql_cursor_rel_ambiguous

Relation @1 is ambiguous in cursor @2

-502

336003094

dsql_cursor_rel_not_found

Relation @1 is not found in cursor @2

-502

336003095

dsql_cursor_not_open

Cursor is not open

-504

335544572

dsql_cursor_err

Invalid cursor reference

-504

336003089

dsql_cursor_invalid

Empty cursor name is not allowed

-508

335544348

no_cur_rec

no current record for fetch operation

-510

335544575

dsql_cursor_update_err

Cursor @1 is not updatable

-518

335544582

dsql_request_err

Request unknown

-519

335544688

dsql_open_cursor_request

The prepare statement identifies a prepare statement with an open cursor

-530

335544466

foreign_key

violation of FOREIGN KEY constraint «@1» on table «@2»

-530

335544838

foreign_key_target_doesnt_exist

Foreign key reference target does not exist

-530

335544839

foreign_key_references_present

Foreign key references are present for the record

-531

335544597

dsql_crdb_prepare_err

Cannot prepare a CREATE DATABASE/SCHEMA statement

-532

335544469

trans_invalid

transaction marked invalid and cannot be committed

-532

335545002

attachment_in_use

Attachment is in use

-532

335545003

transaction_in_use

Transaction is in use

-532

335545017

async_active

Asynchronous call is already running for this attachment

-551

335544352

no_priv

no permission for @1 access to @2 @3

-551

335544790

insufficient_svc_privileges

Service @1 requires SYSDBA permissions. Reattach to the Service Manager using the SYSDBA account.

-551

335545033

trunc_limits

expected length @1, actual @2

-551

335545034

info_access

Wrong info requested in isc_svc_query() for anonymous service

-551

335545036

svc_start_failed

Start request for anonymous service is impossible

-552

335544550

not_rel_owner

only the owner of a table may reassign ownership

-552

335544553

grant_nopriv

user does not have GRANT privileges for operation

-552

335544707

grant_nopriv_on_base

user does not have GRANT privileges on base table/view for operation

-552

335545058

protect_ownership

Only the owner can change the ownership

-553

335544529

existing_priv_mod

cannot modify an existing user privilege

-595

335544645

stream_crack

the current position is on a crack

-596

335544374

stream_eof

attempt to fetch past the last record in a record stream

-596

335544644

stream_bof

attempt to fetch before the first record in a record stream

-596

335545092

cursor_not_positioned

Cursor @1 is not positioned in a valid record

-597

335544632

dsql_file_length_err

Preceding file did not specify length, so @1 must include starting page number

-598

335544633

dsql_shadow_number_err

Shadow number must be a positive integer

-599

335544607

node_err

gen.c: node not supported

-599

335544625

node_name_err

A node name is not permitted in a secondary, shadow, cache or log file name

-600

335544680

crrp_data_err

sort error: corruption in data structure

-601

335544646

db_or_file_exists

database or file exists

-604

335544593

dsql_max_arr_dim_exceeded

Array declared with too many dimensions

-604

335544594

dsql_arr_range_error

Illegal array dimension range

-605

335544682

dsql_field_ref

Inappropriate self-reference of column

-607

335544351

no_meta_update

unsuccessful metadata update

-607

335544549

systrig_update

cannot modify or erase a system trigger

-607

335544657

dsql_no_blob_array

Array/BLOB/DATE data types not allowed in arithmetic

-607

335544746

reftable_requires_pk

«REFERENCES table» without «(column)» requires PRIMARY KEY on referenced table

-607

335544815

generator_name

GENERATOR @1

-607

335544816

udf_name

Function @1

-607

335544858

must_have_phys_field

Can’t have relation with only computed fields or constraints

-607

336003074

dsql_dbkey_from_non_table

Cannot SELECT RDB$DB_KEY from a stored procedure.

-607

336003086

dsql_udf_return_pos_err

External function should have return position between 1 and @1

-607

336003096

dsql_type_not_supp_ext_tab

Data type @1 is not supported for EXTERNAL TABLES. Relation ‘@2’, field ‘@3’

-607

336003104

dsql_record_version_table

To be used with RDB$RECORD_VERSION, @1 must be a table or a view of single table

-607

336068845

dyn_cannot_del_syscoll

Cannot delete system collation

-607

336068866

dyn_cannot_mod_sysproc

Cannot ALTER or DROP system procedure @1

-607

336068867

dyn_cannot_mod_systrig

Cannot ALTER or DROP system trigger @1

-607

336068868

dyn_cannot_mod_sysfunc

Cannot ALTER or DROP system function @1

-607

336068869

dyn_invalid_ddl_proc

Invalid DDL statement for procedure @1

-607

336068870

dyn_invalid_ddl_trig

Invalid DDL statement for trigger @1

-607

336068878

dyn_invalid_ddl_func

Invalid DDL statement for function @1

-607

336397206

dsql_table_not_found

Table @1 does not exist

-607

336397207

dsql_view_not_found

View @1 does not exist

-607

336397212

dsql_no_array_computed

Array and BLOB data types not allowed in computed field

-607

336397214

dsql_only_can_subscript_array

scalar operator used on field @1 which is not an array

-612

336068812

dyn_domain_name_exists

Cannot rename domain @1 to @2. A domain with that name already exists.

-612

336068813

dyn_field_name_exists

Cannot rename column @1 to @2. A column with that name already exists in table @3.

-615

335544475

relation_lock

lock on table @1 conflicts with existing lock

-615

335544476

record_lock

requested record lock conflicts with existing lock

-615

335544501

drop_wal

cannot drop log file when journaling is enabled

-615

335544507

range_in_use

refresh range number @1 already in use

-616

335544530

primary_key_ref

Cannot delete PRIMARY KEY being used in FOREIGN KEY definition.

-616

335544539

integ_index_del

Cannot delete index used by an Integrity Constraint

-616

335544540

integ_index_mod

Cannot modify index used by an Integrity Constraint

-616

335544541

check_trig_del

Cannot delete trigger used by a CHECK Constraint

-616

335544543

cnstrnt_fld_del

Cannot delete column being used in an Integrity Constraint.

-616

335544630

dependency

there are @1 dependencies

-616

335544674

del_last_field

last column in a table cannot be deleted

-616

335544728

integ_index_deactivate

Cannot deactivate index used by an integrity constraint

-616

335544729

integ_deactivate_primary

Cannot deactivate index used by a PRIMARY/UNIQUE constraint

-617

335544542

check_trig_update

Cannot update trigger used by a CHECK Constraint

-617

335544544

cnstrnt_fld_rename

Cannot rename column being used in an Integrity Constraint.

-618

335544537

integ_index_seg_del

Cannot delete index segment used by an Integrity Constraint

-618

335544538

integ_index_seg_mod

Cannot update index segment used by an Integrity Constraint

-625

335544347

not_valid

validation error for column @1, value «@2»

-625

335544879

not_valid_for_var

validation error for variable @1, value «@2»

-625

335544880

not_valid_for

validation error for @1, value «@2»

-637

335544664

dsql_duplicate_spec

duplicate specification of @1 — not supported

-637

336397213

dsql_implicit_domain_name

Implicit domain name @1 not allowed in user created domain

-660

335544533

foreign_key_notfound

Non-existent PRIMARY or UNIQUE KEY specified for FOREIGN KEY.

-660

335544628

idx_create_err

cannot create index @1

-660

336003098

primary_key_required

Primary key required on table @1

-663

335544624

idx_seg_err

segment count of 0 defined for index @1

-663

335544631

idx_key_err

too many keys defined for index @1

-663

335544672

key_field_err

too few key columns found for index @1 (incorrect column name?)

-664

335544434

keytoobig

key size exceeds implementation restriction for index «@1»

-677

335544445

ext_err

@1 extension error

-685

335544465

bad_segstr_type

invalid BLOB type for operation

-685

335544670

blob_idx_err

attempt to index BLOB column in index @1

-685

335544671

array_idx_err

attempt to index array column in index @1

-689

335544403

badpagtyp

page @1 is of wrong type (expected @2, found @3)

-689

335544650

page_type_err

wrong page type

-690

335544679

no_segments_err

segments not allowed in expression index @1

-691

335544681

rec_size_err

new record size of @1 bytes is too big

-692

335544477

max_idx

maximum indexes per table (@1) exceeded

-693

335544663

req_max_clones_exceeded

Too many concurrent executions of the same request

-694

335544684

no_field_access

cannot access column @1 in view @2

-802

335544321

arith_except

arithmetic exception, numeric overflow, or string truncation

-802

335544836

concat_overflow

Concatenation overflow. Resulting string cannot exceed 32765 bytes in length.

-802

335544914

string_truncation

string right truncation

-802

335544915

blob_truncation

blob truncation when converting to a string: length limit exceeded

-802

335544916

numeric_out_of_range

numeric value is out of range

-802

336003105

dsql_invalid_sqlda_version

SQLDA version expected between @1 and @2, found @3

-802

336003106

dsql_sqlvar_index

at SQLVAR index @1

-802

336003107

dsql_no_sqlind

empty pointer to NULL indicator variable

-802

336003108

dsql_no_sqldata

empty pointer to data

-802

336003109

dsql_no_input_sqlda

No SQLDA for input values provided

-802

336003110

dsql_no_output_sqlda

No SQLDA for output values provided

-803

335544349

no_dup

attempt to store duplicate value (visible to active transactions) in unique index «@1»

-803

335544665

unique_key_violation

violation of PRIMARY or UNIQUE KEY constraint «@1» on table «@2»

-804

335544380

wronumarg

wrong number of arguments on call

-804

335544583

dsql_sqlda_err

SQLDA error

-804

335544584

dsql_var_count_err

Count of read-write columns does not equal count of values

-804

335544586

dsql_function_err

Function unknown

-804

335544713

dsql_sqlda_value_err

Incorrect values within SQLDA structure

-804

335545050

wrong_message_length

Message length passed from user application does not match set of columns

-804

335545051

no_output_format

Resultset is missing output format information

-804

335545052

item_finish

Message metadata not ready — item @1 is not finished

-804

335545100

interface_version_too_old

Interface @3 version too old: expected @1, found @2

-804

336003097

dsql_feature_not_supported_ods

Feature not supported on ODS version older than @[email protected]

-804

336397205

dsql_too_old_ods

ODS versions before [email protected] are not supported

-806

335544600

col_name_err

Only simple column names permitted for VIEW WITH CHECK OPTION

-807

335544601

where_err

No WHERE clause for VIEW WITH CHECK OPTION

-808

335544602

table_view_err

Only one table allowed for VIEW WITH CHECK OPTION

-809

335544603

distinct_err

DISTINCT, GROUP or HAVING not permitted for VIEW WITH CHECK OPTION

-810

335544605

subquery_err

No subqueries permitted for VIEW WITH CHECK OPTION

-811

335544652

sing_select_err

multiple rows in singleton select

-816

335544651

ext_readonly_err

Cannot insert because the file is readonly or is on a read only medium.

-816

335544715

extfile_uns_op

Operation not supported for EXTERNAL FILE table @1

-817

335544361

read_only_trans

attempted update during read-only transaction

-817

335544371

segstr_no_write

attempted write to read-only BLOB

-817

335544444

read_only

operation not supported

-817

335544765

read_only_database

attempted update on read-only database

-817

335544766

must_be_dialect_2_and_up

SQL dialect @1 is not supported in this database

-817

335544793

ddl_not_allowed_by_db_sql_dial

Metadata update statement is not allowed by the current database SQL dialect @1

-817

336003079

sql_dialect_conflict_num

DB dialect @1 and client dialect @2 conflict with respect to numeric precision @3.

-817

336003101

upd_ins_with_complex_view

UPDATE OR INSERT without MATCHING could not be used with views based on more than one table

-817

336003102

dsql_incompatible_trigger_type

Incompatible trigger type

-817

336003103

dsql_db_trigger_type_cant_change

Database trigger type can’t be changed

-820

335544356

obsolete_metadata

metadata is obsolete

-820

335544379

wrong_ods

unsupported on-disk structure for file @1; found @[email protected], support @[email protected]

-820

335544437

wrodynver

wrong DYN version

-820

335544467

high_minor

minor version too high found @1 expected @2

-820

335544881

need_difference

Difference file name should be set explicitly for database on raw device

-823

335544473

invalid_bookmark

invalid bookmark handle

-824

335544474

bad_lock_level

invalid lock level @1

-825

335544519

bad_lock_handle

invalid lock handle

-826

335544585

dsql_stmt_handle

Invalid statement handle

-827

335544655

invalid_direction

invalid direction for find operation

-827

335544718

invalid_key

Invalid key for find operation

-828

335544678

inval_key_posn

invalid key position

-829

335544616

field_ref_err

invalid column reference

-829

336068816

dyn_char_fld_too_small

New size specified for column @1 must be at least @2 characters.

-829

336068817

dyn_invalid_dtype_conversion

Cannot change datatype for @1. Conversion from base type @2 to @3 is not supported.

-829

336068818

dyn_dtype_conv_invalid

Cannot change datatype for column @1 from a character type to a non-character type.

-829

336068829

max_coll_per_charset

Maximum number of collations per character set exceeded

-829

336068830

invalid_coll_attr

Invalid collation attributes

-829

336068852

dyn_scale_too_big

New scale specified for column @1 must be at most @2.

-829

336068853

dyn_precision_too_small

New precision specified for column @1 must be at least @2.

-829

336068857

dyn_cannot_addrem_computed

Cannot add or remove COMPUTED from column @1

-830

335544615

field_aggregate_err

column used with aggregate

-831

335544548

primary_key_exists

Attempt to define a second PRIMARY KEY for the same table

-832

335544604

key_field_count_err

FOREIGN KEY column count does not match PRIMARY KEY

-833

335544606

expression_eval_err

expression evaluation not supported

-833

335544810

date_range_exceeded

value exceeds the range for valid dates

-833

335544912

time_range_exceeded

value exceeds the range for a valid time

-833

335544913

datetime_range_exceeded

value exceeds the range for valid timestamps

-833

335544937

invalid_type_datetime_op

Invalid data type in DATE/TIME/TIMESTAMP addition or subtraction in add_datettime()

-833

335544938

onlycan_add_timetodate

Only a TIME value can be added to a DATE value

-833

335544939

onlycan_add_datetotime

Only a DATE value can be added to a TIME value

-833

335544940

onlycansub_tstampfromtstamp

TIMESTAMP values can be subtracted only from another TIMESTAMP value

-833

335544941

onlyoneop_mustbe_tstamp

Only one operand can be of type TIMESTAMP

-833

335544942

invalid_extractpart_time

Only HOUR, MINUTE, SECOND and MILLISECOND can be extracted from TIME values

-833

335544943

invalid_extractpart_date

HOUR, MINUTE, SECOND and MILLISECOND cannot be extracted from DATE values

-833

335544944

invalidarg_extract

Invalid argument for EXTRACT() not being of DATE/TIME/TIMESTAMP type

-833

335544945

sysf_argmustbe_exact

Arguments for @1 must be integral types or NUMERIC/DECIMAL without scale

-833

335544946

sysf_argmustbe_exact_or_fp

First argument for @1 must be integral type or floating point type

-833

335544947

sysf_argviolates_uuidtype

Human readable UUID argument for @1 must be of string type

-833

335544948

sysf_argviolates_uuidlen

Human readable UUID argument for @2 must be of exact length @1

-833

335544949

sysf_argviolates_uuidfmt

Human readable UUID argument for @3 must have «-» at position @2 instead of «@1»

-833

335544950

sysf_argviolates_guidigits

Human readable UUID argument for @3 must have hex digit at position @2 instead of «@1»

-833

335544951

sysf_invalid_addpart_time

Only HOUR, MINUTE, SECOND and MILLISECOND can be added to TIME values in @1

-833

335544952

sysf_invalid_add_datetime

Invalid data type in addition of part to DATE/TIME/TIMESTAMP in @1

-833

335544953

sysf_invalid_addpart_dtime

Invalid part @1 to be added to a DATE/TIME/TIMESTAMP value in @2

-833

335544954

sysf_invalid_add_dtime_rc

Expected DATE/TIME/TIMESTAMP type in evlDateAdd() result

-833

335544955

sysf_invalid_diff_dtime

Expected DATE/TIME/TIMESTAMP type as first and second argument to @1

-833

335544956

sysf_invalid_timediff

The result of TIME-<value> in @1 cannot be expressed in YEAR, MONTH, DAY or WEEK

-833

335544957

sysf_invalid_tstamptimediff

The result of TIME-TIMESTAMP or TIMESTAMP-TIME in @1 cannot be expressed in HOUR, MINUTE, SECOND or MILLISECOND

-833

335544958

sysf_invalid_datetimediff

The result of DATE-TIME or TIME-DATE in @1 cannot be expressed in HOUR, MINUTE, SECOND and MILLISECOND

-833

335544959

sysf_invalid_diffpart

Invalid part @1 to express the difference between two DATE/TIME/TIMESTAMP values in @2

-833

335544960

sysf_argmustbe_positive

Argument for @1 must be positive

-833

335544961

sysf_basemustbe_positive

Base for @1 must be positive

-833

335544962

sysf_argnmustbe_nonneg

Argument #@1 for @2 must be zero or positive

-833

335544963

sysf_argnmustbe_positive

Argument #@1 for @2 must be positive

-833

335544964

sysf_invalid_zeropowneg

Base for @1 cannot be zero if exponent is negative

-833

335544965

sysf_invalid_negpowfp

Base for @1 cannot be negative if exponent is not an integral value

-833

335544966

sysf_invalid_scale

The numeric scale must be between -128 and 127 in @1

-833

335544967

sysf_argmustbe_nonneg

Argument for @1 must be zero or positive

-833

335544968

sysf_binuuid_mustbe_str

Binary UUID argument for @1 must be of string type

-833

335544969

sysf_binuuid_wrongsize

Binary UUID argument for @2 must use @1 bytes

-833

335544976

sysf_argmustbe_nonzero

Argument for @1 must be different than zero

-833

335544977

sysf_argmustbe_range_inc1_1

Argument for @1 must be in the range [-1, 1]

-833

335544978

sysf_argmustbe_gteq_one

Argument for @1 must be greater or equal than one

-833

335544979

sysf_argmustbe_range_exc1_1

Argument for @1 must be in the range ]-1, 1[

-833

335544981

sysf_fp_overflow

Floating point overflow in built-in function @1

-833

335545009

sysf_invalid_trig_namespace

Invalid usage of context namespace DDL_TRIGGER

-833

335545024

sysf_argscant_both_be_zero

Arguments for @1 cannot both be zero

-833

335545046

max_args_exceeded

Maximum (@1) number of arguments exceeded for function @2

-833

336397240

dsql_eval_unknode

Unknown node type @1 in dsql/GEN_expr

-833

336397241

dsql_agg_wrongarg

Argument for @1 in dialect 1 must be string or numeric

-833

336397242

dsql_agg2_wrongarg

Argument for @1 in dialect 3 must be numeric

-833

336397243

dsql_nodateortime_pm_string

Strings cannot be added to or subtracted from DATE or TIME types

-833

336397244

dsql_invalid_datetime_subtract

Invalid data type for subtraction involving DATE, TIME or TIMESTAMP types

-833

336397245

dsql_invalid_dateortime_add

Adding two DATE values or two TIME values is not allowed

-833

336397246

dsql_invalid_type_minus_date

DATE value cannot be subtracted from the provided data type

-833

336397247

dsql_nostring_addsub_dial3

Strings cannot be added or subtracted in dialect 3

-833

336397248

dsql_invalid_type_addsub_dial3

Invalid data type for addition or subtraction in dialect 3

-833

336397249

dsql_invalid_type_multip_dial1

Invalid data type for multiplication in dialect 1

-833

336397250

dsql_nostring_multip_dial3

Strings cannot be multiplied in dialect 3

-833

336397251

dsql_invalid_type_multip_dial3

Invalid data type for multiplication in dialect 3

-833

336397252

dsql_mustuse_numeric_div_dial1

Division in dialect 1 must be between numeric data types

-833

336397253

dsql_nostring_div_dial3

Strings cannot be divided in dialect 3

-833

336397254

dsql_invalid_type_div_dial3

Invalid data type for division in dialect 3

-833

336397255

dsql_nostring_neg_dial3

Strings cannot be negated (applied the minus operator) in dialect 3

-833

336397256

dsql_invalid_type_neg

Invalid data type for negation (minus operator)

-834

335544508

range_not_found

refresh range number @1 not found

-835

335544649

bad_checksum

bad checksum

-836

335544517

except

exception @1

-836

335544848

except2

exception @1

-836

335545016

formatted_exception

-837

335544518

cache_restart

restart shared cache manager

-838

335544560

shutwarn

database @1 shutdown in @2 seconds

-839

335544686

jrn_format_err

journal file wrong format

-840

335544687

jrn_file_full

intermediate journal file full

-841

335544677

version_err

too many versions

-842

335544697

precision_err

Precision must be from 1 to 18

-842

335544698

scale_nogt

Scale must be between zero and precision

-842

335544699

expec_short

Short integer expected

-842

335544700

expec_long

Long integer expected

-842

335544701

expec_ushort

Unsigned short integer expected

-842

335544712

expec_positive

Positive value expected

-901

335544322

bad_dbkey

invalid database key

-901

335544326

bad_dpb_form

unrecognized database parameter block

-901

335544327

bad_req_handle

invalid request handle

-901

335544328

bad_segstr_handle

invalid BLOB handle

-901

335544329

bad_segstr_id

invalid BLOB ID

-901

335544330

bad_tpb_content

invalid parameter in transaction parameter block

-901

335544331

bad_tpb_form

invalid format for transaction parameter block

-901

335544332

bad_trans_handle

invalid transaction handle (expecting explicit transaction start)

-901

335544337

excess_trans

attempt to start more than @1 transactions

-901

335544339

infinap

information type inappropriate for object specified

-901

335544340

infona

no information of this type available for object specified

-901

335544341

infunk

unknown information item

-901

335544342

integ_fail

action cancelled by trigger (@1) to preserve data integrity

-901

335544345

lock_conflict

lock conflict on no wait transaction

-901

335544350

no_finish

program attempted to exit without finishing database

-901

335544353

no_recon

transaction is not in limbo

-901

335544355

no_segstr_close

BLOB was not closed

-901

335544357

open_trans

cannot disconnect database with open transactions (@1 active)

-901

335544358

port_len

message length error (encountered @1, expected @2)

-901

335544363

req_no_trans

no transaction for request

-901

335544364

req_sync

request synchronization error

-901

335544365

req_wrong_db

request referenced an unavailable database

-901

335544369

segstr_no_read

attempted read of a new, open BLOB

-901

335544370

segstr_no_trans

attempted action on BLOB outside transaction

-901

335544372

segstr_wrong_db

attempted reference to BLOB in unavailable database

-901

335544376

unres_rel

table @1 was omitted from the transaction reserving list

-901

335544377

uns_ext

request includes a DSRI extension not supported in this implementation

-901

335544378

wish_list

feature is not supported

-901

335544382

random

-901

335544383

fatal_conflict

unrecoverable conflict with limbo transaction @1

-901

335544392

bdbincon

internal error

-901

335544407

dbbnotzer

database handle not zero

-901

335544408

tranotzer

transaction handle not zero

-901

335544418

trainlim

transaction in limbo

-901

335544419

notinlim

transaction not in limbo

-901

335544420

traoutsta

transaction outstanding

-901

335544428

badmsgnum

undefined message number

-901

335544431

blocking_signal

blocking signal has been received

-901

335544442

noargacc_read

database system cannot read argument @1

-901

335544443

noargacc_write

database system cannot write argument @1

-901

335544450

misc_interpreted

-901

335544468

tra_state

transaction @1 is @2

-901

335544485

bad_stmt_handle

invalid statement handle

-901

335544510

lock_timeout

lock time-out on wait transaction

-901

335544559

bad_svc_handle

invalid service handle

-901

335544561

wrospbver

wrong version of service parameter block

-901

335544562

bad_spb_form

unrecognized service parameter block

-901

335544563

svcnotdef

service @1 is not defined

-901

335544609

index_name

INDEX @1

-901

335544610

exception_name

EXCEPTION @1

-901

335544611

field_name

COLUMN @1

-901

335544613

union_err

union not supported

-901

335544614

dsql_construct_err

Unsupported DSQL construct

-901

335544623

dsql_domain_err

Illegal use of keyword VALUE

-901

335544626

table_name

TABLE @1

-901

335544627

proc_name

PROCEDURE @1

-901

335544641

dsql_domain_not_found

Specified domain or source column @1 does not exist

-901

335544656

dsql_var_conflict

variable @1 conflicts with parameter in same procedure

-901

335544666

srvr_version_too_old

server version too old to support all CREATE DATABASE options

-901

335544673

no_delete

cannot delete

-901

335544675

sort_err

sort error

-901

335544703

svcnoexe

service @1 does not have an associated executable

-901

335544704

net_lookup_err

Failed to locate host machine.

-901

335544705

service_unknown

Undefined service @1/@2.

-901

335544706

host_unknown

The specified name was not found in the hosts file or Domain Name Services.

-901

335544711

unprepared_stmt

Attempt to execute an unprepared dynamic SQL statement.

-901

335544716

svc_in_use

Service is currently busy: @1

-901

335544719

net_init_error

Error initializing the network software.

-901

335544720

loadlib_failure

Unable to load required library @1.

-901

335544731

tra_must_sweep

-901

335544740

udf_exception

A fatal exception occurred during the execution of a user defined function.

-901

335544741

lost_db_connection

connection lost to database

-901

335544742

no_write_user_priv

User cannot write to RDB$USER_PRIVILEGES

-901

335544767

blob_filter_exception

A fatal exception occurred during the execution of a blob filter.

-901

335544768

exception_access_violation

Access violation. The code attempted to access a virtual address without privilege to do so.

-901

335544769

exception_datatype_missalignment

Datatype misalignment. The attempted to read or write a value that was not stored on a memory boundary.

-901

335544770

exception_array_bounds_exceeded

Array bounds exceeded. The code attempted to access an array element that is out of bounds.

-901

335544771

exception_float_denormal_operand

Float denormal operand. One of the floating-point operands is too small to represent a standard float value.

-901

335544772

exception_float_divide_by_zero

Floating-point divide by zero. The code attempted to divide a floating-point value by zero.

-901

335544773

exception_float_inexact_result

Floating-point inexact result. The result of a floating-point operation cannot be represented as a deciaml fraction.

-901

335544774

exception_float_invalid_operand

Floating-point invalid operand. An indeterminant error occurred during a floating-point operation.

-901

335544775

exception_float_overflow

Floating-point overflow. The exponent of a floating-point operation is greater than the magnitude allowed.

-901

335544776

exception_float_stack_check

Floating-point stack check. The stack overflowed or underflowed as the result of a floating-point operation.

-901

335544777

exception_float_underflow

Floating-point underflow. The exponent of a floating-point operation is less than the magnitude allowed.

-901

335544778

exception_integer_divide_by_zero

Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero.

-901

335544779

exception_integer_overflow

Integer overflow. The result of an integer operation caused the most significant bit of the result to carry.

-901

335544780

exception_unknown

An exception occurred that does not have a description. Exception number @1.

-901

335544781

exception_stack_overflow

Stack overflow. The resource requirements of the runtime stack have exceeded the memory available to it.

-901

335544782

exception_sigsegv

Segmentation Fault. The code attempted to access memory without privileges.

-901

335544783

exception_sigill

Illegal Instruction. The Code attempted to perfrom an illegal operation.

-901

335544784

exception_sigbus

Bus Error. The Code caused a system bus error.

-901

335544785

exception_sigfpe

Floating Point Error. The Code caused an Arithmetic Exception or a floating point exception.

-901

335544786

ext_file_delete

Cannot delete rows from external files.

-901

335544787

ext_file_modify

Cannot update rows in external files.

-901

335544788

adm_task_denied

Unable to perform operation. You must be either SYSDBA or owner of the database

-901

335544794

cancelled

operation was cancelled

-901

335544797

svcnouser

user name and password are required while attaching to the services manager

-901

335544801

datype_notsup

data type not supported for arithmetic

-901

335544803

dialect_not_changed

Database dialect not changed.

-901

335544804

database_create_failed

Unable to create database @1

-901

335544805

inv_dialect_specified

Database dialect @1 is not a valid dialect.

-901

335544806

valid_db_dialects

Valid database dialects are @1.

-901

335544811

inv_client_dialect_specified

passed client dialect @1 is not a valid dialect.

-901

335544812

valid_client_dialects

Valid client dialects are @1.

-901

335544814

service_not_supported

Services functionality will be supported in a later version of the product

-901

335544820

invalid_savepoint

Unable to find savepoint with name @1 in transaction context

-901

335544835

bad_shutdown_mode

Target shutdown mode is invalid for database «@1»

-901

335544840

no_update

cannot update

-901

335544842

stack_trace

-901

335544843

ctx_var_not_found

Context variable @1 is not found in namespace @2

-901

335544844

ctx_namespace_invalid

Invalid namespace name @1 passed to @2

-901

335544845

ctx_too_big

Too many context variables

-901

335544846

ctx_bad_argument

Invalid argument passed to @1

-901

335544847

identifier_too_long

BLR syntax error. Identifier @1… is too long

-901

335544859

invalid_time_precision

Time precision exceeds allowed range ([email protected])

-901

335544866

met_wrong_gtt_scope

@1 cannot depend on @2

-901

335544868

illegal_prc_type

Procedure @1 is not selectable (it does not contain a SUSPEND statement)

-901

335544869

invalid_sort_datatype

Datatype @1 is not supported for sorting operation

-901

335544870

collation_name

COLLATION @1

-901

335544871

domain_name

DOMAIN @1

-901

335544874

max_db_per_trans_allowed

A multi database transaction cannot span more than @1 databases

-901

335544876

bad_proc_BLR

Error while parsing procedure @1’s BLR

-901

335544877

key_too_big

index key too big

-901

335544885

bad_teb_form

Invalid TEB format

-901

335544886

tpb_multiple_txn_isolation

Found more than one transaction isolation in TPB

-901

335544887

tpb_reserv_before_table

Table reservation lock type @1 requires table name before in TPB

-901

335544888

tpb_multiple_spec

Found more than one @1 specification in TPB

-901

335544889

tpb_option_without_rc

Option @1 requires READ COMMITTED isolation in TPB

-901

335544890

tpb_conflicting_options

Option @1 is not valid if @2 was used previously in TPB

-901

335544891

tpb_reserv_missing_tlen

Table name length missing after table reservation @1 in TPB

-901

335544892

tpb_reserv_long_tlen

Table name length @1 is too long after table reservation @2 in TPB

-901

335544893

tpb_reserv_missing_tname

Table name length @1 without table name after table reservation @2 in TPB

-901

335544894

tpb_reserv_corrup_tlen

Table name length @1 goes beyond the remaining TPB size after table reservation @2

-901

335544895

tpb_reserv_null_tlen

Table name length is zero after table reservation @1 in TPB

-901

335544896

tpb_reserv_relnotfound

Table or view @1 not defined in system tables after table reservation @2 in TPB

-901

335544897

tpb_reserv_baserelnotfound

Base table or view @1 for view @2 not defined in system tables after table reservation @3 in TPB

-901

335544898

tpb_missing_len

Option length missing after option @1 in TPB

-901

335544899

tpb_missing_value

Option length @1 without value after option @2 in TPB

-901

335544900

tpb_corrupt_len

Option length @1 goes beyond the remaining TPB size after option @2

-901

335544901

tpb_null_len

Option length is zero after table reservation @1 in TPB

-901

335544902

tpb_overflow_len

Option length @1 exceeds the range for option @2 in TPB

-901

335544903

tpb_invalid_value

Option value @1 is invalid for the option @2 in TPB

-901

335544904

tpb_reserv_stronger_wng

Preserving previous table reservation @1 for table @2, stronger than new @3 in TPB

-901

335544905

tpb_reserv_stronger

Table reservation @1 for table @2 already specified and is stronger than new @3 in TPB

-901

335544906

tpb_reserv_max_recursion

Table reservation reached maximum recursion of @1 when expanding views in TPB

-901

335544907

tpb_reserv_virtualtbl

Table reservation in TPB cannot be applied to @1 because it’s a virtual table

-901

335544908

tpb_reserv_systbl

Table reservation in TPB cannot be applied to @1 because it’s a system table

-901

335544909

tpb_reserv_temptbl

Table reservation @1 or @2 in TPB cannot be applied to @3 because it’s a temporary table

-901

335544910

tpb_readtxn_after_writelock

Cannot set the transaction in read only mode after a table reservation isc_tpb_lock_write in TPB

-901

335544911

tpb_writelock_after_readtxn

Cannot take a table reservation isc_tpb_lock_write in TPB because the transaction is in read only mode

-901

335544917

shutdown_timeout

Firebird shutdown is still in progress after the specified timeout

-901

335544918

att_handle_busy

Attachment handle is busy

-901

335544919

bad_udf_freeit

Bad written UDF detected: pointer returned in FREE_IT function was not allocated by ib_util_malloc

-901

335544920

eds_provider_not_found

External Data Source provider ‘@1’ not found

-901

335544921

eds_connection

Execute statement error at @1 :
@2Data source : @3

-901

335544922

eds_preprocess

Execute statement preprocess SQL error

-901

335544923

eds_stmt_expected

Statement expected

-901

335544924

eds_prm_name_expected

Parameter name expected

-901

335544925

eds_unclosed_comment

Unclosed comment found near ‘@1’

-901

335544926

eds_statement

Execute statement error at @1 :
@2Statement : @3
Data source : @4

-901

335544927

eds_input_prm_mismatch

Input parameters mismatch

-901

335544928

eds_output_prm_mismatch

Output parameters mismatch

-901

335544929

eds_input_prm_not_set

Input parameter ‘@1’ have no value set

-901

335544933

nothing_to_cancel

nothing to cancel

-901

335544934

ibutil_not_loaded

ib_util library has not been loaded to deallocate memory returned by FREE_IT function

-901

335544973

bad_epb_form

Unrecognized events block

-901

335544982

udf_fp_overflow

Floating point overflow in result from UDF @1

-901

335544983

udf_fp_nan

Invalid floating point value returned by UDF @1

-901

335544985

out_of_temp_space

No free space found in temporary directories

-901

335544986

eds_expl_tran_ctrl

Explicit transaction control is not allowed

-901

335544988

package_name

PACKAGE @1

-901

335544989

cannot_make_not_null

Cannot make field @1 of table @2 NOT NULL because there are NULLs present

-901

335544990

feature_removed

Feature @1 is not supported anymore

-901

335544991

view_name

VIEW @1

-901

335544993

invalid_fetch_option

Fetch option @1 is invalid for a non-scrollable cursor

-901

335544994

bad_fun_BLR

Error while parsing function @1’s BLR

-901

335544995

func_pack_not_implemented

Cannot execute function @1 of the unimplemented package @2

-901

335544996

proc_pack_not_implemented

Cannot execute procedure @1 of the unimplemented package @2

-901

335544997

eem_func_not_returned

External function @1 not returned by the external engine plugin @2

-901

335544998

eem_proc_not_returned

External procedure @1 not returned by the external engine plugin @2

-901

335544999

eem_trig_not_returned

External trigger @1 not returned by the external engine plugin @2

-901

335545000

eem_bad_plugin_ver

Incompatible plugin version @1 for external engine @2

-901

335545001

eem_engine_notfound

External engine @1 not found

-901

335545004

pman_cannot_load_plugin

Error loading plugin @1

-901

335545005

pman_module_notfound

Loadable module @1 not found

-901

335545006

pman_entrypoint_notfound

Standard plugin entrypoint does not exist in module @1

-901

335545007

pman_module_bad

Module @1 exists but can not be loaded

-901

335545008

pman_plugin_notfound

Module @1 does not contain plugin @2 type @3

-901

335545010

unexpected_null

Value is NULL but isNull parameter was not informed

-901

335545011

type_notcompat_blob

Type @1 is incompatible with BLOB

-901

335545012

invalid_date_val

Invalid date

-901

335545013

invalid_time_val

Invalid time

-901

335545014

invalid_timestamp_val

Invalid timestamp

-901

335545015

invalid_index_val

Invalid index @1 in function @2

-901

335545018

private_function

Function @1 is private to package @2

-901

335545019

private_procedure

Procedure @1 is private to package @2

-901

335545021

bad_events_handle

invalid events id (handle)

-901

335545025

spb_no_id

missing service ID in spb

-901

335545026

ee_blr_mismatch_null

External BLR message mismatch: invalid null descriptor at field @1

-901

335545027

ee_blr_mismatch_length

External BLR message mismatch: length = @1, expected @2

-901

335545031

libtommath_generic

Libtommath error code @1 in function @2

-901

335545041

cp_process_active

Crypt failed — already crypting database

-901

335545042

cp_already_crypted

Crypt failed — database is already in requested state

-901

335545047

ee_blr_mismatch_names_count

External BLR message mismatch: names count = @1, blr count = @2

-901

335545048

ee_blr_mismatch_name_not_found

External BLR message mismatch: name @1 not found

-901

335545049

bad_result_set

Invalid resultset interface

-901

335545059

badvarnum

undefined variable number

-901

335545071

info_unprepared_stmt

Attempt to get information about an unprepared dynamic SQL statement.

-901

335545072

idx_key_value

Problematic key value is @1

-901

335545073

forupdate_virtualtbl

Cannot select virtual table @1 for update WITH LOCK

-901

335545074

forupdate_systbl

Cannot select system table @1 for update WITH LOCK

-901

335545075

forupdate_temptbl

Cannot select temporary table @1 for update WITH LOCK

-901

335545076

cant_modify_sysobj

System @1 @2 cannot be modified

-901

335545077

server_misconfigured

Server misconfigured — contact administrator please

-901

335545078

alter_role

Deprecated backward compatibility ALTER ROLE … SET/DROP AUTO ADMIN mapping may be used only for RDB$ADMIN role

-901

335545079

map_already_exists

Mapping @1 already exists

-901

335545080

map_not_exists

Mapping @1 does not exist

-901

335545081

map_load

@1 failed when loading mapping cache

-901

335545082

map_aster

Invalid name <*> in authentication block

-901

335545083

map_multi

Multiple maps found for @1

-901

335545084

map_undefined

Undefined mapping result — more than one different results found

-901

335545088

map_nodb

Global mapping is not available when database @1 is not present

-901

335545089

map_notable

Global mapping is not available when table RDB$MAP is not present in database @1

-901

335545090

miss_trusted_role

Your attachment has no trusted role

-901

335545091

set_invalid_role

Role @1 is invalid or unavailable

-901

335545093

dup_attribute

Duplicated user attribute @1

-901

335545094

dyn_no_priv

There is no privilege for this operation

-901

335545095

dsql_cant_grant_option

Using GRANT OPTION on @1 not allowed

-901

335545097

crdb_load

@1 failed when working with CREATE DATABASE grants

-901

335545098

crdb_nodb

CREATE DATABASE grants check is not possible when database @1 is not present

-901

335545099

crdb_notable

CREATE DATABASE grants check is not possible when table RDB$DB_CREATORS is not present in database @1

-901

335545102

savepoint_backout_err

Error during savepoint backout — transaction invalidated

-901

335545105

map_down

Some database(s) were shutdown when trying to read mapping data

-901

335545109

encrypt_error

Page requires encryption but crypt plugin is missing

-901

336068645

dyn_filter_not_found

BLOB Filter @1 not found

-901

336068649

dyn_func_not_found

Function @1 not found

-901

336068656

dyn_index_not_found

Index not found

-901

336068662

dyn_view_not_found

View @1 not found

-901

336068697

dyn_domain_not_found

Domain not found

-901

336068717

dyn_cant_modify_auto_trig

Triggers created automatically cannot be modified

-901

336068740

dyn_dup_table

Table @1 already exists

-901

336068748

dyn_proc_not_found

Procedure @1 not found

-901

336068752

dyn_exception_not_found

Exception not found

-901

336068754

dyn_proc_param_not_found

Parameter @1 in procedure @2 not found

-901

336068755

dyn_trig_not_found

Trigger @1 not found

-901

336068759

dyn_charset_not_found

Character set @1 not found

-901

336068760

dyn_collation_not_found

Collation @1 not found

-901

336068763

dyn_role_not_found

Role @1 not found

-901

336068767

dyn_name_longer

Name longer than database column size

-901

336068784

dyn_column_does_not_exist

column @1 does not exist in table/view @2

-901

336068796

dyn_role_does_not_exist

SQL role @1 does not exist

-901

336068797

dyn_no_grant_admin_opt

user @1 has no grant admin option on SQL role @2

-901

336068798

dyn_user_not_role_member

user @1 is not a member of SQL role @2

-901

336068799

dyn_delete_role_failed

@1 is not the owner of SQL role @2

-901

336068800

dyn_grant_role_to_user

@1 is a SQL role and not a user

-901

336068801

dyn_inv_sql_role_name

user name @1 could not be used for SQL role

-901

336068802

dyn_dup_sql_role

SQL role @1 already exists

-901

336068803

dyn_kywd_spec_for_role

keyword @1 can not be used as a SQL role name

-901

336068804

dyn_roles_not_supported

SQL roles are not supported in on older versions of the database. A backup and restore of the database is required.

-901

336068820

dyn_zero_len_id

Zero length identifiers are not allowed

-901

336068822

dyn_gen_not_found

Sequence @1 not found

-901

336068840

dyn_wrong_gtt_scope

@1 cannot reference @2

-901

336068843

dyn_coll_used_table

Collation @1 is used in table @2 (field name @3) and cannot be dropped

-901

336068844

dyn_coll_used_domain

Collation @1 is used in domain @2 and cannot be dropped

-901

336068846

dyn_cannot_del_def_coll

Cannot delete default collation of CHARACTER SET @1

-901

336068849

dyn_table_not_found

Table @1 not found

-901

336068851

dyn_coll_used_procedure

Collation @1 is used in procedure @2 (parameter name @3) and cannot be dropped

-901

336068856

dyn_ods_not_supp_feature

Feature ‘@1’ is not supported in ODS @[email protected]

-901

336068858

dyn_no_empty_pw

Password should not be empty string

-901

336068859

dyn_dup_index

Index @1 already exists

-901

336068864

dyn_package_not_found

Package @1 not found

-901

336068865

dyn_schema_not_found

Schema @1 not found

-901

336068871

dyn_funcnotdef_package

Function @1 has not been defined on the package body @2

-901

336068872

dyn_procnotdef_package

Procedure @1 has not been defined on the package body @2

-901

336068873

dyn_funcsignat_package

Function @1 has a signature mismatch on package body @2

-901

336068874

dyn_procsignat_package

Procedure @1 has a signature mismatch on package body @2

-901

336068875

dyn_defvaldecl_package_proc

Default values for parameters are allowed only in declaration of packaged procedure @[email protected]

-901

336068877

dyn_package_body_exists

Package body @1 already exists

-901

336068879

dyn_newfc_oldsyntax

Cannot alter new style function @1 with ALTER EXTERNAL FUNCTION. Use ALTER FUNCTION instead.

-901

336068886

dyn_func_param_not_found

Parameter @1 in function @2 not found

-901

336068887

dyn_routine_param_not_found

Parameter @1 of routine @2 not found

-901

336068888

dyn_routine_param_ambiguous

Parameter @1 of routine @2 is ambiguous (found in both procedures and functions). Use a specifier keyword.

-901

336068889

dyn_coll_used_function

Collation @1 is used in function @2 (parameter name @3) and cannot be dropped

-901

336068890

dyn_domain_used_function

Domain @1 is used in function @2 (parameter name @3) and cannot be dropped

-901

336068891

dyn_alter_user_no_clause

ALTER USER requires at least one clause to be specified

-901

336068894

dyn_duplicate_package_item

Duplicate @1 @2

-901

336068895

dyn_cant_modify_sysobj

System @1 @2 cannot be modified

-901

336068896

dyn_cant_use_zero_increment

INCREMENT BY 0 is an illegal option for sequence @1

-901

336068897

dyn_cant_use_in_foreignkey

Can’t use @1 in FOREIGN KEY constraint

-901

336068898

dyn_defvaldecl_package_func

Default values for parameters are allowed only in declaration of packaged function @[email protected]

-901

336397211

dsql_too_many_values

Too many values (more than @1) in member list to match against

-901

336397236

dsql_unsupp_feature_dialect

feature is not supported in dialect @1

-901

336397239

dsql_unsupported_in_auto_trans

@1 is not supported inside IN AUTONOMOUS TRANSACTION block

-901

336397258

dsql_alter_charset_failed

ALTER CHARACTER SET @1 failed

-901

336397259

dsql_comment_on_failed

COMMENT ON @1 failed

-901

336397260

dsql_create_func_failed

CREATE FUNCTION @1 failed

-901

336397261

dsql_alter_func_failed

ALTER FUNCTION @1 failed

-901

336397262

dsql_create_alter_func_failed

CREATE OR ALTER FUNCTION @1 failed

-901

336397263

dsql_drop_func_failed

DROP FUNCTION @1 failed

-901

336397264

dsql_recreate_func_failed

RECREATE FUNCTION @1 failed

-901

336397265

dsql_create_proc_failed

CREATE PROCEDURE @1 failed

-901

336397266

dsql_alter_proc_failed

ALTER PROCEDURE @1 failed

-901

336397267

dsql_create_alter_proc_failed

CREATE OR ALTER PROCEDURE @1 failed

-901

336397268

dsql_drop_proc_failed

DROP PROCEDURE @1 failed

-901

336397269

dsql_recreate_proc_failed

RECREATE PROCEDURE @1 failed

-901

336397270

dsql_create_trigger_failed

CREATE TRIGGER @1 failed

-901

336397271

dsql_alter_trigger_failed

ALTER TRIGGER @1 failed

-901

336397272

dsql_create_alter_trigger_failed

CREATE OR ALTER TRIGGER @1 failed

-901

336397273

dsql_drop_trigger_failed

DROP TRIGGER @1 failed

-901

336397274

dsql_recreate_trigger_failed

RECREATE TRIGGER @1 failed

-901

336397275

dsql_create_collation_failed

CREATE COLLATION @1 failed

-901

336397276

dsql_drop_collation_failed

DROP COLLATION @1 failed

-901

336397277

dsql_create_domain_failed

CREATE DOMAIN @1 failed

-901

336397278

dsql_alter_domain_failed

ALTER DOMAIN @1 failed

-901

336397279

dsql_drop_domain_failed

DROP DOMAIN @1 failed

-901

336397280

dsql_create_except_failed

CREATE EXCEPTION @1 failed

-901

336397281

dsql_alter_except_failed

ALTER EXCEPTION @1 failed

-901

336397282

dsql_create_alter_except_failed

CREATE OR ALTER EXCEPTION @1 failed

-901

336397283

dsql_recreate_except_failed

RECREATE EXCEPTION @1 failed

-901

336397284

dsql_drop_except_failed

DROP EXCEPTION @1 failed

-901

336397285

dsql_create_sequence_failed

CREATE SEQUENCE @1 failed

-901

336397286

dsql_create_table_failed

CREATE TABLE @1 failed

-901

336397287

dsql_alter_table_failed

ALTER TABLE @1 failed

-901

336397288

dsql_drop_table_failed

DROP TABLE @1 failed

-901

336397289

dsql_recreate_table_failed

RECREATE TABLE @1 failed

-901

336397290

dsql_create_pack_failed

CREATE PACKAGE @1 failed

-901

336397291

dsql_alter_pack_failed

ALTER PACKAGE @1 failed

-901

336397292

dsql_create_alter_pack_failed

CREATE OR ALTER PACKAGE @1 failed

-901

336397293

dsql_drop_pack_failed

DROP PACKAGE @1 failed

-901

336397294

dsql_recreate_pack_failed

RECREATE PACKAGE @1 failed

-901

336397295

dsql_create_pack_body_failed

CREATE PACKAGE BODY @1 failed

-901

336397296

dsql_drop_pack_body_failed

DROP PACKAGE BODY @1 failed

-901

336397297

dsql_recreate_pack_body_failed

RECREATE PACKAGE BODY @1 failed

-901

336397298

dsql_create_view_failed

CREATE VIEW @1 failed

-901

336397299

dsql_alter_view_failed

ALTER VIEW @1 failed

-901

336397300

dsql_create_alter_view_failed

CREATE OR ALTER VIEW @1 failed

-901

336397301

dsql_recreate_view_failed

RECREATE VIEW @1 failed

-901

336397302

dsql_drop_view_failed

DROP VIEW @1 failed

-901

336397303

dsql_drop_sequence_failed

DROP SEQUENCE @1 failed

-901

336397304

dsql_recreate_sequence_failed

RECREATE SEQUENCE @1 failed

-901

336397305

dsql_drop_index_failed

DROP INDEX @1 failed

-901

336397306

dsql_drop_filter_failed

DROP FILTER @1 failed

-901

336397307

dsql_drop_shadow_failed

DROP SHADOW @1 failed

-901

336397308

dsql_drop_role_failed

DROP ROLE @1 failed

-901

336397309

dsql_drop_user_failed

DROP USER @1 failed

-901

336397310

dsql_create_role_failed

CREATE ROLE @1 failed

-901

336397311

dsql_alter_role_failed

ALTER ROLE @1 failed

-901

336397312

dsql_alter_index_failed

ALTER INDEX @1 failed

-901

336397313

dsql_alter_database_failed

ALTER DATABASE failed

-901

336397314

dsql_create_shadow_failed

CREATE SHADOW @1 failed

-901

336397315

dsql_create_filter_failed

DECLARE FILTER @1 failed

-901

336397316

dsql_create_index_failed

CREATE INDEX @1 failed

-901

336397317

dsql_create_user_failed

CREATE USER @1 failed

-901

336397318

dsql_alter_user_failed

ALTER USER @1 failed

-901

336397319

dsql_grant_failed

GRANT failed

-901

336397320

dsql_revoke_failed

REVOKE failed

-901

336397322

dsql_mapping_failed

@2 MAPPING @1 failed

-901

336397323

dsql_alter_sequence_failed

ALTER SEQUENCE @1 failed

-901

336397324

dsql_create_generator_failed

CREATE GENERATOR @1 failed

-901

336397325

dsql_set_generator_failed

SET GENERATOR @1 failed

-901

336397330

dsql_max_exception_arguments

Number of arguments (@1) exceeds the maximum (@2) number of EXCEPTION USING arguments

-901

336397331

dsql_string_byte_length

String literal with @1 bytes exceeds the maximum length of @2 bytes

-901

336397332

dsql_string_char_length

String literal with @1 characters exceeds the maximum length of @2 characters for the @3 character set

-901

336397333

dsql_max_nesting

Too many BEGIN…END nesting. Maximum level is @1

-902

335544333

bug_check

internal Firebird consistency check (@1)

-902

335544335

db_corrupt

database file appears corrupt (@1)

-902

335544344

io_error

I/O error during «@1» operation for file «@2»

-902

335544346

metadata_corrupt

corrupt system table

-902

335544373

sys_request

operating system directive @1 failed

-902

335544384

badblk

internal error

-902

335544385

invpoolcl

internal error

-902

335544387

relbadblk

internal error

-902

335544388

blktoobig

block size exceeds implementation restriction

-902

335544394

badodsver

incompatible version of on-disk structure

-902

335544397

dirtypage

internal error

-902

335544398

waifortra

internal error

-902

335544399

doubleloc

internal error

-902

335544400

nodnotfnd

internal error

-902

335544401

dupnodfnd

internal error

-902

335544402

locnotmar

internal error

-902

335544404

corrupt

database corrupted

-902

335544405

badpage

checksum error on database page @1

-902

335544406

badindex

index is broken

-902

335544409

trareqmis

transaction—request mismatch (synchronization error)

-902

335544410

badhndcnt

bad handle count

-902

335544411

wrotpbver

wrong version of transaction parameter block

-902

335544412

wroblrver

unsupported BLR version (expected @1, encountered @2)

-902

335544413

wrodpbver

wrong version of database parameter block

-902

335544415

badrelation

database corrupted

-902

335544416

nodetach

internal error

-902

335544417

notremote

internal error

-902

335544422

dbfile

internal error

-902

335544423

orphan

internal error

-902

335544432

lockmanerr

lock manager error

-902

335544436

sqlerr

SQL error code = @1

-902

335544448

bad_sec_info

-902

335544449

invalid_sec_info

-902

335544470

buf_invalid

cache buffer for page @1 invalid

-902

335544471

indexnotdefined

there is no index in table @1 with id @2

-902

335544472

Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

-902

335544478

jrn_enable

enable journal for database before starting online dump

-902

335544479

old_failure

online dump failure. Retry dump

-902

335544480

old_in_progress

an online dump is already in progress

-902

335544481

old_no_space

no more disk/tape space. Cannot continue online dump

-902

335544482

no_wal_no_jrn

journaling allowed only if database has Write-ahead Log

-902

335544483

num_old_files

maximum number of online dump files that can be specified is 16

-902

335544484

wal_file_open

error in opening Write-ahead Log file during recovery

-902

335544486

wal_failure

Write-ahead log subsystem failure

-902

335544505

no_archive

must specify archive file when enabling long term journal for databases with round-robin log files

-902

335544506

shutinprog

database @1 shutdown in progress

-902

335544520

jrn_present

long-term journaling already enabled

-902

335544528

shutdown

database @1 shutdown

-902

335544557

shutfail

database shutdown unsuccessful

-902

335544564

no_jrn

long-term journaling not enabled

-902

335544569

dsql_error

Dynamic SQL Error

-902

335544653

psw_attach

cannot attach to password database

-902

335544654

psw_start_trans

cannot start transaction for password database

-902

335544717

err_stack_limit

stack size insufficent to execute current request

-902

335544721

network_error

Unable to complete network request to host «@1».

-902

335544722

net_connect_err

Failed to establish a connection.

-902

335544723

net_connect_listen_err

Error while listening for an incoming connection.

-902

335544724

net_event_connect_err

Failed to establish a secondary connection for event processing.

-902

335544725

net_event_listen_err

Error while listening for an incoming event connection request.

-902

335544726

net_read_err

Error reading data from the connection.

-902

335544727

net_write_err

Error writing data to the connection.

-902

335544732

unsupported_network_drive

Access to databases on file servers is not supported.

-902

335544733

io_create_err

Error while trying to create file

-902

335544734

io_open_err

Error while trying to open file

-902

335544735

io_close_err

Error while trying to close file

-902

335544736

io_read_err

Error while trying to read from file

-902

335544737

io_write_err

Error while trying to write to file

-902

335544738

io_delete_err

Error while trying to delete file

-902

335544739

io_access_err

Error while trying to access file

-902

335544745

login_same_as_role_name

Your login @1 is same as one of the SQL role name. Ask your database administrator to set up a valid Firebird login.

-902

335544791

file_in_use

The file @1 is currently in use by another process. Try again later.

-902

335544795

unexp_spb_form

unexpected item in service parameter block, expected @1

-902

335544809

extern_func_dir_error

Function @1 is in @2, which is not in a permitted directory for external functions.

-902

335544819

io_32bit_exceeded_err

File exceeded maximum size of 2GB. Add another database file or use a 64 bit I/O version of Firebird.

-902

335544831

conf_access_denied

Use of @1 at location @2 is not allowed by server configuration

-902

335544834

cursor_not_open

Cursor is not open

-902

335544841

cursor_already_open

Cursor is already open

-902

335544856

att_shutdown

connection shutdown

-902

335544882

long_login

-902

335544936

psw_db_error

Security database error

-902

335544970

missing_required_spb

Missing required item @1 in service parameter block

-902

335544971

net_server_shutdown

@1 server is shutdown

-902

335544974

no_threads

Could not start first worker thread — shutdown server

-902

335544975

net_event_connect_timeout

Timeout occurred while waiting for a secondary connection for event processing

-902

335544984

instance_conflict

Database is probably already opened by another engine instance in another Windows session

-902

335544987

no_trusted_spb

Use of TRUSTED switches in spb_command_line is prohibited

-902

335545029

missing_data_structures

Install incomplete, please read the Compatibility chapter in the release notes for this version

-902

335545030

protect_sys_tab

@1 operation is not allowed for system table @2

-902

335545032

wroblrver2

unsupported BLR version (expected between @1 and @2, encountered @3)

-902

335545043

decrypt_error

Missing crypt plugin, but page appears encrypted

-902

335545044

no_providers

No providers loaded

-902

335545053

miss_config

Missing configuration file: @1

-902

335545054

conf_line

@1: illegal line <@2>

-902

335545055

conf_include

Invalid include operator in @1 for <@2>

-902

335545056

include_depth

Include depth too big

-902

335545057

include_miss

File to include not found

-902

335545060

sec_context

Missing security context for @1

-902

335545061

multi_segment

Missing segment @1 in multisegment connect block parameter

-902

335545062

login_changed

Different logins in connect and attach packets — client library error

-902

335545063

auth_handshake_limit

Exceeded exchange limit during authentication handshake

-902

335545064

wirecrypt_incompatible

Incompatible wire encryption levels requested on client and server

-902

335545065

miss_wirecrypt

Client attempted to attach unencrypted but wire encryption is required

-902

335545066

wirecrypt_key

Client attempted to start wire encryption using unknown key @1

-902

335545067

wirecrypt_plugin

Client attempted to start wire encryption using unsupported plugin @1

-902

335545068

secdb_name

Error getting security database name from configuration file

-902

335545069

auth_data

Client authentication plugin is missing required data from server

-902

335545070

auth_datalength

Client authentication plugin expected @2 bytes of @3 from server, got @1

-902

335545106

login_error

Error occurred during login, please check server firebird.log for details

-902

335545107

already_opened

Database already opened with engine instance, incompatible with current

-902

335545108

bad_crypt_key

Invalid crypt key @1

-904

335544324

bad_db_handle

invalid database handle (no active connection)

-904

335544375

unavailable

unavailable database

-904

335544381

imp_exc

Implementation limit exceeded

-904

335544386

nopoolids

too many requests

-904

335544389

bufexh

buffer exhausted

-904

335544391

bufinuse

buffer in use

-904

335544393

reqinuse

request in use

-904

335544424

no_lock_mgr

no lock manager available

-904

335544430

virmemexh

unable to allocate memory from operating system

-904

335544451

update_conflict

update conflicts with concurrent update

-904

335544453

obj_in_use

object @1 is in use

-904

335544455

shadow_accessed

cannot attach active shadow file

-904

335544460

shadow_missing

a file in manual shadow @1 is unavailable

-904

335544661

index_root_page_full

cannot add index, index root page is full.

-904

335544676

sort_mem_err

sort error: not enough memory

-904

335544683

req_depth_exceeded

request depth exceeded. (Recursive definition?)

-904

335544758

sort_rec_size_err

sort record size of @1 bytes is too big

-904

335544761

too_many_handles

too many open handles to database

-904

335544762

optimizer_blk_exc

size of optimizer block exceeded

-904

335544792

service_att_err

Cannot attach to services manager

-904

335544799

svc_name_missing

The service name was not specified.

-904

335544813

optimizer_between_err

Unsupported field type specified in BETWEEN predicate.

-904

335544827

exec_sql_invalid_arg

Invalid argument in EXECUTE STATEMENT — cannot convert to string

-904

335544828

exec_sql_invalid_req

Wrong request type in EXECUTE STATEMENT ‘@1’

-904

335544829

exec_sql_invalid_var

Variable type (position @1) in EXECUTE STATEMENT ‘@2’ INTO does not match returned column type

-904

335544830

exec_sql_max_call_exceeded

Too many recursion levels of EXECUTE STATEMENT

-904

335544832

wrong_backup_state

Cannot change difference file name while database is in backup mode

-904

335544833

wal_backup_err

Physical backup is not allowed while Write-Ahead Log is in use

-904

335544852

partner_idx_incompat_type

partner index segment no @1 has incompatible data type

-904

335544857

blobtoobig

Maximum BLOB size exceeded

-904

335544862

record_lock_not_supp

Stream does not support record locking

-904

335544863

partner_idx_not_found

Cannot create foreign key constraint @1. Partner index does not exist or is inactive.

-904

335544864

tra_num_exc

Transactions count exceeded. Perform backup and restore to make database operable again

-904

335544865

field_disappeared

Column has been unexpectedly deleted

-904

335544878

concurrent_transaction

concurrent transaction number is @1

-904

335544935

circular_computed

Cannot have circular dependencies with computed fields

-904

335544992

lock_dir_access

Can not access lock files directory @1

-904

335545020

request_outdated

Request can’t access new records in relation @1 and should be recompiled

-904

335545096

read_conflict

read conflicts with concurrent update

-906

335544452

unlicensed

product @1 is not licensed

-906

335544744

max_att_exceeded

Maximum user count exceeded. Contact your database administrator.

-909

335544667

drdb_completed_with_errs

drop database completed with errors

-911

335544459

rec_in_limbo

record from transaction @1 is stuck in limbo

-913

335544336

deadlock

-922

335544323

bad_db_format

file @1 is not a valid database

-923

335544421

connect_reject

connection rejected by remote interface

-923

335544461

cant_validate

secondary server attachments cannot validate databases

-923

335544462

cant_start_journal

secondary server attachments cannot start journaling

-923

335544464

cant_start_logging

secondary server attachments cannot start logging

-924

335544325

bad_dpb_content

bad parameters on attach or create database

-924

335544433

journerr

communication error with journal «@1»

-924

335544441

bad_detach

database detach completed with errors

-924

335544648

conn_lost

Connection lost to pipe server

-924

335544972

bad_conn_str

Invalid connection string

-924

335545085

baddpb_damaged_mode

Incompatible mode of attachment to damaged database

-924

335545086

baddpb_buffers_range

Attempt to set in database number of buffers which is out of acceptable range [@1:@2]

-924

335545087

baddpb_temp_buffers

Attempt to temporarily set number of buffers less than @1

-926

335544447

no_rollback

no rollback performed

-999

335544689

ib_error

Firebird error

Источник

← →
d@nger

(2010-04-25 09:41)
[0]

Здравствуйте! Имеется таблица (Firebird) с полем дата, и идентификатор клиента.
id org_id date 1 231 01.03.2010 2 231 02.04.2010 3 231 07.04.2010 4 115 15.04.2010 5 115 17.04.2010 6 205 20.04.2010 7 205 02.05.2010 ...

нужно выбрать все записи за определенный месяц. Это я конечно сделал, но теперь нужно выбрать последнюю по дате запись каждого клиента, т.е из приведенного примера должны остаться записи 3, 5, 6. Я конечно могу это сделать в цикле проверяя каждую запись, но это будет не так эффективно если бы это сделать с помощью запроса. Возможно ли сделать такой запрос?

передать требуемую дату параметром?

select * from table where date=:p

← →
d@nger

(2010-04-25 10:01)
[2]

дата не известна, известен месяц. Нужно вытащить все записи за этот месяц и среди этих записей оставить только уникальные организации с последней датой…
select * from table where (date>="01.04.2010")and(date<="30.04.2010") вот это все на что у меня ума хватило… как теперь убрать повторные организации с меньшими дататами, а оставить только одну с наибольшей датой…

> только уникальные организации с последней датой…
+ GROUP BY
и Max

← →
d@nger

(2010-04-25 10:24)
[4]

Урраа! Получилось… погуглил в инете… вот мое решение:

select org_id, max(call_date) from call_log group by call_log.org_id

> d@nger (25.04.2010 10:01:02) [2]

Последняя, она же наибольшая — это MAX естественно.

← →
d@nger

(2010-04-25 10:49)
[6]

теперь не могу объединить эти 2 запроса в один

select * from table where (date>="01.04.2010")and(date<="30.04.2010")
select org_id, max(call_date) from call_log group by call_log.org_id

пишу так:
select id,call_date from call_log where (call_date>="01.04.2010")and(call_date<="30.04.2010")and (id in (select id, max(call_date) from call_log group by call_log.org_id))

ошибка
Invalid token. Dynamic SQL Error. SQL error code = -104. Invalid command. count of column list and variable list do not match.

как правильно его записать?

← →
d@nger

(2010-04-25 11:30)
[7]

я снова погуглил… решение следующее…
select org_id, max(call_date) from call_log group by org_id having (max(call_date)>="01.04.2010")and(max(call_date)<="30.04.2010")

> select org_id, max(call_date) from call_log
> group by org_id having (max(call_date)>=»01.04.2010″)and(max(call_date)<=»30.04.2010″)

индекс по полю org_id или call_date есть? если только по call_date то решение очень глупое… если есть и по org_id, то просто слегка «туповатое».
группировать по всей таблице например 10 миллионов записей. и после обрезать до 10 нужных, это не то же самое, что отобрать 1000 за месяц и после сгруппировать их в нужные 10…

← →
d@nger

(2010-04-26 06:50)
[9]

да… я после понял это как оставил пост…
пытался переделать запрос.. сначала отобрать нужный период а потом сгруппировать по org_id но кроме как создать представление с необходимым периодом и в этом представлении группировать дни… ничего больше не придумал… подскажите как быть…

← →
d@nger

(2010-04-26 07:09)
[10]

может уважаемый админ перенесет мою тему в раздел баз данных?…
может кто нибудь подскажет что нибудь.. оптимально ли делать следующим образом
1) создавать сначала представление,
2) потом делать группировку в этом представлении,
3 )формировать отчет на основе полученных данных,
4) удалить представление

или все таки возможно как то обойтись без представления?

все можно, нужно только немного изучить синтаксис sql, а не искать готовое по инету, понимать что пишешь…
а то до смешного доходит, не мочь сделать в уже готовом легкую коррекцию, поменять оператор и изменить синтаксис в соответствии с его правилами.

p.s. самое место теме здесь. запросы с where описывают на втором, или третьем занятии в книгах типа «sql для чайников», сразу после введения… группировки попозже, но с ними у тебя проблем вроде нет.

← →
d@nger

(2010-04-26 08:14)
[12]

вымучил я все таки этот запрос…

select org_id, max(call_date) from call_log where call_date between "01.05.2010" and "30.05.2010" group by org_id

всем спасибо, что направили на путь истинный.. ))))

> может уважаемый админ перенесет мою тему в раздел баз данных?
> …

С какой стати, твой вопрос вообще не имеет отношения к програмированию в Дельфи, тебе нужно в форум по FB, а здесь такого нет. Наиболее близкая конференция это Общая.

← →
d@nger

(2010-04-26 09:03)
[14]

придется мне опять поднять эту тему…

кроме полей org_id, и call_date? нужно вытащить еще 2 текстовых поля, но в этом случае скрипт не работает, НО если дабавить эти текстовые поля в group by, ошибки нет, но результат не группируется по org_id… как быть в этом случае?

> но результат не группируется по org_id…
эк, я тебя «сглазил»…
> но с ними у тебя проблем вроде нет.

> как быть в этом случае?
читать четвертый раздел «sql для чайников» по «group by». и внимательно смотреть на call_date в запросе.

тут поможет уловка с CONCAT
SELECT * FROM `call_log` WHERE `id` IN ( SELECT CAST(SUBSTRING(MAX(CONCAT(LPAD(`date`,20,0), `id`)), 21) AS INT) FROM `call_log` WHERE `date` between "01.05.2010" and "30.05.2010" GROUP BY `org_id` )
Это на MYSQL. На FB переведешь сам

← →
d@nger

(2010-04-26 10:42)
[17]

что то не получается у меня ничего.. склоняюсь к варианту с представлениями..

← →
d@nger

(2010-04-26 10:43)
[18]

LPAD(`date`,20,0), `id`) может здесь нужнобыло использовать RPAD ?

ИМХО как то так.

select a.org_id, max(a.call_date) from call_log a left join table b on ((date>="01.04.2010")and(date<="30.04.2010")) and a.org_id = b.id group by a.org_id

ужас какой…

простейший вариант это включить поля в агрегатных функциях, аналогично call_date (ведь он то тебе не мешает группировать по org_id)
но лучше конечно так (надеюсь id это ключ, и авто инкремент (ну аналог его в FB), и еще надеюсь даты в строках воспринимаются правильно… хотя в любом случае советую параметры)

select org_id, call_date, еще 2 текстовых поля from call_log WHERE id IN (select max(id) from call_log where call_date between "01.05.2010" and "30.05.2010" group by org_id)

Самое время задуматься: «От инета больше вреда или пользы?»

← →
d@nger

(2010-04-26 11:29)
[24]

> test © (26.04.10 11:08) [19]
>
> ИМХО как то так.
>
> select a.org_id, max(a.call_date) from call_log a
> left join table b on ((date>=»01.04.2010″)and(date<=»30.
> 04.2010″)) and a.org_id = b.id
> group by a.org_id

этот вариант не дает доступа к тектовым полям таблицы call_log, в принципе он вообще ничем не отличается от моего варианта…

← →
d@nger

(2010-04-26 11:31)
[25]

> Дмитрий С © (26.04.10 11:20) [22]
>
>
> > sniknik ©
>
> В условиях нет факта, что id и call_date одновременно возрастают.
>

идея конечно оригинальная, но действительно, кто мешает пользователю добавить новую запись задним числом…

d@nger (26.04.10 11:29) [24]
Какой доступ нужен?

← →
d@nger

(2010-04-26 11:37)
[27]

у меня такая мысль возникла, если группировка работает с агрегатными функциями, нельзя ли написать свою агрегатную функцию, которая ничего не делает, а возвращает то же значение что в него и посупило, например: TXT(«это текст») = это текст …. т.е сделав такю функцию мы сможем ее включить в параметры select и вывести отдельным столбцом

select c.* from call_log left join (select a.org_id, max(a.call_date) from call_log a left join table b on ((date>="01.04.2010")and(date<="30.04.2010")) and a.org_id = b.id group by a.org_id) b on c.id = b.id

d@nger (26.04.10 11:37) [27]
Все уже украдено до нас))

select c.*, «это мы напишем тута»,»а это мы напишем в тама» from call_log с

← →
d@nger

(2010-04-26 11:39)
[30]

помимо ORG_ID и CALL_DATE, есть текстовые поля ORG_NAME и TEXT, которые тоже нужно отобразить в результате запроса . если эти поля включить в select то придется и в группировку их включить, что повлияет на результат группировки

d@nger (26.04.10 11:39) [30]
Проверь запрос из поста 28.

← →
d@nger

(2010-04-26 11:45)
[32]

проверяю….
select * from call_log c left join (select a.org_id, max(a.call_date) from call_log a left join clients b on ((call_date>="01.04.2010")and(call_date<="30.04.2010")) and a.org_id = b.id group by a.org_id) b on c.id = b.id

ошибка…
Invalid token. Dynamic SQL Error. SQL error code = -104. Invalid command. no column name specified for column number 2 in derived table B.

select * from call_log c left join (select a.org_id, max(a.call_date) max_date from call_log a left join clients b on ((call_date>="01.04.2010")and(call_date<="30.04.2010")) and a.org_id = b.id group by a.org_id) b on c.id = b.id

Ну назови поле как нибудь например max_date он же об этом говорит

← →
d@nger

(2010-04-26 11:55)
[34]

> Ну назови поле как нибудь например max_date он же об этом
> говорит

я не знаю куда его воткнуть… я sql плохо пока знаю

я привел же написал куда и где

← →
d@nger

(2010-04-26 12:03)
[36]

сорри.. не увидел…

← →
d@nger

(2010-04-26 12:11)
[37]

теперь другая ошибка …
select * from call_log c left join (select a.org_id, max(a.call_date) max_date from call_log a left join clients b on ((call_date>="01.04.2010")and(call_date<="30.04.2010")) and a.org_id = b.id group by a.org_id) b on c.id = b.id

ошибка …

> Column does not belong to referenced table.
> Dynamic SQL Error.
> SQL error code = -206.
> Column unknown.
> B.ID.
> At line 5, column 34.

> у меня такая мысль возникла, если группировка работает с агрегатными функциями, нельзя ли написать свою агрегатную функцию
читай внимательно, и писать не будет ничего нужно…
> простейший вариант это включить поля в агрегатных функциях, аналогично call_date (ведь он то тебе не мешает группировать по org_id)

ошибка означает нет такого поля
скорее всего это он про
c.id = b.id
b.id должно быть b.org_id
c.id нужно смотреть в названиях полей таблицы

в select * from тожке лучше указать что тебе нужно select c.* from, а то он тебе весь набор вытащит.

Смысл этих операций ты связать по полям id(идентификаторы) выбор из первого запроса и саму таблицу, в результате ты должен получить только те строки из таблицы которые соотвествуют внутреннему запросу.

Надо поля смотреть, может быть у тебя таких и нету в таблице.

← →
d@nger

(2010-04-26 12:33)
[40]

структура таблиц следующая:
таблица call_log
ID — ключ
ORG_ID — ключ организации клиента из таблицы clients.id
CALL_DATE — дата
TEXT — текст
ORG_NAME — текст

в таблице clients много полей… но поле ID точно есть… тоже ключевое…

← →
d@nger

(2010-04-26 12:37)
[41]

вобщем вот в таком виде ошибки нет.. но результат просто выводит все записи…
select c.*, org_name, text from call_log c left join (select a.org_id, max(a.call_date) max_date from call_log a left join clients g on (call_date between "01.04.2010" and "30.04.2010") and a.org_id = g.id group by a.org_id) b on c.id = b.org_id

Я думал что org_id и есть идентификатор, тогда тебе связь нужна по всем полям результирующего набора

d@nger (26.04.10 12:37) [41]
Тут ошибка, он по разным полям связь делает, в смысле он делает связь по ключу первой таблицы с ключем второй таблицы.

← →
d@nger

(2010-04-26 12:49)
[44]

d@nger (26.04.10 12:49) [44]
Не может быть чтобы все строки в таблице соответствовали c.org_id = b.org_id and c.call_date = b.max_date

← →
d@nger

(2010-04-26 13:12)
[46]

> Не может быть чтобы все строки в таблице соответствовали
> c.org_id = b.org_id and c.call_date = b.max_date

возможно это условие как то игнорируется фаербердом

> d@nger (26.04.2010 12:37:41) [41]

Видимо org_id, call_date и все записи только в интервале «01.04.2010» and «30.04.2010»

← →
d@nger

(2010-04-26 13:18)
[48]

> идимо org_id, call_date и все записи только в интервале
> «01.04.2010» and «30.04.2010»

ID ORG_ID CALL_DATE TEXT ORG_NAME
97 59 18.03.2010 gregreg Агропромипорт Холдинг
98 59 13.04.2010 ergregerg Агропромипорт Холдинг
99 59 21.04.2010 regergerg Агропромипорт Холдинг
100 59 28.04.2010 erger65ty546 Агропромипорт Холдинг
101 59 20.05.2010 6356356fvgfd Агропромипорт Холдинг
102 59 29.05.2010 ergerger Агропромипорт Холдинг
103 58 14.04.2010 retкуце ецкецкуе Администрация города
104 58 15.04.2010 цукецкуе ку5435 Администрация города
105 58 22.04.2010 е45243525епкупуц Администрация города

в поле TEXT я так просо аброкадабру написал на время разработки

d@nger (26.04.10 13:12) [46]
Это правило по которому он связывает, он его игнорировать не может.
Измени
select * from call_log c
На
select c.org_id, b.org_id, c.call_date, b.max_date from call_log c
И посмотри построчно.

> d@nger (26.04.2010 13:12:46) [46]

Да как он посмел

← →
d@nger

(2010-04-26 13:23)
[51]

вот сейчас выдал вот это :

ORG_ID ORG_ID1 CALL_DATE MAX_DATE 59 18.03.2010 59 13.04.201 0 59 21.04.2010 59 28.04.2010 59 20.05.2010 59 59 29.05.2010 29.05.2010 58 14.04.2010 58 15.04.2010 58 58 22.04.2010 22.04.2010

пустые значения null

← →
d@nger

(2010-04-26 13:28)
[52]

т.е. там где ORG_ID1 не пустое правильные ответы, теперь осталось только отсеять строки где оно равно null

d@nger (26.04.10 13:23) [51]

select * from call_log c right join (select a.org_id, max(a.call_date) max_date from call_log a left join clients b on ((call_date>="01.04.2010")and(call_date<="30.04.2010")) and a.org_id = b.id group by a.org_id) b on c.org_id = b.org_id and c.call_date = b.max_date

Помойму все дело в right join/left join.

← →
d@nger

(2010-04-26 15:14)
[54]

>
> Помойму все дело в right join/left join.

Ураа! действительно … все заработало как надо.. спасибо огромное TEST … намучились же вы со мной.. еще раз спасибо от души!

d@nger (26.04.10 15:14) [54]
Пожалуйста. Заодно сам обновил знания SQL.

test © (26.04.10 13:39) [53]
call_date>="01.04.2010"
1. нет alias
2. строка вместо даты
3. left join вместо join
4. последнюю запись на дату принято искать по индексу, а не агрегированием

плохие-плохие советы…

← →
d@nger

(2010-04-26 19:21)
[58]

рано что то я обрадовался… взял период за май.. где только одна организация должна выйти, т.к. по второй даты на май нет… все равно две организации выходит… неужели эту на первый взгляд тривиальную задачу так трудно решить?

← →
d@nger

(2010-04-26 19:38)
[59]

попробовал по совету Кщд заменить right join/left join на просто join … и о чудо все стало работать как надо… еще убрал пару условий не влияющих на результат… итоговый результат следующий:
select c.id, c.org_id, c.call_date, c.org_name, c.text from call_log c join (select a.org_id, max(a.call_date) max_date from call_log a join call_log b on a.call_date between "01.03.2010" and "30.03.2010" group by a.org_id) d on c.call_date = d.max_date

> 4. последнюю запись на дату принято искать по индексу, а
> не агрегированием

дело в том что дату пользватель вводит самостоятельно, поэтому поиск по ключевому полю не подходит.. или вы имеете ввиду что то другое…

> и о чудо все стало работать как надо…
до первых повторов дат

вот так попробуй
select org_id, call_date, text, org_name from call_log where id in ( select max(id) from call_log a inner join ( select org_id, max(call_date) as call_date from call_log where call_date between "01.05.2010" and "30.05.2010" group by org_id ) b on a.org_id=b.org_id and a.call_date=b.call_date group by a.org_id) c

не будет зависеть от того
> что id и call_date одновременно возрастают.

главное чтобы id был уникальным. и если в одной группе org_id будет 2 одинаковые даты то возьмется с большим id, хотя это неважно но что то же нужно выбирать.
в твоем запросе ([59]) даже не в диапазоне org_id, а во всем периоде совпадение дат приведет к дублям/»триблям»/»и т.д.блям»

← →
d@nger

(2010-04-26 20:46)
[62]

← →
d@nger

(2010-04-26 20:48)
[63]

> главное чтобы id был уникальным

id ключевое автоинкрементное поле..

> тоже все работает нормально…
тогда оставь эту, эта больше учитывает…
вот забей в приведенном примере данных у всех записей одну и туже дату и проверь обе процедуры.

> процедуры.
блин, запроса.

← →
d@nger

(2010-04-26 21:00)
[66]

> вот забей в приведенном примере данных у всех записей одну
> и туже дату и проверь обе процедуры.

да… твоя корректно отработала… предыдущая показала дубли

спасибо sniknik

>test © (26.04.10 17:47) [57]
это что, приказ?)
мой пост был Вам, а не автору
если считаете мои советы дурными — не следуйте им)

Источник

Home > SQL Server Error Messages > Msg 213 — Insert Error: Column name or number of supplied values does not match table definition.

SQL Server Error Messages — Msg 213 — Insert Error: Column name or number of supplied values does not match table definition.

SQL Server Error Messages — Msg 213

Error Message

Server: Msg 213, Level 16, State 1, Line 1
Insert Error: Column name or number of supplied values 
does not match table definition.

Causes:

This error occurs when doing an INSERT where the columns list is not specified and the values being inserted, either through the VALUES clause or through a SELECT subquery, are either more than or less than the columns in the table. Here are examples on when the error can occur:

-- Sample #1: Using INSERT INTO ... VALUES
CREATE TABLE [dbo].[Customers] ( [ID] INT, [Name] VARCHAR(100))

INSERT INTO [dbo].[Customers]
VALUES (1, 'John', 'Doe')

-- Sample #2: Using INSERT INTO ... SELECT FROM
CREATE TABLE [dbo].[Client] ( [ID] INT, [Name] VARCHAR(100))

INSERT INTO [dbo].[Client]
SELECT [ID], [Name], [Address]
FROM [dbo].[NewClient]

Solution / Work Around:

To avoid this problem, make sure that the values specified in the VALUES clause
or in the SELECT subquery match the number of columns in the INSERT
clause. In addition to this, you must specify the columns in
the INSERT INTO clause. Although the column list in the INSERT INTO
statement is optional, it is recommended that it is always specified so that
even if there are any modifications made on the table, either new columns are
added or inserted in the middle of the table or columns are deleted, the INSERT
statement will not generate this error. (Of course, a different error
message will be generated if a column is deleted from the table that is being
referenced by the INSERT statement).

Given the samples above, here’s how to avoid the error:

-- Sample #1: Using INSERT INTO ... VALUES
CREATE TABLE [dbo].[Customers] ( [ID] INT, [Name] VARCHAR(100))

INSERT INTO [dbo].[Customers] ( [ID], [Name] )
VALUES (1, 'John Doe')

-- Sample #2: Using INSERT INTO ... SELECT FROM
CREATE TABLE [dbo].[Client] ( [ID] INT, [Name] VARCHAR(100))

INSERT INTO [dbo].[Client] ( [ID], [Name] )
SELECT [ID], [Name]
FROM [dbo].[NewClient]

Frequently Asked Questions — SQL Server Error Messages
Frequently Asked Questions — INSERT Statement
Frequently Asked Questions — SELECT Statement

Источник

Ошибка компиляции процедуры

Читайте также: