Giter Club home page Giter Club logo

Comments (3)

sbrossie avatar sbrossie commented on September 20, 2024

I was able to reproduce the issue by first dropping the column updated_date and then adding it again using the migration command: alter table invoice_tracking_ids add column updated_date datetime NOT NULL DEFAULT '1970-01-01 00:00:00' after updated_by;

It really looks like a jooq issue not being able to parse the schema:

Create Table: CREATE TABLE `invoice_tracking_ids` (
  `record_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `id` varchar(36) COLLATE utf8mb3_bin NOT NULL,
  `tracking_id` varchar(128) COLLATE utf8mb3_bin NOT NULL,
  `invoice_id` varchar(36) COLLATE utf8mb3_bin NOT NULL,
  `subscription_id` varchar(36) COLLATE utf8mb3_bin DEFAULT NULL,
  `unit_type` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `record_date` date NOT NULL,
  `is_active` tinyint(1) DEFAULT '1',
  `created_by` varchar(50) COLLATE utf8mb3_bin NOT NULL,
  `created_date` datetime NOT NULL,
  `updated_by` varchar(50) COLLATE utf8mb3_bin NOT NULL,
  `updated_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
  `account_record_id` bigint unsigned NOT NULL,
  `tenant_record_id` bigint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`record_id`),
  UNIQUE KEY `record_id` (`record_id`),
  KEY `invoice_tracking_tenant_account_date_idx` (`tenant_record_id`,`account_record_id`,`record_date`),
  KEY `invoice_tracking_invoice_id_idx` (`invoice_id`),
  KEY `invoice_tracking_id_idx` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin

from killbill.

sbrossie avatar sbrossie commented on September 20, 2024

The workaround is to remove the default value (after ensuring that each row has a default value).

from killbill.

sbrossie avatar sbrossie commented on September 20, 2024

See bug filed on jOOQ side: jOOQ/jOOQ#15486

from killbill.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.