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

unexpected value caused by changing MIN to MAX

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 12.0.2
    • None
    • None
    • None

    Description

      after changing MIN(hwb86.c10) to MAX(hwb86.c10) , col_1's value
      changes from sample_sV... to sample_X1...,but sample_X is less than sample_s

      mysql> SELECT MIN(hwb86.c10) AS col_1, hwb86.c3 AS col_2 FROM t3 AS hwb86 WHERE hwb86.c3 = 8409 GROUP BY hwb86.c3;
      +----------------------------------------------------------------------------------------------------
      | col_1| col_2 |
       
      | sample_sVjbji... |  8409 |
       
      1 row in set (0.00 sec)
       
      mysql> SELECT MAX(hwb86.c10) AS col_1, hwb86.c3 AS col_2 FROM t3 AS hwb86 WHERE hwb86.c3 = 8409 GROUP BY hwb86.c3;
      +----------------------------------------------------------------------------------------------------
      | col_1| col_2 |
       
      | sample_X1dN... |  8409 |
       
      1 row in set (0.00 sec)
      

      How to repeat:

      DROP DATABASE IF EXISTS test;
      CREATE DATABASE IF NOT EXISTS test;
      USE test;
       
      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 GEOMETRY NULL,
          c12 TINYTEXT NULL,
          c13 TINYBLOB NULL,
          c14 SET('x','y','z') NULL,
          c15 TINYINT(1) NULL,
          PRIMARY KEY (c1)
       
      );
       
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1860, 7744, 7184, 2021, '2023-01-01 17:10:10', 67, 54, 89, 89, 'sample_MwjvGnswcZjLZyVCLHTesxIuN1uAhkbE7kNjHNzEIivPwxq9Hxkt4VdX0lyxwgwbSW0XllM9jHpRTVDuPuIZmEGaCF9PyarvE7Uw7DYwX2a5Eb48XBPUQhfaCfGEqhqjDa75I7Yy1k55PZidfh6adb7KlTpcBs7hLoQmsIe0WEosq4eXqi81yXB6WaiC1B7dKYo3avvotIo5GPxnPDw54Xt8C4D01UcfP3GKjTCM2LUahtHR7EzS2YjmA4Km82wvUIznZqw7B6eN9BRr6qmNSLYnuOSCPPqAMOOk90RUr66SLLdLH40e0zvmzEfu3xbfXo3cMELhLCzP2s7SPkFI0BvzHsFKBT1ajY1kM24p3EvhZDxvP2ZiIW3HgSnNDsygtXbM8yJIuZzBkL2Y9WefX9AXNRqZeZQxMOzRBczi4JXvUWEboGouKwYzoLBCizpvsIedWlHzp8ahU4Wd8IhiYwSR0hIrPFNMjVeDgGEyoD7Nu58bXg5eDMbO88OCxU5GED079ORGLobHw104f6ZTO9Qj98W70DvgMAiZLffOHVxi2AFMSpBj6lztyemBKsTwjJQmraBjt264ZkD5ON3LzKuRM9wCCN8ad8adejRNXCD7ovJeCr6bGkaUxkH13qM6Y1YfaXCl2VgnPj4z2x1tE4HhRUKp79IbLYuRBpp9G9zFPY6760NtUoEJTE7XTy5hiEFeldZBYjcFxNOxga3nsVtN5D60vqM7cqqTz3FtPOccMWTiEuwlcwpB04JtG3AKLK3Twzlqc2rHgXt5AsoSfUzWgCXazReEgOvjgSYoxB9Q1lROT5iAnhhQzoMhj4FkF1EIG0ew3jS2WPGVpdcTk1XMQR7KTktP9FolnBKogw3KHdQ8KkkRL0RcPqK5ObyfUcnR5OzsVKSZlxiVGsLOoixZDiIHfkrgcmeTisfP459zv3WIIpAXrzf8rtIW3xMYQwUYNN7WF8srbmpst9djiCVD3u2aWQg4x7pWZPgOahozXdLzMIjJiXt3FafkIih0uUNhIBpR8XrUaMf4PaRt2xkYgAP6dLzu54RC5PBsMYFrAsD4ayRsNTJZ7oGANtQOjnKMAC6lJAfQaZ6gVVlvyz30H6MWxL0MmB1IziwPBeWgWUyjgFy1JNlIZMpk9MObHyH7tSLNm1EJnvKYmNNuuugYYjdKNlwbCBBgC3O1o3Tb72wChoahYNe8apoTckNlEyObvh698UMIIh90nPc7RUwrZ6BnB7atnZ9zV9kr835fq06SRdSHjQ6u8NHq3j2Jcd95kWogUyiiq4xC99DsdWaiGylMecwPBaPsNq84T6lsWmHWlXMbHpIOwhT4OX5kfVeQ8wzkw0hTklanCrfKGXTgd20t3FNoi1GFyRwNq9jikAeoVSyhTcdwRtHdn7VfC0ncjxoHo0jzB77v0AgZHS8jXS5W7MylNo8dbpR7dDfJgMlwOj2wmQsa5LbKNKd8FWjQsQI8Xy3UacjxQ7LGHtN31oB4al5vop9esnoUgnwAArPp32zjIxHBPx4TpATuRIS8skzWpqBHtaJJ7YOkizWIrM9gWkUgoZ47vbv6LqlG2oOnY3zdd0eHEbg63p5o9OnNLfT84dkgZLFTcQgwJ3Pfa1hRGhsKyBwrfhpL6ejxVrPgQdJYizeYzlIjeNh4Y4CfpbI96V3V20inhnfFM4eBMHwiuNj2ohcfFOY64JsZQQF1EVayOccKjDsUkVWKHu2JGwoZkepdj34jKV6TgygW2rr7g3TqXhMqOMyl241mWkBe2cs4IHzyVtmY62Ho96spL9G3LhaL0RZTcFNSuMPc8qG6ZeeBHW0VF5CgHNt1', ST_GeomFromText('POINT(-74.748661 -108.004127)'), 'sample_LRqz1MgDCzGyC8oC10qb1fzhHkvTWJOix39pD8FzBeAKDQodJWEc2MAoDsCrPo1265Y7rZA0PoW9BwbMVQxBCMaBQji2ywsA3Wuo7LzVsnaKgw3NdUkqkhUd7WxVfSliHHNmuOwqENBYriLxXSSgUnhiaYr9XXrCPv1P16SdbiMX', X'DEB7D9ACE3A38CD29AE695AC1ACD9ED9B2C885D499E7AFAED18452', 'x,z', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (7131, 7744, 2975, 2001, '2023-01-01 22:11:49', 50, 40, 79, 24, 'sample_lbLwHlJYx3afYZXqR6pyw7glbNAjzBIKv4o64VVnnhV4jey9uCZ7SvPgOIo9UKlMMVExTRYDfwfWGlSU1zUV1mNAdu5ZJW5OBoQArZSTWLdwukx1snydDpGu92Bf9VRCMINQGTiON7JZqkQczlSgpFLt6fZdKO5JSClY5UraP514ptlln9Ak7S6DEIljqrX3gOfBp1uCmZPz4ugtbUYlr4Ufq1ej0rIWpL4IXu5rZ6eKW7evvZnUwESiKPR2lNgtw7JbpRPlNSUszFfR97NlAIWxlZ8yNWysO410mIVtUPIQX8hsA8TGth7gPZHASJGgktIIfUtT1WQS7bxCiXR0fgCqaTEnxg8NWvMF2L8eGjBJ5ZX6W91hz5OgyWL9FpwqVcp54Sw5ut9i05mANbDC0oszj66MLMtQrHxde2opUkc2UOnXmPvKN3pdClRC0lqN7iRpTqt86duc85XlWQC5k3qg2mwBsYziLCdOfegFM6TBWGlDP8w1vhGM6owD6M96WvAXMMMFIwwifygnBUmrPKKcccwXNhCrBQQYmlimTeyXFc2N7uzEjB0Lhaj1esylNtXz83lo6UF3LtuSfm7BfE1I2GlzF8QzJpVZbGCWqnRzM02AfPtEh92aXzSzC6vVUmF1qTjIP8HG5knemcQbEdWwrDXQxVVwFXdTOWb7YWsshlIUFJ65B', ST_GeomFromText('POINT(66.348875 -9.499925)'), 'sample_MPRJj7p3p88pxkRRvdtiMcpauDVPj6Fo58eiKc6zAGsKyJmKjGIhTVxOtSUPQwCNpzrKCr0ZpbpMbsTIiwlHHVWYcsezwAa655QkApbSBBeAfCx4jMzNtiT5yH6CXTAmz10rrDQmWKb4', X'E1B98A6BDC9153E28F89E8A480594CE797BE39D0BEEAB8B50D', 'y,x', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (5087, 2994, 8409, 2008, '2023-01-01 02:50:06', 81, 82, 66, 65, 'sample_X1dNmZv6Sq821G8HDgiDByc5t7OpmQPccZhmJ3NwSJrDNiLH2NZpU6D7M2q70s0LtvFiQZeAkBh3biYewQ1qs5IYGvATWpgPGaD938pzfNzZGf1Dk49BDcQhnXBYkoDvYFYINfDsYNlW2pdcxfHuZ2ePcS1QlPIXTALDmvzUuyMYq16EFLQTThWDLsnj9P0cm3kVzNYxQxAebon2EizXDybW8uRq8OyAE7NsUIv3p3ebaVx6f5JKRwLsJqgkd3KMNNrSwU19r66N6JiaFrzCQDU1uUtjXERME2D3CtJl9DyST76gMuytaLOSPUsRMbF1fYcyvKqHiLioQHcXLtkELGnBwO8dVtEKRF9SW2C9ZljOESHPedZ5qT1hU9kRVWl3RCrDu2IqHYXIfTcl5V1wXDp5agg2youeR62gtcaGuWOu84uVQdNjW3oKYHAs3i8C0l0bR1xnAkkxXa5VHQOmNB3kgsUt7wL77bWJdMt55BMf2jryoq65D5DtBb9T6nlba5IFC1xJ3LDbrE5gP7u99NjRz1gcxA3yoLNQnuyGPbKu99qbEYkZLd3xO0q4Rx4zapIdYNcRPBla20hiIZyeVvnM3eVdcE9e80RfvAm8AQcpKd0RUefkYqbjILPRjFOSsUnozRmSuOLGeZi1LCAotBvBTOGilewmfyzOrRqwpufGHxOFcVJHqx9Ccka8Md34aq8tnuhOcrz3OWATK68Y4wG4M4zJp3KhB9QIAidA53WwJms25GRBp831LYQWAgncNJfb45Fj1HCBClj7ytSqzYQWWwMjt7rewOZDmjngsHAA9khIay5ZzYRpnyfFxgbKO6t1CK1gN5MaTY0pvSYHU2TX8xAv4Bfx4D1ETupVfZBqddXRhrTI6jrCqIGMsKPcm3ZVGcabx5i8h0ceqCJx3Twa1zLvjzEJpej93efF8oFpXcCWKFe8GIldaaOuBwl2kJuDPOhepjil58DTDRr3Z5cPcy05bGjjUeh3BGbU3amLbmc7XwPHfbG1DuLJeQ0YQmm6RD6DAELaV67rN2wOEwqJQcOEK0RFnziMARF5m5PQuGE7O9frfuZzblgRdHYovUnVWUz6YlV0MDloaLhgXXoaEf3MjodtxXdAKpixHRblF29FtU', ST_GeomFromText('POINT(-36.411583 166.196226)'), 'sample_JT8E0sxzWZJ4bovlJo4gwXeHmUCluPsvNJVjOjRgmeMRc5VPCzpPMjw7xkLRJ44KaqZFp6ZfjITPUNgnbLclQnWwtRBEoGUTGuIspKQk9LPJ34wLr0pJp', X'CBB8CE9B15E4BBAD3FE9A1AB11DA97', 'x,z', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1835, 6919, 9735, 2018, '2023-01-01 13:27:10', 50, 36, 37, 41, 'sample_eUZvbSbQffdSGkdrMPJYwAsgJLCzCuKnj4v4JP8yi1WTwbm5lsIeaeaok9MbxuPC5uI6KC9sMVmhyvljP95xxj52Wfr5fgnPoa1h4WkX5TtY0vKO4bEAzw9jxdFqDosRfZrg6N6ZKX7YViH7fYUKMBiCodviyuY5xlE6zh3McrTc1GfepwwegDn16GzmZvRjzSJqkgnzr63V5yPZk4ZJpiWnYd8v1ifj5DKyhiUjWjK4rMf4Fd430c7xKVvNZfhZcCu9HNDTS809qJYhdbgI5OCiNz6KK', ST_GeomFromText('POINT(72.191562 98.207308)'), 'sample_5ZBFCi0LEJ5LNg0YHArDT0VTUId8bx6kkuc6K2CU51H1jfvYUTHuBKZQNBfGGEkz1LN6j4EWhlpMys60r4W89FpIbsKos6UDxj', X'E0BABB40E5B69EED908644', 'y,x', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1516, 7522, 7714, 2020, '2023-01-01 08:29:54', 39, 84, 70, 70, 'sample_WD3xRKsSLROXRtD8C7oZsLDLQb6PKFVuCv5H7HHNWkwUmfupBCR9bMVXe632TU860PgtE7wIiQFZnhS4CL8J3QQvDvps4aKM5vuel9fDLE8UEYOifBmo1q51YMSQ2RKV4obf0UuWmUPIc0e7KIEi7LKWwSdoMp6Qs62Pd43bPsZHcYDQq00Qu8v9fvO3sPUdtxu4EXXUKk8Qjd9jM5QCj4n5R7Y8ijqZ1W1M3yQR8Y7WQMllYUr4MP5PEDFyAcHhoQp8EbSFhDc6OQZTmOxbYVJA8bYWRV1TQhUKNQPqx0eMhPAsVXsRM1NvvNDuN5iRyK1XxwpQwGG724EeWdloiGwvSYyHk2W0y65uITPicjgwlQyBo8BNwjK3R49r6qQhUlk8rfp2wqDCncuqE7FAo8PNTDQZbySBEDvvqpMRHxPii', ST_GeomFromText('POINT(-36.829529 97.060018)'), 'sample_6', X'CA8DC79ACF97732747D3B7DAA4C0A9EF958957C2A4', 'x,z', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (9549, 6919, 7184, 2006, '2023-01-01 01:31:19', 46, 83, 59, 7, 'sample_X7R5gmAcHBLNiJwe1grmxQT6cvlMiPOvKL22xVlhd6yA524q1R1wMErcXeV9kZiEQg1TWTRKztvSw61gq8Lbto30nayvctIEoL3TyzF2LmZXFYOVtXA7DnNO0GLOVUcg45f1ifC9lZ65yB86Vhnqt8IQoISDv201Vcur5zYoDRhu0m0AuH2iZ0s3YVss7UeEq56butvDyJb58hNG5gTz6FkEsUYEUwpzdJ1pCDTpS2cs0qZLhYmyfnrG3SfLnRXYTDUJu8tVpspGy1EKP6ihX9VOEdggiruroDVS0kpCu7qP4cN80bCDdLh0Ajxtvh4u8SIgYzwVUaItFvDDycaO0iqcUDf8AHcNWGH633ni5v1vtvqMVYhgzCgTDTpYYMgyyAUHB1BRQEZT56gCgnLkhqAYLWUUfXyHa1mtzdQD6Absd8PTIIlPnuHbbWB7V0CGbaPTHRNA94NhGTaYK7UtjIjWsyOISBvQdbMZFFIFspzziKlUxgmYY8Rk02GsidpwQRl1wPTgV9Lodo63QpwEp6Ap79T9gD2FWB3mnmlzWMLQgyYNBbwwOWTM1MdFOYfVtPLthOEA49LhQp3YK6OtXPn26aV4P0c6JKt1Z7c1KfNZoXdUx8dp1ZFhFrcwRy8m5RMC0jGnHfDhiD5WYUTJ0DFokgwERgDNThtLFLlOPLRVXTz5HhRhv43zOfrclV6j0UyTK3OoxptFf6R5sIsUG07T9HoByjbTN4CocY11O4VYkCnjdtG6by4hLLsiOjze33ZesiszmLv67e3SDjaWP1L7mpsjv4IaWNoPS6XJ1JPZwhRiizh9Mj9zxkMkfkoRvOI09Z9rUKEKZLXfzhcWyzzl9sUI9a3TsWSBgS0LM3hHfZW4QLaV0YWtOm9xivCVd2TKplXAybh3tISWYNNEo1uQjlryAj6RIlCgDm5JT9XSCYpF497DZzWb2k4tWv3QbjJX5BgXQ9OVHjzCHTSGsR4NbvHI7vEk1b6EeLeFuUGRkQPWMgUyCSfHqhTeA9y3uTmcr1kdnYO8qlYBceWbQzdRCjmlOYFIUsqR91uJdJweVB3ZpXrbvZODJOd4u1NXmP7xl3EOMdg2dvfisQyqlEQaCV6BpYGG1lMjqOX8No7d1dkVbdyuRoIB66OxfLwd446nFZ06qCpcNiJUnZPz8uuFZhB32giN69hqdqGfjxlnnOy9j4wtfZKvc5vVZkJa5AH2KR6LlyEn22NeUMO24bIiJo3VUo72B2JuQDONTiv2blOeGmEIYeGc6MCbSHRqPsD5uyTzLmWhBJ4ZHOMNHhM919TtmGxSRqV1HGFjlidWPF1HglitMPmxC8EBm2cG8E9I9onqGKi4OPhrvl8XthOxTSyhUy2XgH3oxgc32K6wBbiJNvdrPNKD5wRiZYryrdE7yCgRZ1Ri9WruDHeHZ8KqN8fM5e1B9OWgPqG57m21szIIEn75lboB3uY1BFDiu4dRZJOZrsJqyy8upYULpEeOqq7rje97C1DVe6zSDH468GWqSx6', ST_GeomFromText('POINT(-79.560015 -133.146999)'), 'sample_N433N8YfXse6ZtpkoUzk6cOQxTjcZELQtX5ss81iCTFjaGfqUDI1iD9wDB2GnRSlW5lU1fQ3ixSAadOLivc8d2XOSwfGeW5ZqzHyYQClj3D2GlE4mqibYzF5LMkUp9hoQ8ao00Ptoz3oMpSIdFUTC', X'78D0906BD9BEE0B09BCCAAC790E4AB99E0A79FECBEAA5A3A544B', 'y,x,z', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (7888, 7522, 8416, 2001, '2023-01-01 21:00:49', 72, 14, 75, 88, 'sample_hHQawvc4oTEsrv5wWOGrFVwStzRTfzpfryYuyb7bp1LW32pseDSsdqeDHn7EGAla5N2CPkMP62b82xQmPvLtWkPGbLhT6HWb6SZaIfpj4rITGGJYwEbDnIr7bkFDIRQbHPqJJ7sBc1PFdmMi6396HbwgnNa9HdlxWEP3UJo9zQH96UKXxG23gaa3WsF5WztREBgyAF9TQUuJ0O32naw8EfmYDkAAJ8RaU8Ss0YeB8YbdyImfVCnKic9FUiMo7A6gMbfn4VBk6h74L9VGklOAUkHsRZ7OFxy0Xd8hPjBxjgFNacVIItTKEty1pSZveM7qa67ofP7hLUGbg3c21f64LEvfSpcIYLgNavFWgKohUBbBnO4g5Wgro09c4iflrr7b3ecQCRomOhtHVtJqIjNYakkke8tcZgwYgt1t59HAr9NrW5OnpevGdTJAe38BLnu0fd3OP2sbYMsfxHeSiTscPNF5BLpT1xelTvCBCjRuqfRmFCL7pLqUCjZsg8Tt1adUCOqMsM1Vj99mOdKizUDwk4jdBbCUosYlRLgHR51ME7hn03jOYkEXCGUUp9KoNMtjxcKshXHaJE6qlnoiuKsFZbbKMe9RczutOhTHprmmNkoXmVVVaE3Rdl28sNm9a5dEx2qMZ5MSxk8e3zEhNaaqutD0HfVwj8AxbOKTzZVE2ZTjKHngKVUSlDug1QkTxXVKh85TaIXkhpA3Nqb3sr5Ig1NzOHnOIZsIRBL5a40dEhxGXcJWJVOxE2Ry2J9UJ3g698mpcCEPzt135N0htP5DrUaGl4oBYNUx5TQ7RW9YwOqTQmnmwT7cmndp7RdskD35Ft1R3gQ2DVi9IY6LWAglqSS90vzwf4yMqrqT9cRcbEqmcJ3luVFLyg9836xZDomS8PQtRu4BEjaVrXFv0NTsQ5F9KCAS5LDEBZDKqwAFTrDU8t7l4NNlwuwlnyxEvKlLjXIZ00TwkGb2lTUn6dWyGJ9AU4n46n8Kq95ISMYUa5fo4ErA3HPmG3uhYOsO70sr20Sk6CEiu97GXe81enYOEqomzNDEKH0AAexJcgLrSYO8rVsOooXApTZWBJhAtJhh9s0idUhdITg4dHJh2qQXyWY1fvpX88eVVwcHlxvhZVuzu8UWGrAM1xicW8549aLXsCcxhVPSCtCBx3GmZJNwtFJLLdLwFjuj8QCqHxgD5FsTDTOir6LCROKBeMlOlrC4o9gMp5bKFuBA9SKAQCciV7nSgi1Bv414czyU4sFwrLMs5WbrOMTpaCTihqHhHIHYzW5AyEyWAoWjyQqrBC1wjJEJNrjPCW9e60S9Yh5wTQLt4H9Qf8JiwT9KZio9lmXk09AGsHGneFPc90UYOlQ4dLdM3uiZJxyi5sk3uh8BdGFpnTTLytXmSzPnqtlTS2S6sKEzxCHYEVP0MoGoImFMDbTgl8fxY019xNOSmDAx9PN7mukC6a6o2auv7loluRVo3j8DDXAxgv6icBy95MZs6I7otiph2w8ljJoKTWfZnYpT0IrWExJ4rHDGZMt3WeeH9iJAQNAT9qFHa1M3aazlDh10KAfB25D9TsQBExhLAWGzWrhdN8c3M14D6gZnTyrx747foPzfiW3cqMQchlob0RinF0lyVq4WF9ySf0w8NqWDf82TL8aJcQ3iXu8TDUrktUBzmNrc4xtIkx0z3d5cQ1Ead6xLFs1SM3iKhRgSP1OExHCMK0ozqlqhKCTlGp4cdREA5Bp3KS1xmpWIIXX7ZB0iQcgpkhvMwmz1TeUw0OzcVgWaCdwThlPLyyS8OvqAZAd155aF09S2eoUQsf1WUj5NVnrE2zUSk3qTP6hvYIINBPsdhnxHHzMFiRrhWKKhkUmB1QHiZJA9y5PoikTW7PFxP49VhVy9AL4wsr53CgaJV8vvGM1VIKOaylBsa3AIcHImy3ePTWCHo2cJqNbY4EOHiBnOkCN2YHRLGLb4EI5j75KySGTmvKG62YBRmDoArtrT2HJje', ST_GeomFromText('POINT(-72.632176 -108.427447)'), 'sample_BhYfKUoXI6AVZxcsfqcMkA7OLB8Ejd9F5l32WMiUAldAIzXGRLN3kuasJziDuO46Bo3hASbyANSsxJWwjf5VNG4pBJk2xf93H848NnEZNZ9KvjTSvC', X'CE9DECA2983F5FC8B3E18789D5A8DBAE48CE93E9A297E58498D5A5D2B5D48B47C5B1C69AE6858E1841EE8998', 'x', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (4022, 9631, 4864, 2019, '2023-01-01 14:38:27', 40, 77, 39, 48, 'sample_tV29TncV4JZXDQOdLoms7Zh70h6fGIZHsJK68Ky8lo0bQvTScqCv8CoTMDIWk2LDMBycMNEVvvzyP0aKVpau4za9GtBjkgZ9Ikkc902c81wpwRpbx9KImJPJYjXflCHlOAhtlvTNMZiseUWnNJ6pV7QUK27yDKkw3G3iCAovPgCyI2Djp7pOubTEewjjKksd4T5XkZudMTHAuzSK6U0TdkndGVZPvOFvPFEmohjLs3lCyeH6FQMWOYArjdTTnG8doANXV3txGxDtejQ0zvCxiMwblg7OlEJU7Oghv74VlP1fqhiNku6dw2s7Wzu4a57C9sIC4Wawwi5K6eiylzn9p60hIAuuJANOfYoB9B7eadpkLMcs5sO2fLDeGizsbi0GcxgoEDsCGc7k5qjIkghAHkPMFwIv3q8S5yNaX04Iwq6YWfcfhUg7sdtI6aV0hQaSGtoGOVjeBFtu3lMjHEoEjTyR2HHaubXOLFa9apafdSwzWz4WJ6LwWaJ8fS24FuEuS75bMwtqkvzLSwEkdYIHLfuxqmK6m1lXm4LnygjsIty7RYfNd1pi7Z0CmdMqDqMky3ML1QoNwMRvVle5S7L0Smekal1zu0kWo0jgaSiHNB6227hd1XCCQ1YYnajS7fRbDBE4GnUxJ9j2uYKEXc8rHxdH8ttEtSndDqtA9iuL6Ny8XrOftHsvFCLA5fJTojlt9nDSrQglETuQRLI8s82TszmQiwtv6hJP1s9ZXDA9eyta9VEeFqgQ7QdMdr7zaFHfdb0jqwgAi1EFwvodgkpn6bbxXsdsvhPDG0o6rBH1qzwaJ2I80LDuMclhzPpJ09skXfW4FIx9D2J68mcsR1sSL8ty2tB78nTR8BflJyAo3eOZfgndeOAjlj7A3JdRhNbt0G3e3GSUDI3iIxAaiUgByvsnXEMu0paHuNIrHizwrtX69lcJUPeSsE9L1E1iSMpm5I8UTtDjPBX1QPON5Mob2v5L09XUSlRAHSSMtrsdtnR6aJzqv3ayuPhWBo2sEEvC1YshGPQ0sRC6CU3METP5mhztzeBXZchd2FWpi2WamkIBmGHyfjs7SVW3gB6cewUIcvppgKYqekKBvVvOxXNYpuAOQKqm1jJXl9UREyEmytxHl0SaOj387AqmtP4sNlcxetkX4TioBi0mKJDhSbNLUJFm3weWAJkakSk6lFqhOrxo9QtFyh1ZigLmsEVJnq9luOjeLi36Abh0', ST_GeomFromText('POINT(-65.821309 136.91552)'), 'sample_fa6q65q2yXtnfJF2PUbhErhEq5d64JuGw1bjOzJTbkd3CwKuI07qyGPospcoYGpXpgN7h7CZJjCQ', X'E79999E5BAB0CCBAC2B1D790ECB1BBE795ADC985E1A582E1A48C22D3B3C5AB', 'y,x', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (6426, 7522, 6199, 2004, '2023-01-01 13:57:21', 70, 92, 1, 79, 'sample_XQC1DLyw6Y4EbAuIad6Ijo9M68ErCQkAuN42atfyRhOanVMn4rTMIqX60PcrWPXeBk4nsgonxnBVBBqcUPdTTSkrkG0tKHYXbxuDXCKc37bQRqZyVnAceaFs26Qm3XH6Ejq7SrfArrTJSKUK9QK6BcfNhuN138dMknW0QvD1bkXEhi2GNVajtL1KNr7pttzw37XkzfGCR1o47eFAoGC1y8sho6aYeUhPfU4UygcBtsBdyE7yc31v1rJVYfm9FbRRzCE3NrwWKZkX8EClsvCQzTiawIC3EAVUKwLFfVpfcb1Rdk1xrNNAxOhnE7f5T2tp77NbTP20BhMCQuAq6JOyP7ijw9XQU8uMnyq79rZRuBZxb5bi8b74iHvyBnhvBRQcXlxZU3sm0MHfxcT88xWS2DwXN8s4c6eJrXrs8q7c3zdoYbq8dR0tBGKdIqrrH3jbE8HNIbeMzckSkmVG3E2LwANMKzVMBE305mMyKaFrWJedqSyOgSRDM9lk9LVJEPw4rhfmOUZpWdeTzxDDK0XchkbbglrjsigW8zoDUhZpekklyAXvxqFdjmkSvI5PMJCI9qmYeS9CZRtTZLzlIhBVULFF3TUZcNzvkGL75XDx9qMTyLDKrGSAYmiuKyNjjiuSPNwHUEZ2QNzftFHC24N8UtzZ2JLsnQDj8CUioNOVYiZRquisCiZ1S4RfkeQSXuFefwxgFP6A5EqZRythNDWlR2EfPFshVE6P7eOFII2baqfP8Mnfmjh8a6MQ7ls9XfSHICBAKndx7mw6OGtETrfvipbZ14qK0SmbpkV2fOOoSMc98pn0lob9mjRo02EEKPtvecTMhaX4FqkwVtQxNEE5lTZDg69oms2k8hy4tONHnGqsZcpP3bBVvYO8EzKSRnj2yM1MlBd8aQyfxfrKmDffUgzXgi0oarXd10T9i9E4YXRLdMHqESieHQeIaV7EzVs0irNVfCIsdJXA84WTq7T33huD2OS2OJUYH0gImsWyWjmgwnIOc70kSIeg6RwPJ7Admd7NT06v3C8oXEB8t1Mrq0lpVMkUHElJ4oPOcNS7tSfFzJMsxEWGotHtBTqK9X90K1SCSuStQwptoBhIOHqYThUJyw4qOeT9KlNePQIt53qYr8FH3cVIKRkC0zANFoB4HuyB6WC1rm95LlKf1AXbq3FuxegWDMW5R1BNxfGEaztV8eoG3mJ8BwDdU7Cta7cxUXmqotoRRasnhx91DVLIQZNIA84PLUwITIc7Ye6FBgzUXzuEtHYV7asfDluPaw3bWuyKdU8B1FXVSnO4FKf0qfdbtD8JnPxzYLrbsM3E2DBfsIaNfOrFkS3lTzpbN8tKW9Twqv9cXPbZ64wZTkikhkDUruTlnZJlS0s5Z8hVHEyy1hx3', ST_GeomFromText('POINT(-66.144616 14.613064)'), 'sample_qWVTVUWrdnvfWUv2pLiBAiFa0GRsuztDHNO8GNxDEpddzOpQKmp8CU0ao1SwgGX59IgoeR8FUSsjPSXKSeoYiCaTIEd9vXbDYUFhAd4qRf5hU', X'1ED78A400DEB9FBC63C899D280', 'z', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (4411, 449, 8409, 2013, '2023-01-01 14:29:36', 48, 49, 2, 45, 'sample_sVjbjiDs1X9hoHcn55PKaNzeN8CKpM8gBYSLz3xcv8zmpzRPvjem25LA5y1D44pj9VqVq6IsvvCedBN9SerkHxR8YGyCE1raWypwU8S9p9RORcNB1hgUkHGQk6CsSpkMPMbyrTKUYeE7UquLg19SJoiXKQPWmQbgvhyZ2oXSvGle9CeorSQyfJWIqBpPYoyEmxPrPAFi56oqL2EgAucE2S3cGdQzuxd0OREn6uczIdgXzANDNDeBY0f0tb3SVbloHFqsGJDqgkJ57TgnPaNb21Sf4QbW7muPLGxR9qRVtEvZhv8d3nuDF1FOpypDIUw4oi7FS3JpXcX8pkMVtR8ZfYiFMxp2fUyMCF2J4IhAHswelJqUaAebhMQlZWTe7Qnqtrl96kh8GV5hpQkZQ3WgWQlJnEv5ueI5Qk4i1iBpCMFgxq1D4StCikHdb0jZrmle0OnK23sOqhJe67M57YejPGPLNvJkjHtNakQOTmzse45camAAfagSIiNpamucxGYp3hADgtG4DJTMLxH01ByRyVVKGF73KChc8QlTc11OrwTemf2e75XmA73Q0cX237oyMrALBholU9Qhz2wgzuwHoUxXV8ABnzSibwJK8AQ7zci1qHwrS4E7czqJGCc5i49KSwI07cKQ1xEp1CgAJAKFH2oK0tkzxDzrhg6fcAypucWqeQVGxEpqkYLMDHKeCoo7bWM8RGlMGHjEiTUQ41t6TVSulZ64v05atw7XMvSqlrIW4ALBQFTNBj4DJ4rFDb3ODSVj2cTq1GYC0CaGMMiOLSuFSblB1VLhujVvIX8SOvQCw8kr5KUhurskSK', ST_GeomFromText('POINT(-70.852719 -131.130172)'), 'sample_fEuhusnKnzwx6rdyQDri9yAfztNY50KT3nTanNaCKZbz85fqfehpIopYRsLCdgKaamA3dUkA', X'E0AF9E55767FEBA586CCAFC8B3E58BBEEA87A8E9A8B1', 'z,y,x', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (1085, 2763, 2975, 2007, '2023-01-01 15:12:10', 63, 1, 34, 26, 'sample_aHoPDrM9h9qPx2R5p08vDEY2cvLkh5N9oZZjlOD0ChQwcNQKuIHknQFNITBwl1Ya9X37mTLyjYYo1vZ27FH87Z40mAiWM8cLaLnH8czFIHWfcWLlaXqzDmO1QFllrJXGDGhVJuTIv6ih6iT7sRaWkmQnoMVknNkSm1nXAuM4I81uIVtwtJS7iWQoWGkpUgiXymwNAElixWWb7HpQndKg8siuxMMHIeRw4ZZADaRRV1AIbJVHzPqjT8xh3QYlbC62FU5L5KIQ2nosywiMGb9jUbjePc4FhlxaJ4u23yF9lOjQwW7788QlFI7uyDBOZyQ1ZzMGlMZnSfjZlLXYnwfwYIa15CMIAVNbatKfQ7oOfhWEtNMCjS4vTG1r3pkIS2qmVJtvQ0lOX1pSll3V2WZPGqLlVjhvQBSCzi0SQcSDWAH3Iax0liTmEN8w9FZlbPgx4J8WL46oxiS66wwnSZtY31Q98uFh7pewmFwNFgg0oqkMOWvgpMTmH7jgct3txIqA3nD0CtBvSVrXfcYVJYvUenBcuEvcJO23kl1F7c7DQ8HV1KlOd5SirrK7W3WAKd6yFeucGuohe53h7wFrrKeF2vsQOFdeJF7f1pS5aISuPrw9aKd3Za4cnKC0wFmI7I8FDvnJZrFN3pFqkIkG3BEeBd3OJg7Wtf3wQEVweJN3LBFpaEJF6roXxbLvh2KLHzzBGKNMnBJoJqwQuW2LQhWEQZ6O8ec3mlyS2FsRTPLBSOqbN11QZ5ma9PA6mQGCDUvTt33hSNezWQC7p8qAsUY0S46PgEh7LpDJ3UEBGfakLMIQDv9fJJUz1m6q06QTQyeMdQ2qutYGdRhMFCAwzU587xBaCgQas8eRDPbgq2p87FjzRuf8x4A5uTtVf6AiSekEvectEsv9vWbkvSA2YEz8nd2uwprgQIgcKKDHCkEYMZToy4vnr44x62BLmW3xq9SQcCI3b9Byow6xAhP9kP5HwcnzQ9mJ0hpR9ZmoqKnswbnzkljgsImEhSXF74xtwuuTcrVmi1Za7dX0UwvP8s82bJiWpcHSS2mfYwsGhiXyWuCDvC3o9GWQMLkevbMBJKhmvvSZe997HIocr7h6hqRHMOc1eoviWUHCDsqA7KCkBXh3L5bhnMhtzVEUMVkMZSIn0wh4Ee0IoIJiT3OJYqras15EmIc0BTtkdEQyQ22woIhwKIsVbvlg3pbrLNgDc6HRSklVELiZ4qCG9tahewOjcXFlGH4qfkhjfzQ6r0zmKBuQ0qkce42jBRC1SrrJ3juXf3qfFn8GuaizX1qxrflQzHEPYhZtc2dlrNcJt3SPpq5PbZRf5eyXz6Y9PGH4xAcZcCE4RJbCXQErK5Aup7NOlEab6ZTFR7U5B6DNzsyXNEdGyoVcagmLBLD8K6QRLtY66EmbnjaAWSJEvetWgfM92Fy8m2h5yZWuXWmqR7rIsMlBQNr1d23KZbTHKJmTg2d62pS8E3JPyBuTHT3fxfn68i9QH88KaVtytVHDfqrS8A94kslTIyvNStoetLzwUHIO8lcYaqLiDoUC9u6FHK6wXS7lF9nJQlKMlHYFvX91lXrvZAXHajSqO6SRsrSuFSREzflFdHE6nNyirtd24UzTyPEfjpkIgltNqB3DRA1JMtesh0f699uGyRmnDisXk2570lWDEZzmEhlGNgnJz1S', ST_GeomFromText('POINT(82.595314 62.13004)'), 'sample_IBYf', X'E2AEBFE595B4EA87B8E095AFD2A0E1A0AB72E48580E58892E89FB5147CEFB9BF55EE8B9C0FCDAA', 'x,y,z', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (510, 5571, 7714, 2015, '2023-01-01 02:43:49', 9, 69, 91, 14, 'sample_nZ8grMKFPRjpnLzDX0yF1rqiCAhAwRCIhT8r35YM0lvloSt71JWulAXc8AQCGnXWlZIEu9SnI9cn00c6PS1Irda7xQSlgq0PKYkLh6FvaDkkR2d6h32pkLLfaOowvhDPe0KiYgSfb4rRZuihioJuYfbxrTqAexhzQDBEvQ00nooTUGOuTWdar1vP6v4ixcA0WB5bVUaU9mxQJj7AL974Z5g2tKcBhot8rc61auXoStb01X7hlmuxJZRfWGW1lEnk2i54mPACkORABjIWIk5hwyiSUzRdZftS1c2qaNhhGNeTzCJbejiQvsl0Yt3BOv0zipmqMcVVgUluk6KAauoixb2Ts5s9jcj2Vn0Dy9oB2W2e7XWi9yAYVRKy3Yfxz1P2yMVNX8Lfwv7kvVsXCdXulA3jZWTeNLkFVYjpzUGYhR4qi9R5TOgsgi5sD6bC7On72lLZkH3oaB5fbbiPGW3P7AwjJK9BpXwZogIs1Aljtkzxf9TBdUSQiJyvz8P0yjgfLLopLlwnXLnafpEXaVAdCDeBqgTImvb5LpS3gaVXiopQ0FWeUD9phcYEBpsZL2F11VIObu0k4gYdqBxcwBRdtoTBbWSKW73dQwMD70ylqybAUr41PrX91ngm5GmkzAFaAAStx2T0wtmSllCTMOzZyRCQ2KhpX0YpCg8Ibqm0sD38YwNJf9JYeeGQCyVSJwdYPglb3nym7Yn5WY6Af6JSXdQJtSXI3gOSoOcv9f3MMCuyoOPQPs3r840VtImS0tlMLmdV8C260pKqTM386dcFhHuyLSXJF5KTSMoAl2rBMUHOrj1KjUsiW88eTCIAYrl5aWBjxipX5kP37iAoujMbjxPbXmMRGACkFjPHEGWTV6xDydl6g2vx8WqvhFQTwQx49eRaUSFgztxYVWrde7cNhoEaEPUs6otnJd1phanwbiV4huqiJpkZSG3Ma1LnGyUs0KtFmfq1pI3xjV0Vbh3rcIEqqYt8sKfkEUCyT35wRzTTFcCcRgq5IOtICtQ7Vx8JoDsYBgxnwTfS1glc01uJKBWYjeRhn06gOMnE8DpmjTi7wApfjKfYQ5nop5jcU0XesGLCQJTIe9qTOlX4ioeuPQ5XAtSe4HTMgd8wWbyvOTmA0VK43vlPiU7tclMB7gTNU5R1FYFthgiPYkhe8Y0v7Yc5h8eLfEHbXHxgNrUhtQmwhEhZkykbNd5biJ3AWdXGOVb9x9NjCBsKI80ktPQpIPfXYW9bJd79CeNSYyWFA009pdXp76sie7FbWsVyWKQ1XHEsUinozlhuRZnFnF1TYK3Bx15eZPQqhNT9U1vwiC8DRr6aB3nyxGoLy5XJY7wcbHWYXmVQpVZ1ZfnVNqhuV4NN5sljF0WL3lvohYzenarc4X9xi4D3eYCqalvkbCXv5U7NjRfVvD7vewRTnfwDmWWDGESobkAB201kkPUfhbdBUgwtxGVbQXQ87sawxaguFcwMimfhphUmmGT3hNw1A8bOvLAXp2IOcBOilavISaF7VnagHEirljqVM2myu8pBWdnvmseD6gefBCBs8ZcFUoQ39UAWJh8bNtS2oOpCwHJsO97E6zM7K14RVKq2qwhSoDRJJGc4irkLIfjzXP8cAactNd1nr7rXzkXJjXgJd4KbeT4jRQkANkuNnTdjVnvZxTeUJsMkIaTEnV3kXKIhxHZkuXBPvSivv66EtjwAcloRn3Rs1NVfS8pxhNyrAbBwCr8weuq3Bq2cc4TmVOi9JVGxBh8sdvKvVmV7ngxbqiCH9e6J4Tf1EG34PprA244qH6TLFescFjTwHxvNX1onraCPR2bfRzt92Vm3VTWYeAQjrka32EJKOqdopGfruj7jIv0tUMQefMjYP2hLBqVkR3KEY6WDeFpWgXp', ST_GeomFromText('POINT(-10.840635 -89.809865)'), 'sample_i1dt2wvceZ01hn8h0aqW9cpZahmFvH4nNUf', X'EC9F81CD97C082E1BCB5DAB36949', 'y,x,z', NULL);
      INSERT INTO t3 (c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15) VALUES (3231, 2763, 3056, 2013, '2023-01-01 13:26:25', 40, 47, 18, 35, 'sample_hjTDOAULOkGlzHDbROOOHIYdZXQhRUaT7MH7gx9UP9ATBMNYzR9Gw7mUNAAxTDNuPAh0llmcrfkUcP3DtkoDLz7jHXZB507q3nUdH58h4uy7afN1U2BGpA9HEigGrKu0FmP4byRo5pae5CZK15GOPMXDPs8c2sbT4gY9oR68nkp6hrz6rKzmYux1HvfvrHDLgYnCMft0nbW1L1XBgiJ21G1JdgWw55wQEgvrQmhwBcmU', ST_GeomFromText('POINT(36.082315 -152.710796)'), 'sample_odvI7yJulTApVtFlm8c2azzow4xb8VRzhjxKigVdA6AtdeicakB4IVqFgdCBmnYS8kkjPJ1LR9cV6FM2I0i6AcRhlymCLqAjVQ1WAlrwwQ5ZjtpI9qMZYnPRbi5JQPBPaY5nOqdw6vkvTyCE30r6H69ziQsK3kNGYWuaJcsApn3J9A1TgnK4niFV', X'7476D8B9C4BBDA8DD1BAE8888519635F5D117F4301E4979D50485A53DF9DDFB8E5A7BBD9A8C783', 'y', NULL);
       
      SELECT MIN(hwb86.c10) AS col_1, hwb86.c3 AS col_2 FROM t3 AS hwb86 WHERE hwb86.c3 = 8409 GROUP BY hwb86.c3;
      SELECT MAX(hwb86.c10) AS col_1, hwb86.c3 AS col_2 FROM t3 AS hwb86 WHERE hwb86.c3 = 8409 GROUP BY hwb86.c3;
      
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:

              Git Integration

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