Bug #110385 ALTER TABLE function error with "DEFAULT utc_timestamp(6) "
Submitted: 16 Mar 2023 5:48 Modified: 16 Apr 2023 11:18
Reporter: Matthias Hellmich Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.32 OS:Windows (Microsoft Windows 10 Enterprise)
Assigned to: MySQL Verification Team CPU Architecture:Any
Tags: WBBugReporter

[16 Mar 2023 5:48] Matthias Hellmich 
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\mhellmich\AppData\Roaming\MySQL\Workbench\log\wb.log]

IF you use the Function "alter table" you got en error if the table has a coloum with an default value "utc_timetamp(6)"

How to repeat:
CREATE TABLE `tblmessage` (
  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Describes the unique ID of the data record (primary key)',
  `TimeStampID` datetime(6) NOT NULL DEFAULT utc_timestamp(6)
[16 Mar 2023 11:18] MySQL Verification Team 
Hello Matthias Hellmich,

Thank you for the bug report.
Could you please provide create table statement 'tblmessage'?

Regards,
Ashwini Patil
[17 Apr 2023 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".