mysql> select @@version; +-------------------------+ | @@version | +-------------------------+ | 8.0.35-0ubuntu0.23.04.1 | +-------------------------+ 1 row in set (0.00 sec) mysql> create table t4(id bigint unsigned auto_increment not null primary key,name binary(64) default (sha2(uuid(),512)); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 mysql> create table t4(id bigint unsigned auto_increment not null primary key,name binary(64) default (sha2(uuid(),512))); Query OK, 0 rows affected (0.02 sec) mysql> insert into t4(id) select id from t2 limit 10; ERROR 1406 (22001): Data too long for column 'name' at row 1 mysql> create table t5(id bigint unsigned auto_increment not null primary key,name binary(255) default sha2(uuid(),512)); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sha2(uuid(),512))' at line 1 mysql> show tables; +--------------+ | Tables_in_db | +--------------+ | t1 | | t2 | | t3 | | t4 | +--------------+ 4 rows in set (0.01 sec) mysql> create table t5(id bigint unsigned auto_increment not null primary key,name binary(255) default (sha2(uuid(),512))); Query OK, 0 rows affected (0.02 sec) mysql> insert into t5(id) select id from t2 limit 10; Query OK, 10 rows affected (0.01 sec) Records: 10 Duplicates: 0 Warnings: 0 mysql> select * from t5; +----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | name | +----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | 0x316438663334383062376566633237353737323030663662306235363464333064333261386365396661643630396637373839316161356565396139356466313363306364613439313662323530626239393666616130626634383634646363313565623335356565303333303532353337643734333461363130626231356400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 2 | 0x653330393335666438386161636362386231356233316132653630326362396165333363393533343466663332626461636433656530303133316536613361646362373932653264313232636332383161366436343039386539336435666234373436353232373030376636356536633931356164663232653131326232613000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 3 | 0x663436393533366136366661396661623830326534336635313631343930333865323638383964396636636235386562316165613936633537663666653634616436663765353538653234343732393866323531613838613234663063323563666239373733356261396462623730396538346137646266316534323762383500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 4 | 0x613633616535373862393762376435623636326462646435366466363161663239336432353461643836303935353763313930633761353863336532316539663937303934303632653431356565303133323739613431396664616437336631373061663533353761666534393735306139303832353333646332323561326300000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 5 | 0x346465316231623864656235653063336631323034626563643335646232613462316637303565376338316463646439306435616136343462323365346233633031343531623230376233343065333061666439366539616435313063353834393030323932336666353366636337646564616165303539643130366534626200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 6 | 0x653231653234383339383730303266623265363562313863646665356364663162383562316432626566303035303734363136383165313430313139626134336635646562326330343530306563373764636664373030623862386432363336613533353465633836623638613366386633366165386131326666623235316100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 7 | 0x663363616236646637323934626363373034363864343837396463613063346537666436656566326263373334643764303434653139656565326661636132616266353233373261346235313362626465613863363031616138663363336432666236646361316661316164383566386332383531373939616664646538376600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 8 | 0x643232363130653662356432336330353430383034343838396438353762626638306339373038346339636137393039633834313466376164353364666337373561386535346166633030633264623435313633313930663164386539333538613235383432383766393531303562346330316539646438646131623434313700000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 9 | 0x313937303430306537646337376439633762323235313636396234333130643330353636323034396562303531353466316466303633616533323138326161333465666439663866363534353166643533396539613030313237636437613330646161393533336235333263343966333832356561643262393934626265373400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | | 10 | 0x363836666538623661393531366437373131633962653635666131633533323432386139646330393835636235343263313135623132353065643865623463633330616539653466396131396338396432656530303132346233303235353333643966636165316366663337393430666464313838663734613236643435396400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 | +----+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 10 rows in set (0.00 sec) mysql> create table t6(id bigint unsigned not null auto_increment primary key,name varchar(255) default(sha2(uuid(),512))); Query OK, 0 rows affected (0.02 sec) mysql> insert into t6(id) select id from t2 limit 10; Query OK, 10 rows affected (0.01 sec) Records: 10 Duplicates: 0 Warnings: 0 mysql> select * from t6; +----+----------------------------------------------------------------------------------------------------------------------------------+ | id | name | +----+----------------------------------------------------------------------------------------------------------------------------------+ | 1 | 817184d33175ce6ac93baed83f5e7f598d1b35d4064ee8dd9195fecf8e04bedf092d9ecadb66bb3c5d53e021aed1606385e3f72e462acd6b4c7a72f90d58b83e | | 2 | 7c8137130a7a3538eeda099656d0d7d0b2fb37fabebfd68f1a45d2670e06f015bb64facb56757999faf8cf7787f43f4bcbd57b5760835f59453e464d590af2dd | | 3 | 4b668d17c63293c32d304250061e923d192909c796905cdc1740729c79204a7e6b26a040acabedcea51a9f7470edde6be62162e37ce4a46c4cb0630aa4422c20 | | 4 | f22fd259e0d67b7de53791f19c6d273f8b620ec95a9b1521aeca006acfa039726f1a8236b7e6ec0aedd5781a989328a71fd4480f26f4469000c924505da53b7c | | 5 | 3a2f77bac55ec247e6e98018f6d388a249eee8db0f300bda71f23af92ee10af373606be6f47cf408d9a046e47c532090824ce879764bfece5a516641c09b7a6c | | 6 | d39211593d1d77a3f48f45afa29d53b99ff08eef09418493f12b6b53154288be0ee2114f7ed39ff657ee35146a0c6e00bc60133a1d8f0bcdffec2a945f8aeec2 | | 7 | fef70324d324db123ee915327be69ecae7a2ab4effa33b106db2104ec1116fdb05beacf776dc4d80d40470af3da457d49800696b5681da39377ba1c0355a76f3 | | 8 | 431551ffa705d1c6ebbc800bfb6deba9f529f91ffcda75356e23b6601fc74c93ec75312c4c1694fbc47de5170890e751811bc925d7f5a4f101fa372a118388fd | | 9 | ac46c55660c59682a0d7230ec5c36c0046652eb5de36b3177712275c922e476f47b1e732c3f367e983d16e9f6e6b11d8b9972249076288743066cbf802d4ace3 | | 10 | a989de92fc21abf7cbbccc2dc9f9ff1f1d4dd3d1adbda5e8f96dacdc7ffbb912dc162d22f1375e194bdd84b1442a003f6b88b68e0b2663cbfdd42509c51b657b | +----+----------------------------------------------------------------------------------------------------------------------------------+ 10 rows in set (0.00 sec) mysql> select id,name,length(name) from t6 limit 1; +----+----------------------------------------------------------------------------------------------------------------------------------+--------------+ | id | name | length(name) | +----+----------------------------------------------------------------------------------------------------------------------------------+--------------+ | 1 | 817184d33175ce6ac93baed83f5e7f598d1b35d4064ee8dd9195fecf8e04bedf092d9ecadb66bb3c5d53e021aed1606385e3f72e462acd6b4c7a72f90d58b83e | 128 | +----+----------------------------------------------------------------------------------------------------------------------------------+--------------+ 1 row in set (0.00 sec) mysql>
mysql> create table t6(id bigint unsigned not null auto_increment primary key,name varchar(255) default(sha2(uuid(),512))); Query OK, 0 rows affected (0.02 sec) mysql> insert into t6(id) select id from t2 limit 10; Query OK, 10 rows affected (0.01 sec) Records: 10 Duplicates: 0 Warnings: 0
mysql> create table t7(id bigint unsigned not null auto_increment primary key,name varchar(128) default(sha2(uuid(),512))); Query OK, 0 rows affected (0.02 sec) mysql> insert into t7(id) select id from t2 limit 10; Query OK, 10 rows affected (0.01 sec) Records: 10 Duplicates: 0 Warnings: 0 mysql> select * from t7; +----+----------------------------------------------------------------------------------------------------------------------------------+ | id | name | +----+----------------------------------------------------------------------------------------------------------------------------------+ | 1 | 30449005c32173c1600520be33b8915b57ca3c57ee27bbfa234d392dcf870282ade6250bb8efcc515db77080d09500330dcc4f4cede54001c9e7dbb32dbde086 | | 2 | 43af479e0afb512ee1bc8474c92e19fb8f3a9a7b74d4002d824db0994ca561c2aa9dff3e65dd2138c6922c2443ea74804843ecf2d6219e7b69eff573c3e529c9 | | 3 | 9bd5c78cef7f3bc6dbe7cb92ca29360a149c1f8571432150e51133a5aa2dfca755049c1a386453804d8b77c89bbfca7ee2d1ad54d79d998d579157f3b8cb99dd | | 4 | 141814574f6c0dddfe555b16ed1bd77ce70b65707e061f7d542ae581ce77135463ea86ade2afd55aa51b2c72a06260194f8392e37dfa57bcb376b081367ec0c6 | | 5 | 85c9fdc652e6f0de4bd3c864354770fc647890c39b0b3a92894efa30634219107cdda190c34ecec694e55702d36037f1a8b64a6a657fb0c3e0718139a81666db | | 6 | d503e9a417b1e8403a1129f0ff2be545dd827771e038f2f4d22eab6cfc7a8c4df1543920e814915b361b5305aaaec92d3c6a199cd38e72d801449718be5ed25b | | 7 | 45e99d69d968efe178f41c7d79e15e5a275bef4e56819a46c1083279b5386f48921a109fa2f89c34b80fb0c847553b73d3caf39fdebf90a028852b6ccfdb684a | | 8 | a8143419a6a6a0c451eb32d43501b4e4280d6856273ee9a087b91334ebd5a50d6714758e607eceb91cea140bcc2b0f3c3ff9d604ad5158fc01569de3970e7468 | | 9 | 55967b203fab20a49344957a08a0a089bb871bd82f4653aec8c51fc7a9ec00f092e388c2dab2848d9b440b1f07ee42365ec7e931ebe8cdf918f62a62f8c7f0d5 | | 10 | 8496bf0094f93a83c0d6bd8df678ff2d9eb4b0964a39c1798b36b6c821ed893c10e8e02ff18776d0e350af0623babace7b8e3a878edcc8718fb6f559a417c920 | +----+----------------------------------------------------------------------------------------------------------------------------------+ 10 rows in set (0.00 sec)
mysql> create table t8(id bigint unsigned not null auto_increment primary key,name binary(128) default(sha2(uuid(),512))); Query OK, 0 rows affected (0.02 sec) mysql> insert into t8(id) select id from t2 limit 10; Query OK, 10 rows affected (0.01 sec) Records: 10 Duplicates: 0 Warnings: 0 mysql> select * from t8; +----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | name | +----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | 0x3438303332343732613961313034363333613034313933663561663437333733373862383263303438376234666634623939656433316661666562323936393965633838623166353731666437653165633234633435326332623436353630393133663438643266356632646164633365656665656663353831356238653235 | | 2 | 0x6634623166353232316239363764643833316261663030366664306163646362613837323338303331643630393061353865353261623536383362643437656233303235356536363066356136636339373039626638333766633266333264306330613634356565376633616338333138356139353130643861333139633361 | | 3 | 0x3730653665376633633338396265373238373530356535633234373539363966333963383134623838333630663039373435303564396237663134313034323534653964363238326230623036636232393230366461643539323839373135643064376434313863623262373261363433346662666265373935316638316531 | | 4 | 0x3662353861346535353235386335313035356465333138616536636337346239616534316132353336326336386330356438323333386561623233346163633732663031636262306439643364613537303666326530633132626663613336336464636339386163333238333962336431666134366466313264306636396662 | | 5 | 0x6333643736323532326637613638656338636534323862343833643764333636386237336435663032323738353937353736306130323863343035653230336638396137303062663237353931336437343537656130646238393536346437303331313366633933613964313861663633323936326434656564363263353638 | | 6 | 0x6165303530343339653166616130383462333664343237363063393237663432646135666566336430613730303230343735396262326165623930623933613665376335316637333733316336396464653565363233633434336265653764663039366233303036336261306664663466336265373839643965396638386661 | | 7 | 0x3562323465373266613266663962646433383837646136643366663530303563653233386436336635656334643166343632333337613963313731626363376463373433333437363336373634313739313739643862396233323239613531393061363862393537656463626665363166646162643365303965303834343665 | | 8 | 0x6530336536336663323264373237356162643861313366616639616633653662356534633131656661313862663031643634376163616133323661643131373832633436336533646436323239316163336535383636626166646662393039643733616562626135336135323864393362356334656362623331666433393038 | | 9 | 0x6461646239396331386639653363613632616338313266653266386430303637663863366534303632323666306439353434653434633334633838633766333465323563306333653631623739343530343665623062363235376330613262303966613032353533306532343930353537373238323665343633646536653830 | | 10 | 0x3738633461343233373636643333633536313036626130626466316331376662333062313839363731346434303835646534656437623461613036356637636535373731383265343231353430646535336365616238333738306239356265393364386530346264323939343737323338313863366534633165373737626439 | +----+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 10 rows in set (0.00 sec) mysql>
