[QBERG] mariadbadmin@sw-dbmcs-uat: ~ $ cat CS0493005.sql | /usr/bin/mysql -h 127.0.0.1 -uqdaemon -p<redacted> -t
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
| ri_id | price | priceOriginal | ri_pd_id | ri_va_id | ri_mo_id | ri_ma_id | ri_fa_id | ri_ti_id | ri_in_id | ri_si_id | ri_pv_id | ri_data | ri_ora |
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
| 1012173983 | 1260.03 | 1260.03 | 1344 | NULL | 3727010 | 1 | 2 | 2243 | 1107 | 97 | 94260 | 2022-11-14 | 10 |
|
| 1011894163 | 2999.99 | 2999.99 | 1344 | 1 | 3409525 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894167 | 6499 | 6499 | 1344 | 1 | 3735172 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894176 | 2228.99 | 2228.99 | 1344 | 1 | 3409534 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894230 | 2417 | 2417 | 367 | 1 | 3432503 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894254 | 3898.99 | 3898.99 | 1344 | 1 | 3409525 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
| 1011894269 | 1698.99 | 1698.99 | 1344 | 1 | 3409536 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
| 1011894271 | 1150.99 | 1150.99 | 1344 | 1 | 3439156 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894280 | 1481 | 1481 | 367 | 1 | 3432511 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894323 | 849 | 849 | 1344 | 1 | 3727022 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894341 | 1999 | 1999 | 1344 | 1 | 3717413 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894343 | 1822 | 1822 | 1344 | 1 | 3728960 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894344 | 4999 | 4999 | 367 | 1 | 3511749 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894348 | 1049 | 1049 | 1344 | 1 | 3728955 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894365 | 2699 | 2699 | 1344 | 1 | 3728956 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894375 | 1599.0 | 1599.0 | 367 | 1 | 3755606 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 0 |
|
| 1011894385 | 999 | 999 | 1344 | 1 | 3726996 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894422 | 1894 | 1894 | 367 | 1 | 3739038 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894437 | 3499 | 3499 | 1344 | 1 | 3728958 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894448 | 1694 | 1694 | 367 | 1 | 3755602 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894451 | 1799.0 | 1799.0 | 367 | 1 | 3755602 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 0 |
|
| 1011894455 | 3399 | 3399 | 367 | 1 | 3739036 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894477 | 1810.99 | 1810.99 | 1344 | 1 | 3409535 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894504 | 1456.99 | 1456.99 | 1344 | 1 | 3717413 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894517 | 9999 | 9999 | 1344 | 1 | 3755563 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894523 | 1169 | 1169 | 367 | 1 | 3755607 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894539 | 689.9 | 689.9 | 1344 | 1 | 3439156 | 1 | 2 | 2243 | 1684 | 365 | 182990 | 2022-11-14 | 0 |
|
| 1011894552 | 1338 | 1338 | 367 | 1 | 3755610 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894555 | 1999 | 1999 | 1344 | 1 | 3727203 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894572 | 3105.99 | 3105.99 | 1344 | 1 | 3409529 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
[QBERG] mariadbadmin@sw-dbmcs-uat: ~ $ cat CS0493005.sql | /usr/bin/mysql -h 127.0.0.1 -uqdaemon -p<redacted> -t
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
| ri_id | price | priceOriginal | ri_pd_id | ri_va_id | ri_mo_id | ri_ma_id | ri_fa_id | ri_ti_id | ri_in_id | ri_si_id | ri_pv_id | ri_data | ri_ora |
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
| 1012246468 | 1805.64 | 1805.64 | 1344 | NULL | 3728960 | 1 | 2 | 2243 | 1673 | 352 | 181832 | 2022-11-14 | 12 |
|
| 1012249920 | 1099.00 | 1099.00 | 1344 | NULL | 3727034 | 1 | 2 | 2243 | 545 | 72 | 116219 | 2022-11-14 | 12 |
|
| 1012549475 | 1899.0 | 1899.0 | 367 | NULL | 3432511 | 2 | 2 | 2243 | 133 | 64 | 5072 | 2022-11-14 | 15 |
|
| 1012553805 | 1635.53 | 1635.53 | 1344 | NULL | 3439156 | 1 | 2 | 2243 | 128 | 60 | 128400 | 2022-11-14 | 15 |
|
| 1011894163 | 2999.99 | 2999.99 | 1344 | 1 | 3409525 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894167 | 6499 | 6499 | 1344 | 1 | 3735172 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894176 | 2228.99 | 2228.99 | 1344 | 1 | 3409534 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894230 | 2417 | 2417 | 367 | 1 | 3432503 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894254 | 3898.99 | 3898.99 | 1344 | 1 | 3409525 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
| 1011894269 | 1698.99 | 1698.99 | 1344 | 1 | 3409536 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
| 1011894271 | 1150.99 | 1150.99 | 1344 | 1 | 3439156 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894280 | 1481 | 1481 | 367 | 1 | 3432511 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894323 | 849 | 849 | 1344 | 1 | 3727022 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894341 | 1999 | 1999 | 1344 | 1 | 3717413 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894343 | 1822 | 1822 | 1344 | 1 | 3728960 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894344 | 4999 | 4999 | 367 | 1 | 3511749 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894348 | 1049 | 1049 | 1344 | 1 | 3728955 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894365 | 2699 | 2699 | 1344 | 1 | 3728956 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894375 | 1599.0 | 1599.0 | 367 | 1 | 3755606 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 0 |
|
| 1011894385 | 999 | 999 | 1344 | 1 | 3726996 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894422 | 1894 | 1894 | 367 | 1 | 3739038 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894437 | 3499 | 3499 | 1344 | 1 | 3728958 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894448 | 1694 | 1694 | 367 | 1 | 3755602 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894451 | 1799.0 | 1799.0 | 367 | 1 | 3755602 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 0 |
|
| 1011894455 | 3399 | 3399 | 367 | 1 | 3739036 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894477 | 1810.99 | 1810.99 | 1344 | 1 | 3409535 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894504 | 1456.99 | 1456.99 | 1344 | 1 | 3717413 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894517 | 9999 | 9999 | 1344 | 1 | 3755563 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894523 | 1169 | 1169 | 367 | 1 | 3755607 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894539 | 689.9 | 689.9 | 1344 | 1 | 3439156 | 1 | 2 | 2243 | 1684 | 365 | 182990 | 2022-11-14 | 0 |
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
[QBERG] mariadbadmin@sw-dbmcs-uat: ~ $ cat CS0493005.sql | /usr/bin/mysql -h 127.0.0.1 -uqdaemon -p<redacted> -t
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
| ri_id | price | priceOriginal | ri_pd_id | ri_va_id | ri_mo_id | ri_ma_id | ri_fa_id | ri_ti_id | ri_in_id | ri_si_id | ri_pv_id | ri_data | ri_ora |
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
| 1011947500 | 1699.0 | 1699.0 | 367 | NULL | 3755610 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 6 |
|
| 1011948051 | 1579.00 | 1579.00 | 1344 | NULL | 3727005 | 1 | 2 | 2243 | 545 | 72 | 129504 | 2022-11-14 | 6 |
|
| 1011979286 | 1529.69 | 1529.69 | 367 | NULL | 3755606 | 2 | 2 | 2243 | 1107 | 97 | 94260 | 2022-11-14 | 7 |
|
| 1011981082 | 1679.00 | 1679.00 | 1344 | NULL | 3728962 | 1 | 2 | 2243 | 545 | 72 | 116219 | 2022-11-14 | 7 |
|
| 1011894163 | 2999.99 | 2999.99 | 1344 | 1 | 3409525 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894167 | 6499 | 6499 | 1344 | 1 | 3735172 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894176 | 2228.99 | 2228.99 | 1344 | 1 | 3409534 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894230 | 2417 | 2417 | 367 | 1 | 3432503 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894254 | 3898.99 | 3898.99 | 1344 | 1 | 3409525 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
| 1011894269 | 1698.99 | 1698.99 | 1344 | 1 | 3409536 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
| 1011894271 | 1150.99 | 1150.99 | 1344 | 1 | 3439156 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894280 | 1481 | 1481 | 367 | 1 | 3432511 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894323 | 849 | 849 | 1344 | 1 | 3727022 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894341 | 1999 | 1999 | 1344 | 1 | 3717413 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894343 | 1822 | 1822 | 1344 | 1 | 3728960 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894344 | 4999 | 4999 | 367 | 1 | 3511749 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894348 | 1049 | 1049 | 1344 | 1 | 3728955 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894365 | 2699 | 2699 | 1344 | 1 | 3728956 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894375 | 1599.0 | 1599.0 | 367 | 1 | 3755606 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 0 |
|
| 1011894385 | 999 | 999 | 1344 | 1 | 3726996 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894422 | 1894 | 1894 | 367 | 1 | 3739038 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894437 | 3499 | 3499 | 1344 | 1 | 3728958 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894448 | 1694 | 1694 | 367 | 1 | 3755602 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894451 | 1799.0 | 1799.0 | 367 | 1 | 3755602 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 0 |
|
| 1011894455 | 3399 | 3399 | 367 | 1 | 3739036 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894477 | 1810.99 | 1810.99 | 1344 | 1 | 3409535 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894504 | 1456.99 | 1456.99 | 1344 | 1 | 3717413 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894517 | 9999 | 9999 | 1344 | 1 | 3755563 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894523 | 1169 | 1169 | 367 | 1 | 3755607 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894539 | 689.9 | 689.9 | 1344 | 1 | 3439156 | 1 | 2 | 2243 | 1684 | 365 | 182990 | 2022-11-14 | 0 |
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
[QBERG] mariadbadmin@sw-dbmcs-uat: ~ $ cat CS0493005.sql | /usr/bin/mysql -h 127.0.0.1 -uqdaemon -p<redacted> -t
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
| ri_id | price | priceOriginal | ri_pd_id | ri_va_id | ri_mo_id | ri_ma_id | ri_fa_id | ri_ti_id | ri_in_id | ri_si_id | ri_pv_id | ri_data | ri_ora |
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
| 1011986655 | 1499 | 1499 | 367 | NULL | 3742939 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 7 |
|
| 1011894163 | 2999.99 | 2999.99 | 1344 | 1 | 3409525 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894167 | 6499 | 6499 | 1344 | 1 | 3735172 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894176 | 2228.99 | 2228.99 | 1344 | 1 | 3409534 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894230 | 2417 | 2417 | 367 | 1 | 3432503 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894254 | 3898.99 | 3898.99 | 1344 | 1 | 3409525 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
| 1011894269 | 1698.99 | 1698.99 | 1344 | 1 | 3409536 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
| 1011894271 | 1150.99 | 1150.99 | 1344 | 1 | 3439156 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894280 | 1481 | 1481 | 367 | 1 | 3432511 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894323 | 849 | 849 | 1344 | 1 | 3727022 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894341 | 1999 | 1999 | 1344 | 1 | 3717413 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894343 | 1822 | 1822 | 1344 | 1 | 3728960 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894344 | 4999 | 4999 | 367 | 1 | 3511749 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894348 | 1049 | 1049 | 1344 | 1 | 3728955 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894365 | 2699 | 2699 | 1344 | 1 | 3728956 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894375 | 1599.0 | 1599.0 | 367 | 1 | 3755606 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 0 |
|
| 1011894385 | 999 | 999 | 1344 | 1 | 3726996 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894422 | 1894 | 1894 | 367 | 1 | 3739038 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894437 | 3499 | 3499 | 1344 | 1 | 3728958 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894448 | 1694 | 1694 | 367 | 1 | 3755602 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894451 | 1799.0 | 1799.0 | 367 | 1 | 3755602 | 2 | 2 | 2243 | 134 | 65 | 5073 | 2022-11-14 | 0 |
|
| 1011894455 | 3399 | 3399 | 367 | 1 | 3739036 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894477 | 1810.99 | 1810.99 | 1344 | 1 | 3409535 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894504 | 1456.99 | 1456.99 | 1344 | 1 | 3717413 | 1 | 2 | 2243 | 1289 | 185 | 124843 | 2022-11-14 | 0 |
|
| 1011894517 | 9999 | 9999 | 1344 | 1 | 3755563 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894523 | 1169 | 1169 | 367 | 1 | 3755607 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894539 | 689.9 | 689.9 | 1344 | 1 | 3439156 | 1 | 2 | 2243 | 1684 | 365 | 182990 | 2022-11-14 | 0 |
|
| 1011894552 | 1338 | 1338 | 367 | 1 | 3755610 | 2 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894555 | 1999 | 1999 | 1344 | 1 | 3727203 | 1 | 2 | 2243 | 127 | 59 | 5065 | 2022-11-14 | 0 |
|
| 1011894572 | 3105.99 | 3105.99 | 1344 | 1 | 3409529 | 1 | 2 | 2243 | 131 | 62 | 5070 | 2022-11-14 | 0 |
|
+------------+---------+---------------+----------+----------+----------+----------+----------+----------+----------+----------+----------+------------+--------+
|
[QBERG] mariadbadmin@sw-dbmcs-uat: ~ $ select version();
|
-bash: syntax error near unexpected token `('
|
[QBERG] mariadbadmin@sw-dbmcs-uat: ~ $ sudo mysql
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 23055
|
Server version: 10.6.9-5-MariaDB-enterprise MariaDB Enterprise Server
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> select version();
|
+-----------------------------+
|
| version() |
|
+-----------------------------+
|
| 10.6.9-5-MariaDB-enterprise |
|
+-----------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> select calgetversion();
|
+-----------------+
|
| calgetversion() |
|
+-----------------+
|
| 22.08.1 |
|
+-----------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [(none)]> use temp_cs
|
Reading table information for completion of table and column names
|
You can turn off this feature to get a quicker startup with -A
|
|
Database changed
|
MariaDB [temp_cs]> show create table temp_cs.modelli_paniere_3099727 \G
|
*************************** 1. row ***************************
|
Table: modelli_paniere_3099727
|
Create Table: CREATE TABLE `modelli_paniere_3099727` (
|
`SIID` int(11) DEFAULT NULL,
|
`CDID` int(11) DEFAULT NULL,
|
`PVID` int(11) DEFAULT NULL,
|
`CODICE` varchar(30) DEFAULT NULL,
|
`MOID` int(11) DEFAULT NULL,
|
`PDID` int(11) DEFAULT NULL,
|
`FAID` int(11) DEFAULT NULL,
|
`MAID` int(11) DEFAULT NULL,
|
`TIID` int(11) DEFAULT NULL,
|
`INID` int(11) DEFAULT NULL,
|
`PVTIPO` varchar(8) DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3
|
1 row in set (0.000 sec)
|
|
MariaDB [temp_cs]> isweb.rilevazione_custom_cs \G
|
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'isweb.rilevazione_custom_cs' at line 1
|
MariaDB [temp_cs]> show create table isweb.rilevazione_custom_cs \G
|
*************************** 1. row ***************************
|
Table: rilevazione_custom_cs
|
Create Table: CREATE TABLE `rilevazione_custom_cs` (
|
`rc_id` int(11) NOT NULL,
|
`rc_cd_id` int(11) NOT NULL DEFAULT 0,
|
`rc_pv_id` int(11) NOT NULL DEFAULT 0,
|
`rc_si_id` int(11) NOT NULL DEFAULT 0,
|
`rc_do_id` int(11) NOT NULL DEFAULT 0,
|
`rc_codice` varchar(30) NOT NULL,
|
`rc_va_id` tinyint(4) NOT NULL DEFAULT 1,
|
`rc_pgdir` bigint(19) DEFAULT NULL,
|
`rc_prezzo` decimal(10,2) DEFAULT NULL,
|
`rc_prezzo_listino` decimal(10,2) DEFAULT NULL,
|
`rc_prezzo_spedizione` decimal(8,2) DEFAULT NULL,
|
`rc_importazione` char(1) DEFAULT 'N',
|
`rc_sconto` char(1) DEFAULT 'N',
|
`rc_rs` char(1) DEFAULT 'N',
|
`rc_ricondizionato` char(1) NOT NULL DEFAULT 'N',
|
`rc_ggdisponibile` tinyint(4) DEFAULT NULL,
|
`rc_sottocosto` char(1) NOT NULL DEFAULT 'N',
|
`rc_promoatempo` char(1) NOT NULL DEFAULT 'N',
|
`rc_ts` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
|
`rc_obs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3
|
1 row in set (0.000 sec)
|
|
MariaDB [temp_cs]> exit
|
Bye
|
[QBERG] mariadbadmin@sw-dbmcs-uat: ~ $ cat CS0493005.sql
|
SELECT rc_id ri_id,IFNULL(JSON_VALUE(rc_obs,'$.prezzo'),0) price,IFNULL(JSON_VALUE(rc_obs,'$.prezzo'),0) priceOriginal,PDID ri_pd_id,JSON_VALUE(rc_obs,'$.vaid') ri_va_id,MOID ri_mo_id,MAID ri_ma_id,FAID ri_fa_id,IFNULL(TIID,0) ri_ti_id,INID ri_in_id,SIID ri_si_id,PVID ri_pv_id,DATE (rc_ts) ri_data,HOUR (rc_ts) ri_ora FROM temp_cs.modelli_paniere_3099727 JOIN isweb.rilevazione_custom_cs ON rc_pv_id=PVID AND rc_codice=CODICE WHERE TIID IN (2243) AND rc_ts>='2022-11-14 00:00:00' AND DATE_FORMAT(rc_ts, '%Y%m%d%H') IN ('2022111400','2022111401','2022111402','2022111403','2022111404','2022111405','2022111406','2022111407','2022111408','2022111409','2022111410','2022111411','2022111412','2022111413','2022111414','2022111415','2022111416','2022111417','2022111418','2022111419','2022111420') AND rc_obs IS NOT NULL ORDER BY ri_va_id, ri_id LIMIT 0,30
|
[QBERG] mariadbadmin@sw-dbmcs-uat: ~ $
|
data1.tsv