Ошибка неверный синтаксис для типа bigint

SyntaxError:неверный синтаксис BigInt

Исключение JavaScript «недопустимый синтаксис BigInt» возникает, когда строковое значение приводится к BigInt , но не может быть проанализировано как целое число.

SyntaxError: Cannot convert x to a BigInt (V8-based)
SyntaxError: invalid BigInt syntax (Firefox)
SyntaxError: Failed to parse String to BigInt (Safari)

const a = BigInt("1.5");
const b = BigInt("1n");
const c = BigInt.asIntN(4, "8n");

const a = BigInt("1");
const b = BigInt("  1   ");
const c = BigInt.asIntN(4, "8");

JavaScript

• RangeError:неправильная длина массива

  Исключение JavaScript «Недопустимая длина массива» возникает при указании отрицательного числа с плавающей запятой или превышает максимальное значение, поддерживаемое платформой.

• SyntaxError:недопустимое присвоение левой стороны

  Исключение JavaScript «недопустимое назначение слева» возникает, когда где-то произошло неожиданное.

• TypeError: неверное присвоение константе «x»

  Исключение JavaScript «недопустимое присвоение константе» возникает при попытке изменить постоянное значение.

• RangeError:недействительная дата

  Исключение JavaScript «недопустимая дата» возникает, когда была предоставлена ​​строка, ведущая к Date.parse().

Issue Description

We have a definition for a createdAt column as BIGINT in postgres. We’ve had the defaultValue in sequelize defined and working as:

createdAt: {
    type: DataTypes.INTEGER,
    defaultValue: Sequelize.literal('current_millis()'),
  }

This has been working consistently without issue until approximately June 1st, 11am PST.

Now when performing inserts we receive the error message:

 Unexpected error: invalid input syntax for type bigint: "[object Object]"
SequelizeDatabaseError: invalid input syntax for type bigint: "[object Object]"

What are you doing?

Nothing has changed on our end, so I’m not sure how to provide reproduction to the issue..

What do you expect to happen?

We expect the inserts to interpolate the defaultValue correctly and pass our literal current_millis() function to postgres.

What is actually happening?

We see the error.

Additional context

Inspecting the values being passed it seems that the literal function is not being run and instead a javascript string representation of the sequelize.literal is being set. Inspecting the createdAt definition returns:

{
  type: [Function: INTEGER] {
    types: {
      postgres: [Array],
      mysql: [Array],
      mariadb: [Array],
      sqlite: [Array],
      mssql: [Array]
    },
    key: 'INTEGER'
  },
  defaultValue: Literal { val: 'current_millis()' }
}

Looking into the code base it seems that there are some places that explicitly call out when to run the value as a function, e.g. https://github.com/sequelize/sequelize/blob/master/lib/sequelize.js#L1206-L1214

I’m not sure that exact location is where our issue stems from, but hopefully it helps tracking down what is going wrong.

Environment

• Sequelize version: 5.21.5
• Node.js version: v13.8.0
• Operating System: mac

Issue Template Checklist

How does this problem relate to dialects?

• [ x] I think this problem happens regardless of the dialect.
• I think this problem happens only for the following dialect(s):
• I don’t know, I was using PUT-YOUR-DIALECT-HERE, with connector library version XXX and database version XXX

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I don’t know how to start, I would need guidance.
• No, I don’t have the time, although I believe I could do it if I had the time…
• [x ] No, I don’t have the time and I wouldn’t even know how to start.

Я новичок в PostgreSQL. Я создал ниже функцию PostgreSQL и получил ошибку, как показано ниже:

ERROR:  invalid input syntax for type bigint: "expenseid"

CREATE OR REPLACE FUNCTION insertorupdateinvoice(invoice jsonb)
     RETURNS void
LANGUAGE plpgsql
AS $BODY$
Declare _invoiceid bigint;
begin
  --Consider all columns in specialist table as character varying and code column as integer.
  insert into invoicemaster (expenseid, invoiceno, transactiondate, totalinvoiceamount, invoicedoc, createdby, createdon)
  select j.invoice->>'expenseid'::bigint, 
         j.invoice->>'invoiceno', 
         (j.invoice->>'transactiondate')::date, 
         j.invoice->>'totalinvoiceamount'::double precision, 
         j.invoice->>'invoicedoc', 
         j.invoice->>'createdby'::bigint, 
         (j.invoice->>'createdon')::timestamp without time zone
  from jsonb_array_elements(invoice) as j(invoice)
  returning invoiceid into _invoiceid;
  
  insert into lineitemmaster (invoiceid, transactiondate, merchantname, amount, departmentid, policyid, itemdescription, 
                              itemcategory, itemtype, status, isrejected, createdby, createdon)
  select _invoiceid::bigint, 
        x.invoice->>'transactiondate'::date, 
        x.invoice->>'merchantname', 
        x.invoice->>'amount'::double precision, 
        x.invoice->>'departmentid'::integer, 
        x.invoice->>'policyid'::integer, 
        x.invoice->>'itemdescription', 
        x.invoice->>'itemcategory'::integer, 
        x.invoice->>'itemtype'::integer, 
        x.invoice->>'status'::boolean, 
        x.invoice->>'isrejected'::boolean, 
        x.invoice->>'createdby'::bigint, 
        (x.invoice->>'createdon')::timestamp without time zone
  from jsonb_array_elements(invoice ->'lineitems') as x;
