Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-38053

An error unexpectedly appear after changing sum(x) to sum(x*2)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 12.0.2
    • N/A
    • N/A
    • None
    • Not for Release Notes

    Description

      after changing SUM(DISTINCT 55) to SUM(DISTINCT 55 * 2),an error appear unexpectedly

      mysql> WITH cte_460 AS (SELECT (SELECT SUM(DISTINCT 55) AS subq_col FROM t2 AS s277) AS col_1, tsm16.c9 AS col_2, tsm16.c3 AS col_3 FROM t2 AS tsm16 USE INDEX (idx_t2_pk_c4) GROUP BY tsm16.c9, tsm16.c3) SELECT EXP(kqi23.col_3) AS col_1 FROM cte_460 AS kqi23 WHERE (kqi23.col_1 >= 95);
      Empty set (0.00 sec)

      mysql> WITH cte_460 AS (SELECT (SELECT SUM(DISTINCT 55 * 2) AS subq_col FROM t2 AS s277) AS col_1, tsm16.c9 AS col_2, tsm16.c3 AS col_3 FROM t2 AS tsm16 USE INDEX (idx_t2_pk_c4) GROUP BY tsm16.c9, tsm16.c3) SELECT EXP(kqi23.col_3) AS col_1 FROM cte_460 AS kqi23 WHERE (kqi23.col_1 >= 95);
      ERROR 1690 (22003): DOUBLE value is out of range in 'exp(`kqi23`.`col_3`)'

      How to repeat

      DROP DATABASE IF EXISTS test;
      CREATE DATABASE IF NOT EXISTS test;
      USE test;
      CREATE TABLE t2 (
          c1 INT NOT NULL AUTO_INCREMENT,
          c2 INT NOT NULL,
          c3 DECIMAL(10,2) NOT NULL,
          c4 VARCHAR(50) NOT NULL,
          c5 DATE NOT NULL,
          c6 MEDIUMTEXT NULL,
          c7 LONGTEXT NULL,
          c8 MEDIUMBLOB NULL,
          c9 LONGBLOB NULL,
          c10 ENUM('value1','value2','value3') NULL,
          c11 SET('a','b','c','d') NULL,
          c12 BIT(8) NULL,
          c13 DATETIME NULL,
          c14 FLOAT(8,2) NULL,
          c15 DOUBLE(12,4) NULL,
          PRIMARY KEY (c1)
      );
       
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (994, 3423, 181.05, 'sample_wfxp8dzD7XrFnPLzr', '2024-12-16', 'sample_pVtuVRHgHyCTAdMjTX5uDmgDFTTcRtYK4MA3VzWGhxyRAthAan095ltHnWC2wZqFzmNIz2BhrrY2h0fxo8UzijtqT3Qzyc7ydCZ760AbwzyWxKRhxPNIiXBNmglw9ylwoKoF0Q5QMAuWKKHLT07TyALEjZEq9SXDPPHZkG637npBmt2TKOxONpcXFVVrsW3jgaSAVhmwZMYON8YAyhzkhs0fsDZAohNdcrXeb43HI5de5EWnnY2lj8xyjRyfvWyVnBrhfeRiVnwUHuk0bcwoN3ueyVTRnXwQSF56ZbxUsw4hUmzUQ4GGRNJqlHOzrdMFLZHnsp5SamGZ0WPFJC1Vx1RuAnB5RdThXSIL8o2Fgebw5VIlETIWBvsuSQqrlbUxl0DbKa4xwcIiP23T8cVxdUgU4xKNvx6nab1kO47gdMcGoSGyXyvr23yKaVpjtw6XNe0uwE6zNt4nqZ1IMHxo', 'sample_oIxWhZ5PNoCnBUDNNG1t4uGQ80Jm3dOMyFRe0xsG8bqvWYFDuMqCy715ukwGqx4YD0tNg95vNkY49I1JPAbh5BBrcbTCYpkH1R37hDwaEo0Lzl91rc0tCeXUzOy258wzk7DX3Z11LNDgWU4awzLAAqwgg6l6QUVNdWbDUN3MQYXgivI8FcfivR8MVM40OIkt9fO8BNRyM2wTSSdov5M69ahQHUactc9lQyhXQfKFssG6OK2qKe2LIxK7FT1nHxPTNh7d41fB2bHcrjQ51tWpKJcLUFVVansOZC4fsvYKAamSAEMg3CsdHRNxw9dNCn5504tI75YCiAZT9DJEv7eTX7R07OJUaKE95P4VCs4XzftyMlVR4sPXkCsh7k7MYYBRd5d9iJdQLLOKXV3FUX5qjMRwF0oltoDkNGhVzUwlRuOptO8ROwzJLwCo5Zc7ce9l3bVoWQ3LsFymuRfVPQNPDkec3GZtAddEZBmIvzojWCpi0vhTzdYojxEdQwMHomRvrrYI7XWkrLrOOYwgMnPfHTeyO9oBFhEksiqIvbJHAEP2xCD2J0NvGcap1lZc2ueOUe6pJbZ95HmiFyRwwxMOxfLY4VCD5vgXNZTzeP0q8G0caUPPmLnaPcrw0vcnvR1gJnPdl8YyggslnNMOFmhPU2TK8EO5Xn6QVpvb6zPaM3Bw6sK3u10cw3i3jPuAYGSdMFNIdrU6L0zMUiI1LO4T7us2MUaXM', X'4DD6A6D687C6A9C08CDA93E9B48429DAA8ECBF93E891B67DDEBCDEBCE79C8A20', X'CF8CCBA2C880ED9DA9CF8644ECA5BD53E6B0AAED898E10C398D0AD', 'value1', 'a,c,b,d', b'01101010', '2025-04-25 18:28:30', 90.91, 53.96);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (9219, 8711, 166.61, 'sample_b7C1trecK6yntdY4x3tkM8epFQtYVnoEfz17wiJ0h80', '2025-04-12', 'sample_lM7ywI1JmA9kqk0PwSZZlxesXZdCBedJvwYKBw9dR56w7WO7DzbB1ZVsW2uBiEHEd2wR0zfA4sx55xrLO89GGMf4F2mz0UofYA4LoqJgyFeasOQ0xqixQuPntbtFFaU0qHyeuRqR7GpKm67SSQeJQd5eZ7q71APzN3n0zFxL9bC0jVQUAA2zi4LuWSd0Py4RHM12FEZBN1KuHU5ZozMhLHirnlRKFd0CHuHyUguieTnEjt89dxMMgaDrETZaKHVR1ScgTZefc8hb2Y5a2zsDfzRCQbzUBuZhyxWPDkLMg5eJaLJRAGHMN71OJrpgGZCWwFkmvr3GquST0vH8CnT59cLY9O9v9udhzAtGCiQXbwB5Lj7KzeYHgjKr8X09e6EGFI4JxrFhFkCd8iyB8xSq8NysRpDP91m9AphkU', 'sample_pNAzvJ4VjAPSdNguloV4eVG6u3SzZdFFAOuhhV8Ossq2cFdieqfnhqXkFI4LI0JGQzZWBzSMVDPHQn0Oe3Nv7stxdJlPAXt4VIQTYH9MOQAhXAyMAoxBstAK6oYPsTItXFJytGz7Oa1izmP5LLD6Y2iqWh4faPfdfuygrPwm5cfs0z0bRCMeY6uz7TyAS0YbrZIi7JkCnI785BsewYQPZo7xjzdS47d1oKj4EPSzrSKsyoWNaBR6C1MRljtVdfaDibv5fO9sj9N4QHy0lP29cySiHWUKbcoGMCWqTOmi2c65M232CKXKPGJ1miY9cIhuTTZD5hGQqKQ6uuNKIYLIoZJ1mXCoZyJ85k02lYVhV3E0tlr01DgEDkpaICmjNTzVw35Zc9sU3JJCVlWKLa83FtS8kX3lvVtmWq4G8OWgzaOQKt5dw0H04Ibqj030OZQDqmj15XiBFAS2nXQunJRD8Kx7EkfsAG7FfyIz4P5wqDFJpSKziR8OmR8TZLmv2EVQUltHdy45PCO2AXC4x1sIfP9dmQ1aiECO4ed7urHtLvAZpow3BBcK8VgBugkQxVFqIrXg3RaziUH5wl5DoIAzZmMowtn0Vu2ZpGH5Zdf0RvhFUlAck0tL497tGQydIpqGp9PjEKf6QUCAB3ls7R2XPJaIWyS9U', X'3E00CE8341C791EE918038EE949521C58A15D0B301D3BBE09EADEBBDA75BE890B0D58D53', X'37', 'value1', 'c,b,a', b'11010111', '2025-01-23 17:58:04', 97.71, 79.57);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2340, 3423, 789.64, 'sample_JtpdkPugJClf6wBGA48lgU0DFFQny1d', '2025-01-19', 'sample_7R6EMmsSUYkMz6YCdnJKFiZabj1AjoceqELoBIvttyuANntWJL2Iguil0ggBEhhicCIyajZZCbnYcoia8z8m2xhobdtGwkvfOFQCJYstbgEOwNRMKP3JikRrYTGn6M16dllazrq68Ih1EE6ZgTAYVDzjsMXfYMHELWNupyYn5JJzpScnf9xkHTtu4IoNR4WeVzHt1nzkrI8VhXULipuUH1s9gmSc8Pean8HlBr9tXw2vG5E0N04ZbCricxniIf4xVAEc7Q8n7hVRH58ZsdYOhX', 'sample_xM8sdczNil1Jx36fI84ut9oSzWu5SqPDfYZi4oGkTM8e8szvLvPuJJV7ufUcfdPPSCnEVvClTOLQ4ggZi8YxN1ng6wu8deYRQg0vff9LLvND8uFplp5QAnaMFC6EZqlG92QyIBhLAPkq7AGh2QhQLCJwkeeqDjm03qJP7KPQ8C2ih7t5qJlHej24Bf3cBjBUpvJBNH1DtKhxoShGleC1Zt4yYWgEbnSwcHJTYy039h9MmMX0N18zFK8lgYMF4dQQArfoRoaNZeCzjGwWjbRmljfJYcynB7lrY9dQOLUgXQYICgCpQwSEJOO5VON75FroQixq0lJqw30iNKPCfGixCzj9NWZ2iafZo21ODDcN9GFZWpmpmRHIw7K7ivk4gPoEg2Q4Zdfv6FIvQcHVBPDtGwHifLxE3wj39CMEieAxj26kkyPwW2hsfys6UpnwLrjgMtdHetTMoCiRMjtT1r9f61nrBFnTgdoI7JOVTv2dnoOzQkBeYOrpQB186iI7MhBiGCgsoDz0IX2xaiuxQvC2BzUk2ZxOhZLwcbVm3xtdGzyjHvNKevZWruXIoRpg7DOF53zANQRRQ4qFlPj9NySq6ejLvAnppkuq1YVk9zSOnpSAmNf7SRNXjA6O7BwwwKuzHfEafG7JnZOgoqDDCE8Qy7cgMc3vmnndIVuiqZOn5eRWi69Sx1rMo', X'E4B6A42FC3B5E9B69AD0A3EB9DA6EF81A0', X'1CCFA9', 'value3', 'c,b', b'10001011', '2025-03-23 19:05:28', 76.33, 87.70);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (4869, 3575, 142.83, 'sample_kvsDX71mAzReVmNhu7QiIsYUoE1SqxJ', '2025-10-06', 'sample_b2tJmbEH9Xv8uteXTPlST1X494SNpmvVq1720v7FGVRUf41HkgSGlHbdNDi7S4PUIH61lxw0fiBgWUlzJnNFFDDgA6rX48IWKuLWicZi3wOhD3YEvSyGCFy7AwHioanfBtXTqGK4lD0r9nTlUseyOO7YrWuynM6l757SbVZDUxv8Xb0oOHTMdwCulS7qmmYiJ6dwDSt8QGPmDvGMQXIrAThu06uVm5wa2nAg7bZe7OoPQ2VUbXtJKgYrCykTHK6eLVFYIs3tuenEamv4JvpqK9CVev7dtbHcvJ04YIv0VxGHElQwSDulhjO3xaR9mfyAlGK2PvjQKEWn7gFmNGwVVZzRNVV565pGEz4ozE6FKhKAxyBn49WCeouwUYI4U5DypiohZn16snUWj1nEMSjddGGGxgEuNFDzgAHV5ETeV1QTI7lxW1iCDJnsdkFtVlrBoaGAn8NRmP4sf3wbRIIGaPme4UPyjmFidD5mTclXdlp9RWJx6vAF96w6Vv1lKBEgcduQ78FXrzXq65hoRcYL8gzdvI86gUK5wRAGvsAzHzqlUNtEG4NWow3YCgwms0Tji0H7PxQKv6mfMrcAKIa6JXkpg0Z1VMBE8XNVm0Dvu85YEVbkTh1C05CYCitNZGSMD4d9lLhdCCdHAKPfEpJIjiYdRxB5Yu272TQDTdm7TEECixCoM4HqKgsay6q0ki94LgLat1M4iCoEA5znZuhPeBkWKINW01AMfgU7pPqhZWZKKapcNYJ6EqpuHP0MmDKcsx7bDd4dak7NpWSjG9pZ1AZAqi0eUgNaYPRxVD1kuRV16GD9Q6djkqwnhtJJOMH0iyUSzy', 'sample_yNZHZaFHLQgwQWXReALBSnzD7MedQ4MyNNoq2IkJcCBII1LsMJOxWnghWPoV7J6OioviMpRvYPhL5nVVL4lMipjQ8KMx1Nvb8lnAecdyZI4wjhOrsfTycULPar8lnvNq8LtqlQLIQ11yXh3m4iQmRQ02IE2j58K41wh5fyGhNz9TrpFSJhgNx2F4ur3QdqtXHwaWRUgUdIJoWoxmOO2VbaitXDUbHOuJQ5tIYOI5pGckmQ0Vvm5HcO63qGRVcI9dRsffTbVewbe8V9ILyVMVsGPLZtM6oSvbcJHmMHjQ5yeykw1xD4CXVPQ0akzZ5efk2xSWljsMPMMipqvWhxZ7bJAKQmEjJlqQxT2fpipbyZW9cQP8dPZJnENYgzbS95yIb6bfyM8W0rGKrfPQuouljwPS59KgjnKQnfoZhNtO1E1xPe545PknJFz54tjlBWrXqZddEJzhIDImuOxoCUA3ufUgW0yGWatfRF42ezcOZ86XAA5RBVGHyvcC81Co1T5HkOXKFt8ezOiJm9NJL2oglSgYmmWeGusXjGlfW2TZsZ3wIiihLAzhHakzBeNRzHkMDxhTZKpMh6ffzCbbx01w7Q39AJq56cARqTSVnezmruYNpbolbJW80TmA3HLre35IpFzwWXAnskRLK3pK0n2cS8Me1DOEdex8oOjt5xexovpSDTXjfP0n16NKfnN6mktohLiEaSQD4BX2TUPK1Hq27ilJVvrgWGmMTBCMfJoIs8slcahobaEaHenTQf8z7fFIOKSxf7Y5KGKGxRMYZ0eFzWqH93Vmxy0HQqZdrn3HrDp1FzeL6B7Fs414VEVG6MmXTE406DM4LprcOaIBfWZjrZfix3MtWhrTH01GQfjDEXnrmDNoS3d6CjLcfrXDFtUGVkq0JZgnGwt1xMimL5kLHwkdJstZfinf7u97PoFqQfLWpJB0YymynZqiMfzUW8Ob7JWu4KbbsnVz6G4qUsYgYSY4wxPKFfXH7ZfNamHiH4z3AQpGQzEX5ndr1ZwNNDKQzmGKbajKJ5UFeGqNwkytRDIMQdf1f6GxRUYtKYGXvrB1a0U3atr2OuWQAw2LqTbEBVlLAaEg2h8uuqsCB5LfG8NCk3vnHjQhY7IuNx7NAEFByTHvowl8WYBhKfkxzaW3i7S9sepXb18okFtcmBC8nUMJjSU1f7fIsQMBgGJaa3w9Zrl8gVk9MtiJ8u8BjelfqaXb3kf6obkJOfTdXtscFpimU8vuzf7CZPq8dTbAkFzLGbIyNigXiKSK1fAzABEn9qowlSmWstEoOFrK8YfK3k17ZKdrnwBOaayXyS5xTOPZtUniNo2xA6Q9kRcLeQt5pPxqxKDsqYTj55Q6tJ4qAkcGx5fGnOKlekCaOCKBmmz2kXpdgw2Oj1nAKZDD2H5sf3Ft72qE0BtJgmmrONar7PQSVJoDXiTG1IhN3n5OdW9XzV3V19Wr5dGg6wiOiVCyfIBqBw0QOsiA72ytK061bEPeMZgVb0bIJ8baepvqsB9PSas5AkTii5hVyVPSyu3gbzxWeomK8v0mAru84wOw6gWCvtFwrtb2npkR4acPVBFSgSXOmkUjS16uuCRHlePnuXlU5Ui0ZBADCbF2UnVB1Hln6oeuIe7udCnV1NUb9dmiOpYQjpnBEntitZii9cdh5orHjYzX86R2SeailHTHKlsgsnItuzhPfsjGhYYp3NsNQStB', X'3D1AE4B784D7AC78', X'D5B3D18ED3B57BDEA87764DCAFCB84C5B8E3B88A46E09A8574CB9AE8B8BEEA87B1E4A8A4E9BF99CBA3D68DE896AA4C190F', 'value2', 'a', b'01000001', '2025-06-18 19:15:19', 8.76, 22.64);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1830, 3584, 983.64, 'sample_dPiBN3CgbQXn', '2025-01-31', 'sample_vmOgQX3eh6woZTt3aNV0fq55qjVrLpBVAAhaYvNBYAeR1mA30XaRZQYQ1kgy7z1QJvy1MLc64QYNI3hrJIOiiAL8W28iE3Uoomv09eV058D9YoVS7FvIga3h7F7PPbNfpuau6TMJ4G3N3nsXvhTUnFMUsPsUHWucmLkAkIQvzFL1oB5lmIB3rDzeMTjb5eNsaZ7mQM5JKaOfF4Cu4KRGWC1J6ZLrHS92j1dVUp26mUdbpvtguGJN4FVCQC4fJIOuVO7Ow8nHq5twCWPfk1YsEbNQS3bXgyIoxIHhq53ZrYtBK9vJdgxhCHEDk9MLzEQeh7Ncitx8dZE8VoyW9MszIqDbwCg9xwen3ew1thD5TTYJocixCkAVygjivHtZu6yJnOGmxHpHRiukcd7RnLjdLR9RSsygMn6VRjYLQ5OxQayKGziX8Ob11prqFGuSnAKV7iSC8P5n5mHiQJKY2SKpFzKNdh7WMACfMv3pw71xtMp3lsZWPcg2Si0QNJJ768Ce98MY3futDqUQCUXL3WzItP8j31n9ajyuV2Sp', 'sample_fBGXCMkcuMzf36z7sXefqXGSwAUvNfnLCWdDXJyjVWrTr332CS5QHzxFzgcozBcYg2IFYZ3Rx5b1Ux4IVNWqJsG0IqDrTgNaoPYb8NdscYWTDmad7QMYjbpptk8rEcM5hLT2a5VpFpie8ZaCtnMMpwr1KzLmfHuCF7mXKGWbSRFcM9ypn6dfFSgSBBiiFDdtWzMrvREzGvhEF6T68RYH8hMzubRsbjsiSsRHAhVoYGLjC8WttHSiCm2Oc5cnATjNlcuUCPRTzDdMJEG3WCG3GLi32iO8dk27EvmqtMHZYkxop5wqz6zixVJksgoJtPJhzDt39jmwHIHK4dRC1EFFHI993mo6j6kxqJWkMe0hcy2Xscn51f5IJutYIBtXSTpUlDqO5gCfzDn2RASPkIDvrvgjMJ8zgi14HsW1lqPtAUxjKiHvIxc7TtWP9GTJxykRPaH0jzuTm3Jb8cXdljFym31gz1GpIsyzxkHEwytOZE0FoARvB0d5yGLhLk8odFWqS6U77LX13cCJyJ0vFhotTUkJib7lpZqJZD6isVywt63hm48jVdcJIs0RpU2HpLXzMVQl0m3oL4PFaSfeV4aCx4JJCK7t9UNNTQy9Bq4dusSgJHcT52ED1xkP9fbvsC93fOmi1eopUBs3mKAYINbE2jVPLDQoNcbVb1C0u6UaxUZJeYBmOmhERZcUlvb6B4SoXGIpnC3qD5L7jJQAGyV5PzCLOJsZL273wzDjXaMXXCjMLQQrUEtQBgULvnBQ2gkgoicoPxdtvrRC4a9pRMxWnwddO6nRYoxctKoTk6AN4EweE9wZgLFwXHNI8nUVbHi4RQg57VBTa6Avep7CgXTevBWoi8LDmJVFIVBPlYx6ElPW5ui5oc6wun4fZSJYWOhVn95w9W9depE76CB1w4ZQasMzq3kvE2gHvanB3DqiwYPtqjIGsxIPxfdE3B1tnOi4SmF0PI4i5lH4DEZhqoeTbNSWGPS8DrPp41ULYzltRMDBO0B0CaYMXCozxqUdKd38wUbKV8NF8qKKySpwRPkRrjygPkb2nQ0YFxwVS4HD1PyFE61k7XSYihVJecNf2iqDka2OX59DUXloitue9FWIuy7NuXa7FvT3ZFjrwDtWmS5SW1rPkRrl7k4j4k3jcdeXDuNTBz0VqY8wSgSPVx3pCCid90xvOhPzCzl8gXZkDJrYxuV0ViGaFDnphNgC5PTfRLopufAJrrXnouK8Q1JcgTwgGpcD2uQGjbf6CA8jUCkigOSDNF8dr4nEJfDclSn5borOR5jy1kFMgbzlbyXUI2b1TaIdkOLSMfL9dBIDJm19KfItM2qwVwIiwGyOnUn9i38DMJjkBXgee95evEKPyCG1eucwgIhTWWXEX7X62PtXoibUAH8LJFt7PRrAh08b3057w68coqJvA5Bkxp9RkC0XIPxAp2TZRJVyOQu5w4PVsliBC9NYmvTfUTq2K26rj9oHhUPcR19Ib1wf3Y4w2UKl49InpPEQsI7mj1P7de8brlPoTTn2xrNhJwgpnilpL5ttMxgXpPDmAXm4Jr53lhf3ZJ', X'2626', X'56E794A953CFAB30E39CA81DC98552E58B9D74C494E5979836EEA38EEE8C9305E895BCCFB465D49FC9BCC8B0', 'value2', 'b,d,a,c', b'00111000', '2024-12-04 05:24:10', 24.29, 84.91);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1159, 2015, 785.28, 'sample_hmgYY3osvIoyPtf7x8JCxaEg4Wrld', '2025-08-04', 'sample_maZ8HwjVvqPV9JUAqHLU2k14jWaUj9CZ33MuEjYe1JYwcAuN949ycgRAJzXz9pwy2UClE48Rfqw05HOnyI5t6dgsjXYqGyIL5gXN6d3OngfqUjLas1Nk4J7eUtFfBdP9bab8OOvi4qXaGweeWK2jSt4SWsPCfeBcynBHCemiZL4qlvv6AjRAq3MJuBejxevV4Pai0bYwmWGrjyPAwyqAjIwFRN7Wd90eIhmRvczKl60nzHmXDzS3OtyiQanMKG26QhMp82RYKxf0L1liqaC2sVBwh8Va1u0Kskpq2QXqNQWWNU25tqTA6ZliMPMSkDCDFkirpRzfFuSLolPwsFzQpJEoAbSt7LhSipjclYRyBv5AD4Qa', 'sample_yPrgJHgSEFM4dVCTdspg8j5CjtgTCPIOsesjXM32XJLmNEGXMQ6WfH1do4q83xMByYeZibXejW3zSoqwFzUZpY6wlDa7sW6A4gYlGKRq2d4doorSybFiVs0cQtvi0gghHLCCKAC0ZTRo92AFzXJiZcxMjkYjKSImASBQaw5sPoTNplp4AZDRhiGGRkej9urhBm67RLwYuvpcmWNmnwkpcu2hseG9EPLhMw7ggWcZwoS3ekKHaRd2tuqXR2n2GAEAV3DBdxnyKUi8VVyV6JF3uxmJSkO7hsr0FpWBu7A5Hy6ZaEg0x5K5IjUhaeqamsvMr4yNNorW1T1xCO4QBzh7D6nzM1BP8csASxmJuMPi17WfeSMhtOUHgRNdpLkatedBDp74jc5BRN5eleHVtaPSztRHv8VMTnvNfMbjONa8iKAwZiCcfwMxwQoNsUdNbvfbO7oVM2JbECgolMegZvOR9IHrqKKwXM5D4a2P9mJy0mN3ul6A9cM33gVAynHN4h1g81KZv0b55mGhkKk1IfSHDbc5D5mp4QQsckks4w0BNITiiSuO6PMVmlZ9I5hwrIxDUyPVaxinkxsBhP5EGNxKrwiWChDSTB5BecGUjk4jinFwGWYAx2fkCfBhKhgcyWvlDTutfZCI5HS1awiatwkc73zdR88wE2ssXeV4IrCQqd2jE3waj6LTbPam2XBTLKrOBMa72T0bDwL5gJkIu2j5mB0P4HlvGwKjmcBtBolPcevr3Cf9fE3nDphHExAmlaNfyAnTd7DQtApcGG9eabZfA8bqUipCYf1P0pf5u9DOuH6hfw8pVs2JSkkDrcwe61RbGsONoZflQtqXacqdil0kgpDCne8JBfX3LZt6RTGPMPqtIyR58WNYHTsozw95XPDvd3yt3I3Yi0Cvv3xZyzmtSO5PzdGHMgxlNUUJvsL4POGXGCmtLSthSWSXOujwKTSyESm41E3VPYMcGW25SxOFeXzui4ubFNGFxFgW33vVBpyTbeiWIQ17FSiMK3wzuQSmlsykE0qafY9C0vf12u7W0qWxuFjDxM7Ah39BK9Isz9eX55e16OWO1liV2Yadh2ps9fKAuyncWGtIo0FJBiPO9sNGuslJrpH1RJ8Ni9kmrmDfdzpE9H99Q3dat7DjECajFCd3R4o5tpUhLp5qXjvWCwfKUpZAYJz1X6aLU1830CmtTn2xazDC1dq9go0NN5UvoLRFSMGQM8nrDh94v17rypC8YebFvHYdL1zAWkiJj71FdnDtPJMw4cfHNEW6NXrHtUCMYgputt8yxqXwg1yDyNbuQyvv', X'D88EE391A9D2B3E2ABBAE88C96CA8B2CC3B0CEB55AE89BAD54C59344DAB4D085E683ADE88CB904D8B3', X'E4B59EE9BD9BE787A4EAAEB2E983B3E882B8D5BE205FC583C38EE2BDB5C199', 'value2', 'a,b', b'10101000', '2024-12-27 17:14:38', 71.52, 85.92);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2120, 4556, 261.49, 'sample_72', '2025-05-08', 'sample_RTCJ7cXFqP0ulTRDUhqPaKaF2U0BUELQrpqjS19OjvN68TBJczxvT3jzyV43orgINYIpKrOpvUJZfKcBVFMGj5m7RRSe6kZM16DHBePxBgQrbOIvW1g6ObbbCRc4D41D1POH6qZqO0YFYFn7oqpdOqhQhYDQhfQl3WsVe8cY29Y95MveUIZo033Em3', 'sample_juw7gwm0vysGzQpBNecGHDEpYpZw2tgwPWIAdLW12JZDrqCggcmeiD1PP3ZsSFAz2uKQj5lFIxSq1R9Qio8TvQja3Up88Y0DsiMBOdt5AzCSKi69EVM7D8Acjn1WChSSHv2UocFzWiWq9km4s5jSr4q68l2vkKEksJfCDAmKX8P5ny0EoAaEWLQaSMtSiqe8sFeXzbgkcBnX7Wj0cypo1udQ9O6dPD9z5ORPk3GS9e432CFWm0ifkaQ08uML9pGV3TG0UyZ3TixxLcjGIJ8iO3eNMGq3KvADaLHLdZygF0sq0Pvas95UEtsmPpcxGUYGRFiOnJIn1rS3m6cdMdVXsyXVCnWcxVTOORIFJDbuvObvy9NH2qv4tDsKBwrZuEXEHEA8Z59CTjkz6dghnnIT3Asj0F6DIIUvMXOBBZ4XgbBYlTRaL9FZEUjjTE4oGEM0DYtEt0563odYxyL9hsnjP0w9BXpYUGOfXzqyD4b4y0RYFkAId7JXz8FgKmbaOaVMxnlPQvJX9GUemeIR71NZC5Cv6PdaFXVbMVwrGihcgzdFquQ91VzRwCsIuYWI7H0jfcfK5IKhaxl9OuoowEqb7cKNKwha3Kcdp6uCNQ3Pc5kmTEMynkZqE4dvvtrKVCXjcAfLcY3yI8sAkYsDrVwsXAhZaICKFEHsgYZAQMZBSNfOCn9k128vDeFoZYK9ClUGAEpcZHGEgKCNMJ7A81Wl0yrzN7yqPqq4yOGOruqlZPTEtbBjIbWOyzOy8VBYRxrOKdvuHrpSJ4Q3w0kBhTTgbI14SauWLQLbKhM5NcvcxBTjsW3UDlKrhzBO42AMtzoTu9imXudn5QyTLGRRotcx5vuhoSj2JP7PxhN4tpBaBytwYy4AYmsnMuXJA9cZsFZIlHvp7f9B1L4pNjyusv1ogFzFyYJuJUwqVcGTD2a6vEOecSB0zpLx8FX5O0tP9f87D4zzQS2kmDygrKGCoWG2GvjnJiQMz0hHQknn1WczXD6GoScT0st6X1UGr9UuwoXcQHkKTTfz5b6ToksdIkUqTMtAy2EmSkcm23AlpViGOv1bD87wxenBA2fRETUISIOlYjJy7YIh4x1I46V2o6HLCYrmjg5pzvROd4GWFNqXGsLBVcQZ44KFKgPp4QmMmGVNJiS5JyrUnYKlijFb3tWR9NgjMy78Bdlmpb00EOVl806VgfgNoIdzjra5zuzTNSDWGVz7CNUteBfRJkokT3CL6jMOmm', X'E1828E34067BDC94C691DBB2DEAACC80C5B6EF81BD3AD3B8E3AF9A04E8BFA0CF88E9AAB73E505FCA95', X'D086EDB79AD186EF9791CBA146DEBAC7A1C2B4E284B33241D3B2EF8A93D582DAB7EEBCA6CFB7ECBE98D186D3B27350', 'value1', 'c', b'11111000', '2025-06-03 05:07:18', 93.60, 39.50);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (5257, 9502, 828.25, 'sample_sg5dRY0qfQGNRrlBB8LFScbTU7T', '2025-07-14', 'sample_kqqHkazplz5juuNHL44afvEvzmXLFW3fQUY1g2wOlzlgogikrfMeqxM6NA4VSw4TL0piGggqxmne5f8tjq7tdTwRP2aUoFYvWzSRMdGZVUZB79WEtX9EBC537CEJF83Z1xbJ6DH5vf5QQz1Gye6gC3LcU0FGrVWS4WhHum9Q0glbbura0on8T9LxXWfPXAkPpN5e0ODQxDBDHB6JjrEspNrLJfhsKahmIaDOXi9rojQEuJ4WDpklEOQ2yleF04ExuCGAZk1u1KnPDVpTvCoHRKk2rXFJv4MjyeyCGNny5AmcJAVs80UZWr29AZxMcBX1yZRerhF9D164jvm4OrzvW5emQm7in6mgp8Fm0mbv9cxrTRklCAiygWPWDfJYJ9pUT7ZSRul9nuV0rAXdEarD7ZsPL25TPVjJL8otVf5C43jtkeB6ZWCE9skgeQr3HeUqCC7R5WD1QasubjdlJhQO12sV8usFIgrVgKB5pKKL2AfR5kzDUWSIvkCHYcW5jLWEiR1q8ds8eOv2xD5pBEyueYpxFSYioESVXn0AIV2OHGGHPwlHOlpVfa3hEkmJJF93twVaUqomFoYpfR9fOD2orEnTJ8vOO406VVqvy66tBpk4FZoGp1FNetTkBiHql6uCUuGHVC4h6uBbYxYW6xpxB31X6bFD00nvlLivZbRJWPsstrRqS4h2sfsR4nm1IDqrtp81vs5wtgV0HqC', 'sample_4zfgMbIV8cozADetsWLe8bEtSpJl6kaynIguwHZOF6V9UFfrlkHY44ZXYgGEVhMP3DF7ycEK29jlqLWSE6ToByikgyXXJxNSmpldnaovqJkgbrSSga0JBZJgKve3s70My3hBGrzNuFJyOcSRqPT3aKu1Qajt5MXt4ds2FTIyySeo8v9n8c5spsPvNhjSXUEYr4b2vbxR1u7JjAYk3VbXHM1JaAegARvRBK8Oeb76mPsJ3xODaXewtJIX44LA8GK3v8TeiS0XwoqyD0UF84Acu0ugTwe5xD1ZAoE9rZBfTHOYQzsBzCa2VUJTI4QpX9PFvZCyBjdLbRN1luOLJ0ZAMfacNNrEvVYTQc8hjpqMqDhdNHoG3dx9nu7au8u14jeirlkiLEe83JSIOnpDQCuYsaBvyPUOFL0X5j5j21kowm4NM0RaliXDPMolwxMgh4TuF7aKXoGc6KxeS0qjSa9rvR4SmkVzUdbyeaKcaS8ALBpag1REg2s0Wus2kc9gVmY6kPtUbDVNwneD9EuSi8yrnU1iGUPRBfSoeaJ1BHesMk9BdMYGfWsPb3RkdepnENwZzkAnEYcqE2jOL6re5Cpejwwz3QOfMc4rrBRP1Qz4sTC98NJ0pJJ8XvcPY9sdCapQsnHhPTIFUsumf3PY60rxsZNa7M2LmuqF8vHE9yi2LYtV6Y3N6UUwcvki2b05AwEIZPGT5TuohrQV5jW9u7GOxLFaiTBHVWYeoKA5YbuXhynyKFOXuyWlPXWiBY26ZjMnRfoPOulMoXubH4VlrwdYL19shOtjb0P2tk1UGx3Ez4phQ5FoqU4PiBEQMF5kIm18QQ7X7KzpkwTEu6pkUSnJ1Hm4VJxspEeVi2JFyFiVdxbFixo7J9nm3znGK3', X'ECA3B5C29CC491E1AAABD99473EEBCA51AEAA38AD6AF0102C598C6B9DD8BE79ABD4AD9B81ACE8EEE95A928E180AD', X'501B64E88FA5E48CAADE8FDF8FDD962809ED8D90ECA5840BC78FC69DD69FCDAA17E187AFC6925EE3A599', 'value2', 'd,b,c,a', b'11100100', '2025-06-20 16:23:19', 21.92, 77.33);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (7590, 3423, 165.61, 'sample_C', '2024-11-18', 'sample_zmf9vZuZbP7q0ULMaNqvC7eJLjzO3iyElpsLYUPHatI245brwY1MLke4ZA5OzDeg0tye5tXKfkgHdk87kK0QkMP8vuzRErGRrkConochcLIDMTguwXbt03E2sDr74Dsty5y2cTex5Te8x9SHkW1NnogIf3HVu1xm5uJG7iEIWnyW8JbQYBOvfIGq9ei75BHFBJPg9L5ktULUOBmyhj8NP3ia8QiCfR0UiB42v5jzFzVQVAnPq5n8G57ufyfWBkoXFnY30bMMf0VCTIZWaK4B6GbKSH9WKqLtMowbRzKUKnh5XIprB5c2YhNK1fWNZZTK1XIYZWdhzyjNFwpgk7ErWUAVKbg5Nc7MSbqfkgnun4bYMJkISGhmnSYTPaoPqlmr2ncRxPJdAgJSbwQHBt7fOkkliogGe6RbQbwUdKvqTFExMoP7LlKTR2xKZFKVemvzT2p4iVd4oMs9u1S3rRX0jXtGrOWdCCLXzBMIa8O9yIo00LJ3kVmPmysZV0cZumY9EcAX2BzkZ6E6eaVuGWwyEvc8lbUo5as3UzKtx9iFZuIXrjIsXq6vyhvpMCDQnl0ZDD4DkzKuMVHUqmkHMsIQbVotrAraobLTGzSWJLzNOCiu9kWX7Jl9SFJl3zbnyIhAd9y6EnVndZafAyYGbsFqUZF4KYETOuhDeg2HLw3m1eTg6IlDMgSBt9KkqmqWP2xKvpX1v4aNHM2MNcpoVw01SYaEl9hWr8eX2YtnW3Iig4eXX3RnC2GvxYLdKMIu0seIeN3vpELJ6fougbRngAyshjFoUt1ZTiD44S', 'sample_M5hp4cD36t2CxYF4QfH8ZbbSoLgO9F80JGoAkQYGfDhphQ8UAaSGe71IgKwOLbbuzAkp4XeEwdcSZisGkvBPBqXpzdQYwqRmZe2NcyHSp1VMF8i4WuJfaEJDdr3PUrldtVZF0L19QQmwi99dXlXqylfmfvmsTjDhPjHEQMbY5fpLhSYGHwyCWZZ03NqL4H85y9zFRNb3ZyS9yjMGXFhBcylgcHG8hwgEacwJanQHp6bTAoJMf1AC2PGfQ6zEY3w71VSLHW9SiJ25HdDhpMaa5nXbBoCbUGez9RxZIJXjcfswqCF4OFrpnsx1G9UJn8OHDdpS6r9cIlWdtD3G57QmwPR4ds9s5vjA0R3KtCzoPlIisR0xuRA0pJmRb0hfIKH3EkYeay5iEeZ9cwIRKVr9JFGRIYmeZzABAaCvJpW7rNVU8KSebU8SXOlGrcebGAqFME2X92s2mKozC6NhmkdGNBawS1EsZg4FaQbySsmofIQUxc7EbJbLDcIIkV47pj5CgRTNAOKm4ibfOYPkoGI7agnA1OWOVHkwfolGinkO5O08xTl3cdDMX6N56zXSQPVUo8sOVJwtIaZCj1j2FZstKhJ53hzMrHmx8apAqnxBTUqxUhhXzlZNqgPmtvBRgt65mdxRb4XfCTdaMFFtr3qZvIJJH8DfYZYTsN6NDyxhlOycqdFKqzAGkedVp2GZJCaF7FSLotx7cwk84T5ZaFqw2T6BxWDQYIn4R6v1ZDBe81cUUYMEXsoqoDmymS7g2a64jGOHu6iq4b59km5V5UH3RWfpVPA9ebRNqEj5mV1aqLaVJSt7JAqNKqW5QhhbFmjkPeGLkAWHsSgl1gBRepTz6D8xwZvb72h85ixifFbgprki3WlOVus5w9EHxqtDLL7u8Sd7ic4ewuihdRanB71LAdNda3MYFEDJWyUQMl5XDmpQ0X3mLE4pLKdDLYZ8K1b71xVDF9VV1Fxnpzko7RE7wTL3CpDoT7JG5dOKAvyTxNjgzSAB06A8FuYCaIQzwx7F3ErnzTUS1qKxLHgziNyd9kUZtf3HuUfaCwMNvUcWe854sbYSc541JZcM2zMAnpWHIECDUmnJGlHF1PKA6YMpbRgJg69jgkl5oIUazjrmFvPCNWR2I22HI8WXzop118a5ZBJQEUf', X'E487ABDFB15FCA976E3671DEA7E38E86D8BEE49DA2C2AC40C3BDC58ACE86', X'C2A6E39985E99DBEEBA2BBE385937DD7BAE6AA83C890E085B017', 'value2', 'b,a', b'11000001', '2025-01-12 15:01:30', 80.10, 0.11);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (6732, 9828, 495.72, 'sample_ZSJkvPpd7UlZsV5oAN3rqd0Wud0e8vWHjulQ99', '2025-01-11', 'sample_mIfcgdgeVaMvE2eCmDKFn6ArGsMZXi41XA9yjTiJuHWZI24kqO63scOpgdX8nQM8CJTNxG1dOQ9lE6CFyIkSzSU94Z0Ygl8KUcTae1nIzwnFki8HT8S0Iou1LFEq9pQPMELRRweFSS0RU0zsySbcIdFSoMNCk9k5huvJS2KnunkBGP4BgQS6muwU5eE4PIlVvPPUH2N2gif17HepJCezqJi9MwC7LXbaH6LANcO4nqQUVOy6ShWOvs1hs7NeKqhujo4RUr4iWjW70hqIqV19KVDKXHfM6SKYg', 'sample_pZ5FOivQ408EqlygQmOy96Qw37Z5MLm29pabROKaVlQyY6RuMDkMLayG8IZUtXNDwyYjKPoeSyD4LQHf4knuF7lZ5beh1DRleIvKRpCqfXwO3fj2ctMeUSSBUSz20ZAX6oltajmEdGKgZFYAj2d9PpTEQGThqgrerUpetzlZytfktq4U9Fix9xkx7R54geDXAf1zUcNZbcPeehqEy8u23iA9vR2BqYqoU18rLMeMtxhYBLTLQzSCAzTrLdvE71vHzzY0TaPRW7Z9WLlz9jqHzLCQ5HAVD7Ksiaa0rPtbjVK8ck6m2Y0H5MpVsfLd8sh41M0ridafpQo5FbwUPCCHKhdFS2ddJAM3GhtI7W8DJ0pulQLTDdOQCNeujqyfgfktqbz3UntrQckg25VLrFHCSs44oscCmilX1nkvKtexkuIiraEQXgB0948O9UxCYF8nHAgIXEYnc41IYEhhqhlTcbwVlLAZetxdg65kkrmmvk1cUxCKihGO8AdUGbRNclYKyMaZLQSAqWkdpsHAJ4QmHxRZ8lAYSIhXYxGRbReeKvhHkGL4HI9tidnfPAzlRvWimWmvtaPVasb9HTuwzaYabRXvl0ydsMAg9evorRFPy1tNmR4qHjOZESvqjGsABp3u7inH3ELZrWdhDRLjhHQTatLhhfnlPsPKdsoCP5UfhlamSSC6E8vceKgU977iQ61bxiREmBY2gNMT1o9HlaaVHArQiQ1M324oWav3NsdIK7nLEmkbOJEdcE32tUbUeJGAaNtopuDsixN2DQNsTsD62VSxZ8pyvZVnIt1MjT122krugPwMUxkFiK12pPeV1Utpqi2XYGjOMAL6mz3r8oS0bCyl0xCscDeGprmi388sLnvRcKs7oi7pj34UpveDV8pduc3xR9wvLg22iFLS9leqQ8zZ7clo31GDwLiT5OS9fSOUd6jdGf49smNbRXh58isqDNszMtipc0VkddkbhkyUeiDUiMC8Xv9gc0KmPgTiC7lAXdtwXO4mz0ZZ8WRTwUmg2sYEugVBncW6XTUnRWiUPQ34KcLwkTbsBDdZcGTlxSyVhTrBbUPMkbv41jRMlzMRXA1BzZrZMtaao3vZrk4SjfrWuuRkr2ryuvoo5BDVaObITjEv6', X'C2BBCB9AD781E59F90ED9AAEECBABCDC96E2B49F6AE49A881345ED86A1CFA9EFB98FC09A30D6AFDE96C4B8C2B0', X'D3AD', 'value1', 'd,a', b'10010011', '2025-04-16 17:49:41', 25.70, 92.21);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (8014, 3575, 919.65, 'sample_IDzL0l6rZ904m0kemHu2uOzm51Gv9h3XZSMRj3FRi', '2025-10-20', 'sample_8qPQ2BZP0BiEN8p6lCD48kaztfPQyUUXwVhtIasTUfAheOctRYSUtMlswudqv0N8B0OcBKcs0OjGy3Pm2SjwFsfkMI3PYZnSLNr6P1sCFxgxA0nFjmmXQ9DPrPslGKrxUT8UYKUU0kZ7Fo7XMIzVXZGVLiH3cGpUx02wcRVBytSLqN2dETE7TCvEwXxb8PZZC0wfYNL6E8juO7yr2k9zxI7XKQZwQU2IpTjQ8VADdRrx0pe7Q2Lka0vvVs88e6i1EZ3bm2lFsWjsAyG1xlocf7FkxpguKq33fGv3Iijzflq0l2kJcUJ86V3eZhMWZKookaNUvY0YFtw2ZkD9SAJYIuqzDqhX8MoS1iOQ2fEJbl1vP9JIDCQf41yLdAWal6maIc8jFHzDuIl7xAuIXgnlifpGx8jdWC5BOShWZe4L9smHdVk8tseBU1EdaPHFgeT2KBqgg0yMQZnAkRHyktpIugyK2dSrDmONBDN6OsQQxcDdPzwzaJ3w5Zgw91CmxIZbkVl23fpHxnbsJuncE01JqM9vOtF3i1F21NthEO4tz3PfDkXtlUxeyMrJ0SFEnw906bcxqwDHbzvtQS1ksbYTAzdz5lX5d2iLgVlk0lhIecQgn4mw0wL81niYUwSsgNBN77IDGwNGzdllhqrA2qgdhrzwvIa8tkUUmcleGxHTrSweP8l7fWp5IWbDPSs5OqSNmLFs12FtH0N17Nypozwdghg2VfMeCTW8S9I8jt0OfaquneyvMDNQ1NUdQqWjsKjzA6Td1wcp9eltJyr9Jw7FNXMlfGr7O35obju8iXCZ3zhD4HJtqUPpgDciV0cv', 'sample_6vaPS1NEfFGP9cAvKDomE3dOEGlvTNFm9VxQ44iqPbMAspUGDF5e', X'C7873C', X'CDB8C0B1E08A8DE59B8AE9BAB1EE9C8DE8BF8DC99BCAB0C290E19D8ED59ECFA841C4B1CDA81DE1A7AAEF9FBD3D', 'value3', 'c', b'00100001', '2024-10-27 14:31:17', 23.18, 20.58);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (5873, 8644, 70.38, 'sample_UAlfGqbnEeB', '2025-05-10', 'sample_lh4uk8m7CAueF2zigYeQtP2ZLFYGnzbXE5bKkAjwPpYaJj6HznZuBS0lhSro8kEE4mxniQwv7fATGU', 'sample_D6gGhxlw3pnqjlAh1mmsXEpqVP9HfmEFrRptsWtKIwFuv0xI4eaIt0r9ySAR5H6KSPlFaqAF4SjFHSv5vO8blHBs6OGb4FXwXCuQTjms4OVG2fKDVYO4TQYTx4qIG4ghxw0A1YS6DPjBjNtMYAu87I955gf6VvHLNjj3kw2ffnNc7bkI5tvFEx4EclCuiQtWSkqiddg3c5Twzo4dG0LOLznrjDr78iqJNswuHlS3y48HGTafg2YLzDmNZyRwYg8rnv1kZOUwOZmYFpq408taZdpSK3n0iotgqNHjA3rqB9VejGRiLokxs6wOwQZv73wyI9Sl0h2EaN1cMIDoIg5I5drgw1Q1l59IT5mAoa9D2wDh2iAZrBgIV5DI7nElvKfItsEbKKxtZ41WhYp5Ho4Mbf4MrhDRse40DO0APvM6QlJTx4Ab5PGr9nQHT9QXrAvsLypNz8f4akEUCC86TLIJd73dyzOiLIDQx82fG7cFD2xEwXKHGS6zyrGt9uCca0jE9vGKJFrdSFopxTZcFIJaaZQDYWtUJdVv5Vj6nqxQAKaeSaRaJjW5RVzcJ68cXuim0Ks1NSxjYAqBXsGN4vEtmwrVaE2ToG4Lcxx8rT1euxfVdwftgCivnUgRVigORdo9K0AGGzgjDtQH4N8ve3GA6HYwSpD1JqylooWB9OH02e5P2ngFHHM3KoMQEIgGTZOj63VbosniTpqhlzhJs0BwAwfawmM503klRxdLTmI2LwCtYajoxPUv3h5R306Xj5sLPGMDneiFG64jIqL2wFyXZo39ctfWLcC8UT4tlxEtVtt3qK1EvPFNxsWNCPmfWcFmyjGTF8TTwVHIUDxS5LLervrHkQDwHAC6hYIWdeVK6ChL0MY4ukWoKXAcNTwdZI2w58l0PmliWGYRv6PpgxQYfjuy3NS1qNnCqI77ZNTrftzzygbeOHWu9IdvXudgnLzytPeaQN5U2jea6XIJjwSOJAqnQg3XysBIsK0NsYBZYsFbwj443K4RiHoAzJaKU52dgMHvcNcyf3iMwP38NKP2yc42ZsAh87ZVz8NHRQESleoXRcqeF3sQBzCCbTaHPOyW2VwPfRPsb3m1k2LceWkCEcwYXyU7iyUX', X'E59E91ED9D84C791', X'0FE9A3A456EBA193DC8438E0A3BBC6B16319E7BB93EE989867DA9E42EC98A4D1931DCE855979', 'value3', 'a,c', b'10100011', '2025-06-21 19:33:48', 42.53, 77.62);
      INSERT INTO t2 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (3833, 2932, 829.12, 'sample_G', '2025-03-15', 'sample_DAUporMiAVJw4irPIInbla9ez9wv5aYBTUcp51s25sns9UOjlX6SZHqk4WpCwyKB2u7r5fZMxFfOhlgroFfi8NOqzu2y6u1me3ygYw73QEVgsyBPCfCNp91IYBpag0cngynP9fraf3OGIZV4YVRC3Fi67ZuTMd1tAHIxpCpPNOUAjqtEi3FjDdnX4vfC3RRDl7qiI4vS3XpMAnrIKTQCisn0PuhjMTlf0phCoCeCWjoWteXijVPJlYEmp8edUfEh7dtj', 'sample_653pF8Z9CPLpMoAXRzhsG7OwZfnvrmwRgl0Plu360xdczL8p0wQmHuqDRKXokT2p4vzmc2hrYmv89JeTBGCglo0cARaEtjk5plYQLpMcQZK0cAR38bKFkvRcox8ar43yUz3188Rcs5pol2yd4ZW1Aidxs6eDhXPy4ZIYjaYZ2P6jjRLG7YerMPd4VWVlSOAcKjJcNtoP0MMzodNcdwCTgsHvPuAj7PWfkvaYyXhs31Vr1FwmgeAT7WzkX7pcAZQNTy5IwrjvBnoyPmrBqgmO29AjLFhY7D8rL92rr9hTEVWMsVCeGt9Pex3y5g2acGGgp9Qi1ju8J5xX4XDVHenZ0wXyZFMoKGEJ0ElZKLA0BYmHED7XKW6Sk9JmjRcNqkPcABhRCTIcrh8aRFaoFv5Sn588ZJGyHEAph1JTFS47VGcMBC4ntt2bnltEE2kfYVY4xWNwDQGpYG1YiMXYMil7Ok9jkwcnGJRaXKfK533LQpQ5h90TYO20LwXSTNElEKbMtdV9lxaSUBYf7AJTYa63h7uFq0P0iWfeP4uqm5JgWAtc5Jf46YKilx4kX7CDigtjlAlRC6n4IHWoOY89fIFLKLato8dUasTexsLDw65fYS8yw9zoDTYpRxKnBBCBnDWxRy8EwBKPpiaOLjk7zYOEaXHmOOfTR3waWSFSbO8SBFjDcveZORf7cM1rvWYmeRu9XTG9f0NJ9bKnQxL1phwe7yL04LcVRDONqMymUkjT48ttSADVsT1nkbMUcPxhzARzkZPOY9G8eBLc9AoYAQxrNIhFnYoePJp0lUlsNanwwkbqKfFISkOqHqh8iHdnjL40wCQVe1CHRWvPNNxIgoYLO8CFaxPljYrDdlKUQ5CQd2lhSTWNmvd5PgixCYqPm1wnID2aPcXhiXbzD2iQF3E5wJgy491bRS76xw695nC3oyFSWbxW7VB1z3KheEinpkLnehPCJ1sbSFT4hmR274i01vw86pvjJlyCa560g9PW8Ueovfb2S5O1t3Xb56aXz7bpR9Ex7awOgUnaFMMtYBziMVKqTQ8oKcioZEm58cYpI5DZF4y9106eILyJkWiOpeNa8e5eBuf0lt4fmUHPQLJR2GfXi2fRWV6xzkM0IxolPJkhrHXMGrEuNwK0YhNZcxWXRk7unI1JJYrGmwZaBHGsK1oAtOVL0KYTSVDVKLRBFP6AJvk5qx4JeUsaRReu', X'C398E7909DEF99BF2059CFB5EF94AEC5BAE2AC84EC9491C7AE7AEFB1AD73EA95A5E9BBA2DB901C41E28F9CEA8F85', X'1AE2AEA01EEFA0A3D893E9B086DF954110D2A7ECA1BE1BC1B4660043E9B6983E3C', 'value1', 'd,c', b'00001110', '2025-04-01 13:51:51', 60.86, 44.87);
       
      CREATE UNIQUE INDEX idx_t2_pk_c4 ON t2 (c1, c4);
      WITH cte_460 AS (SELECT (SELECT SUM(DISTINCT 55) AS subq_col FROM t2 AS s277) AS col_1, tsm16.c9 AS col_2, tsm16.c3 AS col_3 FROM t2 AS tsm16 USE INDEX (idx_t2_pk_c4) GROUP BY tsm16.c9, tsm16.c3) SELECT EXP(kqi23.col_3) AS col_1 FROM cte_460 AS kqi23 WHERE (kqi23.col_1 >= 95);
      WITH cte_460 AS (SELECT (SELECT SUM(DISTINCT 55 * 2) AS subq_col FROM t2 AS s277) AS col_1, tsm16.c9 AS col_2, tsm16.c3 AS col_3 FROM t2 AS tsm16 USE INDEX (idx_t2_pk_c4) GROUP BY tsm16.c9, tsm16.c3) SELECT EXP(kqi23.col_3) AS col_1 FROM cte_460 AS kqi23 WHERE (kqi23.col_1 >= 95);
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            chen7897 cl hl
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.