[MDEV-3786] LP:778915 - Error "1660 Illegal value used as argument of dynamic column function" is not helpful Created: 2011-05-07  Updated: 2012-10-04  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Philip Stoev (Inactive) Assignee: Michael Widenius
Resolution: Won't Fix Votes: 0
Labels: Launchpad, MariaDB_5.3

Attachments: XML File LPexportBug778915.xml    

 Description   

Error " 1660 Illegal value used as argument of dynamic column function" shows up when one tries to assign two values to the same dynamic column within a single statement. The same operation would be allowed in an INSERT, where the last value would be used. So, either make dynamic columns behave as INSERT, or provide a better error message, e.g. "duplicate field name"

For example:

 SELECT COLUMN_CREATE( 5 , 1 , 5 , 1 ) ;

 Comments   
Comment by Michael Widenius [ 2011-05-10 ]

Re: Error "1660 Illegal value used as argument of dynamic column function" is not helpful
This is a restriction of the current implementation. I will for now document this in the manual.
The idea is that in the future it will behave as INSERT in this case.

Comment by Rasmus Johansson (Inactive) [ 2011-05-10 ]

Launchpad bug id: 778915

Comment by Michael Widenius [ 2011-05-10 ]

Re: Error "1660 Illegal value used as argument of dynamic column function" is not helpful
For now, you can only get the error: "Illegal value used as argument of dynamic column function" if you provide a too big column number (> 65535) or if you have the same column number twice in a COLUMN_CREATE or COLUM_ADD function.

Generated at Thu Feb 08 06:51:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.