This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-14. For the latest, interactive version please visit https://mariadb.com/kb/.

Created: 7 months, 3 weeks ago
Modified: 7 months, 3 weeks ago
Type: article
Status: active
License: CC BY-SA / Gnu FDL

Attachments

No attachments exist

Error 4002: WITH column list and SELECT field list have different column counts

Error Code	SQLSTATE	Error	Description
4002		ER_WITH_COL_WRONG_LIST	WITH column list and SELECT field list have different column counts

Possible Causes and Solutions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ MariaDB Error Codes 4000 to 4099 ↑
Error 4000: COM_MULTI can't return a result set in the given context
Error 4001: Command is not allowed for COM_MULTI
Error 4002: WITH column list and SELECT field list have different column counts
Error 4003: Too many WITH elements in WITH clause
Error 4004: Duplicate query name in WITH clause
Error 4005: No anchors for recursive WITH element
Error 4006: Unacceptable mutual recursion with anchored table
Error 4007: Reference to recursive WITH table in materialized derived
Error 4008: Restrictions imposed on recursive definitions are violated for table
Error 4009: Window specification with name is not defined
Error 4010: Multiple window specifications with the same name
Error 4011: Window specification referencing another one cannot contain partition list
Error 4012: Referenced window specification already contains order list
Error 4013: Referenced window specification cannot contain window frame
Error 4014: Unacceptable combination of window frame bound specifications
Error 4015: Window function is allowed only in SELECT list and ORDER BY clause
Error 4016: Window function is not allowed in window specification
Error 4017: Window frame is not allowed with
Error 4018: No order list in window specification for
Error 4019: RANGE-type frame requires ORDER BY clause with single sort key
Error 4020: Integer is required for ROWS-type frame
Error 4021: Numeric datatype is required for RANGE-type frame
Error 4022: Frame exclusion is not supported yet
Error 4023: This window function may not have a window frame
Error 4024: Argument of NTILE must be greater than 0
Error 4025: CONSTRAINT failed for
Error 4026: Expression in the clause is too big
Error 4027: Got an error evaluating stored expression
Error 4028: Got an error when calculating default value for
Error 4029: Expression for field is referring to uninitialized field
Error 4030: Only one DEFAULT partition allowed
Error 4031: Referenced trigger for the given action time and event type does not exist
Error 4032: Default/ignore value is not supported for such parameter usage
Error 4033: Only row based replication supported for bulk operations
Error 4034: Uncompress the compressed binlog failed
Error 4035: Broken JSON string in argument to function at position
Error 4036: Character disallowed in JSON in argument to function at position
Error 4037: Unexpected end of JSON text in argument to function
Error 4038: Syntax error in JSON text in argument to function at position
Error 4039: Incorrect escaping in JSON text in argument to function at position
Error 4040: Limit on JSON nested strucures depth is reached in argument to function at position
Error 4041: Unexpected end of JSON path in argument to function
Error 4042: Syntax error in JSON path in argument to function at position
Error 4043: Limit on JSON path depth is reached in argument to function at position
Error 4044: Wildcards in JSON path not allowed in argument to function
Error 4045: JSON path should end with an array identifier in argument to function
Error 4046: Argument 2 to function must be "one" or "all".
Error 4047: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.
Error 4048: Incorrect GeoJSON format specified for st_geomfromgeojson function
Error 4049: Incorrect GeoJSON format - too few points for linestring specified
Error 4050: Incorrect GeoJSON format - polygon not closed
Error 4051: Path expression '$' is not allowed in argument to function
Error 4052: A slave with the same server_uuid/server_id as this slave has connected to the master
Error 4053: Flashback does not support
Error 4054: Keys are out order during bulk load
Error 4055: Bulk load rows overlap existing rows
Error 4056: Can't execute updates on master with binlog_format != ROW
Error 4057: MyRocks supports only READ COMMITTED and REPEATABLE READ isolation levels
Error 4058: When unique checking is disabled in MyRocks, INSERT,UPDATE,LOAD statements with clauses that update or replace the key are not allowed
Error 4059: Can't execute updates when you started a transaction with START TRANSACTION WITH CONSISTENT [ROCKSDB] SNAPSHOT
Error 4060: This transaction was rolled back and cannot be committed. Only supported operation is to roll it back, so all pending changes will be discarded
Error 4061: MyRocks currently does not support ROLLBACK TO SAVEPOINT if modifying rows
Error 4062: Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine
Error 4063: Unsupported collation on string indexed column
Error 4064: Table '%s' does not exist, but metadata information exists inside MyRocks. This is a sign of data inconsistency. Please check if frm exists, and try to restore it if it does not exist
Error 4065: Column family flag is different from an existing flag
Error 4066: TTL duration in MyRocks must be an unsigned non-null 64-bit integer
Error 4067: Status error received from RocksDB
Error 4068: Status error received from RocksDB
Error 4069: TTL support is currently disabled when table has a hidden PK
Error 4070: TTL column in MyRocks must be an unsigned non-null 64-bit integer, exist inside the table, and have an accompanying ttl duration
Error 4071: The per-index column family option has been deprecated
Error 4072: MyRocks failed creating new key definitions during alter
Error 4073: MyRocks failed populating secondary key during alter
Error 4074: Window functions can not be used as arguments to group functions
Error 4075: OK packet too large
Error 4076: Incorrect GeoJSON format - empty 'coordinates' array
Error 4077: MyRocks doesn't currently support collations with "No pad" attribute
Error 4078: Illegal parameter data types for operation
Error 4079: Illegal parameter data type for operation
Error 4080: Incorrect parameter count to cursor
Error 4081: Unknown structured system variable or ROW routine variable
Error 4082: Row variable does not have a field
Error 4083: END identifier does not match
Error 4084: Sequence has run out
Error 4085: Sequence values are conflicting
Error 4086: Sequence table structure is invalid
Error 4087: Sequence access error
Error 4088: Sequences requires binlog_format mixed or row
Error 4089: is not a SEQUENCE
Error 4090: is not a SEQUENCE
Error 4091: Unknown SEQUENCE
Error 4092: Unknown VIEW
Error 4093: Wrong INSERT into a SEQUENCE. One can only do single table INSERT into a sequence object
Error 4094: At line in
Error 4095: Subroutine is declared in the package specification but is not defined in the package body
Error 4096: Subroutine has a forward declaration but is not defined
Error 4097: Compressed column can't be used in key specification
Error 4098: Unknown compression method
Error 4099: The used table value constructor has a different number of values

Error 4002: WITH column list and SELECT field list have different column counts

Contents

Possible Causes and Solutions

Products

Services

Pricing

Resources

About Us

Download MariaDB