Bug #119695 The appearance of rows that should not exist caused by on clause
Submitted: 16 Jan 6:59 Modified: 16 Jan 8:48
Reporter: Aaditya Dubey Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:8.0.44 OS:Any
Assigned to: CPU Architecture:Any

[16 Jan 6:59] Aaditya Dubey
Description:
the first query’s result should be an empty set.But there are unexpected rows appear,and after changing on clause to forever True,the result become correct

mysql> WITH cte_484 AS (SELECT ttd62.c6 AS col_1, ttd62.c14 AS col_2, COS(ttd62.c15) AS col_3, LOG(ttd62.c3) AS col_4 FROM t2 AS ttd62 USE INDEX (idx_t2_c15_c14)) (SELECT 1 AS col_1, ROUND(ynq31.c8, 2) AS col_2 FROM t3 AS ynq31 INNER JOIN cte_484 AS owj93 ON EXISTS(SELECT rel82.col_4 AS col_4 FROM cte_484 AS rel82 WHERE (ynq31.c6 = rel82.col_3) ORDER BY rel82.col_4 LIMIT 1) ORDER BY ynq31.c11 DESC);
+-------+-------+
| col_1 | col_2 |
+-------+-------+
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
+-------+-------+
21 rows in set (0.00 sec)
mysql> WITH cte_484 AS (SELECT ttd62.c6 AS col_1, ttd62.c14 AS col_2, COS(ttd62.c15) AS col_3, LOG(ttd62.c3) AS col_4 FROM t2 AS ttd62 USE INDEX (idx_t2_c15_c14)) (SELECT 1 AS col_1, ROUND(ynq31.c8, 2) AS col_2 FROM t3 AS ynq31 INNER JOIN cte_484 AS owj93 ON ('1' = '1') ORDER BY ynq31.c11 DESC);
+-------+-------+
| col_1 | col_2 |
+-------+-------+
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    15 |
|     1 |    82 |
|     1 |    82 |
|     1 |    82 |
|     1 |    82 |
|     1 |    82 |
|     1 |    82 |
|     1 |    82 |
|     1 |    55 |
|     1 |    55 |
|     1 |    55 |
|     1 |    55 |
|     1 |    55 |
|     1 |    55 |
|     1 |    55 |
|     1 |     5 |
|     1 |     5 |
|     1 |     5 |
|     1 |     5 |
|     1 |     5 |
|     1 |     5 |
|     1 |     5 |
|     1 |    49 |
|     1 |    49 |
|     1 |    49 |
|     1 |    49 |
|     1 |    49 |
|     1 |    49 |
|     1 |    49 |
+-------+-------+
35 rows in set (0.01 sec)

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)
);
CREATE TABLE t3 (
    c1 INT NOT NULL AUTO_INCREMENT,
    c2 INT NOT NULL,
    c3 INT NOT NULL,
    c4 YEAR NOT NULL,
    c5 TIME NULL,
    c6 TINYINT NULL,
    c7 SMALLINT NULL,
    c8 MEDIUMINT NULL,
    c9 BIGINT NULL,
    c10 LONGTEXT NULL,
    c11 VARCHAR(255) NULL,
    c12 TINYTEXT NULL,
    c13 TINYBLOB NULL,
    c14 SET('x','y','z') NULL,
    c15 TINYINT(1) NULL,
    PRIMARY KEY (c1)
);
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 t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (6321, 2932, 2120, 2004, '2023-01-01 07:36:33', 12, 38, 82, 70, 'sample_b0H7NIXeKB8EymA1Z51EKlUQ9YdgX2wKLENJn2NSr38ymLpS9rtEmi1VBP7kCEFRAPNFQz9N6Tip92R9V8tG0mfBQvsqnMIFY70TdCAHA9dIiPktL1NIeocyWwQhBUwgvWy29F1SpMkbHTphwdlEVu8Ngg0UXGPsLw0DqtpZioF06lzMJwQc45kKMIpD8xQJNh3HjWg5wKLs0t94ASy63fKFsWPVaYZDxcEJqCWl81pT81B8JOv3XEQAN5m4jeSIRwPH66jNgAcf2oqbOCTKCg8qeXEKyaeCwhBRMcFlh5DNBegGFsRjHecXoZVYcZiC0Qlzr4o00pMHwV8aPJcXJx5vNbdy3YBPwYNnJxbiYdn74dZNGaAFh0o5KF2u76aE2se3Y2EaJLtX86IFRdcNJP75UfDwMqYFgwndm59AcGg7piUaoiL4nS8zHwvtj3N0qmWOaRAOBLc5tSglRzo5dj4m67M7J0NL5twwGw64y4uxlgIJM00SibK3DGclhz2OzXsWbfW4nezNq2sFSTVt1sOtlNotIEnuf6ZZdtY5ySRQa4kJoFp3ZC9tQm6esozSnNpb2oQ3l3DkQnom0YdDzdrvSRzOTUTqDttgKPBo7xfHR4vJkjz08CN54a4JgsoOT8Crck8BqcCGtjDivOgOQUrKkFMUNgkOlaj8fkinUShAGRybTw0F7sswlFE1BgLciik0GQD71iEucG4lL6Nw5f5LhAEbeJtbKC4n5WdChmJ4h4zPlg0wRZ9W7JEkIcurqPPgADBC4kae2nA2nAfjjHQYVMusj8XAQsKlgZHLuxib5EZPASdwCvbxgDbqL3tsVCgr0wqyNGVfZvGJaR0GDUwc73zN0vGYseiMEP7WoRbeQ4SU7g00PVV9f2V1nSx3fQDFHbYd7CwfAMK1evH4aTuj7voBRTySVI9Dhs8N2Mjvx1zaRHSUoxfH6pnG2GM7fqbvCxnz4lQMjUtFHCFoXytuH9Tc3Z9iAxo9cbine3xu8rNyZbZs62uS5RciOT2YHaqelORK6YCCHYK', 'sample_BP', 'sample_ThYy03eQiJaSHY7KzuyTncEDzJ5dE9FYJQEdmPyJPa9LwsyfdQNf1AWAETPXC5SCTXNHDo8YsWwwqQo1mVDfxSY01ea1BlU7wJJRX0kbiNjyk9E4puutfqeC4wzewwTCkJXchV9eL37LQux62y6Suq2rue0QoR7sfX2FGEacx6MD13jAVUE3AB0LiwGT', X'D58C4BD2892AEFA9864AE785A70EC1B47FD99F58DA9FE9A281DAA42043504B6B', 'x,z,y', NULL);
INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (2035, 4556, 2340, 2005, '2023-01-01 07:09:27', 0, 65, 15, 25, 'sample_NRvxoKjHdjeyiUy2Tq6CcNbeKpmThwNDM4eEVL3p8sMoZYS2J7UZaOpgWQhLKRXRdPf4y8PIVmbSEgAcbiMYcrAFJX51mZt4wUkGcY92SiAspCVhRevAEOqZW3Wt82DDmGOFvinPh9wqkl2EZmEIJOtZkjrf1FuyFamhtY1QByZYZxPzNNVzyxgj48nOH5snRCFYE1kxrYfkkhDhSZd1zfUrpfAliVfe7cBTzsMceg2O5Kt7a8pnOkcXXkWRzu9e4SxAeSc2TVeoNbUs8lVGK9anX9Oj4SOd9M5ebLh71N1VKOLoVGRflbNVmDm58zWUlExNdde8Auyw1J2MMVRnj6ZnN3BaJH9sBCEkEBaWrCW0d9oNcSYjWxlinf7WjUOlCqdEc2H6bqC4OIceVN1gHVX9L2tocm52DkAedgfsNritm7TBS4zmIeAAsiyiSdoU1SODNeVyMRDlO2VhMSOPrjIJyTNL9BFIEJmXk1lQUt6ID0wdOSN2UIGQj6c', 'sample_Oasx8mRwcgxWOtWI2XmI7hvvvZy75on6KQbqEOCpmDbvwxeuTZYlgYSBHiayIA6J5ORww8Ow4glWF2qkn54bQO4zGe4iffsK0iM5xdEN', 'sample_XRJcMMznYlkdgcuS5QF6qGos1MT5etBPlbioyiT289RfjzZqJTUkQw3jz1kx2uYaykOKjypRemP4O3sEW49jr6KhfMiA9KS4gvMv3j6xBK', X'E381B4DBB769C69D22E4998D0BCBBED1A1E99EA30ADB9DDEBBD799', 'y,z', NULL);
INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (4150, 3423, 994, 2003, '2023-01-01 22:43:46', 19, 46, 49, 46, 'sample_2kjkgdqdKPlR8J1J6kdnN1O8yNwn3bMzj8Z01bIIuVYzAljwLJ2oq9xAQasT8QiZxXrcz8HQn8qh1rQe6sCLl5GwDM0fwvS5x4ReSA5M4IXBexTBnkJRweSG0CgdgwZ49f8fXt1xLZgVlO6N4hr1eF4qpQFvaTqRYJtXhoz2pGlS3o7Bp4e9AYgsnmlhKB5UcCP4HecWaMG7LfOGCQltlY4uOXGav1ul5bkcaOtkIME8nYXttVi3XvQLWN3U91Z7KhVE1ZlxVnHapimBp08e4LxXiAWgcrxC2pi26pS4pnkJU7sD2XymPXmTq1tx6wHfepT0z4Eu2YmF0kWATdtGUOu5VcPCI0sa4K1M5kegiyQ5lTrhfFWUQJWQNT5rKlkpa1ximnwphlvRrV7I8RaCfq6bEwoJf1YlwlMjpO46zRyxtuo12DC2dF3kRQ3WLeyR3mv83u5NhM7hWw688SXhZbHFoEE5lP8Co3Txwljem4hLVUT1Mvc9Bd1WbwONRhZHCVGxUxBgonEjU4Z338osFm8VbXmZAX69S0pTDOewb0IvkEXH9v2ZlfJJj2gczmwNygBfaqHhGg9JLpJqyLbfEjj3kN6jOannuQhFL9LS3QoPiLhyLMemgpqFYI24TqZKW2OMBmpMN3rwjxAaw7qpzIkDxKIJsnO9XUg61fKgeK18mq4rxnRFsybon47LEmjwdNO2Qj1OqwFHXFxnc00CusOiXhOYi3ItoKNp9ewQAS6zksgCncdgmW4aDY9jFFIXwQdwuSlDa29ZyhGnB1vxO62st9yoxKxtF6OHRzW84sJdWZ9UHH2sFIDnCIgUr0lFCpgtdoNPJqLrMeOk2QgozPjR5RqsiAfFCLbUyJkDCHNF3hQjeAo78GStHMytqyiMzekhd7S2bqrZUIKwIww11n95nzl1xK7ozhX7l7JmpzerhCYbmhPaSiTrDUkoaz7PTiA23oBlXimXpDeGXHywlTO3smRZMMV5srpt920uu8dGKNPiBpypeZELXs53inPis9BM3EJIXHaJarLR7stLYA9wEhFv05zC9boL2iTdRynRxQuoKvo0iMFATdX6WuEnP8FMkJkifikcA2xiegnh6dvFoVJUVfKvLALrKeN2BHJu6ztDa9hvYVorJQb9lh5', 'sample_1VdfXOZwAA4G6o3RYgz850VXncj4EUsRl8nuHMOZTmfMmEk3TT78y8OOss7HnLaijg004Owa13ynjc65yeM1HgHWe0qRMiZleNVyiP7iVQk6sy5VTe4l7Mazdzu2K3tEwksyWPz1wJnRQkrAZxgC69sqdp77jU4sRP2qNgYXMibMW6zhnJ8Sn33i', 'sample_NKrUyPT9yMvvuX8PwWn6oECfFCv0W1H5QldTeI08zXXI12aksPGk0QSdopZ46GnXhL1QQBO0bHIDmwxf1GKSLQ99yHMnrABPzTtD3wVKKbBfTv8mGwbZCCBKDEBBN564NdRWzOmMFTlw4AGihpHTJ8Xhk3QasPu1wk', X'CD9B46E8B5894D5E7D', 'z,x', NULL);
INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (4922, 954, 4869, 2021, '2023-01-01 06:36:18', 19, 50, 55, 65, 'sample_NTrYxKtQPl4FLrt24vkLQoT1gVcntayj1ARA9aRcMcKJxzZ82CCc7KWUdvhCnRlauUts8Klnk5S79chFkzYWOukbINHH8INiGGDXMCKWdARClW7JeGw4v2RHPiv1ujOHwwIHu2TvzZGGEvhnc138wpYgly2rDNgzNl8NfADtOSn8aA5BrUHGnievhwBCU1t7ckh2yvJmBIhG7TEE2xbwedQ', 'sample_9aBiOKQWlD6V8bnMlAnngXZ1YieyzuAPe18BnchnfXv6jiQr7DaO7p8iNRIy3HRcpus3SXH95WlUixQOUStr548OLHbSdgpkqOTlSazJIaPLHIMFBW9KE3D', 'sample_UmiYLgxZvp53mPtZvonfQqC6O5HoEmaq7nUw0', X'ED8D8C70E98E9C434E5D0D4EE589A67BC392E182A6CE82C999D9BB54', 'y,x,z', NULL);
INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (7547, 8711, 5257, 2017, '2023-01-01 01:17:28', 87, 47, 5, 26, 'sample_gDJ69eOb1Q1kaZT1HhphuM27LNYEUWz87jBhIS63ZRKG135CBNvmJauyvzJ5zUMCMgkffsTHxPWYtUe77RTE4dXFKIbvhfgClHYeFbdOpjLsc6MRWEeKQQSExA8ftXlyL6il6k43nG9G4Z3YfEjlmmSkL0ympG5Ig82oethcHqpi75LDnT1xr4nAhx4yxONXZTfZVlBofM8AU7772Cce5rhL6K3vlFup3gPmDgDO8MjCsCRjLSAJ0msEmHiZ9meUJGM9NNdIUgB9HEuE72fZlpejtSUT4sbx9Eq2i6D34iRHo96YMwVCZ2e5wGXxKsuCJ7aY9wxHmzYUPW9LbvXVYnPBTvoXAz8CHCVvKtCKXOGi1GozDyay4Mh4Sg545Rm8UPrfTuE7YaSZqOOFePvFF5d3A9GLSj4tFMYAqYB3oeLDDCIWGsOaXAZpjiyCwTQSHM7L7RrBTIA1yCsDyhcRT1vAgg9vxnsRcdUjCabBAjTy8jF00nLDOO97RS9ZaLc5YYsZyyAwVn3eVSzlJ8gerRkvnoMOo3vArC0HrauWSn0ZTS7i9NABwuZADI00y9SXcG44jqvkTaTsJQgIJ017WNAL57L6BHGIInzROhk1Sxm9qlyzmprYCxuKfiud0GIypGN5DLqe1B0IoCRLkPBScKsLEPNlg9TnVUML1YH92PdUoSWdBhCSCmuRWellQzdTrjipEn', 'sample_8Qhk551ndz', 'sample_cfyuAkinznRvU0c0aPjqz1pAOg5KwPVMLVOJn5ChxShtY1lN7JV1HXS2gMrMhWMbTzlfBKZsuIU3OjwzsU9sEFiNQIDfVn5bOvEr8hOLGOn3mARFY4KS9IeUZ333QNsBlWR1SwkvMvwJrA8XrTkFeCvJIu5azvthOaDBMjiiFa7Da91VBlVreroqCDw1gUE1B', X'53E59A96E5BD88EF96A4122503356D44EDAFA5037A01', 'y,x,z', NULL);
CREATE  INDEX idx_t2_c15_c14 ON t2 (c15, c14);
CREATE  INDEX idx_t3_c6_c8_c11 ON t3 (c6, c8, c11(63));
WITH cte_484 AS (SELECT ttd62.c6 AS col_1, ttd62.c14 AS col_2, COS(ttd62.c15) AS col_3, LOG(ttd62.c3) AS col_4 FROM t2 AS ttd62 USE INDEX (idx_t2_c15_c14)) (SELECT 1 AS col_1, ROUND(ynq31.c8, 2) AS col_2 FROM t3 AS ynq31 INNER JOIN cte_484 AS owj93 ON EXISTS(SELECT rel82.col_4 AS col_4 FROM cte_484 AS rel82 WHERE (ynq31.c6 = rel82.col_3) ORDER BY rel82.col_4 LIMIT 1) ORDER BY ynq31.c11 DESC);
WITH cte_484 AS (SELECT ttd62.c6 AS col_1, ttd62.c14 AS col_2, COS(ttd62.c15) AS col_3, LOG(ttd62.c3) AS col_4 FROM t2 AS ttd62 USE INDEX (idx_t2_c15_c14)) (SELECT 1 AS col_1, ROUND(ynq31.c8, 2) AS col_2 FROM t3 AS ynq31 INNER JOIN cte_484 AS owj93 ON ('1' = '1') ORDER BY ynq31.c11 DESC);
[16 Jan 8:48] Roy Lyseng
Thank you for the bug report.
Verified as described.