end;
$BODY$;

Я выполняю функцию, как показано ниже:

select * from insertorupdateinvoice('{"expenseid":1,
    "invoiceno":"04012022",
    "transactiondate":"2022-01-04",
    "totalinvoiceamount":1000.00,
    "invoicedoc":"invoicedoc",
    "createdby":"1",
    "list":[
      {"transactiondate":"2022-01-01", "merchantname":"Apple", "amount":"100.50", "departmentid":"1","policyid":"1", "itemdescription":"iphone 14 pro max", "itemcategory":"55", "itemtype":"499", "status":"true", "isrejected":"false", "createdby":"1"},
      {"transactiondate":"2022-01-02", "merchantname":"Samsung", "amount":"1050.35", "departmentid":"2","policyid":"2", "itemdescription":"samsung galaxy tab", "itemcategory":"40", "itemtype":"50", "status":"true", "isrejected":"false", "createdby":"1"},
      {"transactiondate":"2022-01-03", "merchantname":"Big bazar", "amount":"555.75", "departmentid":"3","policyid":"3", "itemdescription":"grocerry", "itemcategory":"5", "itemtype":"90", "status":"false", "isrejected":"false", "createdby":"1"}
    ]}');

Ошибка, которую я получаю, как показано ниже:

ERROR:  invalid input syntax for type bigint: "expenseid"
LINE 2:   select j.invoice->>'expenseid'::bigint, 
                             ^
QUERY:  insert into invoicemaster (expenseid, invoiceno, transactiondate, totalinvoiceamount, invoicedoc, createdby, createdon)
  select j.invoice->>'expenseid'::bigint, 
         j.invoice->>'invoiceno', 
         (j.invoice->>'transactiondate')::date, 
         j.invoice->>'totalinvoiceamount'::double precision, 
         j.invoice->>'invoicedoc', 
         j.invoice->>'createdby'::bigint, 
         (j.invoice->>'createdon')::timestamp without time zone
  from jsonb_array_elements(invoice) as j(invoice)
  returning invoiceid
CONTEXT:  PL/pgSQL function insertorupdateinvoice(jsonb) line 5 at SQL statement
SQL state: 22P02

Итак, я получил решение для этого, как показано ниже, поскольку не используйте имя jsonb при извлечении значений.

    CREATE OR REPLACE FUNCTION public.insertorupdateinvoice(
        invoice jsonb)
        RETURNS void
        LANGUAGE 'plpgsql'
        COST 100
        VOLATILE PARALLEL UNSAFE
    AS $BODY$
    Declare _invoiceid bigint;
    begin
      insert into invoicemaster (expenseid, invoiceno, transactiondate, totalinvoiceamount, invoicedoc, createdby, createdon)
      values ( (invoice->>'expenseid') :: bigint, 
               (invoice->>'invoiceno') :: character, 
               (invoice->>'transactiondate') :: date, 
               (invoice->>'totalinvoiceamount') :: double precision, 
               (invoice->>'invoicedoc') :: character, 
               (invoice->>'createdby') :: bigint,
               NOW()
             )
      returning invoiceid into _invoiceid;

      insert into lineitemmaster (invoiceid, transactiondate, merchantname, amount, departmentid, policyid, itemdescription, 
                                  itemcategory, itemtype, status, isrejected, createdby, createdon)
      select _invoiceid::bigint, 
            (x->>'transactiondate')::date, 
            x->>'merchantname', 
            (x->>'amount')::double precision, 
            (x->>'departmentid')::integer, 
            (x->>'policyid')::integer, 
            x->>'itemdescription', 
            (x->>'itemcategory')::integer, 
            (x->>'itemtype')::integer, 
            (x->>'status')::boolean, 
            (x->>'isrejected')::boolean, 
            (x->>'createdby')::bigint,
            NOW()
      from jsonb_array_elements(invoice ->'lineitems') as x;
    end;
    $BODY$;

У меня в модели было поле с

book_classes = (("","Select Form"),("1",'F1'),("2",'F2'),("3",'F3'),("4",'F4'),("All Forms","All Forms"))
b_classes = models.CharField('Form',max_length=9,choices=book_classes,default="n/a")

А затем изменил его на

b_class =models.ForeignKey(ClassBooks,on_delete=models.CASCADE)

Где

class ClassBooks(models.Model):
    name = models.CharField(max_length=10,help_text='The class the book belongs to')

Теперь я застрял, потому что когда я пытаюсь мигрировать, я получаю ошибку.

Invalid input syntax for type bigint:"All Forms"

Что мне нужно сделать?

b_class =models.ForeignKey(ClassBooks,to_field='name',on_delete=models.CASCADE)

Вернуться на верх

Tag1 supports the Drupal Project.