Chat2DB icon indicating copy to clipboard operation
Chat2DB copied to clipboard

Bug: Syntax parsing error

Open QingXiao111 opened this issue 1 year ago • 1 comments

Chat2DB Version

3.1.19

Describe the bug

While adding data, an error occurred. (Most likely because of wrong quotation marks) UPDATE shenhetiaojian SET dm_term = 'gs_Company_Mark = '工业' and nvl (business_Income, 0) >= 20000 and substring(org_code, 1, 2) in (   'BJ',   'TJ',   'HB',   'SX',   'NM',   'LN',   'JL',   'LJ',   'SH',   'JS',   'EJ',   'AH',   'FJ',   'JX',   'SD',   'HE',   'HU',   'HN',   'GD',   'GX',   'HA',   'SC',   'GU',   'YN',   'SA',   'GS',   'QH',   'NX',   'XJ',   'XH',   'AB',   'KZ',   'UH',   'BT',   'LA',   'VS',   'CQ',   'CH',   'MF',   'WG',   'DS',   'NJ',   'XY',   'EN',   'OS',   'YS',   'FN',   'PH',   'ZG',   'GL',   'QB',   'AQ',   'HL',   'RN',   'BN',   'IH',   'SG',   'CX',   'JU',   'TG',   'DX' )' WHERE uuid ='CD2339A532FB4A0FAB2CA7AE32C77614';

QingXiao111 avatar Jan 25 '24 03:01 QingXiao111

Hello, can you provide us with the database type and table structure?

openai0229 avatar Feb 22 '24 13:02 openai0229