MySQL Forums
Forum List  »  Perl

Re: Unknown column 'subtest_id' in 'NEW'
Posted by: Prashant Tekriwal
Date: September 10, 2013 07:27AM

We can't use AUTO_INCREMENT in tables where we are using 'id' from 'seq' because we use one single incrementing sequence across multiple tables if that what you mean.

Also we don't want to use AUTO_INCREMENT for 'id' in seq table because that would insert as many rows in seq table as many times we want a new id.

In our case we have just one row in seq table.

I know this whole logic is very tedious but this is how it is currently and we need to change a lot of logic to change this behavior.

If I can get to know what is actually causing the issue that will be really helpful.

I am totally stuck because of this issue.

Any help will be highly appreciated.

Options: ReplyQuote

Written By
Re: Unknown column 'subtest_id' in 'NEW'
September 10, 2013 07:27AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.